InLattice   AP/AR Automation

1. If you have QuickBooks Online account already, go to step Register with InLattice. Otherwise, register your QuickBooks Online account

Registration screen of QuickBooks Online account
2. After registration, login to your QuickBooks Online account and create your company.

3. Add customer and vendor in your QuickBooks Online company.
4. Register with InLattice.
5. When you login first time to InLattice, the screen shown below gives the option to link your InLattice account with your QuickBooks Online account.

6. If you have not logged in to QuickBooks Online account, you will be prompted to login and select the company.

7. After successful login, you will be asked to authorize the connection of your QuickBooks Online account with your InLattice account.

8. After authorization, your QuickBooks Online account connection data is saved with Inlattice.

9. Click on OK, you will be redirected to your InLattice account

10. Upload QuickBooks Customer List – This can be done using InLattice > Settings > QuickBooks Interface > Refresh Customer list option.
11. 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.

12. 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)

13. Set Up Customer Bank account info – Either you can do as part of step 12 or you need to login to customer account to update this information.
14. 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.

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

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

Pre-Approved customers

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

With Online Payment Authorization by Customer

6. Send the invoices to customer.
7. Customers will get an email notification.
8. Customer can click on the link to view the invoice and click on “Pay this invoice” to authorize payments
9. When customer makes a payment, you will get an email notification

10. 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.

12. Download the file most recent ACH NACHA file .

13. Send the NACHA file to Bank as per your bank’s guidelines.
14. Export payments into QuickBooks.
15. All paid invoices will be sent to QuickBooks.
</ol Export Payments to QuickBooks. Invoices will be marked as paid

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