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.
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.
|
||||||||
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.
|
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).
Reconcile bank statements
Once you have printed the Cash Book Reconciliation Statement:
Compare the Cash Book Reconciliation Statement to the statement you received from your bank.
Mark off the transactions processed by the bank as per their statement on the Reconciliation Statement.
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.
Reconcile all transaction that appear on the bank's statement and on your Reconciliation statement, using the Cash Book Deposits & Withdrawals program.
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.