Account Reconciliation

This page describes the Account Reconciliation report in the Nominal Ledger.


You will most commonly use this report to help with the task of bank reconciliation, which you should do using the 'Account Reconciliation' window. The report is a list of Transaction rows (i.e. individual account postings) for the report period in date order, showing for each the Account, Transaction Number and Date, Amount in either Base Currency (as selected) and Amount in foreign Currency (where appropriate). You can choose whether the report will list reconciled or unreconciled postings or both. If you choose both, reconciled or unreconciled postings will be shown in separate sections.

You can also produce this report from the 'Account Reconciliation' window, by selecting 'Account Reconciliation Report' from the Operations menu (with 'cog' icon, Windows/macOS) or Tools menu (with 'wrench' icon, iOS/Android). When you produce the report in this way, the specification window will not appear. Instead, the report will be produced for the Account, Tags/Objects and Reconciliation Code that you have entered in the 'Account Reconciliation' window, and the selection of the Reconciled and Unreconciled options will also be taken from the 'Account Reconciliation' window. You should therefore supply this information in the 'Account Reconciliation' window before producing the report.

When printed to screen, the Account Reconciliation report has the Standard ERP Drill-down feature. Click (Windows/macOS) or tap (iOS/Android) on a Transaction Number in the report to open a Nominal Ledger Transaction. If the Nominal Ledger Transaction was created from a Sub System record (e.g. from a Receipt or Payment), you can then open the Sub System record by selecting 'Open Subsystem Record' from the Operations or Tools menu.

Paste Special    Reporting Periods setting, System module
The report will list the postings (i.e. the Transaction rows) made during the period that you specify here. The default value is the first period in the Reporting Periods setting.

Using the Reconciled and Unreconciled options below, you can choose whether reconciled or unreconciled postings or both will be included in the report. By default, the period specified here will be used for both reconciled and unreconciled postings. However, if you are using the Ignore Period Start Date for Unreconciled Transactions option in the Reconciliation Settings setting, the start of the period will be ignored when listing unreconciled postings. All unreconciled postings up to the end of the specified period will be listed.

Paste Special    Account register, Nominal Ledger/System module
Range Reporting    Alpha
Use this field to limit the report to Transaction rows posting to a certain Account, or range of Accounts. Usually you will only need to specify your Bank Account(s) or other reconcilable Account here, otherwise the report will be much longer than necessary.

In multi-user systems, you can use Access Groups to prevent the postings to sensitive Accounts such as salary Accounts being listed in this report, depending on the user producing the report. To do this, list the sensitive Accounts in the Block A/Cs field in each Access Group as appropriate.

Paste Special    Tag/Object register, Nominal Ledger/System module
Specify a Tag/Object here if you need the report to list Transaction rows with a particular Tag/Object. If you enter a number of Tags/Objects separated by commas, only those Transaction rows with all the Tags/Objects that you have listed will be shown in the report.

Recon. Code, Exclude with Code
If you want to list reconciled Transaction postings with a particular Recon. Code, enter that Recon. Code here. To list all reconciled postings except those with a particular Recon. Code, tick the Exclude With Code box as well.

Reconciliation Codes are arbitrary codes that you can use to identify postings that you have reconciled on a particular day or from a particular bank statement. Specifying a Reconciliation Code here will therefore allow you to list those postings if you need to check them at a later date.

This field and check box will have no effect if you are only listing unreconciled postings.

Select this option if you need reconciled postings to be included in the report.

Select this option if you need unreconciled postings to be included in the report. You must select at least one of the Reconciled and Unreconciled options or the report will be blank.

Show Recon. Comments
When you reconcile each posting, you can mark it with a Reconciliation Code. The Reconciliation Code that you use might be connected to a longer description in the Reconciliation Descriptions setting. Select this option if you want these longer descriptions to be included in the report.

Values in
If you are using the Dual-Base system, use these options to specify whether the values in the report are to be shown in Base Currency 1 or 2.

If you are not using the Dual-Base system, use the Base Currency 1 option to produce a report in your home Currency.

You can choose to have Descriptions or Tag/Object Codes included in the report. If you choose the

Descriptions option, the Description from each Transaction row will be shown together with the Text from its Transaction header.

Note that the calculation of the Reconciled Before Period, Reconciled During this Period and Reconciled Balance at End of Period figures assumes postings are reconciled on their Transaction Dates rather than their Reconciliation Dates.


Reports in the Nominal Ledger:


Go back to: