Language:


Bank Reconciliation

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

---

The Bank Reconciliation report is one of two reports in the Nominal Ledger that you can use to help with the task of reconciling bank statements, the other being the Account Reconciliation report. Use the Account Reconciliation register to reconcile bank statements.

The Bank Reconciliation report is a list of unreconciled postings to a specified Bank Account from a specified period. An unreconciled posting is one that you have not reconciled to a transaction on your bank statement using the Account Reconciliation register. The report divides the unreconciled postings into three groups: Outstanding Payments; Outstanding Receipts; and Bank Charges. The third group includes all postings that do not fall into the other two groups (e.g. bank interest, transfers between bank accounts, salary payments).

When producing the report, you will enter the closing balance from your last bank statement. The report will display a new balance, calculated from that figure and including the unreconciled postings. This new balance will be compared to the balance for the Bank Account in your database on the last day of the report period. If the two balances are different, the probable reason is that there is still at least one unreconciled posting that you can reconcile with the bank statement.

When printed to screen, the Bank Reconciliation report has the Standard ERP Drill-down feature. Click (Windows/macOS) or tap (iOS/Android) 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 (Windows/macOS) or Tools menu (iOS/Android).

Period
Paste Special    Reporting Periods setting, System module
Specify the report period. This should be sufficient to include all unreconciled postings to the Bank Account.

Note that a posting to the Bank Account that you made during the report period and that you reconciled after the report period will be treated as unreconciled. The report period may therefore need to have an earlier start date than that of the bank statement you are working from.

Pay Mode
Paste Special     Payment Modes setting, Sales/Purchase Ledger
Enter a Payment Mode: the report will list all unreconciled postings to the Account shown on flip A of this Payment Mode.

The report will be empty if you do not specify a Payment Mode.

Balance
Enter the closing balance from your last bank statement. The report will calculate a new balance that takes the unreconciled postings into account. This new balance is then compared with the current balance for the Account in the Payment Mode specified above.

Values in
If you are using the Dual-Base system, values in this report can be shown in either Base Currency. Use these options to choose which Currency is to be used on this occasion.

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

---

Reports in the Nominal Ledger:

---

Go back to: