Skip to main content

QuickBooks export errors and how to fix them

What each QuickBooks export error means, what causes it, and the steps to fix it - grouped by error type.

Written by Lubica Jakubac

Where to find export errors

When an export to QuickBooks fails, the document moves to the Export Failed tab inside the folder. Open the document to see the exact error message returned by QuickBooks, along with a Dismiss button.

The first step for any export error is the same: open the document, read the error, fix the underlying cause, click Dismiss, then export again. The sections below describe the most common errors grouped by what caused them.

πŸ‘‰ What does "Dismiss" do?

Dismiss clears the error from the document so you can try to export again. It does not fix the cause - if you dismiss without fixing what made the export fail, the next export attempt will fail the same way.


Connection and access errors

These errors mean that the link between Datamolino and QuickBooks is not currently usable - either the authorization for the connection has expired, the QuickBooks session has timed out, or the QuickBooks user does not have the right permissions.

πŸ‘‰ "ValidationFault 6000: Business Validation Error: An unexpected error occurred while accessing or saving your data"

ValidationFault 6000 error message on a document with Dismiss button

This is a generic QuickBooks-side error. It typically appears when the authorization for the connection token has expired or the QuickBooks session has timed out. To fix it:

  1. Check that your folder is connected to QuickBooks.

  2. Refresh the QuickBooks connection on the folder.

  3. Click Dismiss in the error message on the document and try exporting again.

  4. If the issue persists, disconnect and reconnect the folder to QuickBooks, then try again.


User access errors

πŸ‘‰ "Export failed: Unauthorized Request: User is not a member of the specified Realm"

Realm error message on a document with Dismiss button

A Realm in QuickBooks refers to the specific QuickBooks company that the folder is connected to. This error means the QuickBooks user does not have permission to create the kind of document you are exporting.

To fix it:

  1. Check the user's permissions in the QuickBooks company that the folder is connected to. Can the user create bills, expenses, or invoices directly in QuickBooks?

  2. Once permissions have been adjusted in QuickBooks, Refresh connection on the folder.

  3. Click Dismiss on the error message and try the export again.

πŸ‘‰ Some users export fine but I get the Realm error. Why?

Compare the QuickBooks permissions of the users who can export with your own to see what needs to be adjusted.


Foreign currency errors

πŸ‘‰ "ValidationFault 2410: The currency and exchange rate are required for transaction in foreign currency"

ValidationFault 2410 error displayed on a document in Datamolino

The document is in a foreign currency and the issue date is set in the future. QuickBooks needs an exchange rate for the transaction, but exchange rates are only available for present or past dates - so a future date on a foreign-currency document fails the check.

To fix it on a single document:

  1. Open the document

  2. Click on Dismiss in the error message.

  3. Change the Issue date to today or an earlier date.

  4. Save the change.

  5. Export again.

Issue date field on a document with a corrected past date

πŸ‘‰ The currency error appears even though my issue date is today. What else could it be?

Multi-currency must be turned on in your QuickBooks company for foreign-currency transactions to be accepted. If multi-currency is off in QuickBooks, every foreign currency document will fail at export. Enable multi-currency in QuickBooks settings, then refresh the connection on the folder.


Line item, ledger account, and tax code errors

These errors come from the QuickBooks validation rules on the document. Datamolino checks the document against the same rules QuickBooks would apply, and blocks the export when something is missing or inconsistent.

πŸ‘‰ The error says a line item or ledger account is missing

If you are exporting from the Invoice total view: Select a ledger account.

If you are exporting from the Tax summary or Line items view: Select a ledger account or add one line items if there are none.

Then click on Dismiss in the error message and export.

πŸ‘‰ The error mentions the tax code

Each tax line and each item line needs a tax code that QuickBooks will accept on this document type. Open the document and check that:

  • A tax code is selected on every line that requires one.

  • The tax code matches the type of document - sales tax codes for sales documents, purchase tax codes for bills and expenses.

If your company has VAT disabled in QuickBooks, you still need to select the QuickBooks "No VAT" tax code on every line. Learn more about exporting to QuickBooks for No VAT companies.

πŸ‘‰ The error says the document totals do not match

QuickBooks rejects documents where the captured totals do not reconcile with the line totals and tax. Open the document and check that the line amounts, tax amount, and total add up. The totals view in Datamolino shows the breakdown side by side - adjust the line amounts or the tax code to clear the mismatch, then export again.


Class, Location, and Customer/Project errors

QuickBooks can be set up to require a Class, Location, or Customer/Project on every transaction. When those settings are enabled in QuickBooks, the corresponding field on the Datamolino document must be filled before export.

πŸ‘‰ The export fails because a Class or Location is missing

Open the document and fill in the missing Class or Location on each line (or at the document level, depending on how your QuickBooks is configured). If your folder uses locked Location or Class, the value is forced into every line automatically - if the list is empty, the QuickBooks list has probably changed since the last sync.

πŸ‘‰ The export fails because the Customer (Project) field is missing

This happens when QuickBooks has Track expenses and items by customer turned on and your purchase document does not have a customer selected. Open the document, select the right Customer or Project on each line, dismiss the error, and export.

πŸ‘‰ The list of Classes, Locations, or Customers is empty in Datamolino

The list is pulled from your QuickBooks company. If something is missing, run Refresh connection on the folder to pull the latest list from QuickBooks. If a value still does not appear, check that it is active in QuickBooks - inactive entries are filtered out.


Bank account and export type errors

Some QuickBooks export types have stricter requirements than a normal bill or invoice. The most common cases are Check and Expense, which need a bank or credit card account on the document.

πŸ‘‰ The error says a bank account is required

You are exporting the document as a Check or an Expense, but no payment account has been selected. Open the document, select the correct bank or credit card account, dismiss the error, and export. If the list of accounts is empty, refresh the connection so the latest list is pulled from QuickBooks.

πŸ‘‰ The error says the export type does not match the document

A bill cannot be exported as a sales receipt, and a credit note cannot be exported as an invoice. Open the document and check the Export As setting at the top - it must be a type that QuickBooks accepts for that document. Switch to a valid type, dismiss the error, and export.


Generic business validation errors

Sometimes QuickBooks returns a generic Business Validation Error that does not point to a specific field. These usually mean that the document on the QuickBooks side has been changed in a way Datamolino cannot detect from the failure message alone.

πŸ‘‰ The error wording does not match anything in this article

Datamolino passes the message returned by QuickBooks through to the document, so the exact wording on screen depends on your QuickBooks company and language. If you see an error that is not described above:

  1. Refresh the QuickBooks connection on the folder.

  2. Click Dismiss and try to export again - some errors are temporary.

  3. If the export keeps failing, contact support@datamolino.com and share a link to the document.


Finding a document in QuickBooks after export

πŸ‘‰ I exported a document but cannot find it in QuickBooks. Where do I look?

The quickest way is to click the QuickBooks icon next to the document (or inside the document) in Datamolino. It opens the same document directly in QuickBooks.

If the icon takes you to QuickBooks but you cannot find the document in the list you expected, check the Export As setting on the Datamolino document. Bills, Supplier Credits, Expenses, and Checks all live in different parts of QuickBooks - the document will be in the list that matches the export type you used.

Learn more about QuickBooks export types.

Did this answer your question?