Resolve the Error: Journal Entry Import Error: “The amounts in a journal entry must balance.

Scenario

Imported Trial Balance through a Journal Entry and received an error “The amounts in a journal entry must balance.”

If we are able to verify the amounts balances in the CSV file and all values in the cell are valid, the format maybe the issue.

Solution 1

1. Create a csv file for Journal import which must include Account, Currency, Date, and Amount (Debit Amount & Credit Amount).
2. Navigate to Setup > Import/Export > Import CSV Records
3. On the Import Assistant page:
   1. Step 1: Scan & Upload CSV File
      1. Import Type = Transaction
      1. Record Type = Journal Entry
   1. Step 2: Import Options
      1. Data Handling = Add
   1. Step 4: Field Mapping
      1. Account <=> Journal Entry Line: Account
      1. Currency <=> Journal Entry: Currency
      1. Date <=> Journal Entry: Date (Req)
      1. Amount <=> Journal Entry Line: Debit
   1. Step 5: Save & Run

Remove the Entry No. line in the field mapping to create a single journal entry. Can be imported even if the Amount Credit is not included in the field mapping.

When trying to import Multiple Journal Entry Import, External ID or Document Number for the Debit and Credit per journal entry should be the same.

Solution 2

All Debit lines should be listed in the CSV File consecutively as well as the Credit lines. The system reads the lines in the import consecutively so if the debits are listed first in the file, it is expected that there are no debit lines after the credits as well.