Check and recalculate accounting

Documentation •
In this article

The command to recalculate and check your accounting can be called up as follows:

  • with the Shift + F9 keys (Windows and Mac) or Cmd + 9 (Mac)
    Primary accounting recheck
  • with the Actions menu → Check accounting command
    This solution includes several extensive control options - Extensive accounting recheck
  • Display the Balance column through the Data menu → Columns setup.

If there are error messages or differences you should correct them.

Primary accounting recheck

The Check Accounting command mainly checks the version in use and, if an updated version is available, the program prompts you to update to the latest version. We strongly recommend updating as many features have been improved and different problems solved.

The recalculate and recheck accounting function will execute the following operations:

  • Reset the accounts balances, as well as the cost centers and segment balances
  • Verify and report if there are errors in the various tables (Accounts, Transactions, VAT Codes and Exchange rates tables)
  • Re-enter all the operations as if they were being entered for the first time
    • for the multi-currency accounting, it will recalculate the opening balances in the basic currency using the latest exchange rates
    • if the transactions rows are not locked, it will recalculate all transaction rows:
      • the VAT percentages are taken over from the VAT Codes table and the VAT amounts are recalculated again
    • Update the account balances, as well as the cost centers and the segment balances
    • In the Cash Manager, the progressive account balance in the Transactions table is recalculated
  • it will recalculate the Accounts and Categories table totals (income and expenses)
    • it will update the Diff. Budget and the Previous year columns
    • In the multi-currency accounting, it will update the Balance Calculated column in line with the latest exchange rates and the exchange rate differences.

Extensive accounting recheck - the Check Accounting window

On top of the principal recalculation and recheck of the accounting, additional checks are executed.

Check Accounting image

Recalculate accounting plus additional checks

This is one of the most useful features: the entire accounting file is being rechecked, all the balances are recalculated and the user is notified if errors are found. The command also updates the texts in the Account Descriptions and Categories columns (Transactions table), if these have been changed.

Accounting properties

This option is being activated by default. The program verifies whether the data entered into the File and accounting properties correspond to the actual accounting (for example: opening and closing date, VAT account, accounts for exchange rate differences, etc.).

Transactions

Differences within transactions

If this option is activated, the program verifies whether there are differences between Debit and Credit or between Accounts and Categories in the Income & Expense Accounting.

  • The rows where the differences occur are being indicated in the Messages Window.
  • The Balance Column shows the difference between the debit and credit movement. If there is an error, the balance does not go to zero.
  • Also, the program shows the total difference amount in the Information window at the bottom of the screen (only when being positioned in the Transaction table).

Include intermediary differences

If this option is activated, the program verifies whether there are differences between Debit and Credit, in composed transactions (transactions over multiple rows).
Often differences are caused by incomplete entries or errors in the amounts (as for example in the following example).

differenze nelle registrazioni

 Balance checks (#CheckBalance)

By activating this check, the program will signal wether the balance indicated in the description is different from the accounting balance on the indicated data. 
The transactions #CheckBalance are used to indicate that the account balance on a determinate date is correct.
At the end of the month, quarter or year it is useful to create #CheckBalance postings for the cash and bank accounts. The #CheckBalance transactions are also useful in conjunction with the lock transactions command.
Using the #CheckBalance transactions you will notice if, after closing the period, incorrect transactions have been made..

Characteristics of #CheckBalance transactions

  • Date. Must be the date the balance refers to.
  • Description must contain
    • #CheckBalance followed by the account balance, including decimals.
      #CheckBalance -1200.00
      #CheckBalance  0.00
    • For multi-currency accounting, the wording #CheckBalance followed by the currency abbreviation and the account balance, including decimals.
      #CheckBalance  CHF -1200.00
      #CheckBalance  EUR 0.00
      #CheckBalance -1200.00 Without the currency code, the check is done on the basis of the balance of the base currency.
  • Debit Account indicates the account on which the verification is to be carried out.
  • Amount must be left blank.

The program has detected a difference between the checking balance and the account balance in the file.

CheckBalance

Same document with different dates

When this option is activated, the program will alert if transactions with the same Doc number have a different date. For transactions on more than one row, where there is no correspondence between Doc and Date, the program cannot correctly determine the counterpart.

Accounts

Chart of accounts structure

When this option is activated, the program checks whether the grouping structure in the Chart of Accounts is correct.

Existence of exchange rate differences

When this option is activated, the program checks whether there are unrecorded exchange rate differences.

Opening balances differ from last year's balances

When this option is activated, the program verifies whether the opening balances of the new year match with the closing ones of the previous year. If there are differences between the closing balances of the previous year and the opening balances of the new year, these are reported as a total amount in the Messages window.

Personalized checks (Banana Extensions)

When this option is activated, the program runs checks on the functions that have been added by user (Extensions), for customized verifications.

Include additional checks with the shortcut Shift + F9

When this option is activated, the program will run all the checks activated in the dialog window, when pressing Shift+F9. Otherwise only an accounting recalculation will be done (Mac version: Shift + Cmd + 9).

 

help_id
dlgcontrollaconta

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