Overview

Learn how to seamlessly import transactions from QuickBooks Online into ACH Universal Online. This guide walks you through the integration process, troubleshooting tips, and best practices for ACH file creation.

Getting Started

ACH Universal Online automatically reviews your bank account register to identify transactions that have not yet been processed by the software. These unprocessed transactions will be clearly displayed, allowing you to take appropriate action.

Note: Only transactions that have not been processed by ACH Universal Online will appear in this view. This helps ensure accuracy and prevents duplicate processing.

Create transactions in QuickBooks Online as you normally do.

Please remember that not all customer and vendor activity will be recorded in the register. Tips:
--Enter expenses and checks.  If you use Bills - remember to 'Pay Bills'
--Customers - Enter Sales Receipts.  If you use Invoices - remember to  'Receive Payments'
--Run payroll as usual, do not opt for QuickBooks Online payroll services (use paper checks).
 

Tip: If you don't see a transaction in your QuickBooks Online check register, ACH Universal Online will not see it either.

QuickBooks Online Integration Setup

1. Launch ACH Universal Online
2. Click the QuickBooks Online Integration tile on the home page
3. Connect to QuickBooks 
4. Select the appropriate bank account for ACH origination

Importing Transactions

Once you are connected:

• On the Transactions tab, click 'View Transactions' to accept the default range - or enter your own.

• The first time you run Transactions in ACH Universal Online, it will automatically create a profile for each of your customers, employees, and vendors who have transactions.
• Enter the banking information into the profiles that you want processed.
• Click here to learn more about Profiles.

• Once you have entered the information into the profiles that you want to process, click on 'View Transactions' again. Transactions that have not been processed will be displayed.
• Learn more about holding or excluding transactions from a file
• Check the transactions and control totals at the bottom. When you have confirmed the correct transactions and totals, click on 'Create ACH File'.

Frequently Asked Questions (FAQs)

1. Can I import transactions from multiple QuickBooks accounts.

Yes. ACH Universal Online allows you to have multiple accounts. You will need to create a separate account for each QuickBooks account.

2. What if my ACH file date falls on a holiday?

You can manually adjust the file date in the setup wizard.

3. How do I exclude a transaction from an import?

Use the 'Do Not Send' options in the integration box.

4. Can I re-import a transaction that was already processed?

Yes, by deleting the import or using the override feature.

Need Help?

Still have questions? Contact Treasury Software Support or visit www.treasurysoftware.com for personalized assistance.