Skip to main content

Bank Transaction Report

Lists every deposit and withdrawal of your bank accounts in a date range, with the running balance of each account.

Menu: Reports › Financial Reports › Bank Transaction Report

Required permission
Reports › Bank Transaction Report › View

What it's for​

Use it to reconcile CIRMS with the bank statement. It includes payments and collections by bank transfer or check, bank deposits of cash, POS card payments and bank transactions entered in Bank Transaction. Filter by Transaction Type to see only one kind.

Example

The bookkeeper compares the report for account BDO Savings 1234 with the bank statement for March. The statement shows a deposit of 18,000.00 on 12 March that is missing in the report: a collection by bank transfer was never recorded, so she asks the branch to create it.

Options on the screen​

  • From / To: the period, and the bank accounts and branches to include.
  • Transaction Type and Payment Type (in the filters).

Filters​

Click Filters to narrow the report. You can filter by:

Transaction Type, Payment Type.

Columns​

ColumnWhat it shows
Bank AccountThe bank account.
ParticularThe customer, supplier or description of the movement.
InMoney deposited or received.
OutMoney withdrawn or paid.
BalanceThe account's running balance.
RemarksThe transaction's remarks.
Other InfoThe transaction's sheet number, reference and remarks.

Also shows: Date, Branch.

For searching, express filters, sorting, column settings, exporting and printing, see About reports.

TEST SITE