Cash Flow
The Cash Flow dashboard for Sage XRT Advanced reports bank transactions and reconciliation status across companies, bank branches, and financial flows. It includes the number of transactions, reconciled and not reconciled counts, the reconciliation discrepancy, and the details of each transaction.
How to use the cash flow dashboard
- Follow the number of transactions and the reconciled percentage, with the manual and automatic split.
- Compare reconciled and not reconciled transactions to find unmatched entries and the discrepancy found during reconciliation.
- Split transactions by company, flow, and bank branch in the doughnut charts.
- Look up transaction details in the worksheet, including date, flow code, description, and reconciliation status.
Filters
Use the filtering panel at the top of the Cash Flow dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.
Date Type: multiple values
Key performance indicators (KPIs)
The key performance indicators (KPIs) at the top of the dashboard show five transaction and reconciliation measures, and update based on the filters you apply.
| KPI | What it measures |
|---|---|
| Count | Total number of transactions analyzed. |
| Reconciled vs. Not Reconciled | Count of transactions that are matched versus unmatched. |
| Reconciled % | Percentage of transactions reconciled. |
| Reconciliation Discrepancy | Difference identified during reconciliation. |
| Manual vs. Automatic Reconciliation | Number and percentage of transactions reconciled manually or automatically. |
Visual components
| View name | Type of view | What it shows |
|---|---|---|
| Company | Doughnut | Splits transactions by company, with one slice for the share of each. |
| Flow | Doughnut | Groups transactions by flow, such as disbursement and receipt. |
| Bank Branch | Doughnut | Divides transactions by bank branch. |
| Yesterday Balance | Vertical Bar | Displays historical account balances. |
| Transaction | Worksheet | Lists transaction details, including date, flow code, description, and reconciliation status. |