Download Reconciliation Statements
Account Reconciliation generates comprehensive reconciliation statements in Excel format that document the complete reconciliation process. The export options and contents differ depending on whether the reconciliation is a bank account reconciliation or a manual reconciliation.
The downloaded statements can be used for:
Audit documentation and evidence
Management reporting and presentations
Variance analysis and investigation
Sharing reconciliation details with stakeholders
Archiving completed reconciliations
The exported Excel file includes the following information based on reconciliation type:
Content |
Bank Account |
Manual |
|---|---|---|
Account details and period information |
✓ |
✓ |
GL Balance |
✓ |
✓ |
Support Balance (bank statement or manual entry) |
✓ |
✓ |
Matched transactions with GL and bank details |
✓ |
— |
Unmatched transactions or line items |
✓ |
✓ |
Carryover items from previous periods |
✓ |
✓ |
Workflow history (preparer, reviewer, approver) |
✓ |
✓ |
Comments from all workflow stages |
✓ |
✓ |
Export Statement for Bank Account Reconciliation [v26.2]
For bank account reconciliations, the export opens the Export Reconciliation Statement dialog, where you choose how the statement workbook is rendered before exporting.
To download a bank account reconciliation statement:
Navigate to the Reconciliations module.
Locate the reconciliation you want to export.
-
Click the Export to Excel icon (down arrow) in the Actions column.
The Export Reconciliation Statement dialog opens, providing the following options:
Option
Description
Sections
Selects which lines to export: Full statement, Unmatched only, or Matched only.
Detail level
Selects the level of detail: Summary only or Summary + detail. Full statements always include detail tables.
Include statement first-page image
When enabled, includes the bank statement first-page image in the export.
Description max length
The maximum number of characters for line descriptions. Default is 100.
Under Sections, select Full statement, Unmatched only, or Matched only.
Under Detail level, select Summary only or Summary + detail.
Enable or disable Include statement first-page image.
Set the Description max length if required.
-
Click Export.
The statement downloads automatically to your default downloads folder.
Export Statement for Manual Reconciliation
For manual reconciliations, the statement is exported directly to Excel.
To download a manual reconciliation statement:
Navigate to the Reconciliations module.
Locate the reconciliation you want to export.
-
Click the Export to Excel icon (down arrow) in the Actions column.
The statement downloads automatically to your default downloads folder.