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:

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)

3. Cash disbursements (money out)

4. Closing cash and the floor check

Closing cash = opening + receipts − disbursements. Under it, add two rows:

The worked example: one quarter, week by week

Here’s an invented service business with six staff:

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:

  1. Replace last week’s forecast with actuals. What actually came in, what actually went out, the real bank balance.
  2. 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.
  3. Update invoices and bills. Mark what got paid, add new invoices sent and new bills received.
  4. Roll forward. Drop the finished week and add a new week 13, so you’re always looking a full quarter ahead.
  5. 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:

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.

Keep reading

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.

See the Week Cash Gets Tight Before It Arrives

The 13 Week Cash Flow Forecast & Runway Planner — 14 tabs and 1,816 formulas for a small business cash forecast: a rolling 13-Week Forecast grid driven from one start Monday (opening cash, receipts, payments, closing cash and headroom above your cash floor); a Runway tab with the first week below your floor, the date you run out if nothing changes, your lowest balance and break-even monthly revenue; Receivables aged Current/1-30/31-60/61-90/90+ with DSO and expected pay dates; Payables with Can Delay flags; Recurring payroll, rent, retainers and loans by frequency (weekly, fortnightly, monthly, quarterly); Base/Best/Worst Scenarios; Seasonality; Forecast vs Actual accuracy scoring; and a Dashboard that ranks invoices to chase and bills you could hold, with 20 data checks. Sample quarter pre-filled. Works in Excel and Google Sheets.

View on Etsy — $18.99