Sunday, November 22, 2026

13-Week Cash Flow Forecast: How to Build One (Free Calculator)

Build a simple 13-week cash flow forecast to spot cash shortfalls weeks in advance. Step-by-step guide, example and free calculator.

Category: BusinessLast updated: November 20268 min read

A 13-week cash flow forecast lists the cash you expect to receive and pay out each week for the next quarter, so you can see the exact week your bank balance gets tight. Start with today’s bank balance, add expected receipts, subtract expected payments, and carry the closing balance forward. Update it every week with real numbers.

Profit and cash are not the same thing. A business can show a healthy profit on paper and still run out of money, because customers pay late, stock has to be bought up front and tax bills land on fixed dates. Most small businesses that fail do not run out of customers first. They run out of cash.

How to Make an Invoice Template (Free Step-by-Step Guide for 2026)Also readHow to Make an Invoice Template (Free Step-by-Step Guide for 2026)

A short, rolling cash flow forecast is the simplest early-warning system you can build. It takes about an hour to set up and fifteen minutes a week to keep current. This guide shows you how to build one, what to include, and how to read it, plus a free calculator you can use right now.

If you only check your bank balance, you see where you are today. A forecast shows you where you will be in six weeks, while there is still time to do something about it.
In this article
  1. Why 13 weeks?
  2. What goes into the forecast
  3. Free 13-week cash flow calculator
  4. How to build your forecast step by step
  5. A quick example
  6. How to read the results
  7. Ways to improve cash flow once you see a gap
  8. Common mistakes
  9. Frequently asked questions
  10. Explore more

Why 13 weeks?

Thirteen weeks is one quarter. It is long enough to catch big outgoing payments such as quarterly tax, rent reviews, insurance renewals and seasonal stock, but short enough that your estimates stay realistic. Banks, finance providers and turnaround advisers use the same 13-week format, so if you ever need finance or an overdraft, you will already have the document they ask for.

Weekly columns matter too. Monthly forecasts hide timing problems. If payroll goes out on the 5th and your biggest customer pays on the 25th, a monthly view looks fine, but you may be short for three weeks in between.

What goes into the forecast

Section What to include Where to find it
Opening cash Cleared balance in all business bank accounts Online banking
Cash in Customer payments, card settlements, financing received, grants, owner top-ups Accounts receivable list, sales pipeline
Cash out: regular Payroll, rent, software, utilities, finance repayments Bank statements, direct debits
Cash out: suppliers Bills already received and expected stock orders Accounts payable list
Cash out: one-offs Tax payments, equipment, annual subscriptions, insurance Tax calendar, renewal emails
Closing cash Opening cash + cash in − cash out Becomes next week’s opening cash

Record cash on the date it actually moves, not the invoice date. An invoice raised today with 30-day terms belongs in the week you realistically expect the money, which may be week six rather than week four if that customer usually pays late.

Free 13-week cash flow calculator






Enter your numbers and press Run forecast.
  1. Enter today’s cleared bank balance.
  2. Use your average weekly receipts and payments from the last two or three months.
  3. Add your largest known one-off bill, such as a tax payment, and the week it is due.

How to build your forecast step by step

  1. Set up 13 weekly columns. Use a spreadsheet with weeks across the top and the sections above down the side.
  2. Enter your opening balance. Use cleared funds only. Ignore money that is still pending.
  3. List receipts customer by customer. For each unpaid invoice, put the amount in the week you honestly expect payment. Add new sales you are confident about.
  4. List every payment. Start with fixed costs, then supplier bills, then one-offs from your tax and renewal calendar.
  5. Calculate closing cash. Carry each week's closing balance into the next week's opening balance.
  6. Mark your minimum cash line. Decide the lowest balance you are comfortable with, such as two weeks of payroll, and highlight any week below it.
  7. Roll it forward weekly. Every Monday, replace last week's estimates with actual figures and add a new week 13.
Compare forecast against actual every week. If your estimates are consistently too optimistic about customer payments, adjust the timing for those customers rather than the amounts.

A quick example

A small design studio starts with 20,000 in the bank, receives about 9,000 a week and spends about 10,000. That slow 1,000 weekly drain looks harmless. But a quarterly tax payment of 8,000 is due in week six. The forecast shows the balance dropping to around 6,000 that week and continuing to fall to roughly -1,000 by week 13. Seeing this in week one, the owner chases two overdue invoices, moves a software renewal to annual billing next quarter and agrees a small overdraft before it is needed.

How to read the results

  • Steady decline: your regular costs exceed regular income. This is a profitability or pricing issue, not just timing. Review your margins and markup.
  • Sharp dip then recovery: a timing issue. Short-term options include negotiating supplier terms, invoice finance or a small credit line. See how invoice factoring works.
  • Healthy surplus: plan where extra cash goes, such as a reserve, debt repayment or investment.

Ways to improve cash flow once you see a gap

A forecast is only useful if it changes what you do. When you spot a weak week, work through these levers in order, starting with the ones that cost nothing:

  • Invoice faster. Send invoices the day work is delivered, not at the end of the month, and make sure payment details are clear.
  • Shorten payment terms for new customers. Moving from 30 to 14 days, or asking for a deposit on large jobs, brings cash forward without raising prices.
  • Chase overdue invoices on a schedule. A polite reminder on the due date and a phone call a week later recovers most late payments.
  • Talk to suppliers early. Many will agree to split a large bill or extend terms if you ask before the due date rather than after.
  • Delay optional spending. Push back equipment upgrades, new hires or marketing experiments until the forecast shows room for them.
  • Arrange finance before you need it. Banks are far more willing to approve an overdraft or credit line when your forecast shows you planning ahead.

Common mistakes

  • Using invoice dates instead of realistic payment dates.
  • Forgetting VAT, sales tax or payroll taxes that are collected now but paid later.
  • Leaving out owner drawings.
  • Building the forecast once and never updating it.
  • Counting a sale before the customer has committed.
A cash flow forecast does not need to be perfect to be useful. A rough forecast you update every week beats a detailed one you build once a year.

Frequently asked questions

How accurate does a 13-week forecast need to be?

Aim for the right direction and timing rather than exact amounts. The first four weeks should be fairly precise because most of those bills and receipts are already known. Weeks nine to thirteen are naturally rougher.

Is a cash flow forecast the same as a budget?

No. A budget plans income and expenses for the year, usually by month, and often uses accounting dates. A cash flow forecast tracks the timing of actual cash movements week by week.

What is a safe minimum cash balance?

Many small businesses aim to keep at least one month of fixed costs in the bank, and more if income is seasonal. Our business emergency fund calculator helps you set a target.

Can I use accounting software instead of a spreadsheet?

Yes. Many accounting tools include cash flow forecasting based on your invoices and bills. A spreadsheet is still useful for adding one-off payments and what-if scenarios.

Explore more

News recorder
Written by

News recorder