Balance column to detect accounting differences

Documentation •
In this article

The Balance column is present in the Transactions table in the double-entry accounting, multi-currency accounting, income/expenses accounting, and cash manager files. It is very useful because it detects accounting discrepancies in the Transactions table. 

When accounting discrepancies are encountered, it is essential to identify the cause and proceed with the correction. 

Errors are likely due to the following reasons:

  • The cell where the Debit account, Credit account, or Category is recorded was inadvertently left blank or is incorrect.
  • For an entry spanning multiple accounts or categories, the total amounts do not match.
  • In an entry with a VAT code, the VAT breakdown or the VAT account is incorrect.

Note: In composed transactions of several rows, the program will display a difference between Debit and Credit until the entry is completed.

▶ Watch the video: The new Balance column

The Balance column in Double-Entry Accounting

In double-entry accounting, the Balance column shows the differences between the Debit and Credit columns. 

When the accounting is correct, the Balance column should have no value (empty cells):

  • The balance is zero if the sum of the amounts in the Debit and Credit columns offset each other (no difference).
  • For entries spanning multiple accounts, a balance is displayed until the entry is completed for all the accounts and/or categories involved. With the final entry, the balance should reach zero.

Balance column

In the example image, a difference of 150 was generated:

  • In the entry on line Doc 1, the account 4999, which does not exist in the chart of accounts, was entered; therefore, a difference of 100 was created in the Balance column on the same line.
  • In the entry spanning multiple accounts on the lines Doc 2, the total amount paid is 1,000, but the final entry does not zero out the total amount (1,000) between the Debit and Credit columns, because the counter entries total 950; thus, an additional difference of 50 is added, leading to a total difference of 150.

The Balance column in Income/Expense Accounting

In Income/Expenses Accounting and Cash Manager, the Balance column shows the differences between the Account and Category columns.

When the accounting is correct, the Balance column should have no value (empty cells):

  • The balance is zero if the sum of the amounts in the Account and Category columns offset each other (no difference).
  • For entries spanning multiple accounts, a balance is displayed until the entry is completed for all the accounts and categories involved. With the final entry, the balance should reach zero.

balance column

In the example image, a difference of 1000 was generated:

  • In the entry on line Doc 2, the category was not entered in the Category column. Therefore, the amount, having been recorded only in the Account, resulted in a difference of 1000.

Checking the Accounting

The Check accounting command also includes a check of the Balance column.

If the Balance column is not zero, it means there are errors. To locate the first row where the accounting discrepancy occurred:

  • Scroll through the Balance column to identify the first row where the discrepancy starts.
  • Use the Recalculate accounting command, which indicates the row where the discrepancy begins.

Help us improve the documentation

We welcome feedback on how to improve this page.

Tell us what theme needs a better explanation or how to clarify a topic.

Share this article: Twitter | Facebook | LinkedIn | Email