Check out the most common errors and our tips to fix them

If there are errors, you'll receive an Error Report with an extra field which describes errors for each item in detail. Here is an example of an error report:

Screenshot 2023-04-12 at 15.16.34.png

This report informs you that you're trying to import an account that already exists.

<aside> ⚠️ The Error Report contains only the data that wasn't imported to Eleven. Mind that we only proceed with the import once all the errors have been fixed. For example, if you do not have a value in a base currency for a journal entry, the whole CSV will not be imported.

</aside>

Tips for fixing import errors

Some general tips, before you proceed:

<aside> 💡 Refer to the Error Report to correct your import CSV file Fix the errors in the import file, then run your import again.

</aside>

<aside> 💡 Know how to delete and start over Sometimes, the best course of action is to delete the items you imported and try again. For example, to delete imported Journal Entries at once, select the items in the Journal Entry view and select Actions → Delete journal.

</aside>

<aside> 💡 After you run any import, look at your new data in Eleven. Verify that your information is mapped correctly.

</aside>

Common Import Errors

Let’s look at the most common import errors and how to fix them.

Accounts / Contacts

Error message Steps to take
❌ Account type and account subtype constraint violation. The couple account type and account subtype is invalid. There is a mismatch between the account Type and the associated account Subtype. It might be that the associated Subtype has a wrong value. For example, if you select Revenue Account Type and Account Payable as an account subtype.

To avoid this situation, always use drop-downs in the import file. These drop-downs automatically list only the allowed Subtypes for a selected account Type. | | ❌ Characteristic not found | This error will appear when one of the values set in the import file cannot be found. For example, it might happen that you set a currency which hadn't been set in the selected client company settings. In this case, please, add the currency to the company settings and repeat the import. | | ❌ CSV record invalid | This means that one or several of your records in the CSV file is not a valid: have a wrong numbering convention, contain non-valid characters. | | ❌ Invalid header, import cancelled | This means that the number of columns or column header names of the template are not valid. Please, check that:

  1. you have used the right template
  2. the names and the order of the headers are as per the template | | ❌ Monetary constraint violation. Monetary option selected for this row is invalid based on type and subtype | There is a mismatch between the Monetary / Non Monetary value entered and the account Type / Subtype. For example, a P&L account has been set as a Monetary account. | | ❌ Parent account not found | The parent account defined for this account does not exist / has not been created. In the import file, the parent accounts should be located before their child accounts. | | ❌ Unique constraint violation | The import is failing, because one or several of your records are not unique. Verify that you do not have accounts with the same account code or name. |

Bank Statements