Reconciliation Report
Objective: Gain an understanding of the Reconciliation Report and how to run it.
NOTE This Reconciliation Report is identical to the Reconciliation Report available in the Accounting module. By making this report available in both modules, users with access to either module are able to run the report as needed.
The Reconciliation Report is generated in order to confirm that the Valuation records match with the Accounting records. The purpose of account reconciliation is to provide accuracy and consistency in financial accounts.
In Brightly Assetic, the Reconciliation Report is carried out at the component level to show the latest changes made to an Asset.
Steps to Generate a Reconciliation Report:
In the Navigation Sidebar, select 'Valuations' to load the Valuations Dashboard, then select 'Report' from the Reconciliation menu in the top right.
This loads the Reconciliation report.
Green tiles indicate that Valuation and Accounting records match, while red tiles indicate that there is some variance between the two. For any Asset Category where there is variance, the 'details' button can be used to open the Reconciliation Detail Report for that Asset Category in a new tab.
The report information contained in the 'Variance due to unprocessed Valuation Records' can also be exported using the 'Export detail report' button.
Back on the main Reconciliation Report, Basic Mode can be enabled from the Actions menu:
Turning on Basic Mode allows the report to be grouped by the available Financial Class/Subclass, and exported:
Click on the 'Export all transactions' button to export the Valuation Ledger Report (Fair Value) details into an Excel sheet.
A confirmation message will be displayed after the export has started:
To view the exported report, click on the 'Reconciliation' drop-down in the top right, and select 'Exported Reports':
Click on the menu icon for each report to download or delete that report export:
The downloaded export will be a zipped file, so users will need to unzip it to access it.
