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.
No comments to display
No comments to display