Skip to main content

Managing Reconciliations Page

The Reconciliations page provides comprehensive tools for filtering, searching, and managing reconciliations.

To manage Reconciliations:

  1. Navigate to the Reconciliations module.

    The Reconciliations tab is displayed by default, showing all configured accounts.

  2. 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.

  3. 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.

  4. 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:

  5. Click Go to Files to view or upload supporting documents for each account.

  6. Click Export to download the reconciliation statement in Excel format.

  7. Click three dots (More Options) to access the following options:open Reconciliation details page.

    1. Open Reconciliation details — Opens the Reconciliation Details page.

    2. 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:

  1. Select Change Assignees from the 3-dot menu.

    The system displays the Change Assignees dialog.

  2. Select the new assignee for one or more roles.

  3. 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.

Was this article helpful?

We're sorry to hear that.