Cash Flow Forecast Template: 12-Month and 13-Week Excel Model
This cash flow forecast template combines a 12-month planning model with a 13-week cash-control sheet. The annual view tells you where the low point sits. The weekly view tells you which receipt, payroll run, tax payment, or supplier commitment creates it.
The model uses bank timing, not invoice timing. Revenue can look healthy while the account is short for payroll. That gap is why profitable businesses still get trapped, and why a forecast that stops at monthly sales is not a cash forecast.
What is inside the cash flow forecast Excel template?
The workbook separates assumptions, annual planning, short-horizon control, forecast variance, decision output, and model checks. Each sheet has one job so you do not bury the cash decision inside a giant grid.
| Sheet | Decision it supports |
|---|---|
| Assumptions | Opening cash, floor, scenario, variable-cost ratio, variance threshold |
| 12-Month Forecast | Monthly opening cash, receipts, payments, closing cash, floor gap |
| 13-Week Control | Specific weekly receipts, payments, owners, and confidence |
| Variance | Forecast versus actual cash in and out, with cause |
| Summary | Low month, floor breaches, 13-week risk, and next action |
| Checks | Roll-forward and identity controls |
Get the Excel workbook with a 12-month forecast, 13-week cash control, scenarios, variance review, cash-floor chart, and model checks. Enter your details and I’ll email the secure download link. The newsletter checkbox is optional and can be cleared if you only want the workbook.
The sample numbers are intentionally plain. Replace them with cleared opening cash and defensible bank-date estimates before reading the chart.
Build the 12-month cash flow forecast from bank dates
Start the cash flow forecast template with cleared cash. Then estimate when customer money will reach the bank and when payroll, suppliers, tax, debt, capital spending, and owner draws will leave it. An invoice issued in July but paid in September belongs in September cash receipts.
- Opening cash: the cleared balance available at the start of the month.
- Customer receipts: cash expected from sales, based on collection behavior.
- Other receipts: grants, tax refunds, asset sales, or other cash that should not be hidden inside sales.
- Operating payments: payroll, suppliers, facilities, software, professional fees, and other running costs.
- Scheduled payments: tax, debt service, annual renewals, capital purchases, and owner draws.
- Closing cash: opening cash plus total cash in minus total cash out.
The business.gov.au cash flow statement guidance uses the same opening-cash, cash-in, cash-out, and closing-cash logic. It also tells businesses to label estimates and state how taxes such as GST are treated. The workbook gives you a Notes field in Assumptions for those choices.
Do not total opening and closing cash as if they were monthly revenue. They are balances at points in time. The workbook labels its rightmost column 12-month total / ending so flow rows and stock rows do not pretend to mean the same thing.
Add a 13-week cash flow forecast when the floor is close
A 12-month forecast is a planning tool. A 13-week cash flow forecast is a control tool. Use the weekly sheet when the monthly model gets close to the minimum cash floor, a customer payment slips, or a funding decision cannot wait for month-end.
| Weekly field | What belongs there | Why it matters |
|---|---|---|
| Committed receipts | Cash with a strong date and evidence | Separates bankable receipts from hope |
| Probable receipts | Cash with timing or approval risk | Keeps uncertainty visible |
| Receipt owner | Person responsible for the collection | Creates accountability |
| Confidence | High, medium, or low | Makes fragile weeks obvious |
| Committed payments | Payroll, suppliers, tax, debt | Protects obligations |
| Discretionary payments | Spend that can still move | Shows the first controllable lever |
| Floor gap | Closing cash minus minimum floor | Starts action before cash turns negative |
Do not solve every low week by moving supplier payments without agreement. That improves the spreadsheet and damages the business. First confirm customer collections, discretionary commitments, owner draws, financing timing, and the terms already negotiated.
Use scenarios to test the plan, not decorate it
The Assumptions sheet includes Base, Upside, and Downside receipt multipliers plus a variable-payment ratio. A scenario earns its place when it changes a decision. If all three cases stay safely above the floor, stop tweaking. If the downside case breaks the floor in November, decide what must happen before November.
- Base: the most defensible view from current orders, collection history, and known costs.
- Upside: a better case that still respects delivery capacity and collection timing.
- Downside: slower receipts or weaker sales without quietly removing fixed obligations.
A 20% downside multiplier is not a prophecy. It is a stress case. Replace it if customer concentration, seasonality, renewal timing, or a signed backlog gives you a better range.
The published break-even point calculator can test the unit economics behind the plan. The published business budget guide sets the operating targets. Use the accounts receivable aging report to replace hopeful customer dates with evidence. This cash flow forecast decides whether the timing survives.
Forecast variance is the part most templates miss
Do not overwrite last month’s cash flow forecast template and congratulate yourself for a cleaner new one. Record actual cash in and out beside the old forecast. Then classify the miss: timing, volume, price, missing item, or one-off.
| Variance type | Example | What to change |
|---|---|---|
| Timing | Customer paid in August, not July | Collection-date assumption |
| Volume | Fewer projects closed | Sales and capacity assumption |
| Price | Supplier unit cost increased | Cost assumption or pricing |
| Missing item | Annual insurance renewal omitted | Forecast checklist |
| One-off | Unexpected legal settlement | Do not force it into the normal run rate |
Accuracy should compound. A forecast that misses for a different, documented reason each month is learning. A forecast that misses for the same unexamined reason is reporting fiction.
What the cash decision dashboard should trigger
The Summary shows the 12-month low point, low month, months below the floor, 13-week minimum cash, and weeks below the floor. Each breach needs a dated response, not a red cell left for later.
- Update the 13-week view at invoice and payment level.
- Freeze uncommitted cash until the shortfall is explained.
- Assign owners to large probable receipts.
- Resolve disputed invoices before assuming collection.
- Start financing or cost action before the breach month.
- Re-run the downside case after the action is modeled.
Business.gov.uk funding-application guidance tells funding applicants to prepare a 12-month forecast and think about when customers pay, not when invoices are issued. That is also the right discipline when no lender is involved.
If the forecast keeps breaking for reasons outside the model, use the published cash-flow killers guide to inspect the operating causes.
Where this cash flow template stops
The cash flow forecast template is best for a small business that wants a transparent planning model and can maintain it weekly or monthly. It is not a bank reconciliation, audited forecast, statutory cash flow statement, or lender guarantee.
- Move to a connected FP&A or accounting system when several entities, currencies, or bank accounts must consolidate.
- Use a detailed project model when milestone billing and delivery cost need contract-level forecasting.
- Get accounting and tax advice for accrual treatment, indirect taxes, debt classification, and statutory reporting.
The U.S. Small Business Administration finance guidance explains the difference between cash and accrual accounting. This workbook follows cash movement for planning. Your accounting records may recognize the same sale or cost in a different period.
Frequently asked questions
Is this cash flow forecast template free?
Yes. The Excel workbook is free to download and edit. It includes a 12-month model, 13-week control sheet, scenario assumptions, variance review, dashboard chart, and formula checks.
What is the difference between a 12-month and 13-week cash flow forecast?
A 12-month forecast supports planning, budgets, and funding conversations. A 13-week forecast supports short-term cash control by naming weekly receipts, payments, owners, and confidence.
Should a cash flow forecast use invoice dates or payment dates?
Use the expected bank date for cash forecasting. Keep invoice dates in the sales or receivables system, then model when the customer is likely to pay.
How often should I update the cash flow forecast?
Update the 12-month model at least monthly. Update the 13-week sheet weekly when cash is close to the floor, receipts are uncertain, or material payments are approaching.
Can this Excel cash flow forecast replace accounting software?
No. It is a planning and control model. It does not reconcile bank accounts, create a ledger, prepare statutory statements, or replace accounting advice.
What to do next
Set the minimum cash floor before changing a single forecast number. Then replace the sample receipts and payments with expected bank dates and read the first breach, not the annual total.
If the floor breaks, move straight to the 13-week sheet. Name the receipt, payment, owner, and date that changes the outcome. That is the decision the forecast exists to support.