Cash Book > Reports > List of Bank Balances

List of Bank Balances

You use this program to generate a report of balances for each bank currently defined.

Report Options

Field Description
Bank balances as of Select the month for which you want to generate the report.

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.

Selection criteria

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

Indicate the currency(ies) for which you want to print the bank balances.

The listing includes the balances for the selected currency only.

A specific Currency can only be entered if you selected the setup option Foreign currency cash book required (Cash Book Setup) and if you selected to include All banks in the report.

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).

Report Details

The following columns are included in the report:

  • Statement balance - indicates the sum of all reconciled deposits and withdrawals to date.
  • Outstanding deposits - indicates the sum of all unreconciled deposits to date.
  • Outstanding withdrawals - indicates the sum of all unreconciled deposits to date.
  • Current cash book balance - indicates the sum of the last Statement balance plus the outstanding deposits and outstanding withdrawals to date.
  • Local equivalent - indicates the local currency equivalent of the Current cash book balance to date. This column is only displayed if the Foreign currency cash book required setup option is enabled in the Cash Book Setup program.

The balances on this report should balance to the corresponding General Ledger control accounts for these banks for the same period, provided the General Ledger has been updated with all Cash Book transactions processed up to the time of generating this report. In addition, the values in the Current cash book balance column should equal the final balance printed on the Cash Book Reconciliation Statement for each bank over the same period.