The 13-Week Cash-Flow Forecast: the one report that ends payroll anxiety

Profit is an opinion. Cash is a fact. You can have a healthy P&L and still lie awake the week before payroll — because profit and cash are not the same thing, and your accounting reports were never designed to tell you what's actually in the bank next Tuesday. The 13-week cash-flow forecast is.

If you build only one financial tool this quarter, build this one. It's the single highest-leverage report I set up for almost every new client, and it's usually the thing that turns "I'm flying blind" into "I know exactly where I stand."

I've watched this play out more than once: an owner closes their best quarter ever — record revenue, healthy profit on the P&L — while sitting about nine days from missing payroll and not knowing it. The money was real. It was just trapped in receivables that wouldn't land until the following month. A 13-week forecast shows you that cliff weeks before you reach it, while you can still steer around it.

What a 13-week cash forecast actually is

It's a simple, rolling week-by-week projection of the cash moving in and out of your business over the next quarter. Three columns at its core:

• Cash in — customer payments you realistically expect to land each week (not invoices you've sent — money you'll actually collect).
• Cash out — payroll, rent, suppliers, loan payments, taxes, subscriptions — everything leaving the account.
• Running balance — last week's closing cash, plus in, minus out. This is the number that matters.

That running balance line is the whole point. It shows you, weeks in advance, exactly when cash gets tight — while you still have time to do something about it.

Why 13 weeks?

Thirteen weeks is one quarter — long enough to see a real trend and catch a crunch before it arrives, short enough that your estimates stay grounded in reality. Beyond a quarter, weekly cash forecasting gets speculative; for that you want a monthly model instead. Thirteen weeks is the sweet spot for operating decisions.

Why it beats your P&L for day-to-day decisions

Your profit-and-loss statement is essential — but it's built on accrual accounting, which records revenue when you earn it and expenses when you incur them, not when cash changes hands. That gap is exactly where owners get blindsided:

• You invoice a big client in March and book the revenue — but they pay in June. Profitable in March, cash-poor until June.
• You buy inventory in advance. Cash gone now; the "expense" shows up only as you sell it.
• A quarterly tax bill or annual insurance premium lands all at once and the P&L barely flinches, but your bank account takes the full hit.

How to build one this week

You don't need fancy software. A clean spreadsheet beats a tool you never open. Here's the fastest path:

1. Start with today's bank balance. One real number, pulled from your account. That's week 0's closing cash.
2. Lay out 13 weekly columns. One row block for cash in, one for cash out, one for the running balance.
3. Fill in the knowns first. Payroll dates, rent, loan payments, recurring subscriptions, known tax deadlines. These are the easy, certain outflows.
4. Add expected collections. Go through your receivables and place each one in the week you'll actually get paid — based on the client's real behaviour, not their terms.
5. Layer in the variable stuff. Estimated new sales, supplier orders, owner draws. Be conservative on the way in, generous on the way out.
6. Update it weekly. Every Monday, roll it forward one week and replace estimates with actuals. This is what makes it a living tool instead of a dead spreadsheet.

The mistakes that make it useless

Three traps I see constantly:

• Confusing invoiced with collected. An invoice is a hope; a payment is a fact. Forecast the money, not the paperwork.
• Being optimistic on timing. If a client "usually" pays in 45 days, don't model 30. Optimism is how forecasts lie to you.
• Building it once and abandoning it. A forecast you don't update is just a guess with a date on it. The weekly 10-minute refresh is where all the value lives.

Done right, this one report changes how it feels to run your business. You stop reacting to surprises and start making moves — chasing a payment early, delaying a purchase a week, drawing on a credit line before you're desperate instead of after.