Journal Entry Import Errors
This section describes errors that you might see on a journal entry import. See the following:
For information about other errors you might see on a journal entry import, search for the error message on SuiteAnswers.
Invalid account reference key ‘xxx’ for subsidiary ‘xxx’
To resolve the error, verify the format of the Account field, ensure that the account is active, and map the internal ID, if required.
First, make sure the Account field in your CSV uses the same format as NetSuite:
-
Go to Transactions > Financial > Make Journal Entries.
-
From the Account dropdown list, select the account. Ensure the format of the account in your CSV file matches the format of the account name you see there.
Next, check if the account is inactive.
-
First, ensure internal IDs are displayed. Go to Home > Set Preferences > General.
-
In the Defaults field group, check the Show Internal IDs box and save.
-
Go to Lists > Accounting > Accounts.
-
Check the Show Inactives box.
-
Look for the Internal ID that was referenced in the error message.
-
Clear the Inactive box for the account. Also verify that the account is associated with the correct subsidiary.
If the internal ID is used, on the Field Mapping page, click the edit icon beside the Account field.
Click Choose Reference Type, and then select Internal ID.
Invalid department reference key xxx
Verify the following for departments:
-
Make sure the department is spelled correctly. If there’s a parent-child relationship, include all parent names. For example, if Accounting is under Finance, enter it as Finance : Accounting.
-
Ensure the department is active. Go to Setup > Company > Departments. Check the Show Inactives box and make sure the department from the error message isn't inactive.
-
If you’re using internal IDs, go to the Field Mapping page, click the edit icon next to Department, select Choose Reference Type, and choose Internal Id.
-
If you’re using external IDs, do the same thing but choose External Id as a reference type instead.
Invalid entity reference key xx for currency xx
To correct the error, verify the following:
-
Ensure that the entity record (customer, vendor, employee, other name) is active.
-
Check how the entity record (customer, vendor, employee, other name) is listed in NetSuite, and ensure that the value in the CSV file has the same format.
-
Makes sure the entity record has the same currency as the Journal Transaction Currency. If the primary currency is different, you can add the transaction currency as a secondary currency on the entity record.
No empty or blank headers are allowed in the CSV file
Ensure that you have included column headings in row 1 of your CSV file, similar to the following example.
Amount |
Debit |
Credit |
Memo |
Entity |
Class |
Department |
Location |
---|---|---|---|---|---|---|---|
Account 1 |
— |
100 |
Example JE #1 |
— |
— |
Customer Support |
Head Office |
Account 2 |
100 |
|
Example JE #1 |
— |
— |
Customer Support |
Head Office |
Account 1 |
525.67 |
|
Example JE #2 |
— |
— |
Customer Support |
Head Office |
Account 2 |
— |
525.67 |
Example JE #2 |
— |
— |
Customer Support |
Head Office |
Please enter the value(s) for Account
The error might appear even if the Account field has already been included in the field mapping. The error occurs when there is an extra line in the CSV file, usually a line or row for the total of both the Debit and the Credit columns.
Since each row is treated as an account line, NetSuite thinks the total row is another entry and expects all the required fields, including Account.
To fix the error remove the extra total row from your CSV file.
Amortization end date cannot be before amortization start date
The Start Date and End Date fields on a Journal Entry form are only available when the Revenue Recognition feature is enabled under Setup > Company > Enable Features > Accounting.
In the CSV file, check the dates entered in the Start Date and End Date columns. The start date must be before the end date. Modify the CSV file as needed.
Rounding Error xx.xx
To correct the error:
-
Remove amounts with value = 0.00 in the Debit or Credit column.
-
NetSuite formats columns to expose additional decimal places. Even if your CSV shows 0.00, there might be hidden decimals from the original export.
-
If there is already an amount on the Debit side for the line item other than zero, there is no need to enter zero (0.00) in the Credit side, and vice versa.