Castan

Cash flow forecast template: a free 13-week or 12-month forecast to fill in, with an example

Bookkeeper leads this guide

Published 9 November 2026Updated 17 November 20268 minute read

Go to the formEvery outside fact read on 9 November 2026
On this page

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.

Forecast
13-week cash flow forecast
LineWeek 1Week 2Week 3Week 4Week 5Week 6Week 7Week 8Week 9Week 10Week 11Week 12Week 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

A design studio’s 13-week cash flow forecast, weeks 1 to 6, with a $25,000 minimum
LineWeek 1Week 2Week 3Week 4Week 5Week 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

Three horizons, and what each is for
HorizonBuilt fromWhat it is for
13 weeks, by weekThe direct method: invoices and when each customer usually pays, payroll dates, bills, tax datesThe next dip, and what to do before it
3 months, by monthThe same, grouped by monthPlanning decisions; Sage’s guide names three months as the standard and one month as the minimum
12 months, rolling by monthLast year’s figures and the planHiring, 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

  1. 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
  2. 2Ramp: cash flow forecasting, by Fiona Lee, updated 30 July 2026the direct and indirect methods; the 13-week, monthly and long-term horizons
  3. 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
  4. 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.