Blog · Board and management reporting · Finance and FP&A teams
A cash flow dashboard reconciles opening cash, receipts, payments, and closing cash before explaining movement categories. Work through a US company example, a delayed receipt, and the checks that keep actual cash separate from forecasts.
A Power BI cash flow dashboard should prove that opening cash plus receipts minus payments equals closing cash, then explain the movements. Put that reconciliation ahead of charts so readers can distinguish a business change from missing or duplicated transactions. Use posted cash activity for the actual view and keep expected payments and receipts separately labeled.
The overview needs opening cash, receipts, payments, net movement, closing cash, and the difference from the independently reported closing balance. Beneath it, show movement categories and account detail. A flat balance can conceal asset purchases funded by borrowing, so the ending balance alone does not explain cash performance.
Microsoft describes a Power BI dashboard as a single page containing visual highlights. For cash reporting, the bridge is the highlight; the transaction-level reconciliation supports it. Broader Power BI dashboard examples cover other business measures without replacing this balance proof.
Covirage is not affiliated with Microsoft or Power BI.
The SEC's guide to financial statements distinguishes cash movements from profit and describes operating, investing, and financing activities. The example below uses those categories for a management view of actual cash. Finance should approve classifications and reconcile any differences from the company's formal statement of cash flows.
Bring a cash ledger export with transaction identifier, posting date, account, description, amount, currency, and cash-flow category. Bring opening and closing balances for the same accounts and dates. Bank statement exports can provide another check, with outstanding checks and deposits handled through the bank reconciliation.
For this illustration, a US equipment distributor reports September 2026 cash in USD. Its management cash scope includes its USD operating and reserve bank accounts. There are no foreign exchange movements, restricted balances, or changes in account scope during the month. Opening and closing balances use posted ledger cash, and the bank reconciliation is completed separately.
Receipts are positive inflows. Payments appear as positive values in the payment column and are subtracted in the bridge. Invoices issued and bills received do not belong in this cash movement view until the related cash entries are posted.
Net cash movement = Cash receipts - Cash payments
Calculated closing cash = Opening cash + Net cash movement
Reconciliation difference = Independently reported closing cash - Calculated closing cash
Transfers between included accounts cancel at the consolidated level. Match their two entries, retain them for account reconciliation, and exclude their paired amounts from external receipt and payment totals. Otherwise internal cash movement inflates activity without changing company cash.
The following category summary comes from the company's checked cash transactions. Every payment is shown as a positive amount in its own column, and blank activity is represented by zero.
| Cash activity | Category | Receipts (USD) | Payments (USD) |
|---|---|---|---|
| Customer collections | Operating | 320,000 | 0 |
| Supplier refund | Operating | 5,000 | 0 |
| Supplier payments | Operating | 0 | 180,000 |
| Payroll | Operating | 0 | 90,000 |
| Rent | Operating | 0 | 25,000 |
| Interest paid | Operating | 0 | 8,000 |
| Income taxes paid | Operating | 0 | 12,000 |
| Equipment purchase | Investing | 0 | 60,000 |
| Loan proceeds | Financing | 100,000 | 0 |
| Loan principal repayment | Financing | 0 | 30,000 |
| Owner distribution | Financing | 0 | 20,000 |
| Total | 425,000 | 425,000 |
Receipts total 320,000 + 5,000 + 100,000 = $425,000. Payments total 180,000 + 90,000 + 25,000 + 8,000 + 12,000 + 60,000 + 30,000 + 20,000 = $425,000. Net cash movement is therefore 425,000 - 425,000 = $0.
The opening balance from the ledger is $250,000, and the independently exported closing balance is $250,000. The bridge proves the closing figure:
| Reconciliation step | Calculation | Amount (USD) |
|---|---|---|
| Opening cash | Opening balance export | 250,000 |
| Add receipts | Transaction total | 425,000 |
| Subtract payments | Transaction total | -425,000 |
| Calculated closing cash | 250,000 + 425,000 - 425,000 | 250,000 |
| Reported closing cash | Closing balance export | 250,000 |
| Difference | 250,000 - 250,000 | 0 |
A zero difference proves that the selected transactions bridge those balances. It does not prove that every transaction has the right category. That needs a separate review.
Use the receipt and payment rows to calculate each category. This provides an independent view of the same net movement, with no forecast assumptions.
| Category | Calculation | Net cash movement (USD) |
|---|---|---|
| Operating | 320,000 + 5,000 - 180,000 - 90,000 - 25,000 - 8,000 - 12,000 | 10,000 |
| Investing | -60,000 | -60,000 |
| Financing | 100,000 - 30,000 - 20,000 | 50,000 |
| Total | 10,000 - 60,000 + 50,000 | 0 |
The business generated $10,000 of operating cash. Equipment used $60,000, while net financing supplied $50,000. Together they explain why cash remained at $250,000. Borrowing is visible as financing rather than being mistaken for customer collections.
Microsoft's dashboard design guidance recommends context for important figures and emphasis on the audience's decisions. Here, the category bridge gives the finance team that context. The broader cash flow dashboard guide covers the management view, while the Excel dashboard guide covers spreadsheet presentation.
Suppose $40,000 of the original customer collections is actually posted in October. Change September customer collections from $320,000 to $280,000. Every other transaction and the opening balance remains unchanged.
| Measure | Original (USD) | Revised (USD) | Revised calculation |
|---|---|---|---|
| Customer collections | 320,000 | 280,000 | 320,000 - 40,000 |
| Total receipts | 425,000 | 385,000 | 280,000 + 5,000 + 100,000 |
| Total payments | 425,000 | 425,000 | Payments unchanged |
| Operating cash movement | 10,000 | -30,000 | 10,000 - 40,000 |
| Net cash movement | 0 | -40,000 | 385,000 - 425,000 |
| Calculated closing cash | 250,000 | 210,000 | 250,000 - 40,000 |
For this variation to reconcile, the revised closing balance export must also show $210,000. If the reported balance stays unchanged, investigate the transaction timing or the account scope rather than forcing the difference into a category. The delayed receipt belongs in October actuals when posted; its expected timing belongs in the separate Power BI cash flow forecast discussion.
All example amounts are whole dollars, and no rounding is needed. For real files, reconcile in the ledger's smallest currency unit before rounding dashboard displays.
Bring a sample of your own cash ledger and balance exports to Covirage, or upload a Google Sheet containing the same columns. Covirage maps the columns, and its tools compute and check cash movements against balances; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your own files.
See Covirage for finance teams for the finance reporting context.
Show opening cash, total cash receipts, total cash payments, net movement, closing cash, and a reconciliation difference. Add movement categories and account detail beneath the overview. Make the reporting cutoff and included cash accounts visible so users can reproduce the balance.
An actual cash dashboard reports movements that have occurred within its stated period. A forecast estimates future receipt and payment timing. They can support the same review, but actual and expected amounts need separate labels and should not be combined in a reconciled actual balance.
Operating cash can fund asset purchases, debt repayments, or owner distributions. Closing cash reflects all included movements. A movement-category bridge explains how positive operating cash is offset elsewhere, even when the opening and closing balances are identical.