Cash flow forecast chart: examples and checks

A cash flow forecast chart should show when the company approaches its minimum cash reserve, with the receipts and payments explaining why. Plot closing cash separately from cash movements, and keep alternative scenarios on the same timeline. A healthy final balance can conceal a difficult month before it.

Choose the chart for the business question

Use a cash flow projection chart to decide whether collections need attention, discretionary spending can proceed or funding must be available. Start from a dated cash schedule.

The SBA's financial-management guidance distinguishes recording a sale from recording the receipt of payment. That timing difference matters here: a booked sale does not increase the cash balance until the expected collection date.

Microsoft's chart-type guidance describes line charts as suitable for trends across equal time intervals. Use one shared dollar scale when comparing cash balances; a second axis can make an inadequate reserve appear comfortable. Covirage is not affiliated with Microsoft.

For the underlying schedule, use the cash flow forecast guide. The examples below focus on chart selection and interpretation once those rows exist.

Example: a US distributor's four-month cash outlook

A fictional Michigan equipment distributor prepares a forecast for November 2026 through February 2027. It starts November with $180,000 in available cash. Management assumes a $100,000 minimum operating reserve.

Receipts are customer collections; payments cover operating, tax, capital and financing outflows. Assume no new borrowing or unlisted inflows. Table amounts are unrounded USD.

The calculations follow directly from the table:

Net movement = Receipts - Payments

Closing cash = Opening cash + Net movement

Headroom = Closing cash - Minimum operating reserve

If columns A:G contain the table and rows 2:5 contain the months, enter =C2-D2 in E2, =B2+E2 in F2 and =F2-$J$1 in G2, with the reserve in J1. Fill those formulas down. Set the next opening balance to the preceding closing balance: B3 is =F2.

Chart one: show the cash movements

The bars are receipts; the line is payments. Chart values divide table amounts by 1,000 into USD thousands, without rounding.

Payments exceed receipts in November, December and February. January generates $30,000 of positive net movement, but that does not erase the earlier cash consumption. Across the full schedule, receipts total $1,030,000 and payments total $1,070,000, giving net movement of -$40,000.

This chart explains the movement. It does not show the cash available to meet a payment because it excludes the opening balance. Never interpret a negative monthly net movement as proof that the bank balance is negative.

Chart two: reveal the reserve gap and a timing variation

Now change one assumption: a $50,000 customer receipt expected in December moves to January. No amount is lost and no payment changes. December receipts become $160,000; January receipts become $350,000.

The blue line is base closing cash; the dashed orange line is the delayed case. The dotted gray line is the reserve. Coincident scenario points overlap; values are USD thousands.

Both cases end February at $140,000. Yet the minimum displayed month-end headroom changes from $20,000 in the base case to -$30,000 in the delayed case. Positive closing cash of $70,000 still breaches the company's $100,000 reserve.

Finance should test December at weekly or daily detail before authorizing discretionary spending. Sales can seek earlier collection; treasury can evaluate documented funding availability. Put proposed responses in a separate revised case. A 13-week cash schedule helps investigate that tighter period.

Check the figures before sharing the chart

For every row, closing cash less opening cash less receipts plus payments must equal zero. Next month's opening balance must equal this month's closing balance. Across the base schedule, $180,000 + $1,030,000 - $1,070,000 = $140,000, matching the final point. The delayed case has the same total receipts, payments and final cash.

Keep undrawn facilities separate from bank cash. Identify borrowing availability conditions and label any measure that includes it.

An indirect cash flow forecast can supply cash movements from projected profit and balance-sheet changes, but it still needs the same balance reconciliation. A free cash flow forecast answers a different question about operating cash generation after capital spending.

Where cash forecast charts go wrong

• Calling month-end headroom the period minimum. Monthly points do not reveal a payroll-day trough. Match the date interval to the payment decision.
• Mixing balances and flows. Receipts are movements; closing cash is a stock. Do not stack them together as though they were additive.
• Changing axes between scenarios. Preserve dates, dollar scale and reserve definition so the visual comparison is fair.
• Dropping the delayed receipt. A timing variation must remove the receipt from one period and add it to the new period, unless collection itself is also at risk.
• Drawing through missing periods. A blank month is missing evidence, not a zero movement. Resolve it before presenting a continuous line.

Check the figures behind your chart in Covirage

Bring your dated receipts-and-payments workbook, opening cash and scenario assumptions. Covirage maps the columns, and its tools compute and check balances and headroom; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See Covirage for finance teams for the supporting workflow.