Bank Reconciliation Report

Report Module Guide: Bank Reconciliation Report

Module Location

Finance > Reports > Bank Reconciliation Report

Module Objective

The Bank Reconciliation Report module is used to print, view, and export the final report from a Bank Reconciliation process that has been completed. This module is the means to generate the formal document from a reconciliation that has been previously created and approved in the Bank Reconciliation module.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to find and generate a specific reconciliation report.

Here is an explanation for each parameter:

• Account:

  • The primary filter to select the specific bank account whose reconciliation report you want to generate.

• Reconciliation Date:

  • Specify the From and To date range to find reconciliation documents that were created in that period (e.g., October 1, 2025, to October 31, 2025).

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially selecting the bank Account and specifying the appropriate Reconciliation Date.

Step 2: Generate the Report

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

• [Display Report]: To preview the bank reconciliation 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 have the standard format of a Bank Reconciliation Report, which displays:

• Balance per Bank (Bank Statement Balance).

• Add: Deposits in Transit.

• Less: Outstanding Checks.

• Adjusted Bank Balance.

• Balance per Company (General Ledger Balance).

• Add/Less: Reconciling items (e.g., Bank Fees, Interest Income).

• Adjusted Company Balance.

Both adjusted balances must ultimately show the same figure.

Tips & Important Notes

• This report can only be generated if the reconciliation process for that account and period has been completed and approved in the Bank Reconciliation module.

• This is a very important audit document and serves as proof that internal control over cash has been properly executed.

• Save this report, either in printed or digital form, as part of the monthly book-closing documents.