Every service-business owner remembers one particular month: the one where the profit and loss looked great and the bank account did not agree. Profitable on paper, tight in reality. That gap between earning money and having money is the thing a cash flow forecast exists to close, and the 13-week version is the most useful tool I know for closing it.
I picked this up in an operating context where it is standard equipment, the kind of private-equity-backed environment where you are expected to know your cash position weeks out, not guess at it. The surprising thing is how few small service businesses run it. The generic mechanics are easy to find. What is harder, and what actually matters for a trades or service business, is reading the forecast through the lens of how you really get paid: seasonally, by project, sometimes through insurance, almost never on the day you invoiced.
Why Thirteen Weeks
Thirteen weeks is one quarter. That length is the sweet spot: far enough out to see trouble coming with time to act, short enough that the forecast stays accurate.
Shorter windows, four to eight weeks, only show you problems once it is too late to negotiate terms or arrange financing. By the time a four-week forecast flags a shortfall, you are already inside it. Longer windows, six to twelve months, drift into guesswork because too many variables move and the precision evaporates. One quarter captures a full cycle of payroll runs, quarterly bills, and customer payment patterns without losing reliability. It is long enough to be useful and short enough to be true.
The Structure
The forecast is simple in shape. For each of the next thirteen weeks you lay out four things.
- Starting cash: what is in the account at the beginning of the week.
- Cash in: every receipt you actually expect that week, based on when you think customers will pay, not when you invoiced.
- Cash out: payroll, rent, vendor payments, loan payments, and taxes due that week.
- Ending cash: starting plus in, minus out, which becomes next week’s starting cash.
That is the entire instrument. There is nothing clever about the arithmetic. The discipline is in one line of it, and getting that one line honest is what separates a forecast that protects you from one that lies to you comfortably.
The Line That Matters: Cash In
The single most important discipline is forecasting cash in by when you actually expect to collect, not when you sent the invoice. This is where a service business diverges hard from the textbook.
Your collections are not smooth. A trades business with seasonal swings, project-based billing, or insurance-paid work has lumpy, delayed, sometimes unpredictable receipts. An invoice sent today might pay in two weeks, or in sixty days, or, for insurance-pay work, considerably longer. If you forecast cash in on invoice dates, you will build a forecast that shows money arriving on days it does not arrive, which is worse than no forecast at all, because it is confidently wrong.
Reading the forecast well means reading your own collection timing honestly, which is exactly what your accounts receivable aging tells you. The forecast and the AR aging are two views of the same reality: the aging shows you how collection has actually behaved, and the forecast turns that history into a week-by-week projection of cash. Read your aging honestly and the forecast almost builds itself.
How to Build and Run It
Build it in a spreadsheet alongside your QuickBooks data. Pull the knowns first, payroll dates, rent, loan payments, tax due dates, and lay them into the weeks where they fall. Then layer in expected collections based on your real AR, not on hope.
Update it weekly, rolling the window forward one week each time so you are always looking thirteen weeks ahead. The roll is what makes it a living instrument instead of a one-time exercise. As the business grows you can connect it to the accounting system so actuals flow in automatically, but do not wait for that. A manual version updated every Monday morning beats a sophisticated one nobody maintains, every time.
What It Catches
Here is the payoff. A week-six payroll shortfall is visible in week two, when you still have room to do something about it: push collections, time a large payment differently, or arrange a credit line draw on your terms instead of in a panic. The four weeks of warning are the whole value. They turn a crisis into a decision.
Without the forecast, you discover the same shortfall on payday, when your only options are bad ones. For a service business with uneven cash timing, this is the single most valuable financial habit there is. It does not eliminate cash pressure. It converts cash pressure from a surprise into a thing you can see coming and manage, which is what separates reacting on payday from running the month on your own terms.
Picture a Tampa Bay roofing contractor in August with three large jobs closed and invoiced, a P&L that looks like the best month of the year, and a week-five payroll that the forecast says will not clear because two of those jobs are insurance-pay and will not collect until October. Without the forecast, that is a payday emergency. With it, it is a phone call in week one: a collection push on the third job, a short draw on the line of credit, a vendor payment moved by a week. Same facts, completely different month, and the only thing that changed was four weeks of warning.
The forecast runs on clean receivables and accurate books, and building this kind of forward cash visibility is part of the work we do for HVAC and other service-trade businesses across Tampa Bay.
At Tide & Ledger, bookkeeping and managerial accounting for businesses in Tampa Bay, this kind of forward cash visibility is part of the work.
Frequently Asked Questions
Why 13 weeks specifically and not a month or a year?
Thirteen weeks is one quarter, which is the balance point between foresight and accuracy. A four-to-eight week window flags problems too late to fix them. A six-to-twelve month window drifts into guesswork as variables pile up. One quarter is long enough to see a payroll shortfall coming with time to act, and short enough that the projection stays reliable.
How is a 13-week cash flow forecast different from my P&L?
The P&L tells you whether you earned a profit. The forecast tells you whether you will have cash in the account when bills come due. They diverge because booked revenue and collected cash arrive on different days. A profitable month on the P&L can still produce a cash shortfall, and only the forecast shows that gap before it becomes a problem.
Do I need special software to run one?
No. A spreadsheet alongside your QuickBooks data is enough, and a manual version updated every Monday beats a sophisticated one nobody maintains. As the business grows you can connect it to your accounting system so actuals flow in automatically, but the habit of updating and rolling it forward weekly matters far more than the tooling.
What is the most common mistake in building one?
Forecasting cash in by invoice date instead of by when you actually expect to collect. For a service or trades business with seasonal, project-based, or insurance-paid work, collections are lumpy and delayed. Building the forecast on invoice dates produces a projection that shows money arriving when it does not, which is worse than no forecast, because it is confidently wrong.
