Emburse
Help Centers

QuickBooks Desktop Export & Sync Errors


This article lists common error messages which may be returned when exporting to QuickBooks Desktop. You can view these errors on the Accounting Sync History Page via Company Settings > Accounting Sync History. 

Please Note: Bank debit errors will not indicate the specific transaction within the batch that is causing the error.

Error: QBWC1039: There was a problem adding the application. Check QWCLogs.txt for details. Unique OwnerID/FileID pair value required.

Reason:

This error indicates that the WebConnector file was already downloaded and the system is having a conflict when adding it again.

Solution: 

  1. Open QuickBooks Desktop in Single user mode with Admin credentials/ Permissions and download the WebConnector file from Abacus.
  2. Go to the location where the WebConnector File is downloaded, right click on the .QBWC file and Open With > Notepad.
  3. Once it has been opened, locate the OwnerID and FileID entries, seen below:
    qb_10.png
  4.  Change one character in each line, to either a different number or letter. Example: change "c" to an "a" and change the "d" to an "a."
  5. It does not matter which letter or number you change it to, but it must be different. Save the file and close.
  6. Launch the .QBWC file, and add it again and update the password for the WebConnector file from Abacus.

Error: QBWC1039: Error adding Bill for company (b9jn6js3qpyno6vcyjp9trje) Error: The "billable status" field has an invalid value "NotBillable". QuickBooks error message: Target is not reimbursable.

Reason:

The GL accounts that can be billable are limited to Expense, Other Expense and Cost of Goods sold.

Solution:

  1. Change mapping of problem categories.
  2. Edit the expense to be not billable.
  3. Change the category to something else.

Expenses that are tagged with a 'Customer' will automatically be synced through to QB with the 'Billable' field filled out, whether or not it is or is not billable. Because these expenses have the 'Customer' expense field, which is mapped to 'customer' in QB, filled out, it is preventing the expenses from syncing and throwing the 'Billable' error."

Error: This application is unable to log into this QuickBooks company data file automatically. The QuickBooks administrator must grant permission for an automatic login through the Integrated Application preferences. If such permission was already granted, the administrator must revoke permission, save preferences, then grant the permission again.

Reason:

The error is displayed when the Abacus is not added as an Integrated application in QuickBooks.

Solution:

Remove Abacus from the WebConnector and download a new WebConnector file

  1. Go to QuickBooks >> Edit >> Preferences >> Integrated Applications >> Company Preferences >> Abacus >> Remove.
  2. Go to QuickBooks WebConnector >> Select Abacus >> Remove/
  3. Try the steps starting from Step 2 from the article How do I connect QuickBooks Desktop software to Abacus?

Error: QBWC1012: Authentication failed due to following error message. Index was outside the bounds of the array. See QWCLog for more details. Remember to turn logging on

Reason:

The error is displayed when Abacus as an integrated application needs to be re-authorised. 

Solution: 

Visit this Intuit page for more information: Fix WebConnector error QBWC1039

  1. Sign in to QuickBooks as the Admin user in Single User mode.
  2. If QuickBooks is in Multi-user mode, go to the File menu, then select Switch to Single-user Mode.
  3. From the Edit menu, select Preferences.
  4. Select Integrated Applications, and then select the Company Preferences tab.
  5. Uncheck the box for Don’t allow any applications to access this company file.
  6. In the SDK App Authorization pop-up, select Yes.
  7. Check your third-party application to allow access.
  8. Select OK.

Error: “QBWC1013: Error connecting to QuickBooks" or "Application requested to abort"

Reason:

This error is displayed with the Abacus WebConnector having problems connecting to the QuickBooks Company file.

Solution: 

  1. Ensure that QuickBooks company file is open or ensure that the file path for QuickBooks data file is updated in Abacus.
  2. Open QuickBooks and press F2 key to launch the Product Information window.
  3. Copy the Location of the QuickBooks data file path.
  4. Log in to Abacus, go to Settings >> Accounting Sync page >> Setup >> 4. Company file.
  5. Paste the file path and save.
  6. Run the WebConnector.

