Cash Book > Reports > Reconciliation Statement

Reconciliation Statement

You use this program to generate a list of all unreconciled deposits and/or withdrawals held within the Cash Book system.

This report is normally used to perform a preliminary reconciliation against the bank statement, before using the Cash Book Deposits & Withdrawals program to reconcile transactions.

Report Options

Field Description
Reconciliation as of

Reconciliation statement as of Indicate the Period for which you want to generate the reconciliation statement(s).

A drop down selection box is available, with the options Current month, Previous month 1 and Previous month 2. The default is the Current month.

OptionDescription
Current monthSelect this to generate the report for the current month.
Previous month 1Select this to generate the report for the previous month.
Previous month 2Select this to generate the report for the month before last.
Include option  
Include banks where all transaction have been reconciled Select this to print a reconciliation statement for those banks that have no unreconciled transactions. Only the bank balances are listed for these banks.

If you do not select this option, then banks with no unreconciled transactions are excluded from the report.

Include banks where the cash book balance is zero Select this to include banks with a zero-value bank balance and banks with a statement balance but where the cash book balance is zero.
[Note]

Selecting this option will always return all other banks with zero balances, regardless of any other selections made for this report.

Selection criteria

Field Description
Bank selection Indicate the bank(s) for which you want to print the reconciliation statement(s).

Output Options

These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).

Notes and warnings

Restrictions and limits

  • Banks with no unreconciled transactions are ignored by the program and will therefore not be listed in the report.

Reconcile bank statements

  • Once you have printed the Cash Book Reconciliation Statement:

    1. Compare the Cash Book Reconciliation Statement to the statement you received from your bank.

    2. Mark off the transactions processed by the bank as per their statement on the Reconciliation Statement.

    3. Make a note of items appearing on the bank's statement which do not appear on the Reconciliation Statement.

      Process these items using the Cash Book Deposits & Withdrawals program as reconciled items. These would typically be items such as bank charges.

    4. Reconcile all transaction that appear on the bank's statement and on your Reconciliation statement, using the Cash Book Deposits & Withdrawals program.

    5. Print a Cash Book Reconciliation Statement that reconciles the Cash Book to the bank statement and matches the Cash Book balance to the General Ledger balance.

      Since you will probably have entered transactions for the current period by the time you reconcile the previous month's transactions, the Bank Total on the reconciliation report will not match the General Ledger balance as of the end of the previous period. Use the last reconciled balance with a previous month's date to match the to General Ledger.

      You can use the GL Query program to obtain the General Ledger balances or alternatively print a GL Trial Balance report of the selected bank control accounts.