ACH Universal - Advanced Topics > Accounting System Integration > QuickBooks Direct Deposit ACH Reports
How to report/export payments for ACH transmission. The example illustrates QuickBooks 2006, but the process can be used with any accounting package.
Run a check register for the appropriate date range and save it to Excel or a comma delimited (csv) file.
In QuickBooks:
Enter into the register for the 'ACH Transmissions' account ('Lists', 'Chart of Accounts', select 'ACH Transmissions').
Click the Print icon (or 'File', 'Print Register'), select the appropriate dates and click 'OK'.
For the 'Print to' option buttons, click 'File', and pull from the drop down box to the right, 'Comma delimited file'.
We highly recommend that you first preview your records!!
After your review, click 'Print' to save it to a file. This file will be used by ACH Universal.
Page url: http://www.treasurysoftware.com/TSHelp/index.html?quickbooks_direct_deposit_ach_.htm