Cash Flow Forecast Template
Thirteen weeks of cash visibility, in the format lenders and boards ask for.
Illustrative preview · Opening cash · Receipts · Payments · Closing cash
What's in the template
Built by FP&A professionals, for companies. Every tab has a job.
Thirteen weekly columns
The standard short-term cash window, week by week.
Receipts by source
Customer collections, financing, and other inflows kept separate.
Payments by category
Payroll, suppliers, rent, tax. The lines that actually move cash.
Closing cash and buffer
Each week ends with a cash position and a distance to your minimum.
How to use it
Four steps, in order. The first one matters most.
Start with real opening cash
Bank balance today, not the balance sheet number.
Forecast collections, not revenue
Cash arrives when customers pay, which is not when you invoice.
Schedule payments by week
Payroll dates and supplier terms drive the timing.
Watch the closing line
If any week breaches your buffer, act now, not that week.
Download the Cash Flow Forecast Template
Free, in Excel, with instructions and a worked example. We ask for an email, and that's the whole price.
No spam. Unsubscribe anytime.Common questions
Related templates
Templates go stale. Reportly doesn't.
Every template is a manual snapshot. Reportly builds the same outputs automatically from live QuickBooks data, and keeps them current.