Overview

Integrating QuickBooks Online with Treasury Software's ACH Universal Online empowers businesses to streamline ACH file creation for payroll, vendor payments, or customer collections. This seamless connection eliminates manual data entry, reduces errors, and ensures compliance with banking standards. Whether you're a business owner, accountant, or financial administrator, this guide provides a step-by-step walkthrough to help you get started quickly and confidently.

Table of Contents

1. Step-by-Step Setup Instructions

   a. Create a New Account

   b. Complete ACH File Setup

   c. Launch the QuickBooks Online Wizard

   d. Enter Banking Information for Profiles

   e. Create a Test ACH (Nacha) File

2. Video Tutorials
3. Frequently Asked Questions (FAQs)

Step-by-Step Setup Instructions

Step 1: Create a New Account

• On the ACH Universal Online Home Page, click the '+' next to Accounts, and create a new account.
• Name your account (e.g., Operating, Payroll)
• Create separate accounts for each bank if originating ACH files from multiple sources

Step 2: Complete ACH File Setup

• From the ACH Universal Online Home Screen, click on the 'ACH Setup' tile.
• Use your bank's ACH setup details from the welcome packet.
• If unavailable, Treasury Software can extract setup info from an existing ACH file
• Use Advanced Setup if:
  • You have a customer ID, then your Immediate Origin ID
  • You need offsetting records for balanced files

Step 3: Launch the QuickBooks Online Wizard

• From the ACH Universal Online Home Page, click on the 'QuickBooks Online Integration' tile.
• Click on 'Connect' 
• Log in with your QuickBooks Online Admin credentials
• Select the bank account to integrate and click 'Save.'

Step 4: Enter Banking Information for Profiles

• Import profiles via Excel/CSV (Name, ABA Routing Number, Account Number)

• Profiles are created automatically during transaction viewing

  Important: Profile names must match QuickBooks Online exactly for successful integration

• More information about Profiles

Step 5: Create an ACH (Nacha) File

• View transactions and verify profiles
• Click 'Create ACH File'
• Save and upload the file to your bank

Video Tutorials

Getting Started with QuickBooks Online, Part I

Getting Started with QuickBooks Online, Part II

Frequently Asked Questions (FAQs)

1. Do I need admin rights in QuickBooks Online?

Yes, admin access is required to authorize the integration.

2. Can I import banking profiles from Excel?

Yes. Just ensure the names match exactly with those in QuickBooks Online.

3. Can I exclude transactions already paid by check?

Yes. Highlight the transactions and click 'Do Not Send Permanent' to exclude them from the ACH file.

4. Is this integration compatible with multiple bank accounts?

Yes. You can create separate ACH Universal Online accounts for each bank account.

Need Help?

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