Managing Reconciliations Page
The Reconciliations page provides comprehensive tools for filtering, searching, and managing reconciliations.
To manage Reconciliations:
-
Navigate to the Reconciliations module.
The Reconciliations tab is displayed by default, showing all configured accounts.
-
Use the action buttons to set specific reconciliations:
Control
Function
Upload
Uploads the supporting documents that are associated with reconciliation periods
Refresh
Refreshes the Reconciliation page with latest reconciliation data
Search Bar
Searches accounts and bank accounts by name or number
Assignees Dropdown
Displays the list of Assignees
Sort by
Sorts the data by most recent, least recent, legal entity, GL balance, and support balance
Status Bar
Filters the data by reconciliation status:
All
Not Started
In Progress
In Review
Pending approval
Completed
Clear Search & Filters
Removes all applied filters and returns to the default view
Pagination
[v26.1]
Displays page navigation controls at the bottom of the reconciliation list, including rows per page selector and page numbers. The pagination bar also displays a Reconciliation Usage Label showing the number of enabled reconciliation accounts against the allowed limit (e.g., "Reconciliations: 6 of 5000 used").
When the limit is reached, the label displays in red text: "Reconciliations: 25 of 25 used (Limit Reached)" — indicating no additional accounts can be enabled until existing accounts are disabled.
-
Review account information in the reconciliation list:
Column Name
Description & Usage
Legal Entity
Legal Entity Name
Account
Displays two sections:
GL Account: Shows account number, account name, and currency (legal entity currency from ERP)
Support Source: Shows manual icon for manual reconciliations or bank account number and currency for bank reconciliations
Balances
Displays two sections:
GL Balance: The general ledger balance from the ERP system
Support Balance: The balance from uploaded bank statement (for bank accounts) or manually entered balance (for manual accounts)
Difference
Shows the difference between GL Balance and Support Balance
Assignees
Lists the preparer, reviewer, and approver assigned to the reconciliation
Status
Current workflow status (e.g., Review Required, Pending Approval, In-Progress, and Approved)
Go to Files
Shows number of supporting documents attached. Click the file count to navigate to the Files module filtered for this account
Export to Excel
Download Statement (exports the reconciliation statement in Excel format)
More Options
Three-dot menu with options including Open Reconciliation Details and Change Assignees
Open Reconciliation details — Opens the Reconciliation Details page for the selected account.
Change Assignees[v26.1] — Opens the Change Assignees dialog to update the Preparer, Reviewer, or Approver. Admin users only.
-
Click on any Account to open the Reconciliations details page which enables you to match General Ledger (GL) entries with bank statement lines for a selected account and period.
Work with the appropriate account reconciliation transactions:
Click Go to Files to view or upload supporting documents for each account.
Click Export to download the reconciliation statement in Excel format.
-
Click three dots (More Options) to access the following options:open Reconciliation details page.
Open Reconciliation details — Opens the Reconciliation Details page.
Change Assignees — Opens the Change Assignees dialog. See Change Assignees below.
Change Assignees [v26.1]
To change the Preparer, Reviewer, or Approver for a reconciliation:
-
Select Change Assignees from the 3-dot menu.
The system displays the Change Assignees dialog.
Select the new assignee for one or more roles.
Click Save. The assignee is updated for the selected reconciliation.
Note: The Change Assignees option is available on any reconciliation regardless of its status and is restricted to Admin users only.
Note: Changing an assignee resets the reconciliation status to In Progress. A note on the dialog warns: “Changing the assignee will reset the Status back to In Progress.”
The assignee list uses the same list of assignees available in Account Settings. The change applies only to the specific reconciliation instance and does not affect the Legal Entity Account configuration. The change is recorded in the workflow history with full traceability.