QuickBooks Batch Integration Process

Integrating with QuickBooks Batch Process requires a number of technical setups along with a few configuration elements in the EKA Omni TMS.

Technical Requirements:

QuickBooks Online

Third Party service to upload documents to QuickBooks Online

EKA Omni TMS Configurations:

EKA Administrator turns on the integration - the date of this entry is the date from which files will begin to be created

EKA Administrator sets frequency of batch files

EKA Administrator enters the email address(es) for batch file distribution

QuickBooks account numbers entered

To get started, your EKA Customer Support resource will collaborate with you to determine the best setting options. Each type of batch file can be set to a different frequency: daily, weekly or monthly. You will need to designate one or more recipients for file distribution.

QuickBooks Online Configurations

The account numbers in QuickBooks also require a short setup process that assists with the mapping. 

1. Click on the Settings icon, Account and Settings → Advanced
2. Under Chart of Accounts, turn on “Enable account numbers” and check “Show account numbers”
3. Under Categories, turn on “Track classes”
4. Add the QuickBooks accounts that were entered into EKA Configurations
1. Click Settings → All Lists under “Lists”
2. Chart of Accounts
3. Click New
4. Account Type must equal the type for the account you are adding from EKA Configurations
5. Account Number must equal the account number from EKA Configurations
6. Detail Type - name values do not really matter
7. Save and Close

File Requirements for Upload to EKA

The file uploads to EKA use existing reports that are available in QuickBooks, but these reports will require a few small modifications that can be saved for reuse.

Invoice Payments

1. Search for “Invoices and Received Payments” under the Reports tab
2. Choose the desired date range
3. Click Customize → Change Columns
4. Add the following columns
1. Open Balance
2. Payment Method
3. Customer
5. Save the customized report for easier access later. Saved custom reports will be under the Report → Custom Reports tab

Settlement Payments

1. Search for “Bills and Applied Payments” under the Reports tab
2. Choose the desired date range
3. Click Customer → Change Columns
4. Add the following columns
1. Open Balance
2. Payment Method
3. Vendor
5. Save the customized report for easier access later. Saved custom reports will be under the Report → Custom Reports tab

To view an overview of the QuickBooks Batch product click here.

To get started with a QuickBooks integration, contact Customer Success team at support@go-eka.com.