Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
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.