While importing journal entries, the error “Invalid account reference key ___ for subsidiary ___” may sometimes occur. To resolve this error, Check the below conditions:
- Verify the format of the Account field.
- Ensure that the account is active in NetSuite.
To verify the format of the Account field in the CSV file by comparing with NetSuite:
- Go to Transactions > Financial > Make Journal Entries.
- From the Account dropdown list, select the account that is provided in the csv file. Ensure that the format of the account in the file matches the format of the account name displayed in journal lines.
To check whether the account is inactive:
- Go to Lists > Accounting > Accounts.
- Check the Show Inactives box of needed accounts.
- Check the Internal ID that was referenced in the error message.
- If account is inactive, then clear the Inactive box for the account.
- Also verify that the account is associated with the correct subsidiary.
Always map the internal ID of any records to avoid such csv import errors. If the internal ID is used, on the field Mapping page of csv import, click the edit icon beside the Account field. Click Choose Reference Type, and then select Internal ID.