Download Reconciliation Statements

Account Reconciliation generates comprehensive reconciliation statements in Excel format that document the complete reconciliation process.

Download from Reconciliation List

To download a reconciliation statement:

1. Navigate to the Reconciliations module.

2. Locate the reconciliation you want to export.

3. Click the Export to Excel icon (down arrow) in the Actions column.

   

   The statement downloads automatically to your default downloads folder.

The exported Excel file contains the follwoing:

• For Bank Account Reconciliations:

  • Account details and period information

  • GL balance and bank statement balance summary

  • Complete list of matched transactions with GL and bank details

  • Complete list of unmatched transactions requiring attention

  • Carryover items from previous periods

  • Reconciliation workflow history with preparer, reviewer, and approver details

  • All comments added throughout the workflow

• For Manual Reconciliations:

  • Account details and period information

  • GL balance and manually entered support balance

  • Complete list of unmatched line items with descriptions

  • Carryover items from previous periods

  • Reconciliation workflow history with preparer, reviewer, and approver details

  • All comments added throughout the workflow

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