Error: QuickBooks found an error when parsing the provided XML text stream

Reason:

The error message you received is related to the information sent by your application provider and QuickBooks is unable to recognize it. This happens due to special characters or fields that have more characters than QuickBooks can support.

Solution: 

  1. Log in to Abacus and click Transactions or Reimbursable Expenses in your admin sidebar to locate the expense or transaction.
  2. Remove any special characters entered in the expense.
  3. Go to Account & Settings by clicking the Gear button on the top right side of the page and select Accounting Sync History.
  4. Select Accounting Sync History and select Sync type as Corporate Card Expenses or Bank Debits and Errors Only option.
  5. Click Re-sync Record and run the WebConnector.

Error: QuickBooks cannot open this file. A background process may have already opened a different QuickBooks file. Please try closing any such background process and then re-open the file.

Reason:

There may be too many versions of QuickBooks desktop open at the same time.

Solution 

  1. Open Task manager.
  2. Navigate to the Details tab and look for QuickBooks.
  3. Close all instances of QuickBooks.
  4. Try to launch QuickBooks desktop. 

Error: Object not found

Reason:

This error occurs when an employee, vendor, customer, or account has been made inactive in QuickBooks Online.

Solution: 

The QuickBooks Admin is able to check the Audit log to see if there are reports regarding the changes. The Administrator can check the employee, vendor, or accounts for an inactive item and make it active. 

  1. Log in to Abacus and go to Account & Settings and select Accounting Sync History.
  2. Select Accounting Sync History and select Sync type as Corporate Card Expenses or Bank Debits and Errors Only option.
  3. Click Re-sync Record and run the WebConnector.

Error: Cannot sync without a corporate card account selected

Reason:

This error occurs when the Admin is exporting Corporate Card Expenses into the accounting system and the Cards are not mapped with a Credit card type GL account.

Solution:

  1. Go to Account & Settings by clicking the Gear icon on the top left side of the page.
  2. Select the Accounting Sync Tab.
  3. Scroll down to the Corporate card section.
  4. Locate the card and map it with a credit card type GL account.

Error: 1039: This application has not accessed this QuickBooks company data file before. The QB admin must grant an application permission to access a QB company data file for the first time

Reason:

The user does not have correct admin permissions to launch the Web Connector for the first time - this seems to be different from permissions to run this in the future/after the initial sync.

Solution: 

The user needs to log out and log back in to QuickBooks using Admin credentials in single user mode into and follow the below steps.

  1. In QuickBooks Desktop, go to the Edit menu, then select Preferences.
  2. Select Integrated Applications, then go to the Company Preferences tab.
  3. If more than one application is listed, select Abacus and select Properties.
  4. On the Access Rights tab, take note of the name in the Login as field and clear the Allow this application to read and modify this company file checkbox.
  5. Select OK to save the changes.
  6. In the Login as field, select the name that was previously used. Select OK twice.

Error: WebConnector error: This application is unable to log into this QuickBooks company data file automatically. The QuickBooks administrator must grant permission for an automatic login through the Integrated Application preferences. If such permission was already granted, the administrator must revoke permission, save preferences, then grant the permission again.

Reason: 

When setting up the Abacus WebConnector application, the correct permissions were not granted and the Abacus WebConnector application is unable to automatically log in to QuickBooks.

Solution: 

The user needs to log out and log back in to QuickBooks using Admin credentials in single-user mode before following the below steps:

  1. In QuickBooks Desktop, go to the Edit menu, then select Preferences.
  2. Select Integrated Applications, then go to the Company Preferences tab.
  3. If more than one application is listed, select Abacus and select Properties.
  4. On the Access Rights tab, take note of the name in the Login as field and clear the Allow this application to read and modify this company file checkbox.
  5. Select OK to save the changes.
  6. In the Login as field, select the name that was previously used. Select OK twice.

