GL Reconciliation
The GL Reconciliation dashboard provides a clear view of reconciliation status across companies and bank accounts. It helps finance teams monitor automated and manual reconciliation performance and identify aged unmatched transactions.
Benefits of this dashboard
- Increase financial accuracy: Helps ensure your general ledger reflects real-world transactions.
- Accelerate close cycles: Speeds up month-end close by identifying unreconciled entries earlier.
- Mitigate financial risk: Prevents financial misstatements due to unreconciled or aged entries.
- Optimize reconciliation processes: Highlights opportunities to improve automation rates and reduce manual workload.
Visual components
| Title | View type | Description |
|---|---|---|
| Reconciliation Details | Worksheet | Table listing imported, auto-reconciled, manual-reconciled, and unreconciled entries by group. |
| Non-Reconciled Aging | Worksheet | Table grouping unreconciled entries by how long they have remained unmatched. |
| Reconciliation by Company | Stacked Bar | Compares companies by reconciliation status across four categories. |
| Reconciliation by Bank Account | Stacked Bar | Show reconciliation performance by bank account. |
Reconciliation Details: key metrics
- Imported Entries: Total GL transactions imported for reconciliation.
- Reconciled Entries (Auto): Number and percentage of entries matched automatically.
- Reconciled Entries (Manual): Number and percentage of entries matched manually.
- Not Reconciled Entries: Number and percentage of entries still unmatched.
Non-Reconciled Aging: key metrics
- Non-Reconciled Aging: Breakdown of unmatched entries by age bracket:
- ≤ 30 Days
- > 30 Days
- > 60 Days
- > 90 Days
Filters
You can filter the dashboard with these panels:
- Period
- Company
- Bank
- Account
- Bank Branch