Troubleshooting your QuickBooks Online Integration – Abacus

The first step in troubleshooting any issue with your accounting sync is to check your Accounting Sync History page. Under Company Settings, click the Accounting Sync tab, then click the Accounting Sync History button in the upper right corner.

ES - Access Sync History QB.png

This page tells you which Emburse Spend data has synced into your connected accounting software. If there are any sync errors, they will appear in the Status column on the right.

ES - Accounting Sync History.png

An incomplete integration to QuickBooks Online can result in a failure to sync. If you’ve hit a roadblock with your QuickBooks Desktop integration, there are a few steps you can take to troubleshoot the issue.

1) Are all of your categories mapped to your active items in your chart of accounts?

Abacus gives you the option to add additional data to each expense by setting up custom categories and sub-categories. You can learn how to do this here. After you’ve set up your Expense Categories, the next step is to map those to your chart of accounts. If you haven’t mapped your Abacus Categories, the sync to QuickBooks Online will break. You can learn how to map your categories to your GL codes here.

2) Are any of your categories mapped to accounts that no longer exist in QuickBooks?

If you’ve deleted any items on your General Ledger that are mapped to active Abacus categories, the sync will fail. Open up your Categories page and match this against your Chart of Accounts. If anything has been deleted from your GL, you’ll need to make the corresponding updates to your Category Mapping in Abacus.

Please note: If any changes are made to your chart of accounts in QuickBooks, you must go back to your Categories page and re-map them to the updated account! This will not update on its own. If a Abacus category is mapped to an account that no longer exists or has been edited in QuickBooks Online, it will break the sync.

3) Are your corporate cards mapped to the corresponding card feeds?

If you are using Abacus for corporate card reconciliation and have selected to sync to multiple card feeds in your QuickBooks, you need to ensure all Team Cards to the corresponding feeds in QuickBooks. To set this up, go to the accounting sync page and scroll to Corporate Card Expenses at the bottom of the page.

4) Is the person who set up the Integration with Abacus no longer an Admin in QuickBooks?

If the person who set up the integration between Abacus and QuickBooks no longer has Admin permissions in QuickBooks or no longer has an active profile, the new QuickBooks administrator must redo the sync. To redo the sync with an active QB admin, you will need to enter in the credentials for the active member.

If you have an administrator set up in QuickBooks, it appears in the User List as either Admin or User Name (admin). To view the member list Choose Company > Set up Users and Passwords > Set Up Users.

5) Are your Team Fields mapped to your custom fields in QuickBooks?

Abacus gives you the option to set up Team Fields, which you can assign to your employees and map to your accounting fields in QuickBooks. After you’ve set up your Team Fields, the next step is to map those to the corresponding departments.

6) Are your Expense Fields mapped to your Custom Fields in QuickBooks?

Similarly, you can use Expense Fields in Abacus to add additional information to each expense. After you’ve set up your Expense Fields, the next step is to map those to the corresponding Department or Class. You can go here to check if your Abacus Expense Fields have been mapped to your Accounting Fields in QuickBooks.

7) Is your default expense account up to date?

In your Accounting Sync settings page, make sure that the default bookkeeping category is mapped to an account that still exists. If it's been edited, you will need to update your selection by choosing the up to date account from the dropdown menu.

8) Have you updated your 'close date' in your settings?

If you officially close the books in Abacus, you will need to keep this date updated each month in your settings. If you enter a close date for April 30th, 2021, then any expenses dated before that date will update to May 1st, 2021. You will need to update this date in Abacus each time you close the books!