Error: Error adding Bill for company Error:  There was an error when saving a Bill. QuickBooks error message: Only one a/r or a/p account allowed per transaction.

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: 

  1. In Abacus, go to Account & Settings by clicking the Gear icon on the top left side of the page.
  2.  Select the Accounting Sync Tab.
  3. Scroll to the Default Expense Account.
  4. Select an Account that is not A/R or A/P.
  5. Save.

Error: WebConnector: Could not start QuickBooks

Reason:

The QuickBooks WebConnector is unable to detect the Company file as it is not open.

Solution:

  1. Launch QuickBooks Desktop and the WebConnector.
  2. Select the WebConnector file and click update selected.

Error: The user you are trying to log in with is already logged in from another machine. Error Code: 80040437

Reason:

This error occurs if you are logging into 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.

  1. Launch QuickBooks Messenger (Company menu > Chat with a Coworker).
  2. From the Actions drop-down, select Close Company File for Users.
  3. Select the user whose QuickBooks you want to close.
  4. Select Close Company File.
  5. In the Confirmation window, select Yes.

Error: QBWC1085: There was a problem with the log file. QuickBooks WebConnector will continue without the log file.

Reason: 

The error happens because the QuickBooks WebConnector lacks permissions to write messages to a log file.

Solution: 

  1. Close completely out of QuickBooks and WebConnector.
  2. Go to: C:\ProgramData\Intuit\QBWebConnector\log.
  3. Rename the QWCLOG.txt to QWCLOGOLD.txt.
  4. Restart QuickBooks WebConnector to generate a new QWCLOG.txt file.
  5. Launch QuickBooks and WebConnector.

Error: The application trying to connect to QuickBooks is not supported while multiple instances of QuickBooks are running.

Reason:

This error may occur when using QuickBooks in multi user mode in a terminal server environment.

Solution:  

  1. Log in to QuickBooks using the QuickBooks user account assigned to Sync & Save.
  2. Uncheck the option "Keep QuickBooks running for quick startups" found under Edit > Preferences > General > My Preferences.

Error: Records stuck in the 'syncing' status 

Reason:

The record was Final Admin approved and is trying to Sync into QuickBooks via WebConnector 

Solution:

Please reach out to the Abacus Support team.

Error: Error adding Bill for company Error: The "Bill External GUID" field has an invalid value "XYZ". QuickBooks error message: A transaction's external guid must be unique.

Reason:

This error occurs when the Bill already exists in QuickBooks.

Solution: 

  1. Locate the Bill in QuickBooks.
  2. Once Located, log in to Abacus and select Account & Settings.
  3. Select Accounting Sync History Select Sync type Bank Debits and Errors Only option.
  4. Click Dismiss error to clear the error.

Error: QuickBooks error message: The account for this transaction must be of type Credit Card.

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: 

  1. Go to Account & Settings by clicking the Gear icon on the top left side of the page.
  2. Select Accounting Sync and scroll down to the Corporate Cards section.
  3. Select and update the card with a credit card type GL account and save.
  4. Select Accounting Sync History Select Sync type as Corporate Card Expenses and Errors Only option.
  5. Click Re-sync Record to sync the transaction into QuickBooks and run the WebConnector.

Error: The account period has closed. Txn Date= MM/DD/YYYY is before book closing date=XX/YY/YYYY

Reason:

This error occurs when syncing a Corporate card transaction or a Reimbursement into QuickBooks which has an expense date in a Closed period.

Solution:

  1. Open the closed period in QuickBooks.
  2. Log in to Abacus and go to Account & Settings and select Accounting Sync History.
  3. Select Accounting Sync History and select Sync type as Corporate Card Expenses or Bank Debits and Errors Only option.
  4. Click Re-sync Record and run the WebConnector.

Error: Error adding Credit Card Charge for company (XYZ) Error: The "billable status" field has an invalid value "Billable". QuickBooks error message: Target is not reimbursable.

Reason:

This error occurs when an incorrect GL account is selected is an Item type and Item is an account type that does not support Billable expenses.

