To import payroll and bank transfer information from QuickBooks (Desktop version), or to update previously-imported data, you can use the Standard Import method.
Using this method, you must run a report in QuickBooks, export the data in the report to an Excel spreadsheet, and then import the Excel file into the system.
You can use the AccountingLink utility to import basic setup data and initial transaction data, but you must use this method to update transaction data or to perform the initial import of payroll and bank transfer data.
To import data from an Excel spreadsheet:
1. In QuickBooks, run the Custom Transaction Detail report for the target client and export the report to Excel.
You must select the date range for the report from the Modify Report dialog, and clear the Splits checkbox in the Columns list, and, for cash method clients, clear uncheck the Original Amount option. In addition, ensure that the Type, Date, Num, Memo, Account, Clr, Debit, Credit, and Balance options are selected.
Important!! At this point, you can minimize the QuickBooks application, but QuickBooks and Accounting Power must both be installed and open on the same computer.
2. Select Standard Import from the Integration menu in Accounting Power to open the Standard Import screen.
3. (Optional) Click the Templates button to open a sample template of the spreadsheet to use for the import operation.
4. Click the Transactions radio button, select QuickBooks from the drop-down list in the Source File Type field, and enter a date range to import in the From and To fields.
The date range you enter must match the date range of the QuickBooks report you prepared.
Note: If you are prompted that the volume of data you are importing exceeds a safe limit for a single transfer (approximately 5000 transactions), run the QuickBooks report for a smaller date range, and import the data in multiple passes.
5. Click Import to begin the transfer.
When the import operation is complete, verify the results. If a customer or vendor has an outstanding balance, enter it in the Customer or Vendor Setup screen.
Because QuickBooks conceals some transactions from external software programs, review the Trial Balance to ensure the numbers match those you expected.
If not, generate a General Ledger report in QuickBooks to find the concealed transactions, selecting the Transaction Type under Filters, selecting Multiple Transaction Types, and selecting Paycheck, Payroll Liability Check, Inventory Adjustment, Item Receipt, and Transfer.