Language:


Individual Reports - Account Reconciliation

The Account Reconciliation report is included in the following Standard products:
  • Standard Accounts (Nominal Ledger module)
---

You will most commonly use this report to help with the task of bank reconciliation, which you should do using the Account Reconciliation register. 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 and whether it has been reconciled.

You can also produce this report from the Account Reconciliation register, by selecting 'Account Reconciliation' from the Operations menu.

When printed to screen, the Account Reconciliation report has the Drill-down feature common to many reports in Standard products. Click on a Sub System Number (e.g. Invoice Number) in the report to open the Nominal Ledger Transaction for that Sub System record. You can then open the Sub System record itself (e.g. the Invoice) by selecting 'Open Subsystem Record' from the Operations menu.

Period
Paste Special    Reporting Periods setting, System module
All Transaction rows whose dates fall in the period entered here will be included in the report. The default value is the first period in the Reporting Periods setting.

Accounts
Paste Special    Account register, Nominal Ledger
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 need to specify your Bank Account(s) or other reconcilable Account here, otherwise the report will be much longer than necessary.

Balance Date
Paste Special    Choose date
Two totals are shown for each Account: the total reconciled from Transaction rows whose dates fall within the report period and the total reconciled from Transaction rows whose dates fall before a certain date. Specify that date here.

Reconciled
Check this box to include reconciled Transaction rows in the report.

Unreconciled
Check this box to include unreconciled Transaction rows in the report. At least one of the Reconciled and Unreconciled boxes must be checked or the report will be blank.
---

In this chapter:

Go back to home pages for: