Monday, September 17, 2018

CSV Import > Add > Journal Entry > CSV Response: 'The amounts in the journal entry must balance'

1. Make sure that the Debit and Credit amounts are not on the same line.
 

Example: 

Account            Debit  Credit

AR-Store Sales 21.90  21.90

 

Should be:

Account             Debit  Credit

Account 1          21.90

Account 2                    21.90

 

Or

2. For Multiple Journal Entry Import, ensure that the External ID for the Debit and Credit per journal entry is the same.

Example:

External ID       Account             Debit  Credit

1234                Account 1          21.90

12345              Account 2                    21.90

Should be:

External ID       Account             Debit  Credit

1234                Account 1          21.90

1234                Account 2                    21.90

Or

3. The Total amount for the Debit and Credit columns of the CSV file must be equal. 

No comments:

Post a Comment