Cash and Bank Balance Position Report
Report Module Guide: Cash and Bank Balance Position Report
Module Location
Finance > Reports > Cash and Bank Balance Position Report
Module Objective
The Cash and Bank Balance Position Report module is used to generate a report that displays the ending balance of all cash and bank accounts the company holds as of a specific date. This report provides a quick and comprehensive overview of the company's total liquidity position (cash and cash equivalents).
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:
-
Company:
-
Select the company whose report you wish to see from the dropdown.
-
-
Period:
-
Specify the report's date range. The To date is the "as of" date at which the balance will be displayed.
-
-
Currency:
-
Set the currency preference for the report, whether to use the base currency or the transaction currency rates.
-
2. Steps to Generate the Report
Step 1: Set Report Parameters
Define the parameters you need, especially the To period which will be the reference date for the balance position.
Step 2: Generate the Report
After all parameters are set, click one of the two buttons at the bottom:
-
[Display Report]: To preview the balance position report directly on your screen.
-
[Export to MS Excel]: To download the report data in an Excel file format.
3. Report Content (Conceptual)
The generated report will be a simple list that will most likely display:
-
Account Code (Cash/Bank).
-
Account Name (e.g., 'MAIN CASHIER', 'BANK BCA IDR', 'BANK MANDIRI USD').
-
The Ending Balance as of the selected date.
-
A grand total of all cash and cash equivalents.
Tips & Important Notes
-
This report is crucial for daily liquidity management.
-
Use this report to provide a quick overview to management regarding the company's current cash position.
-
This is a very frequently used operational report by the Treasury and Finance Management teams.