Skip to main content

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.