Scenario:
A user experienced an issue during the import of an amortization journal entry, triggering the error message: "The amounts in a journal entry must balance." Despite the user's verification that the entries were balanced across subsidiaries and in total, the error remained unresolved. They questioned whether unique external IDs were required for each entry and requested assistance with troubleshooting this specific concern.
Solution:
To resolve this error, here are the following things you can check:
1.CSV File Format: Ensure that the "Debit" and "Credit" amounts are not listed on the same line in the CSV file. Instead, they should be on separate lines, as demonstrated below:
Example:
Account | Debit | Credit
Account 1 100.25
Account 2 100.25
2. Multiple Journal Entry Import: When importing multiple journal entries, verify that the "External ID" for the Debit and Credit transactions within each journal entry is identical.
3. Total Amount Balance: The sum of the "Debit" and "Credit" columns in the CSV file must be equal, indicating a balanced journal entry.
-----
If you find this information useful, let us know by reacting or commenting on this post!