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.
- 100% free
- Call direct
- Voice search
- Urdu & English
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.
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.
In this article
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 today’s cleared bank balance.
- Use your average weekly receipts and payments from the last two or three months.
- 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
- Set up 13 weekly columns. Use a spreadsheet with weeks across the top and the sections above down the side.
- Enter your opening balance. Use cleared funds only. Ignore money that is still pending.
- 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.
- List every payment. Start with fixed costs, then supplier bills, then one-offs from your tax and renewal calendar.
- Calculate closing cash. Carry each week's closing balance into the next week's opening balance.
- 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.
- Roll it forward weekly. Every Monday, replace last week's estimates with actual figures and add a new week 13.
A quick example
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.
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.
