← Back to Free Resources

12-Month Cash Flow Forecast Template for Excel

Your bank asks what next year looks like. Type last year's numbers, set four assumptions, and the sheet shows the month your bank balance gets lowest.

Excel file, 4 tabs Works in Excel, Google Sheets, Numbers By Dominik Gabor

Free. No email, no sign-up.

The Forecast tab: lowest bank balance 16,941 in August 2027, with money in, money out and the bank balance for each of 12 months
The Forecast tab with the example numbers. The lowest month gets a red outline; months under your minimum turn red.

How to use it

  1. Assumptions tab: fill in the blue cells. Bank balance today, the first forecast month, sales growth, how many days your customers take to pay, materials as a share of sales, and the lowest balance you are comfortable with.
  2. Last year tab: type last year's numbers by month. Sales means what you invoiced, not what came in. Your bookkeeping software's profit and loss report has most of them.
  3. Forecast tab: read the lowest bank balance and the month it happens. Then change one assumption and watch every month after it move.

Try this first: set "Include it in the forecast?" to No. That is your year if the overdue invoices never come in. In the example, August drops from 16,941 to minus 894.

What is inside

TabWhat it does
Start hereThe three steps and how the model works, in plain English.
AssumptionsEvery input in one place, plus an overdue-invoices switch and a table for one-off payments like a new machine.
Last yearTwelve months of sales, payroll, rent, overheads, VAT and loan repayments.
ForecastMoney in, money out and the bank balance for 12 months, the lowest month, the first month under your minimum, and a chart.

What the model assumes

It is a simple model on purpose, so you can see every step.

  • Sales follow last year's months, plus your growth. A slow July last year means a slow July next year.
  • Money in arrives after your average days to pay. At 33 days, 90% of a month's sales arrive the next month and 10% the month after.
  • Payroll, rent and overheads repeat last year's months, so holiday pay, bonuses and yearly bills land where they did.
  • Materials scale with sales. One-offs go in the month you type.

The example numbers belong to a made-up company. Replace them with yours, row by row.

Want this built from your own books?

I set up AI systems for owner-run companies: the forecast built from your bank export and updated every month, so the tight month shows up while you can still act on it.

See my services

This template is a planning tool, not tax, legal or financial advice. Check the result with your accountant.