Cash Reconciliation
The Cash Reconciliation dashboard for Sage XRT Advanced shows reconciliation status between bank statements and accounting records. It includes imported, automatically reconciled, manually reconciled, and not reconciled entries for the month to date and the year to date, and how long unreconciled transactions have stayed outstanding.
How to use the cash reconciliation dashboard
- Compare automatic and manual reconciliation by account and by company in the two volume charts.
- Find the transactions still to reconcile by how long they have stayed outstanding, in the aging worksheet.
- Follow imported and reconciled entries for the month to date and the year to date, with the percentage of automatic, manual, and not reconciled entries.
Filters
Use the filtering panel at the top of the Cash Reconciliation dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.
Key performance indicators (KPIs)
The key performance indicators (KPIs) on the dashboard show seven reconciliation measures, once for the month to date and once for the year to date, and update based on the filters you apply. The year to date version of each measure starts with YTD.
| KPI | What it measures |
|---|---|
| Imported Entries | Total number of bank transactions imported for reconciliation, in the selected period and since the start of the year. |
| Reconciled (Auto) Entries | Number of transactions automatically matched and reconciled based on predefined rules, in the selected period and since the start of the year. |
| Reconciled (Auto) % | Percentage of transactions reconciled automatically, in the selected period and since the start of the year. |
| Reconciled (Manual) Entries | Number of transactions reconciled manually when automatic matching is not possible, in the selected period and since the start of the year. |
| Reconciled (Manual) % | Percentage of transactions reconciled manually, in the selected period and since the start of the year. |
| Not Reconciled Entries | Number of transactions still unmatched and requiring follow up, in the selected period and since the start of the year. |
| Not Reconciled % | Percentage of transactions still pending reconciliation, in the selected period and since the start of the year. |
Visual components
| View name | Type of view | What it shows |
|---|---|---|
| Reconciliation by Account (Volume) | Stacked Bar | Compares imported, automatically reconciled, manually reconciled, and not reconciled entries by account. |
| Reconciliation by Company (Volume) | Combination | Displays reconciliation status by company to compare entities side by side. |
| Non-Reconciled Aging | Worksheet | Groups unreconciled transactions by how long they have been outstanding, with a historical count for 30 days or less, more than 30 days, more than 60 days, and more than 90 days, alongside the date, bank amount, and cash flow amount of each transaction. |