13 Week Cash Flow Forecast Template for Small Business: Step by Step
Your accounting software can tell you what happened last month. It can’t tell you whether there will be enough in the bank on the Friday payroll goes out six weeks from now. If you’ve ever looked at a healthy profit and loss and still felt a knot in your stomach on payday, you need a different tool: a 13 week cash flow forecast.
This guide walks you through building one from scratch: the rows to include, where each number comes from, and a complete worked quarter so you can see how the arithmetic catches a cash crunch weeks before it happens. At the end you can copy the layout or download the finished template.
Every figure in this guide belongs to one invented example business. These are illustration assumptions, not benchmarks. Swap in your own numbers.
What a 13 week cash flow forecast actually does
A 13 week cash flow forecast is a grid with one column per week for the next quarter. Every column answers the same question:
Opening cash + cash coming in − cash going out = closing cash
Closing cash in week 1 becomes opening cash in week 2, and so on to week 13. That chain is the whole idea. It forces you to put each real payment in the week it actually happens, rather than spreading it evenly across a month.
Three things make it different from the reports you already have:
- It’s cash, not profit. An invoice you sent counts when the client pays it, not when you billed it. A loan repayment counts in full, even though only the interest shows on your P&L.
- It’s weekly. Payroll, rent and quarterly taxes don’t arrive as monthly averages. They land in specific weeks, and those weeks are where businesses get caught.
- It looks forward. It’s built from what you expect to happen: invoices outstanding, bills due, payroll scheduled. That’s why you can act on what it tells you.
The rows every 13 week forecast needs
Keep the structure simple. You need four blocks.
1. Opening cash
Week 1’s opening figure is the actual balance in your business bank accounts on the morning the forecast starts. Use a Monday. After week 1, every opening figure is just the previous week’s closing figure.
2. Cash receipts (money in)
- Collections from invoices you’ve already sent. List every unpaid invoice with the date you realistically expect to be paid. That’s not always the due date. A client who pays 20 days late every time will probably keep doing it.
- Recurring revenue. Retainers, subscriptions, rent you receive, regular contracts.
- New business. Sales you haven’t invoiced yet but reasonably expect. Be conservative here, because this is the line most forecasts get wrong.
- Other receipts. Tax refunds, asset sales, a loan drawdown you’ve already agreed.
3. Cash disbursements (money out)
- Payroll. Put each run in its actual week. Weekly, fortnightly and twice-monthly schedules land very differently across 13 weeks.
- Fixed overheads. Rent, software, insurance, utilities, phone.
- Loan repayments. The full payment, principal and interest.
- Supplier bills (payables). Every bill you owe, in the week you’ll pay it.
- Variable costs. Materials, contractors, ad spend: the costs that move with sales.
- Taxes. Quarterly estimates, sales tax remittances, payroll tax deposits. They’re easy to forget because they don’t arrive monthly.
- Owner draws. If you pay yourself, it’s cash leaving the business.
4. Closing cash and the floor check
Closing cash = opening + receipts − disbursements. Under it, add two rows:
- Cash floor. The minimum you never want to drop below. A practical starting point is roughly your biggest single week of outgoings, so one bad week can’t empty the account.
- Headroom. Closing cash minus the floor. Any negative number here is a warning.
The worked example: one quarter, week by week
Here’s an invented service business with six staff:
- Opening cash: $30,000
- Payroll: $14,000 every second week (weeks 2, 4, 6, 8, 10, 12)
- Rent and fixed overheads: $5,700 in the first week of each month (weeks 1, 5, 9, 13)
- Loan repayment: $1,800 monthly (weeks 3, 7, 11)
- Contractors and variable costs: $1,500 every week
- Quarterly tax payment: $6,000 in week 7
- Cash floor: $15,000
Receipts come from invoice collections and monthly retainers, so they’re lumpy: big weeks when retainers land, thin weeks in between.
| Week | Opening | Receipts | Payments | Net | Closing | vs $15k floor |
|---|---|---|---|---|---|---|
| 1 | $30,000 | $18,000 | $7,200 | +$10,800 | $40,800 | OK |
| 2 | $40,800 | $6,000 | $15,500 | −$9,500 | $31,300 | OK |
| 3 | $31,300 | $9,500 | $3,300 | +$6,200 | $37,500 | OK |
| 4 | $37,500 | $4,000 | $15,500 | −$11,500 | $26,000 | OK |
| 5 | $26,000 | $15,000 | $7,200 | +$7,800 | $33,800 | OK |
| 6 | $33,800 | $5,500 | $15,500 | −$10,000 | $23,800 | OK |
| 7 | $23,800 | $3,000 | $9,300 | −$6,300 | $17,500 | Tight |
| 8 | $17,500 | $12,000 | $15,500 | −$3,500 | $14,000 | Below |
| 9 | $14,000 | $15,000 | $7,200 | +$7,800 | $21,800 | OK |
| 10 | $21,800 | $7,000 | $15,500 | −$8,500 | $13,300 | Below |
| 11 | $13,300 | $8,500 | $3,300 | +$5,200 | $18,500 | Tight |
| 12 | $18,500 | $6,000 | $15,500 | −$9,500 | $9,000 | Below |
| 13 | $9,000 | $15,000 | $7,200 | +$7,800 | $16,800 | Tight |
| Total | $124,500 | $137,700 | −$13,200 |
Payments in each payroll week are $14,000 payroll + $1,500 variable = $15,500. Week 7 is $1,800 loan + $1,500 variable + $6,000 tax = $9,300.
What the numbers are telling you
The average hides the problem. Over the quarter this business burns $13,200, about $1,015 a week. At that rate, $30,000 looks like more than six months of cash. A monthly view would feel comfortable.
The weekly view doesn’t. Cash first drops below the $15,000 floor in week 8, again in week 10, and bottoms out at $9,000 in week 12, right after a payroll run. Nothing here is a disaster yet. But a single client paying three weeks late in that stretch would turn “tight” into “can’t make payroll.”
You can see it seven weeks early. That’s the point. In week 1 you have time to fix week 8. In week 8 you don’t.
Fixing it with the two cheapest levers
When a forecast shows a gap, there are two moves that cost nothing before you consider borrowing: collect faster or pay later.
Say one client has a $6,500 invoice that’s already overdue, and the forecast currently assumes it lands in week 13. Chase it so it lands in week 7 instead, and every closing balance from week 7 to week 12 rises by $6,500:
| Week | Closing before | Closing after collecting $6,500 in week 7 |
|---|---|---|
| 8 | $14,000 | $20,500 |
| 10 | $13,300 | $19,800 |
| 12 | $9,000 | $15,500 |
Every week now clears the floor. One phone call, made in week 1 because the forecast told you to, removes the whole problem. If that call fails, the next step is looking at which supplier bills could reasonably move a week or two. Never payroll and never tax deposits. The forecast tells you how much you’d need to move, and when.
For the full step-by-step on the payroll question specifically, see how to know if you can make payroll next month.
How to build it in a spreadsheet
You can lay this out in about an hour.
Step 1: One start date drives everything. Put the forecast’s start Monday in a single cell. Week 1’s date is that cell; week 2 is =previous week + 7. Change one cell and the whole grid moves forward.
Step 2: An invoices tab. One row per unpaid invoice: client, invoice number, amount, due date and expected pay date. Then pull each one into the right week with:
=SUMIFS(Invoices!Amount, Invoices!ExpectedDate, ">="&WeekStart, Invoices!ExpectedDate, "<"&WeekStart+7)
Step 3: A bills tab. The same structure for what you owe, plus a column marking whether each bill could be delayed if needed. That column becomes your list of options when a week goes tight.
Step 4: A recurring tab. Payroll, rent, software, loans and retainers, each with an amount and frequency (weekly, fortnightly, monthly, quarterly). This is the fiddliest part, because a fortnightly payroll and a monthly rent fall in different weeks, and a monthly bill on the 31st behaves strangely in short months.
Step 5: The grid. Receipts rows pull from the invoices and recurring tabs; payment rows pull from bills and recurring. Closing = opening + receipts − payments. Next week’s opening = this week’s closing.
Step 6: The floor check. =IF(Closing<Floor,"BELOW FLOOR",IF(Closing<Floor*1.25,"Tight","OK")) gives every week a status you can read at a glance.
Keep it alive: the weekly routine
A forecast you build once and never touch is wrong within a month. The habit that makes it work takes about 15 minutes every Monday:
- Replace last week’s forecast with actuals. What actually came in, what actually went out, the real bank balance.
- Note how far off you were. If receipts come in under forecast week after week, your expected pay dates are too optimistic. Push them out.
- Update invoices and bills. Mark what got paid, add new invoices sent and new bills received.
- Roll forward. Drop the finished week and add a new week 13, so you’re always looking a full quarter ahead.
- Read the floor row. Any week below the floor gets a specific action and a name next to it.
Run a worst case, not just a best guess
Your forecast is a set of assumptions, and the biggest one is how fast clients pay. Build at least two versions:
- Base: your realistic expected pay dates.
- Worst: a share of each week’s expected collections slips a week, and new business comes in lighter.
If the worst case still clears your floor, you can relax. If it doesn’t, you know exactly how big the buffer needs to be. That ties directly into how much cash runway a small business needs.
Weekly or monthly?
If your income and costs arrive evenly, a monthly forecast may be enough. Most small businesses aren’t like that. Payroll lands every other week, retainers on the 1st, quarterly tax once a quarter, and those lumps are exactly what a monthly total smooths away. Our weekly vs monthly cash flow forecast comparison runs this same example both ways so you can see what each view shows.
Before you start, it’s also worth reading the cash flow forecast mistakes small business owners make. Most of them come down to one of two errors: using due dates instead of realistic pay dates, or forecasting from profit instead of cash.
Get the finished template
The 13 Week Cash Flow Forecast & Runway Planner is the complete workbook behind this guide, with 14 tabs and sample data already forecast so you can watch it work before you add your own numbers. Set one start Monday, your opening cash and your floor. Then list your unpaid invoices with expected pay dates, your bills (flagged if they could be delayed) and your recurring items with their frequencies. The 13-week grid, the Runway tab and the Dashboard do the rest. It shows the first week you drop below your floor, the date you’d run out if nothing changes, your lowest balance, aged receivables with days sales outstanding, and Base, Best and Worst scenarios on one dropdown. A Forecast vs Actual tab scores your accuracy each week, and the Dashboard ranks your oldest invoices to chase and your largest delayable bills. It works in Excel and Google Sheets, with no macros and no subscription.
Featured on ReadySheetGo
13 Week Cash Flow Forecast & Runway Planner — $18.99
A rolling 13-week grid driven from one start date, aged receivables, delayable payables, recurring payroll and overheads, Base/Best/Worst scenarios, seasonality, runway and break-even answers, forecast vs actual tracking and a one-screen dashboard. Works in Excel and Google Sheets.
Keep reading
- How to know if you can make payroll next month: the 10-minute payroll check and what to do if you’re short
- Weekly vs monthly cash flow forecast: which should a small business use?: the same quarter shown both ways
- How many months of cash runway does a small business need?: gross burn, net burn and picking your number
- Cash flow forecast mistakes small business owners make: nine errors that make a forecast look safer than it is
General information only, not accounting, tax or financial advice. A cash flow forecast is only as good as the assumptions you put in it. All figures are illustration assumptions for one invented business. Speak to an accountant about your own tax payments and financing options.
Frequently Asked Questions
What is a 13 week cash flow forecast?
It is a week-by-week projection of the cash your business will receive and pay out over the next 13 weeks, roughly one quarter. Each column starts with opening cash, adds expected receipts, subtracts expected payments and ends with closing cash, which becomes the next week's opening balance. Because it is weekly, it shows the specific weeks where cash gets tight, which a monthly view averages away.
Why 13 weeks instead of 3 months?
Thirteen weeks is one quarter measured in whole weeks, so every payroll run, rent payment and quarterly bill lands in a specific column. It is far enough ahead to act on a problem (chase invoices, delay a bill, arrange credit) and near enough that your receipts and payments are mostly known rather than guessed.
How often should I update a 13 week cash flow forecast?
Weekly. Each week, replace the forecast figures for the week that just ended with what actually happened, check how far off you were, and add a new week 13 at the end so the forecast always looks a full quarter ahead. That roll-forward habit is what keeps it useful.
Can I build a 13 week cash flow forecast in Google Sheets?
Yes. The forecast is simple arithmetic (SUM and SUMIFS by week), so it works the same in Google Sheets and Excel. A ready-made template saves the setup: date headers driven from one start date, invoices and bills that drop into the right week automatically, and a dashboard that flags the first week below your cash floor.