Vendor Payments ACH/NACHA for QuickBooks Desktop

Stop Writing Checks – Make Direct Deposits to Your Vendors

Make Payments to Vendors by Direct Deposits using ACH – NACHA file

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

  • Create Vendor Payments in QuickBooks
  • Create Vendor payments NACHA file
  • Automatic Direct Deposit notification through email
  • Provide Online Access to payment details
  • Provide payment history to Vendors

The process includes registration, one time setup of vendor accounts with bank information, importing bill payments info from QuickBooks and creating NACHA file.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.

  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

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.

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

  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 InLattice_test2@infonics.com.qwc, the below window appears, click OK.

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.

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

  1. Upload QuickBooks Vendor List – This can be done using InLattice > Settings > QuickBooks Interface > Refresh Vendor list option
  2. Setup 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) Vendor Banking information, Select Yes in “Do you want to setup vendor banking information?” Otherwise for testing purpose, you will be required to login as a vendor to enter this information
    3. Select Balanced/Unbalanced file option based on your bank’s requirements
    4. Enter other data provided by the bank
  1. Setup Vendor Accounts in InLattice – Go to Settings > Add users to add vendor accounts to InLattice. Based on your setup, you can also enter vendor bank information here. You will receive email notification with vendor userid and password. (InLattice Support Team can setup user accounts, after the vendor list is uploaded to InLattice)
  2. Setup Vendor Bank account info – Either you can do as part of step 7 or you need to login to vendor account to update this information
  1. Enter Bill Payments Extract Begin Date – Go to Settings > QuickBooks Interface > Enter Bill Payments Extract Begin Date and enter a date.

Whenever new vendors added to QuickBooks,

  1. Upload QuickBooks Vendor List
  2. Setup New Vendor Accounts in InLattice
  3. Setup Vendor 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 Bill Payments for the vendors in QuickBooks
  1. Login to InLattice account
  2. Click on Import > Bill Payments
  1. Run Web Connector
  2. All payments made in QuickBooks since last import will be uploaded to InLattice > Bill Payments > Draft folder. You will be directed to Bill Payments > Draft folder
  1. You can authorize all payments by selecting all payments in draft folder and clicking on Authorize ACH payment
  2. Click on ACH NACHA file button and click on Create File button. You will be directed to the file download screen. Vendors will receive an email notification, informing them about the payment, if email notification option is enabled.
  1. Download the file most recent ACH NACHA file
  1. Send the NACHA file to Bank as per your bank’s guidelines
  2. You can also send all payment info to Vendors. Vendors will receive an email with a link to payment document. Vendors can access these documents online for two years.
  1. If you do not want to send the payment details to Vendors, you can delete the rows from the draft folder

For additional support, please contact us at support@inlattice.com