Below is a list of common errors you may encounter during an import to QuickBooks Online:
Account does not exist in QBO Chart of Accounts
Class does not exist in QBO list
Entity does not exist in QBO list
Department does not exist in QBO list
Could not create journal entry for DocNumber ''. Details: Please balance your debits and credits
Could not create purchase: Duplicate Document Number Error
Token refresh failed. Re-Authorization required
Invalid IIF file - chosen delimiter not found
Error: Account does not exist in QBO Chart of Accounts
The Account value specified to be integrated into QuickBooks Online cannot be found in your client's QuickBooks Online Chart Of Accounts list. Please review the source data and the Chart Of Accounts list in QuickBooks Online to ensure the Account is correct and exists in QuickBooks Online.
To view the Accounts list in detamoov, access the QuickBooks Online moov configured for your client, hover over their configuration and click the "Show QuickBooks Accounts" icon.
Please note that this is a read-only view of the Accounts list. Any change to an invalid or missing class would need to be made in the source data sent to detamoov or in the QuickBooks Online account.
Note: common errors can be incorrectly typed account names as these values, including the number of spaces in the account name, must match the account name in QuickBooks.
Error: Class does not exist in QBO list
The class value specified to be integrated into QuickBooks Online cannot be found in your client's QuickBooks Online Class list. Please review the source data and the class list in QuickBooks Online to ensure the class is correct and exists in QuickBooks Online.
To view the Class list in detamoov, access the QuickBooks Online moov configured for your client, hover over their configuration and click the "Show QuickBooks Accounts" icon.
Please note that this is a read-only view of the Class list. Any change to an invalid or missing class would need to be made in the source data sent to detamoov or in the QuickBooks Online account.
Note: common errors can be incorrectly typed class names as these values, including the number of spaces in the class name, must match the class name in QuickBooks.
Error: Department does not exist in QBO list
The Department value to be integrated into QuickBooks Online cannot be found in your client's QuickBooks Online Department list. Please review the source data and the Department list in QuickBooks Online to ensure the Department is correct and exists in QuickBooks Online.
To view the Departments list in detamoov, access the QuickBooks Online moov configured for your client, hover over their configuration and click the "Show Chart of Account" icon.
Please note that this is a read-only view of the Departments list. Any change to an invalid or missing class would need to be made in the source data sent to detamoov or in the QuickBooks Online account.
Note: common errors can be incorrectly typed department names as these values, including the number of spaces in the department name, must match the department name in QuickBooks.
Error: Entity does not exist in QBO list
The Entity (Customer, Vendor or Employee) value to be integrated into QuickBooks Online can not be found in your client's QuickBooks Online Entity list. Please review the source data and the Entity lists in QuickBooks Online to ensure the Entity is correct and exists in QuickBooks Online.
You can also have detamoov created the entity if it does not exist in QuickBooks Online. To activate this option, access the QuickBooks Online moov from your moovs section and then click the moov configuration on the right.
Click Next, locate the Action - QBO Import step, and then toggle the 'Use default parameters' off. Then activate the Auto-create Entities in QBO if they don't exist.
Click Next at the bottom of the page, and then Save on the next page to complete the changes.
This error indicates that the total amount under debits does not equal the total amount under credits for the journal entry. QuickBooks Online will not allow unbalanced journal entries to be created. Please check to ensure that the total amounts on both sides match.
This error indicates that the invoice name/number/ID is already being used in QuickBooks. To resolve this error, please review the Duplicate Document Number article to resolve this error.
Error: Not connected to QuickBooks
In order for detamoov to connect to your client's QuickBooks Online account, they must first authorize the detamoov app to allow a connection. Access our Connect to QuickBooks Online article on how to allow detamoov to connect to your client's QuickBooks Online account.
Error: Token refresh failed. Re-Authorization required
Something occurred in the client's QuickBooks Online account that requires the detamoov app to be re-authorized. Please Contact Us to resolve this error.
Error: Invalid IIF file - chosen delimiter not found
If you are using an IIF file as the source data, this error is caused by the format of the data used to trigger the QuickBooks Online moov not matching the expected format. For example, if you have configured the IIF (tab delimited) to QuickBooks Online moov, but the data you send detamoov is an IIF format that is a comma-delimited.
To correct this error, you will need to deactivate the active configuration for your client and then adopt and configure your client for the IIF (comma delimited) to QuickBooks Online moov.
To deactivate the client's configuration for the IIF (tab delimited) to QuickBooks Online moov, click the moovs link on the left and then click the IIF (tab delimited) to QuickBooks Online moov.
Then click the client row in the moov configurations sect that you wish to deactivate.
On the edit configuration view, change the Status to 'Inactive' and change the File Name Starts With field to include the word "inactive" before the existing value.
Then Click Next in the lower right and scroll down to the bottom of the next page and click Next.
On the Review page, click Save.
To adopt the correct moov, click on the moovs link on the left and then click the ADD button.
Then expand the Accounting/General Ledger section and select the appropriate moov.
Note: if the file you are importing is in our Standard GL format, then you will need to select the Standard GL to QuickBooks Online moov above.
Click the "USE THIS MOOV" button.
You can then configure your client for this moov by visiting the "Configure a client for a QuickBooks Online moov" section of our Connect To QuickBooks Online article.
