Treasury dashboard examples: cash and liquidity

Treasury dashboard examples should answer a concrete question: does each entity have enough usable cash to meet its dated commitments and retain its approved buffer? Show balances and expected movements separately, then reconcile the result. The group total helps, but the entity and timing detail determines where a shortfall needs attention.

Separate cash held from cash expected

A cash balance describes a point in time. Receipts and payments describe movements over a period. The SEC's guide to financial statements makes this distinction between balance sheets and cash flow statements, and separates operating, investing and financing cash flows.

A treasury review uses that distinction to keep its starting position separate from its forward view. Label opening cash as reconciled actual cash. Label future customer receipts as expected, even when the invoice is already overdue. An overdue invoice is not money available in the bank.

For a longer planning horizon, use the cash flow forecast method. This example focuses on near-term entity liquidity and commitments rather than reproducing the full financial reporting package.

Bring the balances and dated commitments

Consider a US industrial distributor with a parent entity and separate East and West operating entities. All balances and commitments below are in USD. Treasury reconciles the opening position at October 23, 2026, and reviews the next seven days, October 24 through October 30.

The files are bank balance exports, bank reconciliations, an entity cash ledger, customer receipt expectations and an unpaid commitments list. Each source needs an as-of timestamp. Commitments should identify the entity responsible, due date, amount, source reference and whether the payment is already reflected in opening book cash.

Start with reconciled cash rather than an unexplained bank screenshot. The IRS recordkeeping guide describes reconciling business checking records with the bank statement and checking deposits and disbursements. Here, the controller resolves bank-to-book differences before treasury uses the opening position.

Unavailable cash represents balances specifically identified in the company's records as unavailable for general payments during this horizon. The dashboard preserves them in total cash but subtracts them when calculating usable cash. Treasury records the reason and supporting reference rather than assuming every account balance is interchangeable.

The opening identity is $1,430,000 − $105,000 = $1,325,000. It must hold both by entity and for the group.

Work the liquidity position by entity

The receipt and payment schedules below cover only the stated horizon. Payments already deducted in the reconciled opening book balance are excluded from these future commitments. No borrowing, intercompany transfers or asset sales are assumed.

Each buffer is a management-approved planning input, not an industry benchmark. It stays separate from unavailable cash: the buffer is a target retained balance, while unavailable cash is excluded from the spending pool.

Forecast closing usable cash = Usable opening cash + Expected receipts − Payment commitments

Closing liquidity headroom = Forecast closing usable cash − Required closing buffer

For Parent, closing cash is $850,000 + $200,000 − $550,000 = $500,000. After its $200,000 buffer, headroom is $300,000. West has $150,000 + $90,000 − $260,000 = −$20,000 before allowing for its buffer.

The group identity is $1,325,000 + $410,000 − $1,110,000 = $625,000. Subtract the combined $375,000 buffer to get $250,000 of group headroom.

Yet West is $95,000 below its closing buffer and cannot fund all listed commitments from its assumed cash sources. Parent's surplus does not automatically resolve that position. Treasury must establish whether funds can reach West before the relevant obligations fall due; the table assumes no transfer has been approved or made.

Check the dates as well as the totals

These are closing figures for the horizon, not the lowest cash balances within it. A receipt arriving after a supplier payment could leave a temporary shortfall even when closing headroom is positive. Arrange the underlying rows by expected value date and roll the balance forward to inspect that sequence.

The daily cash flow view develops that dated roll-forward. Keep the payment date, cash cutoff and owner beside large commitments so treasury can distinguish a known funding need from an incomplete export.

Reconcile expected receipts to identified invoices or other documented sources, and commitments to the unpaid obligation list. Check that an invoice has not appeared in both a supplier payment file and a separate manual request. Intercompany movements need matching entries on both sides when they are included, rather than being treated as new external cash.

The working capital reporting review can explain which receivables or payables are driving the cash schedule. It should not replace the dated treasury view: a balance movement alone does not establish when cash will settle.

Change one input: a West receipt slips outside the horizon

Now change only West expected receipts, from $90,000 to $40,000. The $50,000 difference is delayed beyond the review window. Opening balances, payment commitments and buffers stay unchanged.

West's funding gap to its buffer grows to $145,000. Group headroom falls by the same $50,000 delay, yet remains positive. That combination shows why consolidated liquidity alone cannot identify the entity that needs action.

The variation changes receipt timing, not revenue or profit. Keep that distinction clear when explaining the result; cash flow versus profit covers the broader accounting difference.

Where it goes wrong

• Mixing bank and book positions. Outstanding items can explain a difference. Reconcile the starting balance before adding future movements.
• Counting a payment twice. An issued payment may already reduce opening book cash. Do not subtract it again as a new future commitment.
• Treating expected receipts as settled funds. Preserve the expected date and evidence. A collection assumption can change while the underlying invoice remains unchanged.
• Using group cash for every entity. Entity ownership, restrictions and transfer timing can prevent a surplus elsewhere from covering a local payment.
• Calling closing headroom the minimum. A horizon-end balance misses earlier pressure. Inspect the dated roll-forward before concluding that timing works.

Review your treasury files in Covirage

Bring entity cash balances, the unavailable-cash schedule and dated receipt and commitment exports. Covirage maps the columns; its tools compute and check the balances and headroom, and 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 export.

See Covirage for finance teams for the wider financial review.