Solution: 

  1. Log in to Abacus and click Transactions or Reimbursable Expenses in your admin sidebar to locate the expense or transaction.
  2. Edit the Expense information and update the Category on the expense.
  3. Go to Account & Settings and select Accounting Sync History.
  4. Select Accounting Sync History and select Sync type as Corporate Card Expenses or Bank Debits and Errors Only option.
  5. Click Re-sync Record and run the WebConnector.

Error: Object "XYZ" specified in the request cannot be found. QuickBooks error message: Invalid argument. The specified record does not exist in the list.

Reason:

This error indicates that the item mapped to an expense is no longer active or deleted.

Solution: 

  1. Log in to Abacus, go to the transactions tab and locate the expense.
  2. Edit the Expense and update the Expense item on the expense.
  3. Go to Account & Settings and select Accounting Sync History.
  4. Select Accounting Sync History and select Sync type as Corporate Card Expenses or Bank Debits and Errors Only option.
  5. Click Re-sync Record and run the WebConnector.

Error: Error adding Credit Card Charge for company Error: Object "XYZ" specified in the request cannot be found.

Reason:

This error occurs when the Corporate card is mapped to a Credit card type GL account but it is either inactive or deleted in QuickBooks. 

Solution: 

  1. Log in to Abacus and select Account & Settings.
  2. Select Accounting Sync and scroll down to Corporate Cards section.
  3. Locate and replace the Corporate card mapping with an Active account and save it.
  4. Select Accounting Sync History and select Sync type as Corporate Card Expenses and Errors Only option.
  5. Click Re-sync Record and run the WebConnector.

Error: The query request has not been fully completed. There was a required element ("Abacus") that could not be found in QuickBooks. 

Reason: This error occurs if the Vendor “Abacus” is deleted

Solution: 

  1. Restore the vendor Abacus in QuickBooks.
  2. Once Located, log in to Abacus and select Account & Settings.
  3. Select Accounting Sync History Select Sync type as Corporate Card Expenses and Errors Only option.
  4. Click Re-sync Record and run the WebConnector.

Error: The "CreditCardCharge External GUID" field has an invalid value "XYZ". QuickBooks error message: A transaction's external guid must be unique.

Reason: 

This error occurs when the Bill already exists in QuickBooks 

Solution:

  1. Locate the Bill in QuickBooks.
  2. Once Located, log in to Abacus and select Account & Settings.
  3. Select Accounting Sync History Select Sync type as Corporate Card Expenses and Errors Only option.
  4. Click Dismiss error to clear the error.

Error: There was an error when saving a credit card charge. QuickBooks error message: Transaction split lines to accounts receivable must include a customer on that split line

Reason:

This error occurs when a Customer is not selected/mapped on the split expense when exporting to an Accounts receivable type account.

Solution:

  1. In Abacus, use the Live Filter feature to locate the expense.
  2. Edit the expense and add a Customer and save it.
  3. Select Accounting Sync History Select Sync type as Corporate Card Expenses and Errors Only option.
  4. Click Re-sync Record to sync the transaction into QuickBooks and run the WebConnector.

Error: QBWC1048: QuickBooks WebConnector could not verify the web application server certificate

Reason:

This error occurs if the WebConnector certificate is not verified 

Solution:

  1. Remove the old certificate in QuickBooks by going to Edit >> Preferences >> Integrated Applications >> Company Preferences >> Select Abacus >> Remove.
  2. Refer to the article How do I connect QuickBooks Desktop software to Abacus? and complete steps 2-8.
  3. Run a WebConnector sync.

Error: QuickBooks had a problem receiving an expense from us. The response from the application was: The request has not been processed. The vendor name " VENDOR NAME: of the list element is already in use. Please rename the merchant on this expense or find the employee, customer, or other name that matches the merchant on this expense in QuickBooks and rename it, then re-export. 

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: 

  1. Update or modify the name of the item in Abacus.
  2. Select Accounting Sync History Select Sync type as Corporate Card Expenses and Errors Only option.
  3. Click Re-sync Record to sync the transaction into QuickBooks and run the WebConnector.

For Web Connector-specific queries, see this article on Troubleshooting QuickBooks Desktop Sync.

Related articles

Articles in this section