There are two possible reasons why a CSV results to an error: “The amounts of this journal entry must balance by location”.
Enable the preference Allow Non-Balancing Classifications in Setup > Accounting > Preferences > Accounting Preferences > General Tab > Classifications. Checking this box means that the user prefers NetSuite to not require Journal Entries to balance by Department, Class, Location or modify the entry when performing a journal entry import.
- The Dept./Class/Location set on the Debit journal entry is different from the Credit counter part.
- The number of decimal places set in the journal entries amount are different (e.g. Debit – 55.20 and Credit – 55.200)