Many service-business owners know the month: the profit and loss looked great and the bank account did not agree. Profitable on paper, tight in reality. That gap is one of the systems that strain first when a business grows. A cash flow forecast is how you see and manage that gap, and the 13-week version is the format I keep coming back to.
I picked this up owning the P&L for two trades businesses at Apex Service Partners, in an operating context where a rolling cash forecast is standard equipment, and I was struck by how many good businesses run without one. The generic mechanics are easy to find. What is harder is translating your actual receivables, your customers’ payment history, and the work already scheduled into weekly collection assumptions you can defend. For many service businesses that is the hard part, because collection timing can be seasonal, project-based, insurance-dependent, or simply later than the invoice date.
Why Thirteen Weeks
Thirteen weeks is one quarter. It captures a full cycle of payroll runs, quarterly bills, and customer payment patterns while still resting on assumptions you can defend.
Horizon is a trade-off. Four to eight weeks gives more near-term precision and is genuinely valuable when cash is tight. Six to twelve months helps with planning and financing conversations but leans on more assumptions, so it is less reliable for weekly operating decisions.
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: the receipts you actually expect to land that week.
- Cash out: payroll, materials, subcontractors, rent, vendor payments, loan payments, taxes, and any planned equipment purchase landing in that week.
- Ending cash: starting plus in minus out, which becomes next week’s starting cash.
That is the basic skeleton. You can add a minimum-cash threshold, your credit line capacity, and a scenario or two later. The discipline is in one line of it.
The Line That Matters: Cash In
One of the most important disciplines is forecasting cash in by when you actually expect to collect, not when you sent the invoice. This is where service-business reality matters most. Your collections often 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, and insurance-paid work runs on its own clock.
Your accounts receivable aging is one useful input here, because it shows which invoices are outstanding and how old they are right now. But the aging only shows current position. The payment history tells you when the money actually arrives, and that is the number the forecast runs on.
How to Assign a Collection Week
One way to do it, and a defensible one: for each open invoice, look at how that customer settled their last three invoices. Take the middle of the three, not the fastest one, and place the receipt in that week. The fastest payment is the one you remember, and the one you will plan around if you let yourself.
Group by work type instead of by customer where the payer is an insurer or a general contractor, in the cases where the payment channel tells you more than the individual customer’s history does. For insurance-paid work, carrier timing is often more informative than the individual customer’s payment history.
For the weeks beyond the invoices already on the books, layer in expected billings and deposits from scheduled work, recurring contracts, and projects due to hit a billing milestone, using the same collection lags. A forecast built only on today’s AR runs dry in the back half of the quarter, which is exactly the stretch you built it to see.
How to Build and Run It
Build it in a spreadsheet alongside your QuickBooks data. Cash flow forecasting is part of the managerial accounting work at Tide & Ledger, and it still starts here. A spreadsheet works fine as an operating forecast even when it would not work as your accounting system of record; the two jobs are different. Pull the knowns first, payroll dates, rent, loan payments, tax due dates. Then layer in expected collections using lags appropriate to the customer, the payer, or the work type.
The weekly update is where the tool either improves or stalls. Before you roll the window forward, replace the week that just closed with actual results and see where the timing differed. That variance tells you which customers and which assumptions to adjust, so the model gets more accurate as you correct the ones that repeatedly miss. It is also an easy discipline to lose once the week gets busy. A manual version updated every Monday morning beats a sophisticated one nobody maintains.
What It Catches
Here is the payoff. A projected week-six payroll shortfall may become visible several weeks earlier, when you still have room to do something about it: push collections, reschedule a payment, draw on a line of credit you already have, or start a financing conversation earlier than you otherwise would. Without a forecast, the same shortfall can surface much later, when the remaining options are worse.
If collections and major outflows are both highly predictable, you may not need a 13-week forecast as a standing weekly discipline. If they are not, this will not eliminate the pressure, but it moves it from payday to a Monday morning when you still have options.
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.
