GL Reconciliation Cube
The GL Reconciliation Cube dashboard provides a comprehensive view of general ledger reconciliation performance. It helps finance teams track posting reconciliation status, identify discrepancies, and evaluate reconciliation efficiency across companies and banks.
Benefits of this dashboard
- Ensure financial accuracy: Tracks reconciliation progress to confirm that financial records align with actual bank balances.
- Strengthen audit readiness: Provides detailed visibility into reconciliation activity to support internal and external audit requirements.
- Increase operational efficiency: Identifies areas where automation can be improved or where manual reconciliation is excessive.
- Reduce financial risk: Detects unbalanced or unmatched entries quickly to prevent misstatements.
Visual components
| Title | View type | Description |
|---|---|---|
| Summary | Worksheet | Table showing reconciliation statistics by group (for example, company and bank), including all reconciliation statuses. |
| Top 10 Companies by Transaction Qty | Horizontal Bar | Shows the companies with the highest transaction volume. |
| Top 10 Banks by Transaction Qty | Horizontal Bar | Shows the banks with the highest volume of GL transactions. |
Summary table: key metrics
- Postings Imported: Total number of GL entries imported for the selected period.
- Reconciled Entries (Auto): Number and percentage of entries reconciled automatically.
- Reconciled Entries (Manual): Number and percentage of entries reconciled manually.
- Non-Reconciled Entries: Number and percentage of entries not reconciled during the selected period.
- Year-to-Date Metrics:
- YTD Imported Entries
- YTD Auto Reconciled %
- YTD Manual Reconciled %
- YTD Not Reconciled %
Filters
You can filter the dashboard with these panels:
- Period