Short version: A 13-week cash flow forecast places every expected collection and payment into the week it actually happens, so you see a crunch weeks before it lands. The number that matters is the low point of the running balance and the week it falls in. Build it, keep it rolling, and use it to test decisions before you make them.
Profit and cash are not the same thing, and the gap between them is where businesses with good sales still miss payroll.
Your P&L can show a strong month while your bank account is sliding, because the P&L records a sale when you invoice it, not when the money lands. A $200,000 month that collects in 60 days and a $200,000 month that collects in cash look identical on the income statement and completely different in the account. The income statement answers "did I make money?" It does not answer "will I have enough on the 15th?"
The 13-week cash flow forecast answers that second question. It's the report I build first for almost every client, because it's the one that turns a surprise into a decision you make six weeks early.
One quarter, week by week. Long enough to see a crunch coming while you can still do something about it, short enough that the numbers are real instead of guesses. Thirteen weeks out, you know most of what's coming: the receivables you'll collect, the payroll runs, the rent, the loan payments, the tax deadlines. Beyond a quarter it gets speculative. Inside a quarter it's largely knowable, and knowing it is the whole point.
Monthly cash projections are too coarse. A month that nets positive can still have a Tuesday where the account hits zero because a big payable cleared before a big receivable landed. Cash problems live inside the month. You have to look week by week to see them.
Four pieces, in order:
Starting cash. The real number in the bank today, reconciled, not the QuickBooks balance that includes checks that haven't cleared.
Cash in, by week. Not revenue, collections. Take your open receivables and place each one in the week you'll actually get paid, based on that customer's real history, not their terms. A customer who "pays net 30" and always takes 50 days goes in week 7, not week 4. Add expected new sales that will collect inside the window.
Cash out, by week. Payroll on its real dates. Rent, loan payments, and other fixed costs on their dates. Payables placed in the week you'll actually pay them. Quarterly items people forget: estimated taxes, insurance renewals, software annual renewals.
Ending cash, each week. Starting cash plus in, minus out, carried forward. That running line is the report. The week it dips toward zero, or below, is the week you need to have already acted on.
Most owners read a cash forecast for the ending balance. The number that actually matters is the lowest point the running balance hits in the thirteen weeks, and which week it lands in.
If your low point is week 8 and it's uncomfortably thin, you have eight weeks to fix it, which is a lot. You can accelerate a collection, delay a discretionary payment, draw on a line of credit on purpose instead of in a panic, or hold a hire. Eight weeks of lead time turns a crisis into a calendar item. The same shortfall discovered the day it happens turns into a scramble, a maxed card, or a missed payroll.
The forecast isn't a crystal ball and it doesn't need to be. Its job is to let you test a decision before you make it.
Can you afford the new hire? Put the fully loaded cost in the forecast and watch what the low point does. Can you take the big job that needs materials up front and pays in 60 days? Model it and see whether the gap sinks you before the payment arrives. Should you take the early-pay discount a vendor is offering? The forecast tells you whether the cash is there to do it.
That's the difference between running a business on the bank balance and running it on a forecast. The balance tells you where you are. The forecast tells you where you're heading and lets you change it.
A cash forecast built once and filed is worthless by week three. The discipline is rolling it: every week, drop the week that just happened, add a new week 13 on the end, and update the collections and payments against what actually came in. Fifteen minutes a week once it's built.
The update is also where it earns its keep as a feedback loop. When a customer you had pegged for week 6 pays in week 9, you learn something about that customer, and your next forecast gets more accurate. Over a quarter or two, the forecast stops being a guess and becomes a genuinely reliable read on the next 90 days of cash.
The two-minute version: open your bank balance, write down the next four payroll dates and their amounts, and write down the three biggest receivables you're waiting on with a realistic collection date for each. That rough sketch already tells you more than most owners know about their next month of cash.
The full version is a proper weekly model built from your receivables aging, your payables, and your fixed-cost calendar, then kept rolling. Building the first one and setting up the rolling process is a defined piece of work, and it's usually the first thing I do in a fractional engagement, because almost every other financial decision gets easier once you can see the cash coming.
Building the first 13-week forecast and setting up the weekly rolling process is usually the first thing I do in an engagement, because almost every other financial decision gets easier once you can see the cash coming.
A week-by-week projection of cash in and cash out over the next quarter, built from your real receivables, payables, payroll dates, and fixed costs. It shows the running bank balance each week so you can see a shortfall before it happens.
A quarter is long enough to see a crunch while you can still act and short enough that the numbers are knowable. Weekly, not monthly, because cash problems live inside the month: a month can net positive and still have a week where the account hits zero.
The P&L records a sale when you invoice it and tells you whether you made money. The cash forecast tracks when money actually moves and tells you whether you'll have enough on a given day. A profitable month and a cash-tight month can look identical on the P&L.
Weekly. Drop the week that passed, add a new week 13, and update collections and payments against what actually came in. It takes about fifteen minutes once it's built, and the updates make it more accurate over time.
General guidance for business owners, not accounting, tax, legal, or investment advice. Your situation may differ; confirm specifics with your own professionals. Engagements are contracted through Northstar Rose, LLC.
Plain-English guides on running the finances of a small business. One email per guide. Unsubscribe in a click.