Cash Book Transaction

Report Module Guide: Cash Book Transaction Report

Module Location

Finance > Reports > Cash Book Report

Module Objective

The Cash Book Transaction Report module is used to generate a "Cash Book" or "Bank Book" report. This report details all transactions, both inflows and outflows, that occurred on a specific cash or bank account within a single period. It is a fundamental report for daily cash monitoring and the reconciliation process.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Transaction Type:

  • Filter the report to display ALL transactions, or only Inflows or Outflows.

• Cash Book Account:

  • This is the primary filter to select the specific cash or bank account whose report you want to view.

• Start Date / To:

  • Specify the transaction date range to be displayed (e.g., September 1, 2025, to September 30, 2025).

• Approval status:

  • Filter transactions based on their approval status.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially selecting the Cash Book Account to be checked and specifying its date range.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the cash book report directly on your screen.

• [View via Excel]: To download the report data in an Excel file format.

3. Report Content (Conceptual)

The generated report will resemble a cash book or bank statement format, which will most likely display:

• Transaction Date

• Description / Narration

• Document Reference Number

• Debit column (for outflows)

• Credit column (for inflows)

• Running Balance

Tips & Important Notes

• Use this report to perform an internal reconciliation before comparing it with the actual statement from the bank.

• This report is a recapitulation of all transactions recorded in the Bank/Cash Receipt and Bank/Cash Disbursement modules.

• This is a crucial daily operational report for the Treasury and Accounting teams to monitor cash and bank positions.