NSC | Amortization CSV Import Resolve Error: "The amounts in a journal entry must balance"

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: