The short answer
A cash flow forecast estimates the cash a business expects to receive and to pay out over the coming weeks or months, starting from what is in the bank today, so you can see the week the balance would fall below what you need and act before it does.
The free cash flow forecast template below does the arithmetic as you type, for 13 weeks or 12 months. The FDIC and SBA’s Money Smart for Small Business module on managing cash flow calls it a cash flow projection: a forward-looking estimate of cash in and cash out, also called a pro forma cash flow statement, as opposed to the cash flow statement, which is the backward-looking record of what actually moved. The arithmetic is two lines, as Sage’s UK guide, updated in September 2026 and read on 9 November 2026, sets it out: net cash flow is total cash in minus total cash out, and the closing balance is the opening balance plus net cash flow. Below: the template, what goes in, a 13-week example filled in, the direct method, how far ahead to look, and the mistakes that make a forecast wrong.
Cash flow forecast template
Fill in this free cash flow forecast template online: the cash in the bank on the first day, the minimum you will not go below, and the cash you expect in and out each week for 13 weeks or each month for 12 months. The totals, the net cash flow and the closing balance are worked out as you type, each closing balance carried to the next column as its opening, and any period that closes under the minimum is marked. Print it or save it as a PDF to keep or share as a cash flow forecast report; printed with nothing typed, it is a blank cash flow projection template to fill in by hand. The Fill in the example button loads the design studio from the example below, all 13 weeks.
Cash flow forecast template
What you type stays in this browser: nothing is sent to Castan or saved.
| Line | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Opening cash | - | - | - | - | - | - | - | - | - | - | - | - | - |
| Cash in | |||||||||||||
| Customer payments | |||||||||||||
| Loans, investment and grants | |||||||||||||
| Other cash in | |||||||||||||
| Total cash in | - | - | - | - | - | - | - | - | - | - | - | - | - |
| Cash out | |||||||||||||
| Payroll and payroll taxes | |||||||||||||
| Rent | |||||||||||||
| Suppliers and software | |||||||||||||
| Loan repayments | |||||||||||||
| Sales tax, VAT and other taxes | |||||||||||||
| Owner’s draws | |||||||||||||
| Other cash out | |||||||||||||
| Total cash out | - | - | - | - | - | - | - | - | - | - | - | - | - |
| Net cash flow | - | - | - | - | - | - | - | - | - | - | - | - | - |
| Closing cash | - | - | - | - | - | - | - | - | - | - | - | - | - |
What goes in a cash flow forecast
- Opening cash: the real bank balance on the first day of the forecast, not the balance in the accounts.
- Cash in, on the day you expect it to arrive: customer payments (not the day you invoice), loans and investment received, grants, interest and tax refunds. The Money Smart checklist lists cash sales, collections from customer credit accounts, loans, grants, other cash contributions, interest income and tax refunds.
- Cash out, on the day it leaves: suppliers, payroll and payroll taxes, rent, software, loan repayments, the owner’s draws and taxes. Money Smart names operating expenses, payroll, debt payments, taxes, owner’s draws, and losses such as shrinkage, spoilage and obsolescence.
- The tax dates on their own rows. Sage’s template keeps separate rows for VAT, PAYE and corporation tax; in the US the equivalents are sales tax, payroll taxes and estimated income tax.
- A minimum: the balance you will not go below, which is what the forecast is read against.
A 13-week forecast, the first six weeks filled in
| Line | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 |
|---|---|---|---|---|---|---|
| Opening cash | $42,000 | $45,500 | $34,000 | $42,800 | $23,000 | $25,500 |
| Customer payments in | $9,000 | $4,500 | $12,000 | $3,000 | $8,000 | $15,000 |
| Payroll | ($14,000) | ($14,000) | ($14,000) | |||
| Rent | ($3,500) | ($3,500) | ||||
| Suppliers and software | ($2,000) | ($2,000) | ($2,000) | ($2,000) | ($2,000) | ($2,000) |
| Loan repayment | ($1,200) | |||||
| Sales tax or VAT | ($6,800) | |||||
| Net cash flow | $3,500 | ($11,500) | $8,800 | ($19,800) | $2,500 | ($1,000) |
| Closing cash | $45,500 | $34,000 | $42,800 | $23,000 | $25,500 | $24,500 |
Read it against the minimum. Week 4 closes at $23,000, below the $25,000 floor, because a payroll and the quarterly sales tax land in the same week as a slow week of customer payments; week 6 dips under it again. The studio can be profitable that month and still be short that week. Seen from week 1, the dip leaves three weeks to act: ask the client whose $12,000 invoice is due in week 3 to pay on time, move a supplier payment by a week, or arrange a credit line before it is needed. Seen in week 4, it leaves none. The template above carries it to week 13 in the same shape with its example button, and from week 7 the studio stays above its floor, closest in week 10 at $25,300. Each week the past week is replaced by what actually happened and a new week 13 is added, so the view always runs a quarter ahead.
The direct method, week by week
There are two ways to build one. Ramp’s guide to cash flow forecasting, updated on 30 July 2026, describes the direct method as built from the actual receipts and payments you expect, best for short-term accuracy, and the indirect method as starting from net income and adjusting for non-cash items, better suited to longer projections. It describes the 13-week horizon as long enough to cover a full quarter and granular enough to catch the weekly dips. For a small company the direct method is the one to keep: one row for each kind of payment, each amount dated on the day the money is expected to move, which is exactly what the example above is.
How far ahead, and how often
| Horizon | Built from | What it is for |
|---|---|---|
| 13 weeks, by week | The direct method: invoices and when each customer usually pays, payroll dates, bills, tax dates | The next dip, and what to do before it |
| 3 months, by month | The same, grouped by month | Planning decisions; Sage’s guide names three months as the standard and one month as the minimum |
| 12 months, rolling by month | Last year’s figures and the plan | Hiring, growth and a loan or funding application; Sage names a twelve-month rolling forecast for growth or funding |
Update the 13-week view every week and the 12-month view every month. The Money Smart guide is explicit that the projections are estimates that can be revised at any time, and that the point is the habit of thinking about cash.
The mistakes that make a forecast wrong
- Counting an invoice as cash on the day it is sent. Date it on the day that customer usually pays. Money Smart’s days sales outstanding measures that lag: accounts receivable divided by net credit sales, times 365.
- Forgetting the lumpy payments: quarterly taxes, annual insurance, the loan repayment, a deposit.
- No minimum, so nothing tells you a week is too low. Pick the floor before you fill in the weeks.
- Building it once. A forecast nobody updates is wrong by its third week.
- Reading it as profit. The profit and loss statement shows whether the business earns; the forecast shows whether the bank account survives the quarter.
One measure ties the mistakes together. Money Smart’s cash conversion cycle is days inventory outstanding plus days sales outstanding minus days payables outstanding: how many days cash is tied up between paying for what you sell and being paid for it. A shorter cycle means a smaller dip every month, and the levers are the same three: collect faster, hold less stock, and pay suppliers on their terms rather than early.
How Castan helps
Castan builds and runs your company with you, from the first website to the monthly investor update. It is an AI. You build the 13-week forecast; Castan keeps the numbers it starts from. Its bookkeeper keeps the books from the sources you connect and shows, at the top of Financials, cash on hand as of the date you set it, runway in months from the month’s burn, the invoices due or promised to be paid in the next thirty days, and the receivables with what is late. The recurring costs you enter once, rent, payroll, software, post themselves each month. The late invoices are chased with a reminder drafted from the invoice and the last thing that customer said, sent only when you approve; getting late invoices paid is what closes the dip a forecast shows.
Questions people ask
What is a cash flow forecast?
An estimate of the cash a business expects to receive and pay out over the coming weeks or months, starting from today’s bank balance, so you can see a shortfall before it happens. It is also called a cash flow projection or a pro forma cash flow statement.
Is there a free cash flow forecast template?
Yes. The template on this page is free and needs no sign-up: it runs in your browser for 13 weeks or 12 months, works out the totals and the closing balance as you type, marks any period under your minimum, and prints or saves as a PDF, or prints blank to fill in by hand.
What does a cash flow forecast look like?
A table with the weeks or months across the top and the cash in and out down the side: the opening balance, each kind of cash in and its total, each kind of cash out and its total, the net cash flow, and the closing balance, which becomes the next column’s opening balance. The 13-week example on this page is one, filled in.
What is the difference between a cash flow forecast and a cash flow statement?
A cash flow statement records what actually came in and went out over a past period; a cash flow forecast estimates what will. The statement is where the next forecast gets its patterns from.
How far ahead should a cash flow forecast go?
Thirteen weeks, week by week, to manage the next dips; twelve months, month by month, for hiring, growth and a loan or funding application. Update the first weekly and the second monthly.
How do I make a cash flow forecast in Excel?
One column per week or month, rows for each kind of cash in and cash out, the opening balance at the top, net cash flow as cash in minus cash out, and the closing balance as the opening balance plus net cash flow, carried to the next column as its opening balance.
Sources
- 1FDIC and SBA: Money Smart for Small Business, module 10, managing cash flow, participant guide (FDIC-029-2025)statement against projection; cash in, stored and out; the components checklist; the cash conversion cycle; a cash reserve
- 2Ramp: cash flow forecasting, by Fiona Lee, updated 30 July 2026the direct and indirect methods; the 13-week, monthly and long-term horizons
- 3Sage UK: cash flow forecast template, by Laurence Matone, updated September 2026net cash flow and closing balance; one, three and twelve months; rows for VAT, PAYE and corporation tax
- 4Castan: the bookkeeper and Financials
Prices and terms at other companies change over time. Every figure on this page carries the day it was read, and the page it was read on is linked above. If one has moved since, write to hello@castan.ai and the page is corrected. General information, not tax, legal or accounting advice.
