The 13-Week Cash Flow Forecast, Explained
The 13-week cash flow forecast is the single most useful spreadsheet a founder can keep. Here is how to build one, read it, and use it to never get surprised by your own bank account.
If you only ever build one financial model, build this one.
The 13-week cash flow forecast — a rolling, week-by-week projection of every dollar coming in and going out over the next quarter — is the closest thing in startup finance to a smoke detector. It will not run your company for you. But it will tell you, weeks in advance, when the room is about to fill with smoke.
The bottom line: a 13-week forecast lists your starting cash, your expected weekly inflows and outflows, and the running balance that results. Thirteen weeks is one fiscal quarter — long enough to see trouble coming, short enough that your estimates are still believable. You update it every week, and it becomes the one number you actually trust.
Here is how to build it, how to read it, and how to stop it from lying to you.
Why 13 weeks (and not 12, or 52)?
Thirteen weeks is exactly one quarter. That is not an accident — it is the sweet spot between two failure modes.
- Too short, and you are flying nose-down: a four-week view tells you the bills clearing this month but nothing about the payroll cliff in week seven.
- Too long, and you are reading tea leaves: anyone who claims to know their week-by-week cash position 40 weeks out is forecasting fiction. (For the long view, you want an annual model and scenario planning — a different tool for a different job.)
Thirteen weeks gives you enough runway to do something about a problem — chase a late invoice, delay a hire, pull forward a collection, draw on a credit line — while your inputs are still grounded in reality.
The anatomy of the forecast
Every 13-week forecast is the same three-part skeleton. Columns are weeks; rows are the money.
| Section | What goes here |
|---|---|
| Beginning cash | Your consolidated cash position at the start of the week — every operating account, summed. |
| Cash inflows | Customer collections, new bookings paid, financing draws, tax refunds, interest. Cash actually landing, not revenue booked. |
| Cash outflows | Payroll, rent, software, contractors, taxes, loan repayments, ad spend — everything that leaves. |
| Net cash flow | Inflows − outflows for the week. |
| Ending cash | Beginning cash + net cash flow. This becomes next week’s beginning cash. |
That last line is the whole point. Ending cash flows into the next week’s beginning cash, week after week, so a small leak in week two compounds visibly by week ten.
The number that matters is not any single week’s net flow. It is the lowest ending-cash balance across the 13 weeks — your trough. If the trough is comfortably positive, you sleep. If it dips toward zero, you have a date on the calendar and a problem to solve.
A worked example
Say you start the quarter with $420,000 in the bank. You collect roughly $95,000/week from customers and spend about $110,000/week — a $15,000 weekly burn. Boring, until week 6, when annual insurance ($40k) and a quarterly tax payment ($60k) both land.
| Week | Beginning | Inflows | Outflows | Net | Ending |
|---|---|---|---|---|---|
| 1 | 420,000 | 95,000 | 110,000 | −15,000 | 405,000 |
| 2 | 405,000 | 95,000 | 110,000 | −15,000 | 390,000 |
| 3 | 390,000 | 90,000 | 110,000 | −20,000 | 370,000 |
| 4 | 370,000 | 100,000 | 110,000 | −10,000 | 360,000 |
| 5 | 360,000 | 95,000 | 110,000 | −15,000 | 345,000 |
| 6 | 345,000 | 95,000 | 210,000 | −115,000 | 230,000 |
| … | … | … | … | … | … |
Nothing here is an emergency. But notice what the forecast did: it turned “we have plenty of cash” into “week 6 costs us $115k, and we should not start that contractor engagement until week 8.” That is the entire value proposition — converting a vague feeling into a dated decision.
Inflows: forecast cash, not revenue
The most common way a 13-week forecast lies to you is by confusing revenue with cash. You can book a $50k annual contract today and not see the money for 45 days. Your P&L is delighted; your bank account has not noticed.
So forecast collections, not bookings:
- Start with your open invoices and their due dates, then haircut for reality — if customers pay 12 days late on average, slide them 12 days right.
- For subscriptions, use billing dates, not contract start dates.
- Be honest about your DSO (days sales outstanding). If you want to know why cash always feels tighter than revenue suggests, that gap lives in your cash conversion cycle.
When in doubt, be a pessimist about timing. Cash that shows up early is a pleasant surprise; cash you counted on that arrives late is a fire drill.
Outflows: the ones that bite are the ones you forgot
Payroll and rent are easy — they are predictable and large, so you remember them. The forecast-killers are the lumpy, infrequent costs:
- Quarterly or annual tax payments
- Annual software renewals (that “small” $24k/year tool, billed once)
- Insurance premiums
- Payroll’s third pay-run in a five-Friday month
- Contractor true-ups and bonuses
Build a checklist of these and place each one on the exact week it clears. A 13-week forecast that only contains your smooth, recurring costs is a forecast that will betray you in week six.
The rolling update: this is the habit that matters
A 13-week forecast is not a document you build once. It is a rolling model: every week you drop the week that just happened, add a new week 13 at the far end, and — most importantly — replace your estimates with what actually happened.
This weekly variance check is where the magic is. When week 3’s real collections come in $18k under your estimate, you do not just shrug and move on. You ask why, and you adjust the next ten weeks accordingly. Over a couple of months your forecast stops being a guess and starts being eerily accurate, because it has been trained on your real patterns. (The same discipline, applied to budgets, is variance analysis.)
Do this every Monday with coffee. Fifteen minutes. It is the highest-ROI fifteen minutes in your week.
Spreadsheet or software?
A spreadsheet is the right place to start, and our free template below will get you running this afternoon. Spreadsheets are honest, flexible, and free.
They are also where forecasts go to die. The weekly update is manual, the bank-balance copy-paste is error-prone, and the moment you add a second entity or a third currency, the formulas turn into a haunted house. Most founders keep a 13-week spreadsheet beautifully for about five weeks, then quietly stop.
This is exactly the chore software should eat. CX Cash pulls your real inflows and outflows straight from your accounts, keeps the rolling 13-week view current to the second, and flags your cash trough before it sneaks up on you — so the forecast updates itself while you go run the company. If you want to see the broader category, start with our cash flow forecasting guide or the tools for cash and treasury management.
FAQ
What is a 13-week cash flow forecast?
It is a rolling, week-by-week projection of your cash inflows and outflows over the next quarter (13 weeks), showing your running bank balance each week. It is used to spot cash shortfalls early and time decisions like hires, large payments, and financing.
Why 13 weeks specifically?
Thirteen weeks is one fiscal quarter — long enough to give you time to react to a looming shortfall, but short enough that your week-by-week estimates remain credible.
How often should I update it?
Weekly. Drop the week that just ended, add a new one at the end, and replace estimates with actuals. The weekly variance review is what makes the forecast accurate over time.
What is the difference between a cash flow forecast and a P&L?
A P&L records revenue and expenses when they are earned or incurred; a cash flow forecast tracks money when it actually moves. A profitable company can still run out of cash if customers pay slowly — which is exactly what the 13-week view exposes.