Blog · Board and management reporting · Finance and FP&A teams
A cash flow dashboard shows actual receipts, payments, and closing cash by period. Build an operating layout from ledger exports, reconcile the balances, and separate cash generated by trading from cash supplied by borrowing.
A cash flow dashboard shows where actual cash came from, where it went, and how much remained at the end of each period. Start with opening cash, receipts, payments, and closing cash, then split the movements by purpose so a loan does not look like better trading.
The central measure is a movement in cash, not revenue or profit. The SEC's guide to financial statements distinguishes cash inflows and outflows from the income statement and groups cash flows into operating, investing, and financing activities.
Net cash movement = External cash receipts - External cash payments
Closing cash = Opening cash + Net cash movement
Keep the scope explicit: included legal entities, cash accounts, currency, period, and cutoff. This example covers one US distributor's USD operating accounts, with no restricted cash, foreign exchange movements, or other reconciliation adjustments.
The dashboard is an internal operating view. Finance should map its categories to the company's accounting policies before using it alongside a formal statement of cash flows. For the wider management view, use the financial dashboard layout, which also covers performance beyond cash movements.
Bring the cash-account ledger export, opening balances, and bank reconciliation for the same period. Retain transaction ID, posting date, account, counterparty, cash amount, and payment category. Include the cash side of each entry once; importing every offsetting journal line as another cash movement would duplicate activity.
Use separate receipt and payment columns with positive amounts, or a signed amount with one documented convention. Identify internal transfers before aggregating accounts. A transfer between included accounts needs to remain visible in each account's reconciliation but should disappear from combined external receipts and payments.
Invoice dates do not establish cash receipts. The IRS discussion of accounting methods explains the timing distinction: under accrual accounting, income is generally reported when earned regardless of when payment arrives. For this dashboard, use recorded cash movements rather than substituting sales or purchase invoices.
The following table summarizes the distributor's cash-ledger rows for July through September 2026. Receipts and payments are positive amounts; their direction is identified in the first column. The opening cash balance for July is $120,000.
| Cash-ledger category | July (USD) | August (USD) | September (USD) | Quarter (USD) |
|---|---|---|---|---|
| Receipt: customers | 420,000 | 465,000 | 450,000 | 1,335,000 |
| Receipt: other operating | 5,000 | 5,000 | 5,000 | 15,000 |
| Receipt: loan proceeds | 80,000 | 0 | 0 | 80,000 |
| Payment: suppliers | 250,000 | 270,000 | 290,000 | 810,000 |
| Payment: payroll | 110,000 | 115,000 | 115,000 | 340,000 |
| Payment: other operating | 45,000 | 50,000 | 50,000 | 145,000 |
| Payment: equipment | 30,000 | 10,000 | 0 | 40,000 |
| Payment: loan principal | 10,000 | 10,000 | 10,000 | 30,000 |
Roll these rows into the main dashboard. Sum receipts and payments across the quarter, but carry forward balances rather than adding monthly balances together.
| Dashboard measure | July (USD) | August (USD) | September (USD) | Quarter (USD) |
|---|---|---|---|---|
| Opening cash | 120,000 | 180,000 | 195,000 | 120,000 |
| Total receipts | 505,000 | 470,000 | 455,000 | 1,430,000 |
| Total payments | 445,000 | 455,000 | 465,000 | 1,365,000 |
| Net cash movement | 60,000 | 15,000 | -10,000 | 65,000 |
| Closing cash | 180,000 | 195,000 | 185,000 | 185,000 |
July receipts are 420,000 + 5,000 + 80,000 = $505,000. Its payments are 250,000 + 110,000 + 45,000 + 30,000 + 10,000 = $445,000. Opening cash of $120,000 plus the $60,000 difference gives closing cash of $180,000.
The quarter proves the same identity: 120,000 + 1,430,000 - 1,365,000 = $185,000. Amounts here are exact whole dollars; percentage changes below are rounded to one decimal place.
Separate the categories using the company's reporting policy. In this example, customer receipts and other operating receipts fund supplier, payroll, and other operating payments. Equipment is investing activity; loan proceeds and principal repayments are financing activity.
| Net movement by activity | July (USD) | August (USD) | September (USD) | Quarter (USD) |
|---|---|---|---|---|
| Operating | 20,000 | 35,000 | 0 | 55,000 |
| Investing | -30,000 | -10,000 | 0 | -40,000 |
| Financing | 70,000 | -10,000 | -10,000 | 50,000 |
| Total | 60,000 | 15,000 | -10,000 | 65,000 |
The quarter's operating calculation is 1,335,000 + 15,000 - 810,000 - 340,000 - 145,000 = $55,000. Adding investing and financing gives 55,000 - 40,000 + 50,000 = $65,000, matching the balance movement.
The business increased cash, but borrowing supported the result. July's financing movement is $80,000 of loan proceeds minus $10,000 of principal repayments. For a separate analysis of payments to lenders, use the cash flow to creditors formula rather than treating net financing as a collection measure.
Put the balance reconciliation at the top, activity movements beneath it, and receipts and payments trends next. Keep the underlying categories available so an apparent change can be traced to the original entries.
Customer receipts rise from $420,000 to $465,000, an increase of 45,000 / 420,000 = 10.7%. They then fall by 15,000 / 465,000 = 3.2%. Supplier payments rise from $250,000 to $290,000, or 40,000 / 250,000 = 16.0%. September's operating cash is therefore zero even though collections exceed July's level.
Treasury owns account scope and the bank tie. Accounting owns classification and period close. Collections explains customer receipts; procurement and accounts payable explain supplier payment timing. FP&A brings those explanations into the management review.
A month-end balance cannot prove there was enough cash on every payroll date. Use the 13-week cash flow layout for near-term payment planning. A cash flow forecast owns the assumptions about future receipts and payments; keep those estimates visibly separate from the actual figures here.
Upload your cash-ledger export and opening balances. Covirage maps the columns; its tools compute and check receipts, payments, and balance movements, while the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See how this work fits Covirage for finance teams.
Use a frequency that matches your payment decisions and the freshness of the underlying records. A treasury team may review daily balances, while a management meeting uses weekly or monthly movements. Always display the last completed reconciliation date so readers know what the figures include.
An actual cash dashboard describes payments and receipts already recorded. A forecast estimates future timing and amounts using expected collections, supplier commitments, payroll, and other assumptions. Keep actual and forecast periods visibly separate, even when management reviews them together.
A transfer between accounts included in the same dashboard changes where cash sits but not the combined balance. Exclude both sides from consolidated external receipts and payments, while retaining them when reconciling the individual accounts. Document which accounts are inside the reporting scope.
Yes. Revenue may be recognized before customers pay, and cash can leave for equipment purchases or debt repayments that do not equal the period's expenses. Read profit and actual cash as separate views, then explain the timing and classification differences.