Of all the tools we build for clients, one gets mentioned in thank-you calls more than everything else combined, and it isn’t sophisticated. It’s a spreadsheet with thirteen columns — one per week, a quarter into the future — showing cash in, cash out, and the balance at the end of each week. That’s the entire tool. The 13-week cash flow forecast has probably prevented more sleepless nights than any other document in finance, and most owners have never seen one.
Here’s the strange part: the companies that need it most are usually profitable. Owners assume cash problems belong to failing businesses, so when a profitable company hits a crunch, it arrives as a betrayal — the P&L says we made money, so where is it? The answer is that profit and cash live on different calendars. You book the revenue in March, buy the inventory in February, pay your people every Friday, and collect from your best customer in May — if they’re prompt. The P&L nets all of that into one tidy monthly number. Cash experiences it week by painful week, and a growing company, buying ahead of ever-larger orders, gets squeezed hardest of all. Growth eats cash, and the P&L never shows the strain.
Why weeks, and why thirteen
The two forecasts most companies already have both miss the danger. The annual budget is too coarse — a month that looks fine in total can contain a Friday where payroll, a loan payment, and a supplier deposit all land before the big receivable does. And the checking-account glance — the method most owners actually use — is precise but blind: it tells you where you are, never where you’re headed.
Weekly granularity catches what monthly hides, because cash problems arrive on specific days, not in monthly totals. And thirteen weeks — one quarter — is the useful horizon: far enough out that you can still do something about what you see, near enough that the numbers are real commitments rather than hopes. A squeeze you spot ten weeks out is a planning item. The same squeeze spotted ten days out is a crisis, and crises are expensive — that’s when you take the emergency line at a bad rate, lean on the supplier who remembers it, or delay the payroll tax deposit and start down a road with no good exits.
A cash crunch discovered ten weeks early is a planning item. The same crunch discovered ten days early is a crisis.
What it looks like in practice
The mechanics are honestly simple. Across the top, the next thirteen weeks. Down the left: beginning cash, then collections — not booked revenue, but when customers will actually pay, based on how they actually behave, which your receivables history already tells you. Then disbursements, with payroll weeks marked, because payroll is the one bill with no flexibility: rent, debt service, insurance on their real dates, supplier payments, taxes. Bottom row: ending cash, week by week, marching a quarter into the future.
The first version takes a few hours to build and is wrong in a dozen small ways. That’s fine — the power isn’t in the first draft, it’s in the rhythm. Every week, you enter what actually happened, see where reality beat or missed the forecast, and roll a new week thirteen onto the end. Within a month or two the forecast stops being a spreadsheet and becomes something closer to instrumentation: you learn that your biggest customer pays in 52 days no matter what the invoice says, that week-one of each month is always tighter than you thought, that the seasonal dip starts earlier than memory claims. The variances teach you your own business.
And once the instrument exists, it starts answering questions before they become emergencies. Can we afford the new hire starting next month? Should we take the early-pay discount from the supplier? What happens if the big customer pays a month late? One change, thirteen answers. Now suppose the answer comes back ugly: the balance bottoms out in week eight, $215,000 below where you need it to be, seven weeks from today. Seven weeks is enough time to choose a response rather than accept one — and choosing well means reading every option for speed as much as size, because a lever that lands in week nine does nothing for a trough in week eight. Here is what that menu typically looks like, with the arithmetic attached.
| Lever | What it releases | Effect at week 8 | When it lands |
|---|---|---|---|
| Chase the two largest past-due accounts | $140k sitting beyond 60 days with customers who pay when asked | +$140k | 2–3 weeks |
| Defer the quarterly owner distribution | Moves $120k of discretionary outflow from week 7 to week 12 | +$120k | Immediate |
| Move two key vendors to 45-day terms | Pushes $95k of payables out past the trough | +$95k | One cycle, 3–4 weeks |
| Delay the operations hire to week 11 | Removes six weeks of salary, recruiting and onboarding cost | +$28k | Immediate |
| Draw on the revolver | $250k of undrawn availability under the line | +$250k | Same week |
| Reprice the underwater service contracts | About 3 points of margin on $4M of annual revenue | — | Two quarters; outside the window |
This is the difference between deciding on gut feel and deciding with headlights on — and it’s why the 13-week model is the first thing we build in nearly every fractional CFO engagement, usually within the first month.
Who needs it — honestly
Not every company needs to run this forever. If you’re sitting on a year of expenses in cash and your receipts arrive like clockwork, a monthly view may serve you fine. The 13-week model earns its keep when any of these are true: growth is consuming working capital faster than profit replaces it; revenue or collections are lumpy or seasonal; a bank covenant, debt payment, or tax obligation leaves little room for error; payroll is large relative to your cash cushion; or a transaction is coming — because buyers and lenders read a well-kept 13-week forecast as evidence of a company that knows itself, and diligence teams notice its absence.
If two or more of those describe you and the forecast doesn’t exist yet, closing that gap is likely the highest-return project in your finance function this quarter. Build it rough, run it weekly, and let it sharpen. The companies that get surprised by cash are almost never the ones watching it thirteen weeks at a time.
Chief Perspective builds and runs 13-week cash flow forecasts as part of its FP&A and Fractional CFO work with middle-market companies. If your cash view stops at the checking account balance, let’s talk.
Common questions
Can’t my bookkeeper just do this?
They can maintain it, and often should — but the judgment calls (how customers really pay, what to do about week nine) are forward-looking work. The best arrangement is usually a CFO-level build and weekly review, with your existing team keeping it current.
What software do we need?
None to start. A well-built spreadsheet fed from your accounting system is the standard, and plenty of nine-figure companies run on exactly that. Tools help later, once the rhythm exists; they don’t create the rhythm.
How long until it’s accurate?
The structure is useful immediately; the accuracy comes from four to eight weeks of comparing forecast to actual and adjusting. By week twelve, the companies we do this with are typically within a few percent on the near weeks — which is all the precision the decisions require.
Is this only for companies in trouble?
The opposite, mostly. Troubled companies are forced into it by their lenders. Healthy companies adopt it by choice — and it’s a large part of why they stay healthy.