Reconciliation Report¶
The Reconciliation Report allows a comparison between the opening and closing balances, as well as the composition of the outstanding items of a financial conciliación.
This report is especially useful for the analysis of bank reconciliations and allows the customization of titles and the inclusion of the company logo in order to make the report more user friendly.
Report Structure¶
The report is composed of the following key elements:
Beginning Balances
Represents the opening balance before considering the reconciled transactions, obtained from table 1.
It can be configured for each conciliación either automatically or manually.
Pending items
They are presented in addition and subtraction, reflecting the movements not yet reconciled.
They allow a detailed control of the records that affect the conciliación.
Closing Balance
It represents the final balance, after adding the transactions pending from conciliar.
In the case of different starting balances, this difference will also be reflected in the final balance of the report.
Where do you get the data from?
From the initial balances, adding the outstanding reconciling items, the system reproduces the composition of the final balance. For its correct functioning it is necessary to define which columns of both tables will be used for the operations and to load the initial balances.
It is important to define correctly in the reconciliation which column is used for the calculation of the amounts in each table:
The company logo is parameterized in Configuration/Companies
The texts to be inserted as titles in the pending transactions, are parameterized in Configuration/Categories, in this way it is possible to customize the report according to the needs of the company and the reconciliation category.
Download Sample Reconciliation Report¶
You can download a sample file in Excel format to see how the report is structured:
Report Customization¶
Title Configuration
Each section of the report can be customized using text labels, allowing the terminology to be adapted according to the company’s needs.
Titles can be configured from the Categories section within the system.
Incorporation of the Corporate Logo
The report also allows the inclusion of the company logo, taken directly from the company’s configuration in the system.
Key Benefits
Full customization: Definition of titles and report structure.
Designed for bank reconciliations: Facilitates the control of records and balances.
Clear view of movements: Difference between reconciled and outstanding items.
Export in Excel and other formats: Allows auditing and detailed analysis.
Optimize your financial conciliación with this customizable and professional report!