GL Reconciliation
The GL Reconciliation dashboard for Sage XRT Advanced checks reconciliation status across companies and bank accounts. It includes imported, reconciled, and unreconciled entries, and how long unmatched entries have stayed that way.
How to use the GL reconciliation dashboard
- Follow imported, reconciled, and unreconciled entries for the selected period.
- Compare automated and manual reconciliation rates across accounts.
- Check unreconciled entries by how long they've stayed unmatched.
- Compare reconciliation status by company and by bank account.
Filters
Use the filtering panel at the top of the GL Reconciliation dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.
Period: one value
Company: multiple values
Bank: multiple values
Account: multiple values
Bank Branch: multiple values
Visual components
| View name | Type of view | What it shows |
|---|---|---|
| Reconciliation Details | Worksheet | Lists entries by group, with:
|
| Non-Reconciled Aging | Worksheet | Groups unreconciled entries by how long they have stayed unmatched, in four age brackets:
|
| Reconciliation by Company | Stacked Bar | Compares companies by reconciliation status across four categories. |
| Reconciliation by Bank Account | Stacked Bar | Displays reconciliation status by bank account. |