CSV Import of journal entry error message: The amounts of this journal entry must balance by location.

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.

  1. The Dept./Class/Location set on the Debit journal entry is different from the Credit counter part.
  2. The number of decimal places set in the journal entries amount are different (e.g.  Debit – 55.20 and Credit – 55.200)

Leave a comment

Your email address will not be published. Required fields are marked *