Background

AccountEdge provides an import and export functionality that works with several other applications. For general information on importing and exporting (and troubleshooting help) please see this article

Integration with Other Applications

AccountEdge Full Service Payroll

AccountEdge Full Service Payroll transactions are exported and saved as AccountEdge General Journal entries. They are imported into AccountEdge using AccountEdge Full Service Payroll transactions (File > Import Data > Full Service Payroll).

Before transactions can be exported and imported into AccountEdge, you will have had to complete the AccountEdge Full Service Payroll configuration. During this process, you will set the accounts Full Service Payroll will use. Follow the instructions in the Online Payroll Guide to AccountEdge Integration.

The two most common issues that arise with importing are:

1. Incorrect account numbers
2. The name of the saved, transactions file was renamed, and as a result, AccountEdge is unable to open the file, or another application is opening the file

Both problems are resolved by inspecting the import transaction file.

Excel

Microsoft Excel is an excellent tool for creating and editing input data files for AccountEdge and Checkout. As mentioned earlier, when saving the data for import, the preferred format is a comma-separated, ASCII text format.

PayPal

Detailed information about how to download PayPal transaction log files, and the fields of data available in those files is available from Pay Pal. The document name is PayPal Merchant Setup and Administration Guide. The log file can be saved as a tab-delimited or comma-separated ASCii text file, and customers can specify a date rage of transactions for each file.

In the log file, a transaction is recorded on a single line, and includes the gross amount, the PayPal fee, and the net amount. In AccountEdge, these three values would likely represent more than one transaction. A scenario could be: the sale is recorded as a Sales Invoice (Sale, gross amount). Payment to that invoice would be recorded as a Receive Payment, paying the full amount of the invoice (gross). A Spend Money transaction would be recorded, expensing the PayPal fee to an expense account from the account the Receive Payment was made to. This scenario affords the ability to track and report PayPal fees as expenses (or Cost of Sales).