Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
NSC | Tips on Importing a Journal Entry with Multiple Debits and Credits
Scenario
When importing Journal Entries using either the Single Entry Import feature or the Import Assistant, the system may return the following error message:
"The amounts in a journal entry must balance."
At first glance, this may suggest a discrepancy between the total debit and credit amounts. However, after verifying that:
- The debit and credit totals are equal,
- All required fields are populated correctly, and
- All values in the CSV are valid,
…the issue may actually lie in how the entries are structured or formatted in the CSV file.
The system processes journal entry lines sequentially, meaning it expects the order of debits and credits to be logically grouped. If, for example, debit lines are listed first, then credit lines must follow without any further debit lines afterward. Alternating or out-of-order entries can disrupt the system's ability to validate the balance, even if the totals are correct.