The 13-Week Cash Flow Forecast: The One Spreadsheet Every Small Business Should Run

Profit is an opinion; cash is a fact, and the 13-week cash flow forecast is how a business converts anxiety about the fact into a schedule. It is the tool turnaround professionals reach for first when a company is in trouble, which tells you something: it is what you would build in a crisis, so building it before the crisis is simply borrowing the discipline early. As an Accountant I have built these for businesses from two people to two hundred, and the honest pitch is this: one hour to build, twenty minutes a week to maintain, and it will show you every cash problem 6 to 10 weeks before it arrives, which is exactly enough time to do something about it.

Why 13 weeks

A quarter, in weekly resolution. Monthly forecasts hide the fatal detail: a month can look fine in total while week two contains payroll, rent, and a tax payment landing three days before your biggest receivable does. Cash problems are timing problems, and timing lives in weeks. Beyond 13 weeks, meanwhile, precision collapses into fiction; the format is honest about the horizon at which a small business can actually see.

Building it in an hour

Thirteen columns, one per week. Three blocks of rows.

Cash in. Start from your AR aging report, because your receivables are not a lump, they are a schedule with probabilities. Place each material invoice in the week you genuinely expect payment, using the customer's actual behavior, not the due date: the client who pays at day 50 regardless of terms goes in the day-50 week. For the long tail of small invoices, apply your historical collection pattern (something like 60 percent in the due week, 30 percent two weeks later, 10 percent straggling). Add committed new revenue only when signed, and haircut anything hopeful. The forecast's value is proportional to its pessimism.

Cash out. Payroll on its actual dates, rent, loan payments, tax dates (the forecast's favorite ambush), software, insurance renewals, inventory or subcontractor costs tied to the revenue above, and the owner's draw stated honestly. Fixed items repeat across columns; lumpy items go in their real weeks.

The bottom three lines. Opening cash, net movement, closing cash, each week's closing feeding the next week's opening. That closing-cash line across 13 columns is the entire product: a picture of your runway with the bumps left in.

Reading it (this is the actual skill)

The line will dip somewhere. The questions that matter: does any week go below your minimum comfortable balance (set one explicitly, typically 4 to 6 weeks of fixed costs), and is the trough temporary or structural? A temporary trough in week 6 is a scheduling problem you now have six weeks to solve: pull a receivable forward with a targeted push on the two invoices that matter (a focused version of the follow-up ladder aimed at specific dollars in a specific week), delay a discretionary payment, or draw the line of credit early and calmly instead of late and desperately. A structural slide, closing cash lower every single week, is not a timing problem at all, and the forecast has just told you so with a quarter's warning, which is the difference between adjusting pricing and headcount thoughtfully versus in a panic.

Then the weekly ritual: every Monday, twenty minutes, enter actuals against last week's forecast and roll a new week 13 onto the end. The variances are where the learning lives; a customer who lands two weeks late in the forecast twice is teaching you their real payment week, and the forecast gets smarter each cycle. (This receivables-behavior layer, who really pays when, and which promises to believe, is the exact data RevCollect maintains automatically, bias disclosed; the forecast is where that intelligence turns into decisions.)

The businesses that die of cash flow are rarely the ones with the worst numbers. They are the ones who saw the numbers last. One hour this week buys you a quarter of headlights.

FAQ

What is a 13-week cash flow forecast? A weekly-resolution projection of cash in, cash out, and closing cash across the next quarter, built from actual receivables, payables, and payroll dates rather than monthly averages.

Why weekly instead of monthly? Cash failures are timing failures within months. Weekly resolution exposes the payroll-versus-receivable collisions that monthly totals hide.

Where do I get the cash-in numbers? From your AR aging, scheduled by each customer's real payment behavior rather than the invoice due date, with hopeful revenue excluded or heavily haircut.

How accurate does it need to be? Directionally honest beats precisely wrong. Weeks 1 to 4 should be tight; weeks 5 to 13 exist to reveal shape and troughs, and they sharpen every Monday as actuals replace estimates.