Only use this page if you cannot connect to QuickBooks using our integration window.
Note: After going through this article, please refer to
When ACH Universal is unable to integrate with QuickBooks Desktop, you can export information from QuickBooks--and then import it to ACH Universal--to create an ACH file.
The first step will be to export the Vendor, Employee, or Customer profile information (bank data).
In QuickBooks, click on Reports->List->Vendor Contact List (for instance)
In the left top corner, click on Customize Report
Then, in the list of columns to include, you can uncheck 'Balance', 'Phone Number', etc.--items not needed--but you will need to check the fields that include: Bank Account Number, ABA Routing Number, and CHK/SAV--as well as Email Address (if you will be using email).
When you click 'OK', you will have a report that includes the data you need in ACH Universal.
Click the icon to export the report to Excel and 'Create New Worksheet':
When the Excel spreadsheet appears, this is the 'Profile' information that will be imported into ACH Universal under the Profiles tab.
You will click 'Next' and then map the column headers (turning them from red to green) to identify just the columns of data that are needed in the Profile. If data was on the spreadsheet that is not needed, you simply leave it unmapped (red) and it is excluded from the software.
You continue through the import wizard until 'Finished'. This imports all of your data into the ACH Universal Profiles.
Click on the Profiles tab, and then click 'Run' to refresh the page, and all data will appear.
By default, only the last 4 digits of the bank account information will show (for security).
See the next article:
Export transactions from the bank register, import that data to match up to the stored Profiles, and create the ACH file.