The 13-Week Cash Flow Forecast, Explained: The Tool Turnaround Pros Build First
A 13 week cash flow forecast tracks cash in and out, week by week, across 90 days. Here is why turnaround pros build it first, and how to build yours.
When a turnaround manager walks into a company that is going under, the first thing they build isn’t a recovery plan. It’s a 13-week cash flow forecast.
Sit with that ordering for a second. The restructuring, the hard cuts, the talks with the board: all of it waits. The cash forecast comes first. You can’t plan a rescue until you can see how many weeks the patient has left.
A 13 week cash flow forecast is a model that tracks the cash coming into and going out of your business, week by week, across the next 90 days. 13 weeks. 13 weekly numbers, not three monthly ones. That weekly resolution is what makes the whole thing work, and a monthly forecast throws it away.
So here is the stand this piece rests on. The 13-week is a survival tool that the calm, solvent owner runs on purpose, long before any of it is on fire. The owners who only reach for it once the bleeding starts have already built it too late.
The 13-week cash flow forecast is the instrument a turnaround pro builds on day one, because it answers the one question that decides survival: is there any single week the bank balance drops below zero?
Why turnaround pros reach for it first
A company can be profitable and still go insolvent. Those are two separate tests, and most owners only ever watch one of them.
Profit is an accounting measure. Cash is the balance in the account. Actually, put it better than that: profit is real, it’s just not money you can spend yet. You can book a great quarter on paper, sell more than ever, and still miss payroll, because the cash to fund all that growth went out the door weeks before the customers paid you back. Accountants have a name for getting killed by your own success. They call it overtrading. The business is solvent on the books and out of cash in the bank, all at once.
That mismatch is exactly what a turnaround pro looks for first.
Think of how an emergency room works. The triage nurse doesn’t treat the patient who looks worst, or the one who shouts loudest. They sort by who is bleeding now, by who runs out of time first. A 13-week forecast triages your cash the same way. It lines up the next 90 days and shows you which week is the casualty, the one where money runs short while you still have room to act.
I saw it happen to an owner I’d met. She checked her bank balance the day payroll was due, found the account short, and only then went to find the one large receivable that had come in late. The shortfall had been there for three weeks. No one on her team was reading the cash weekly, so no one saw the week it would hit. The money didn’t disappear. It was always going to be short that week. She just found out the day of, instead of at the start of the quarter.
What it actually is, and why 90 days
Cash flow forecasting is the process of estimating a company’s future cash levels, and its financial position more broadly. The 13-week version uses the direct method. You schedule the actual cash receipts and disbursements, week by week, and carry the balance forward.
Receipts are mostly the collection of accounts receivable from recent sales, plus any sale of assets or proceeds of financing. Disbursements are the payments going out: payroll, payment of accounts payable, interest on debt. Add each week up, carry the closing balance into the next week’s starting balance, and you can see your cash position 90 days out.
Why 90 days, and not a year? Because the direct method works best over a short horizon, where you’re working with real near-term data instead of guesses. Stretch it much further and the errors pile up fast. 13 weeks is short enough to stay accurate and long enough to act before the shortfall arrives.
And this is where the monthly habit fails you. Think of a submarine running submerged with no measure of its depth. The hull takes on more pressure as it sinks, and the one number that would show the crew the danger is the number they can’t see. Monthly cash forecasting is that dive. It averages 13 weeks of real movement into a single number, and an average can’t tell you which week the hull actually gives. Weekly numbers are the depth reading. They show how close the bottom is while you still have room to surface.
How to build one
You don’t need anything exotic. A common approach is a spreadsheet showing all the cash coming in out to at least 90 days, and all the cash going out over the same period.
- Start with real cash. The actual bank balance, not the accrual book number. The two often differ, and only one of them makes payroll.
- Lay out 13 weekly columns across the top. One week each, left to right.
- Add receipts by week. Time them to when the money actually arrives, not when you made the sale.
- Add disbursements by week. Payroll, payment of accounts payable, interest on debt, and the rest.
- Carry the balance forward. Each week’s closing cash becomes the next week’s starting cash. Now each short week shows.
Closing cash = starting cash + receipts minus disbursements
Where you find a week that runs short, you can act early, while options are cheap: pull in collections, stretch a payment, draw a bridge loan, or surface a quiet line of credit before you need it. The forecast doesn’t fix the problem. It hands you the problem with weeks to spare instead of hours.
One real warning. It’s rare for cash receipts to match a sales forecast exactly, and rare for each customer to pay on time. People pay when they pay. So treat your receipts as estimates, mark the uncertainty, and keep the model current. A forecast built on old data is worse than none, because it reports a precise number you have no reason to trust.
Where CX Cash comes in
The weak point of any 13-week model is the one the textbooks name: it’s only as good as data that stays current. A spreadsheet you refresh once a quarter goes out of date fast, and an out-of-date forecast is just confident fiction. CX Cash keeps the receipts and disbursements flowing in, so the weekly numbers stay live and the short week shows up before payroll, not after. You should know where the money is going. The 13-week is how you see it.
Frequently asked questions
How is a 13 week cash flow forecast different from a budget?
A budget is a fixed plan for what cash should do over a set term. A forecast is an estimate of what cash will actually do, and it flexes as conditions change. The 13-week is the second kind. It’s built to surface a shortfall in advance so you can act, not to grade you against a plan.
Why 13 weeks, and not 12 or 26?
13 weeks is one quarter, which lines up with how businesses already plan. It also sits near the limit of the direct method, where you’re working with real, near-term data rather than projection. Shorter and you can’t see far enough to act. Much longer and the direct method’s errors compound.
Can I still forecast monthly for anything?
Yes. A longer, monthly or quarterly view is useful for the big picture: a full year of planning, fundraising, working capital and liquidity management. Just don’t run short-term survival on a monthly cadence. Use 13 weekly numbers for the next 90 days and a coarser model for the year.
Do I need software, or is a spreadsheet enough?
A spreadsheet is enough to start, and plenty of owners run one for years. The catch is the data going out of date. The moment updating it by hand slips, the forecast stops telling the truth. That’s the gap automation closes.
The stand, one more time
Don’t wait for the turnaround. The whole trick the pros use is to run the 13-week in calm weather, so they never become the company that needs a turnaround pro at all. On a monthly view, the bad week hides inside a healthy total, and you tend to meet it on the day it lands. Put the same cash on a weekly line and it shows up early, while you can still act.
So build it. Grab our free 13-week cash flow model and forecast template, run your numbers through it this week, and send it to the owner who’s still flying on a monthly view. Then come see what CX Cash does once the data feeds itself.
More in Cash Flow Forecasting & Projections
The Cash Conversion Cycle Explained: Read It Like a Race Split
The cash conversion cycle is the clock on every dollar, from the start line where you pay suppliers to the finish where customers pay you. Here is how to read your splits and run a negative one.
Cash Flow Forecasting Techniques: Send the Right Scout Down the Road Ahead
The cash flow forecasting techniques you actually need read the ground ahead like scouts. Pick the one that fits the distance and the time you have, and your forecast stops lying to you.
Direct vs Indirect Cash Flow Forecasting: The Ticket Rail and the Books
Direct vs indirect cash flow forecasting, run like a kitchen: the direct method is the ticket rail during the rush, the indirect method is the books you square after close.