Reconciliation report

This report provides the necessary information to reconcile accounting transactions related to securities. For each selected security account, it summarizes the movements associated with that security, allowing you to compare all recorded transactions with the totals calculated by the program.

Alongside the totals, there is a "Differences" field that highlights any discrepancies between the recorded transactions and the calculated totals. This amount should be zero; otherwise, it indicates that there is an inconsistency in the accounting records.

Selection Dialog

Select the account(s) for which you want to view the reconciliation

Report structure

The structure of this report is similar to that of the security card, as it includes all movements for each security. The only additional column identifies the accounting account associated with each security.

For each security account, the report provides summary totals after listing the movements:

• Opening Balance: Opening Balance of the security account
• Current Balance: Current balance of the security account returned by the program.
• Total securities movements: Sum of the total movements concerning the security (should correspond to the current Balance)
• Differences: Shows the difference between the balance reported in the field Current Balance and the total movements, if everything is correct the amount is equal to zero

Error Messages

• Items table not found: The Items table is not present in the accounting file
  • Add the Items table to your file.
• No Asset found in the Items table: The Items table does not contains any Asset.
  • Add Assets to the Items table.
  • A valid Asset must have an ID and an Asset Account.
• No Asset accounts found in the Items table: No Asset accounts have been assigned to the assets in the Items table.
  • Define an Asset account for each Asset in the Items table using the Asset Account column.

Compatibility version

Minimum required version of Banana Accounting to use this extension: 10.2.1.

You can check your current version of Banana Accounting from the menu: Help > About Banana Accounting+ > Version.