The Cash Reconciliation dashboard provides a comprehensive view of reconciliation status between bank statements and accounting records. It helps finance teams monitor reconciliation volume, method, and timeliness across companies and accounts.
Benefits of this dashboard
- Gain financial clarity: Tracks reconciliation progress to ensure books accurately match actual bank balances.
- Improve risk management: Flags unreconciled transactions that may signal errors, omissions, or potential fraud.
- Increase operational efficiency: Identifies where reconciliation is performed manually versus automatically to guide process automation.
- Strengthen decision‑making: Supports audit readiness and financial reporting with a clear view of reconciliation aging and trends.
Month-to-Date
| Metric | Description |
|---|
| Imported Entries | Total number of bank transactions imported for reconciliation in the selected period. |
| Reconciled (Auto) Entries | Number of transactions automatically matched and reconciled based on predefined rules. |
| Reconciled (Auto) % | Percentage of transactions reconciled automatically. |
| Reconciled (Manual) Entries | Number of transactions reconciled manually when auto-matching is not possible. |
| Reconciled (Manual) % | Percentage of transactions reconciled manually. |
| Not Reconciled Entries | Number of transactions still unmatched and requiring follow-up. |
| Not Reconciled % | Percentage of transactions still pending reconciliation. |
Year-to-Date
| Metric | Description |
|---|
| YTD Imported Entries | Cumulative number of imported transactions from the start of the year to date. |
| YTD Reconciled Entries | Cumulative number of reconciled transactions (automatic and manual) year to date. |
| YTD Not Reconciled Entries | Cumulative number of unreconciled transactions year to date. |
Visual components
| Title | View type | Description |
|---|
| Reconciliation by Account (Volume) | Stacked Bar | Compares reconciliation activity (imported, auto/manual reconciled, and not reconciled) by account. |
| Summary Cards | KPI | Highlights overall reconciliation progress month-to-date and year-to-date. |
| Reconciliation by Company (Volume) | Combination | Shows reconciliation status by company to compare reconciliation efficiency across entities. |
| Non-Reconciled Aging | Worksheet | Categorizes unreconciled transactions by how long they have been outstanding (for example, 0–30 days and 31–60 days). |
| Transaction | Worksheet | Shows cash flow impact and unreconciled bank balances by company for deeper analysis. |
Filters
You can filter the dashboard with these panels:
- Date Type
- Year
- Month
- Account Interco
- Bank
- Account