Cash Flow Report Template: Forecast vs Actual Variance

Choose the report period and source records

Use a completed week or month with a clear start and end. Keep the opening balance, actual transactions and closing balance from the same cash accounts. If you combine accounts, exclude transfers between those accounts from both receipts and payments; otherwise the movement totals can be inflated even when closing cash still reconciles. Keep the original forecast unchanged in a dated backup. Revising it to match actuals removes the evidence you need to learn from the difference.

Read a cash impact with the correct sign

For a receipt, actual minus forecast is its effect on closing cash. For a payment, forecast minus actual is its effect. A payment of $900 against an $800 forecast therefore reduces closing cash by $100.

A receipt of $1,200 against $1,500 reduces it by $300. These are cash impacts, not a diagnosis of why the differences happened. Add the difference in opening cash before you try to reconcile the closing balance.

Work through the $400 difference

In this fictional example, opening cash is $1,000, forecast receipts are $1,500 and forecast payments are $800. Forecast closing is $1,700. Actual receipts of $1,200 and payments of $900 produce $1,300 closing cash. The bridge is $1,700 minus $300 from receipts minus $100 from payments, giving $1,300. If actual opening cash were $950 instead, actual closing would be $1,250 and the bridge would need the separate negative $50 opening difference.

Separate a late receipt from a smaller sale

A Timing label means you suspect money moved into another period. Confirm the invoice, customer response and revised collection date before carrying the missing $300 into the next forecast. An Amount label means the total expected movement changed, such as a revised supplier invoice or customer credit. Split a movement into two explained lines when both causes apply. Unclassified is a useful honest status while you investigate; it is better than inventing an explanation.

Turn the report into the next forecast

Give the customer collection a named owner and a follow-up date. Compare the supplier invoice with its purchase order before approving future spending. Update future weeks from confirmed evidence while preserving the completed-period report. Use the existing 13-week forecast for forward timing; this worksheet is a single-period reconciliation and does not replace it. Neither tool creates a statutory statement of cash flows or calculates tax.

Questions about a cash variance report

Can a profitable business have a negative cash variance? Yes: a profitable invoice can remain uncollected. Does a positive payment impact prove an efficiency gain?

No: the bill may simply be unpaid. What should I do when the bridge reconciles but the bank does not? Check missing transactions, the opening balance and the account scope before describing the report as complete.