How to Generate ACH Files from QuickBooks Online

The Problem: QuickBooks Doesn't Generate ACH Files

QuickBooks Online is excellent at managing invoices, bills, and vendor records. But when it comes time to actually pay those bills via ACH, QuickBooks falls short. There is no built-in feature to generate a NACHA-formatted ACH file that you can upload to your bank.

Most banks accept NACHA ACH files through their online banking portal for batch payments. This is the standard way businesses process payroll, vendor payments, and customer collections electronically. But getting your QuickBooks data into that format requires extra steps.

Intuit offers QuickBooks Payments for individual transactions, but it doesn't support batch ACH file generation. If you want to pay 50 vendors at once by uploading a single file to your bank, you need a third-party tool to bridge the gap between QuickBooks and your bank's ACH portal.

What You Need

Before you can generate ACH files from QuickBooks data, make sure you have the following in place:

• QuickBooks Online account — With active bills, invoices, or payments you want to process via ACH.
• Bank portal that accepts NACHA files — Most commercial bank accounts include an ACH upload feature. Contact your bank to confirm.
• Vendor/customer banking details — Routing numbers, account numbers, and account types for each payee or payer.
• A NACHA file generator — Software that converts your transaction data into the fixed-width NACHA format banks require.

Option 1: Manual Export + Excel

The manual approach involves exporting transaction data from QuickBooks, formatting it in a spreadsheet, and saving it as a fixed-width text file that matches the NACHA specification. Here is what that process looks like:

1. Export your open bills or invoices from QuickBooks as a CSV file.
2. Open the CSV in Excel or Google Sheets.
3. Manually add columns for routing numbers, account numbers, and transaction codes.
4. Format each row to match the NACHA Entry Detail record specification (94 characters, fixed-width).
5. Create the File Header, Batch Header, Batch Control, and File Control records manually.
6. Calculate the entry hash, total debits, total credits, and block count.
7. Save as a plain text file with a .ach extension.

The manual method works in theory, but it is impractical for regular use. A single misplaced character in the 94-character record format can cause the entire file to be rejected by your bank.

Option 2: Use BatchPay QB

BatchPay QB connects directly to your QuickBooks Online account and automates the entire ACH file generation process. Here is a step-by-step walkthrough:

Key Features for QuickBooks Users

BatchPay QB is purpose-built for businesses that use QuickBooks Online and need to process ACH batch payments. Here are the features that matter most:

Setting Up Banking Details

To include a vendor or customer in an ACH batch, you need their banking information on file. QuickBooks Online does not store bank routing and account numbers, so you will need to collect this information separately.

BatchPay QB provides a dedicated Bank Setup page where you can store banking details for each vendor, customer, and employee. The information you need for each entity:

• Routing number — The 9-digit ABA routing number for the payee's bank.
• Account number — The payee's bank account number (up to 17 digits).
• Account type — Checking or savings. This determines the transaction code in the NACHA file.
• Bank name — Optional, but helpful for your own records.

Once saved, banking details are reused every time you include that vendor in a batch. You only need to enter them once. If a vendor changes banks, you can update their details from the Bank Setup page at any time.

Frequently Asked Questions