Sometimes users will change from QuickBooks Desktop (installed) to QuickBooks Online--and there is a direct integration for both versions of QuickBooks in the software, however, Treasury Software works a little differently when integrating with the Online version of QuickBooks.
If you have been using QuickBooks Desktop and the banking information for vendors/employees/customers has been stored on their Profiles, you'll want to create a Customized Report of that information to import into ACH Universal. QuickBooks Online does not have a place for banking information, so the Profiles (names, bank account info, email addresses, etc.) needs to be stored inside of ACH Universal.
To create a customized report of QuickBooks Desktop profile information
In QuickBooks, go to Reports->List->'Contact List' (for vendors, employees, and/or customers--each is a separate Report).
Pull up the Report and then click on the 'Customize' button and put a checkmark next to these 3 (or 4) fields to include in the Report:
- Bank Account Number
- ABA Routing Number
- CHK/SAV
- [optional] Email Address
(You can uncheck any fields not needed, such as address, phone number, balances, etc.)
Once the Report is available, you will click on the 'Excel' option and flip the information into Excel format.
'Save As' in a place that you can access from Treasury Software.
In Treasury Software
Create a new account in Treasury Software (File->New Account->Create an account... give it a new name, e.g., 'QuickBooks_Online_Checking', continue through the wizard until finished. The software will flip into the new account.
--From the new account, click on File->Upsize/Copy Account. This will create a mirrored copy of your QuickBooks Desktop (original) account. https://help.treasurysoftware.com/hc/en-us/articles/360010681294-Copying-Settings-from-an-Existing-Account
--Click on the Profiles tab, and then 'Import' --and select the file you had saved from the QuickBooks Report.
Continue through the import wizard, following these directions: https://help.treasurysoftware.com/hc/en-us/articles/360010353973-Creating-and-Using-Profiles
(In addition to importing Profiles, you can also add one Profile at a time using the 'Add' icon.)
Once you have finished the import, click 'Run' to refresh the page, and you can see all of the Profiles imported by clicking on the icon above the 'View/Edit' link.
When using the QuickBooks Online Integration (cloud icon), the system will look to the QuickBooks Online bank register and the Profiles stored in ACH Universal, and--as long as the names match exactly--you can create the ACH file with that data.
