'Error in record x: Contributes to an unbalanced journal for date (credits exceeds debits by x.xx)' when importing into Sage Accounts
Description

When importing data into Sage 50 Accounts, you can receive the following file import errors:

Error in record x: Contributes to an unbalanced journal for date (credits exceeds debits by x.xx)

Error in record x: Contributes to an unbalanced journal for date (debits exceeds credits by x.xx)

Error in record x: contributes to an unbalanced journal for 24/09/2019 (credits exceed debits by xx). Transactions must be contiguous and on the same date. Editing of journals is also possible when references match.

Error in record x: contributes to an unbalanced journal for 24/09/2019 (debits exceed credits by xx). Transactions must be contiguous and on the same date. Editing of journals is also possible when references match.

NOTE: See a list of other import errors.

Cause
Resolution

In Sage 50 Accounts, ensure journal transactions have matching debit and credit amounts, and post all elements on the same date.

This message appears for the following reasons:

Reason Solution
You're trying to import a journal transaction that doesn't balance.

For example, you import a journal credit but no corresponding journal debit.

If the journal doesn't balance, you must either:
  • Change the transaction type for the affected transaction. For example, if you're entering a bank transaction, use BP or BR
  • Delete the affected transaction
  • Create an entry for the balance using the opposite journal type. For example, if you enter a journal debit for 100.00, enter a journal credit for 100.00 on the same date

You're trying to import a balanced journal but the entries are separated in the import file.

List related journal transactions together in the import file. Ensure all relevant journal debits and credits are together and not separated by other transactions.
You're trying to import a journal that balances but by using the tax amount field. When importing a journal, the net amount values must balance. If you're using the tax amount to make up part of the balance, move the value to the net column.

For example, a journal credit is 120.00 net and a journal debit is 100.00 net with tax of 20.00. Change the journal debit to 120.00 net as the import only includes net amounts.

TIP: If you're importing gross amounts, split the journal further by posting values to the Sales or Purchase Tax control accounts.
One line of a journal has a different date to the rest. If another journal transaction balances the journal on a different date, change the dates to match.
Steps to duplicate
Related Solutions