QuickBooks Desktop Export & Sync Errors
Below are common error messages that may be encountered when exporting to QuickBooks Desktop. You can view these errors on the Accounting Sync History screen in Emburse Spend.
Bank debit errors will not indicate the specific transaction within the batch that is causing the error.
Web Connector Errors
For Web Connector-specific queries, please see this article on Troubleshooting QuickBooks Desktop Sync.
Reason:
The error is displayed when Emburse Spend as an integrated application needs to be reauthorized.
Solution:
Please visit Intuit for more information: Fix Web Connector error QBWC1039
- Sign in to QuickBooks as the Admin user in Single User mode.
- If QuickBooks is in Multi-user mode, go to the File menu, then select Switch to Single-User Mode.
- From the Edit menu, select Preferences.
- Select Integrated Applications, and then select the Company Preferences tab.
- Uncheck the box for Don’t allow any applications to access this company file.
- In the SDK App Authorization pop-up, select Yes.
- Check your third-party application to allow access.
- Select OK.
Reason:
This error is displayed when the Emburse Spend Web Connector is having problems connecting to the QuickBooks company file.
Solution:
- Ensure that QuickBooks company file is open or that the file path for QuickBooks data files is correct in Emburse Spend.
- To do this, open QuickBooks and press F2 key to launch the Product Information window.
- Copy the Location of the QuickBooks data file path.
- Log in to Emburse Spend and select the
Gear in the upper right corner to access Company Settings.
- In the Company Settings menu, select Accounting Integration.
- Scroll down to Set Up and, under Company File, select I Want to Specify the Full Path of the Company File Emburse Spend Will Sync To.
- Paste the file path into the box and select Save.
- Run the Web Connector.
Reason:
This error indicates that the Web Connector file was already downloaded and the system is having a conflict when adding it again.
Solution:
- Open QuickBooks Desktop in Single User mode with Admin permissions.
- Log in to Emburse Spend and select the
Gear in the upper right corner to access Company Settings.
- In the Company Settings menu, select Accounting Integration.
- Scroll down to Set Up and download the QuickBooks Web Connector File.
- Find the downloaded .QBWC file on your device, right-click on it, and select Open With > Notepad (or another text editor).
- Locate the OwnerID and FileID entries in the text file:
- Change one character in each line to either a different number or a different letter (e.g., Change "c" to an "a" and change "d" to an "a"). It does not matter which letter or number you change to, but it must be different.
- Save the file and close it.
- Return to the Accounting Integration screen in Emburse Spend and scroll down to Set Up.
- Under 3. Enter Password, select View Password.
- Copy the password.
- Launch the .QBWC file by double-clicking it or opening it with WebConnector.
- When WebConnector asks for a password, enter the copied password.
Reason:
This occurs when multiple company files are open at the same time.
Solution:
In QuickBooks, go to the File menu.
Select Close Company.
Select the Company File and launch it.
Log in to the QuickBooks file as admin.
Log in to Emburse Spend and select the
Gear in the upper right corner to access Company Settings.
In the Company Settings menu, select Accounting Integration.
Scroll down to Set Up and download the QuickBooks Web Connector File.
- Find the downloaded .QBWC file on your device, right-click on it, and select Open With > Notepad (or another text editor).
- Locate the OwnerID and FileID entries in the text file:
- Change one character in each line to either a different number or a different letter (e.g., Change "c" to an "a" and change "d" to an "a"). It does not matter which letter or number you change to, but it must be different.
- Save the file and close it.
- Return to the Accounting Integration screen in Emburse Spend and scroll down to Set Up.
- Under 3. Enter Password, select View Password.
- Copy the password.
- Launch the .QBWC file by double-clicking it or opening it with WebConnector.
- When WebConnector asks for a password, enter the copied password.
Reason:
This error occurs if the Web Connector certificate is not verified.
Solution:
- Remove the old certificate in QuickBooks by navigating to Edit > Preferences > Integrated Applications > Company Preferences > Select Emburse Spend > Remove.
- Follow steps 2–8 in the article How Do I Connect QuickBooks Desktop Software to Emburse Spend?
- Run a Web Connector sync.
Reason:
The error occurs when the QuickBooks Web Connector lacks permissions to write messages to a log file.
Solution:
- Close out of QuickBooks and Web Connector completely.
- On your computer, navigate to C:\ProgramData\Intuit\QBWeb Connector\log.
- Rename the QWCLOG.txt to QWCLOGOLD.txt.
- Restart QuickBooks Web Connector to generate a new QWCLOG.txt file.
- Launch QuickBooks and Web Connector.
Reason:
This error is displayed when Emburse Spend has not been added as an integrated application in QuickBooks.
Solution:
Remove Emburse Spend from the Web Connector and download a new Web Connector file.
- In QuickBooks, navigate to Edit > Preferences > Integrated Applications > Company Preferences > Select Emburse Spend > Remove.
- Now navigate to QuickBooks Web Connector > Select Emburse Spend > Remove.
- Follow steps 2–8 in the article How Do I Connect QuickBooks Desktop Software to Emburse Spend?
Reason:
You do not have the correct admin permissions to launch the Web Connector for the first time.
Solution:
- Log out of QuickBooks Desktop, then log back in using admin credentials in single-user mode.
- Navigate to the Edit menu, then select Preferences.
- Select Integrated Applications, then go to the Company Preferences tab.
- If more than one application is listed, select Emburse Spend, then select Properties.
- On the Access Rights tab, take note of the name in the Log In As field and clear the checkbox next to Allow this application to read and modify this company file.
- Select OK to save the changes.
- In the Log in As field, select the name that was previously used. Select OK twice.
Reason:
The correct permissions were not granted during setup of the Emburse Spend Web Connector application, preventing it from logging in to QuickBooks automatically.
Solution:
- Log out of QuickBooks Desktop, then log back in using admin credentials in single-user mode.
- Navigate to the Edit menu, then select Preferences.
- Select Integrated Applications, then go to the Company Preferences tab.
- If more than one application is listed, select Emburse Spend, then select Properties.
- On the Access Rights tab, take note of the name in the Log In As field and clear the checkbox next to Allow this application to read and modify this company file.
- Select OK to save the changes.
- In the Log in As field, select the name that was previously used. Select OK twice.
Reason:
The QuickBooks Web Connector is unable to detect the Company file because it is not open.
Solution:
- Launch QuickBooks Desktop and the Web Connector.
- Select the Web Connector file, then select Update Selected.
Reason:
The corporate credit cards in Emburse Spend are not mapped to a GL account in QuickBooks, so transactions cannot be synced to QuickBooks.
Solution:
- Log in to Emburse Spend and select the
Gear in the upper right corner to access Company Settings.
- In the Company Settings menu, select Accounting Integration.
- Scroll down to the list of corporate cards and look for those with blank drop-downs.
- Use the drop-downs to select the correct GL account for each unmapped card, then select Save.
- Scroll back up to the top right corner of the Accounting Integration screen and select Accounting Sync History.
- Filter the list by Corporate Card Expenses and Errors Only, then select Re-sync Record and run the Web Connector.
Bill/Transaction Errors
Reason:
Only Expense, Other Expense, and Cost of Goods Sold GL accounts can be billable.
Solution:
Expenses that are tagged with a Customer will automatically be synced to QuickBooks with data in the Billable field, whether or not the expense is actually billable. These expenses are prevented from syncing because they have data in the Customer expense field, which is mapped to Customer in QuickBooks.
- Change mapping of problem categories in QuickBooks.
- Edit the expense so that it is not billable.
- Change the expense category to something else.
Reason:
QuickBooks is unable to recognize information sent by your application provider. This happens when fields contain special characters or have more characters than QuickBooks can support.
Solution:
- Log in to Emburse Spend and select Card Transactions or Reimbursements in your admin sidebar to locate the expense or transaction.
- Remove any special characters entered in the expense.
- Select the
Gear in the upper right corner to access Company Settings.
- In the Company Settings menu, select Accounting Integration.
- In the upper right corner, select Accounting Sync History.
- Under Sync Type select Corporate Card Expenses or Bank Debits.
- Under Showing select Errors Only.
- Select Re-sync Record and run the Web Connector.
Reason:
This error occurs when the bill already exists in QuickBooks.
Solution:
- Locate the bill in QuickBooks.
- Log in to Emburse Spend and select the
Gear in the upper right corner to access Company Settings.
- In the Company Settings menu, select Accounting Integration.
- In the upper right corner, select Accounting Sync History.
- Under Sync Type select Corporate Card Expenses or Bank Debits.
- Under Showing select Errors Only.
- Select Dismiss Error to clear the error.
Reason:
QuickBooks will not let you record transactions that contain:
- Two A/R accounts
- Two A/P accounts
- One A/R account and one A/P account
Solution:
- Log in to Emburse Spend and select the
Gear in the upper right corner to access Company Settings.
- In the Company Settings menu, select Accounting Integration.
- Scroll down to the Default Expense Type section.
- Use the Select Expense Account drop-down to choose an account that is not A/R or A/P.
- Select Save.
Reason:
This error occurs when an incorrect GL account is selected as an Item type and Item is an account type that does not support Billable expenses.
Solution:
- Log in to Emburse Spend and select Card Transactions or Reimbursements in your admin sidebar to locate the transaction or expense.
- Edit the Expense information and update the Category on the expense.
- In the Company Settings menu, select Accounting Integration.
- In the upper right corner, select Accounting Sync History.
- Under Sync Type select Corporate Card Expenses or Bank Debits.
- Under Showing select Errors Only.
- Select Re-sync Record and run the Web Connector
Reason:
This error indicates that the item mapped to an expense is no longer active or deleted.
Solution:
- Log in to Emburse Spend and select Card Transactions in your admin sidebar to locate the transaction.
- Edit the Expense information and update the Expense item on the expense.
- In the Company Settings menu, select Accounting Integration.
- In the upper right corner, select Accounting Sync History.
- Under Sync Type select Corporate Card Expenses or Bank Debits.
- Under Showing select Errors Only.
- Select Re-sync Record and run the Web Connector.
Reason:
This error occurs when the bill already exists in QuickBooks.
Solution:
- Locate the bill in QuickBooks.
- Log in to Emburse Spend and select the
Gear in the upper right corner to access Company Settings.
- In the Company Settings menu, select Accounting Integration.
- In the upper right corner, select Accounting Sync History.
- Under Sync Type select Corporate Card Expenses or Bank Debits.
- Under Showing select Errors Only.
- Select Dismiss Error to clear the error.
Reason:
This error occurs when exporting to an Accounts Receivable-type account and a Customer value has not been selected on a split expense.
Solution:
- Log in to Emburse Spend and select Card Transactions or Reimbursements in your admin sidebar to locate the transaction or expense.
- Edit the expense to add a customer and save it.
- In the Company Settings menu, select Accounting Integration.
- In the upper right corner, select Accounting Sync History.
- Under Sync Type select Corporate Card Expenses or Bank Debits.
- Under Showing select Errors Only.
- Select Re-sync Record and run the Web Connector.
Corporate Card Errors
Reason:
One or more corporate cards have not yet been mapped to a GL account in your accounting software. If a card is not mapped, transactions from that card cannot be synced by Emburse Spend to your accounting software.
Solution:
- Log in to Emburse Spend and select the
Gear in the upper right corner to access Company Settings.
- In the Company Settings menu, select Accounting Integration.
- Scroll down to the list of corporate cards and look for those with blank drop-downs.
- Use the drop-downs to select the correct GL account for each unmapped card, then select Save.
- Scroll back up to the top right corner of the Accounting Integration screen and select Accounting Sync History.
- Filter the list by Corporate Card Expenses and Errors Only, then select Re-sync Record.
Reason:
This error occurs when you are trying to export a credit card refund and the corporate card account mapped to the credit card is not of the credit-card type. Bank-type GL accounts do not accept credit card refunds to post.
Solution:
- Log in to Emburse Spend and select the
Gear in the upper right corner to access Company Settings.
- In the Company Settings menu, select Accounting Integration.
- In the list of corporate cards, select the associated card and change it from a bank-type GL account to a credit card-type GL account.
- Select Save.
- Scroll back up to the top right corner of the Accounting Integration screen and select Accounting Sync History.
- Filter the list by Corporate Card Expenses and Errors Only.
- Select Re-sync Record and run the Web Connector.
Reason:
This error occurs when attempting to sync into QuickBooks a corporate card transaction or a reimbursement that has an expense date in a closed period.
Solution:
- Reopen the closed period in QuickBooks.
- Log in to Emburse Spend and select the
Gear in the upper right corner to access Company Settings.
- In the Company Settings menu, select Accounting Integration.
- In the top right corner select Accounting Sync History.
- Filter the list by Corporate Card Expenses and Errors Only.
- Select Re-sync Record and run the Web Connector.
Reason:
This error occurs when a corporate card is mapped to a credit card-type GL account but it is either inactive or deleted in QuickBooks.
Solution:
- Log in to Emburse Spend and select the
Gear in the upper right corner to access Company Settings.
- In the Company Settings menu, select Accounting Integration.
- Scroll down to Corporate Cards section.
- Locate and replace the corporate card mapping with an active account.
- Select Save.
- In the top right corner select Accounting Sync History.
- Filter the list by Corporate Card Expenses and Errors Only.
- Select Re-sync Record and run the Web Connector.
Vendor Errors
Reason: This error occurs if the vendor “Emburse Spend” has been deleted.
Solution:
- Restore the vendor "Emburse Spend" in QuickBooks.
- Log in to Emburse Spend and select the
Gear in the upper right corner to access Company Settings.
- In the Company Settings menu, select Accounting Integration.
- In the top right corner select Accounting Sync History.
- Filter the list by Corporate Card Expenses and Errors Only.
- Select Re-sync Record and run the Web Connector.
Reason:
The error occurs when exporting a transaction into QuickBooks with a list name that already exists in a different list in QuickBooks. QuickBooks does not allow you to create a new item with the same name.
Solution:
- In Emburse Spend, navigate to the Admin menu and select Card Transactions.
- Find the transaction in the list and select
Edit.
- In the Merchant/Mileage dropdown, select a different vendor name, then select Save.
- Now select the
Gear in the upper right corner to access Company Settings.
- In the Company Settings menu, select Accounting Integration.
- In the top right corner select Accounting Sync History.
- Filter the list by Corporate Card Expenses and Errors Only.
- Select Re-sync Record and run the Web Connector.
Other Errors
Reason:
There may be too many versions of QuickBooks Desktop open at the same time.
Solution
- Open Task Manager on your computer.
- Navigate to the Details tab and look for QuickBooks.
- Close all instances of QuickBooks.
- Try to launch QuickBooks Desktop.
Reason:
This error occurs when an employee, vendor, customer, or account has been made inactive in QuickBooks Online.
Solution:
Check the Audit log in QuickBooks Online to see if there are reports regarding the changes. Administrators can also check the employee, vendor, or account to see if it is inactive and make it active.
- In QuickBooks Online, navigate to Customers & Leads.
- Find the inactive employee, vendor, or account in the list and select Make Active on the far right.
- Log in to Emburse Spend and select the
Gear in the upper right corner to access Company Settings.
- In the Company Settings menu, select Accounting Integration.
- In the top right corner select Accounting Sync History.
- Filter the list by Corporate Card Expenses and Errors Only.
- Select Re-sync Record and run the Web Connector.
Reason:
This error occurs if you are logging in to QuickBooks in multi-user mode and are already logged in to QuickBooks desktop on a different computer.
Solution:
If you are logged in as the admin, you can close QuickBooks for another user.
- Launch QuickBooks Messenger (Company menu > Chat with a Coworker).
- From the Actions dropdown, select Close Company File for Users.
- Select the user whose QuickBooks you want to close.
- Select Close Company File.
- In the Confirmation window, select Yes.
Reason:
This error may occur when using QuickBooks in multi-user mode in a terminal server environment.
Solution:
- Log in to QuickBooks using the QuickBooks user account assigned to Sync & Save.
- Under Edit > Preferences > General > My Preferences, uncheck the option "Keep QuickBooks running for quick startups."
Reason:
Company file is locked by another client running at machine named [Machine Name] at MM/DD/YYYY #:##:## PM UTC. Please try again later.
Solution:
- Force close QuickBooks and the Web Connector, then attempt to load both again.
- If you are still experiencing this error, restart your computer in the Right Networks environment/PC and then update the Web Connector.