Customer Payment ACH/NACHA for QuickBooks Desktop

Get Paid Faster, Easier & Cheaper

Receive Customer Payments using ACH – NACHA file .

InLattice allows you to create NACHA file required for banks to process ACH transactions.

 Provide online access to invoices created in QuickBooks
 Supports both payment with online authorization and pre-approved payments
 Create customer payment NACHA file
 Post payments into QuickBooks with no data entry
 Automatic debit notification through email
 Provide payment history to Customer

The process includes registration, one time setup of customer accounts with bank information, importing invoices, creating NACHA file and providing online access to customers.The ACH/NACHA file created by InLattice, needs to be submitted by you, to your bank for further processing. Please contact your bank for more information on requirements for processing NACHA file.

How it Works?

  1. Register with InLattice.
  2. Download and install the free QuickBooks Web Connector file- When you login first time, the below screen gives the link to download QuickBooks Web Connector file.
Download .qwc file Screen
On click of “click here” your browser’s file download dialog box is brought up. When this box appears, choose “Ok”, and put the file somewhere on your computer where you can easily find it, such as on your desktop. This is the InLattice application file.
.qwc file download

QuickBooks Web Connector file can also be downloaded from QuickBooks Interface screen after logging in.

Download .qwc file in Quickbooks Interface Screen after login

  1. Setup InLattice with the QuickBooks Web Connector – To begin this step, start QuickBooks on your computer and open your company file. Double click on the saved file, the below window appears, click OK.
Authorize new web service

The QuickBooks Web Connector window will appear with the InLattice application listed.
  1. Run the QuickBooks Web Connector – To make InLattice active, follow these two steps
  1. Enter your Inlattice password into the password field. This is the password that you use when you log in to the Inlattice.
  2. Check the check box in the left column and click “Update Selected”.

Note: If you change your password in the Inlattice, you will need to change it in the QuickBooks Web Connector window.

QuickBooks Web Connector

Password can be saved and no need of entering password every time when Web Connector is run.

  1. Upload QuickBooks Customer List – This can be done using InLattice > Settings > QuickBooks Interface > Refresh Customer list option, Run Web Connector.
  2. Set up ACH Payment Gateway Data – You need to have an ACH account with the Bank. This information is entered in Settings > Setup Payment Gateway > Add/Edit ACH Payment gateway option
  1. You will have the multiple options for creating NACHA file. Select appropriate options
  2. If you want to maintain (Add/Edit) Customer Banking information, Select Yes in “Do you want to setup customer banking information?” Otherwise for testing purpose, you will be required to login as a customer to enter this information.
  3. Select Balanced/Unbalanced file option based on your bank’s requirements
  4. Enter other data provided by the bank.
Settings > Setup Payment Gateway > ACH Payment Gateway screen

  1. Setup Customer Accounts in InLattice – Go to Settings > Add users to add customer accounts to InLattice. Based on your set up, you can also enter customer bank information here. You will receive email notification with customer userid and password. (InLattice Support Team can set up user accounts, after the customer list is uploaded to InLattice)
Settings > Add Users > Add Customers Screen

  1. Set Up Customer Bank account info – Either you can do as part of step 7 or you need to login to customer account to update this information.
  1. Enter Invoice Extract Begin Date – Go to Settings > QuickBooks Interface > Enter Invoice Extract Begin Date and enter a date.

Whenever new customers added to QuickBooks,

  1. Upload QuickBooks Customer List
  2. Setup New Customer Accounts in InLattice.
  3. Set Up Customer Bank account info

Use Settings > Application Settings screen to enable/disable various features of InLattice, setup user preference and banners, header images etc.

  1. Create Invoices for the customers in QuickBooks.
Create > Invoices

  1. Login to InLattice account
  2. Click on Import > Invoices
  3. Import > Invoices

  4. Run Web Connector
  5. All invoices created in QuickBooks since last import will be uploaded to InLattice > Invoices > Draft folder. You will be directed to Invoices > Draft folder

Invoices > Draft folder > Select entries to Authorize payments

Pre-Approved customers

  1. You can authorize all payments by selecting all payments in draft folder and clicking on Authorize ACH payment.

With Online Payment Authorization by Customer

  1. Send the invoices to customer.
  2. Customers will get an email notification.
  3. Customer can click on the link to view the invoice and click on “Pay this invoice” to authorize payments
  4. When customer makes a payment, you will get an email notification
Invoices > Inbox folder > Customer authorize payments online

  1. Click on ACH NACHA file button and click on Create File button. You will be directed to the file download screen. Customers will receive an email notification, informing them about the debit to their account, if email notification option is enabled.
Create NACHA File Screen

Customer Debit Notification Email, when Customer Invoice Payment is Processed

  1. Download the file most recent ACH NACHA file .
Create NACHA file > File Download and History Screen

  1. Send the NACHA file to Bank as per your bank’s guidelines.
  2. Export payments into QuickBooks.
  3. Run Web Connector. All paid invoices will be sent to QuickBooks.

Export Payments to QuickBooks. Invoices will be marked as paid

For additional support, please contact us at