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.
Solution
Follow these steps to resolve the issue:
- Open the CSV file
- Locate the Debit and Credit columns.
- Group all Debit lines together, followed by all Credit lines, or vice versa. Avoid intermixing debit and credit entries.
- Double-check that the totals still balance correctly.
- Save the updated CSV file.
- Re-import the file using your preferred method.
Tips:
- Ensure only one of the Debit or Credit columns has a value per line (the other should be blank or zero).
- Sort by a custom column (e.g., "Line Type") to help organize Debit and Credit lines consecutively.
- Avoid blank rows or improperly formatted numerical values (e.g., currency symbols, commas).
For example:
Hope this helped!