Cash Flow Analysis
The Cash Flow Analysis dashboard provides a comprehensive view of reconciled and unreconciled financial transactions. It helps businesses monitor liquidity, budget alignment, and flow classifications across accounts and entities.
Benefits of this dashboard
- Streamline the reconciliation process: Quickly identifies which transactions require manual review.
- Track budget usage and compliance: Assesses how funds are allocated and whether flows align with approved budgets.
- Increase operational visibility: Monitors cash movements and flow decisions across the organization.
- Support informed financial decision‑making: Helps finance teams maintain healthy liquidity and compliance.
Key metrics at a glance
- Transaction Count: Total number of transactions by entity.
- Converted Debit/Credit: Debit and credit values converted into a reporting currency.
Key performance indicators (KPIs)
| KPI | Description |
|---|---|
| Auto Reconciled | Total number and percentage of transactions reconciled automatically. |
| Manual Reconciled | Total number and percentage of transactions reconciled manually. |
| Not Reconciled | Total number and percentage of transactions not yet reconciled. |
Visual components
| Title | View type | Description |
|---|---|---|
| Reconciliation Rates | Simple Gauge | Shows the percentage of auto-reconciled, manual-reconciled, and unreconciled transactions. |
| Top 5 Banks | Pie | Shows transaction distribution across the top five banks. |
| Top 5 Budgets | Pie | Shows transaction allocation across the top five budget categories. |
| Top 5 Expenses Budget | Pie | Shows expense distribution by budget code. |
| Top 5 Flow | Pie | Shows transaction distribution by flow type (for example, disbursement and receipt). |
| Top 5 Expenses Flow | Pie | Shows expense flow distribution by type. |
| Entity-wise Totals | Worksheet | Shows credit, debit, amount, and transaction count by entity. |
Filters
You can filter the dashboard with these panels:
- Year
- Month
- Account Interco
- Transaction Status
- Transaction Currency
- Company
- Bank
- Bank Branch
- Conversion Date
- Date Type
- To Currency