Troubleshooting QuickBooks Desktop Sync
The first step in troubleshooting any issue with any 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.
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.
A row will be added to the table below every time your Abacus account data is synced into your connected accounting software. You can filter either for Bank Debits or Corporate Card Expenses and then show only the errors.
An incomplete integration to QuickBooks Desktop can result in a failure to sync. If you’ve hit a roadblock with your QuickBooks Desktop integration, there are a few different steps you can take to troubleshoot the issue. Once you've pinpointed the issue, you can re-sync the record to your QuickBooks. If you've already accounted for the transaction, you can click 'Dismiss Error' to remove the error message from the list.
1) Are all of your categories mapped to your chart of accounts?
Abacus gives you the option to add additional data to each expense by setting up custom categories and sub-categories. After you’ve set up your Abacus Expense Categories, the next step is to map those to your GL codes. If you haven’t mapped your Abacus Categories to your GL codes, the sync to QuickBooks desktop will break.
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, Abacus cannot complete the sync. Open up your Categories page in Abacus 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.
3) Are your corporate cards mapped to the corresponding card feeds?
If you are using Abacus for corporate card reconciliation, and have multiple card feeds in your QuickBooks, you need to map your Abacus 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) The person who set up QB Integration with Abacus is 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, the new QuickBooks administrator must redo the sync.
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 Classes/Department/Location?
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 Classes/Department/Location?
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 web connector running?
The QuickBooks Web Connector is an application that enables specially designed web-based applications to exchange data with QuickBooks products. We suggest to always leave the Web Connector running in QuickBooks, because the sync can only happen if the Web Connector is running. If your Web Connector has not been running, you can launch the Web Connector and press Update Selected in order to pull in all unsynced items.
To run WebConnector:
1) Check the box next to Abacus
2) Click "Update Selected"
That's it! Anything queued up to sync should pull through to Abacus.
8) Is your default bookkeeping category mapped to an up to date account?
On 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.
9) Is your QuickBooks Desktop company file specified in your Abacus settings?
Step 4 in your Setup is specifying the QB company file. If you use multiple company files, you will want to set this up. If you just have a single company file, this is still a good way to ensure that the two systems are pointing in the right direction!
To view the company file path in QuickBooks Desktop, press F2 in QuickBooks to get to this screen:
10) QBWC 1012 error
If QuickBooks WebConnector returns a 1012 error, we advise:
1) Remove the Abacus application from the web-connector
2) Remove the Abacus application from the Integrated App section of QuickBooks (you may need to quit QuickBooks and re-open it to ensure that it's gone)
3) Go back to the 'Accounting Sync' page in Abacus to download the web-connector application (step 2 in setup).
4) Continue the setup steps listed in this article, starting with step 4
11) QBWC 1039 Error
If the WebConnector returns a 1039 error, we advise following these steps to edit the OwnerID/FileID:
1. Before beginning to troubleshoot, make sure the .QBWC file is downloaded from Abacus, and QuickBooks is open.
2. If you are currently receiving the QBWC1039 error, go to the path where the .QBWC file is located. In this example, the .QBWC file has been saved to the member's downloads folder:
3. Right-click on the .QBWC file and Open With > Notepad.
4. Once it has been opened, locate the OwnerID and FileID entries, seen below:
5. Change the last character in each line, to either a different number or letter. Example: change "c" to an "a" and change the "d" to an "a".
6. It does not matter which letter or number you change it to, but it must be different. Save the file and close.
7. Launch the .QBWC file, and you should be good to go.