Cash Flow Analysis
The Cash Flow Analysis dashboard for Sage XRT Advanced separates reconciled and unreconciled transactions across accounts and entities. It includes the count and percentage of automatic, manual, and not reconciled transactions, and how transactions divide by bank, budget, and flow.
How to use the cash flow analysis dashboard
- Find the transactions still to reconcile using the not reconciled count and percentage.
- Compare automatic and manual reconciliation through the reconciliation rates.
- Split transactions and expenses by budget and flow in the pie charts, to see how funds are allocated.
- Read credit, debit, and transaction count for each entity in the totals worksheet.
Filters
Use the filtering panel at the top of the Cash Flow Analysis dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.
Year: multiple values
Month: multiple values
Account Interco: multiple values
Transaction Status: multiple values
Transaction Currency: multiple values
Company: multiple values
Bank: multiple values
Bank Branch: multiple values
Conversion Date: multiple values
Date Type: multiple values
To Currency: multiple values
Key performance indicators (KPIs)
The key performance indicators (KPIs) at the top of the dashboard show three reconciliation measures, and update based on the filters you apply.
| KPI | What it measures |
|---|---|
| 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
| View name | Type of view | What it shows |
|---|---|---|
| Reconciliation Rates | Simple Gauge | Displays the percentage of auto reconciled, manually reconciled, and unreconciled transactions. |
| Top 5 Banks | Pie | Splits transactions across the top 5 banks. |
| Top 5 Budgets | Pie | Divides transactions across the top 5 budget categories. |
| Top 5 Expenses Budget | Pie | Groups expenses by budget code. |
| Top 5 Flow | Pie | Groups transactions by flow type, such as disbursement and receipt. |
| Top 5 Expenses Flow | Pie | Breaks down expense flow by type. |
| Entity-wise Totals | Worksheet | Lists credit, debit, amount, and transaction count by entity. |