How to Build a 13-Week Cash Flow Forecast for Your Restoration Company

You finished the job. The work is good, the customer is happy, the file is approved. And you still cannot make payroll on Friday without sweating it, because the carrier is sitting on 70 days of receivables you earned a month ago. That is not a sign you run a bad company. It is the structural unfairness baked into insurance restoration: you pay field labor weekly at a loaded rate, and the money to cover it shows up a full quarter later.

A 13-week cash flow forecast is the tool that turns that gap from a recurring panic into a managed number. It is built for one reason — insurance restoration AR runs 60 to 90 days, which is exactly 13 weeks. RIA Cost of Doing Business Report, 2024 A monthly budget cannot see inside that quarter; it tells you the month was profitable while the cash to prove it lands in week 11. Weekly granularity is the only horizon that lines up the two clocks you actually live by: payroll on Friday and the carrier whenever they feel like it.

This post is the build-it walkthrough for a restoration owner in the $1M–$5M range. It covers why 13 weeks and not monthly, the exact data inputs, how to forecast inflows by AR source and outflows by category with realistic timing, the 30-minute Monday update cadence, variance analysis, and the escalation triggers that tell you when to call the banker. By the end you will have a working forecast and a Monday routine to keep it honest. If you want the SOP version with every checklist step, see the 13-week cash flow forecast SOP; for the original strategy piece, see the original 13-week cash forecast.

Why 13 weeks and not a monthly budget

Median AR-to-revenue runs about 16.5%, with a DSO near 60 days against a healthy target of 45 to 65. That number is fine on paper. The problem is never the average — it is the week. A monthly view buries a 70-day carrier delay inside a "profitable" month and hands you a payroll you cannot fund. The 13-week forecast does the opposite: it puts every inflow and outflow on the specific week it lands, so you see the dip before you fall into it. For the relationship between AR timing and cash, see AR days outstanding for restoration and busy but broke.

The data inputs you need first

You can build the whole forecast from five reports, most of which export from QuickBooks in under an hour:

• AR aging report by job and collection stage — so each open receivable can be assigned an expected pay week, not a generic average.
• AP / unpaid-bills schedule with due dates — so each payable lands in the correct outflow week.
• Payroll calendar — your run dates and approximate gross per run, including the 30–55% burden on field labor.
• Debt and equipment schedules — line-of-credit interest, term-loan payments, and equipment lease and loan due dates.
• Recurring fixed-expense list — rent, utilities, software, insurance, and other monthly certainties.

The single biggest accuracy gain comes from your own carrier and TPA payment history. Pull 12 months and calculate the average days-to-pay for each payer. A carrier that pays in 75 days should be forecast at 75 — not the 30 your gut wants to use. For how insurance receivables actually clear and where supplements hide, see the complete guide to insurance billing accounting and why supplements disappear between Xactimate and QuickBooks.

Forecasting inflows by AR source

Do not forecast inflows as one lump "collections" line. Insurance cash arrives in five distinct streams, each on its own clock, and lumping them together is how forecasts go wrong. Build a separate row for each:

• TPA AR — third-party administrator programs (the code-blue TPA work) often pay on a defined cycle. Use the program's actual cycle, which can be slower than direct carrier work.
• Direct insurance AR — split into ACV (paid first, often within 2 to 4 weeks of the approved estimate) and the RCV holdback (released only after you document completion, frequently 30 to 60 days later).
• Retail AR — cash, customer-financed, or non-insurance jobs. Usually the fastest money, often net 15 to 30.
• Supplement collections — these pay whenever each supplement is approved, which is unpredictable. Companies that track supplements collect at 85–92%; those that do not collect 65–75%. RIA Cost of Doing Business Report, 2024 Forecast only what is approved, and chase the rest.
• Deductible receipts — the customer's portion. Collect it early and forecast it on the week you actually expect the check, not the week of completion.

Assign each open job's expected dollars to a specific week using that source's real lag. A job at the ACV stage with a 75-day carrier gets its ACV in roughly 3 weeks and its RCV holdback later, in week 11 or 12.

Forecasting outflows by category

Outflows are easier because most are dated certainties. Build a row for each:

• Payroll — your largest weekly outflow; field labor at a loaded rate (base wage plus 30–55% burden). Place it on every run date.
• Subcontractors — pay terms vary; place each on its agreed date, not when the invoice arrives.
• Equipment lease and loan payments — fixed monthly dates.
• Vendor AP — materials and supplies, on their due dates from the AP schedule.
• Taxes — payroll tax deposits, sales tax, quarterly estimates.
• Owner distributions — your draws; forecast them, do not pretend they are zero.
• Rent and utilities — fixed recurring dates.

Payroll and subs are the rows that move first and hurt most when AR slips, which is exactly why you want them visible against each week's projected cash. For where overhead and labor sit against benchmarks, see restoration overhead percentage and restoration financial benchmarks.

Set beginning cash and the minimum-cash line

Seed week 1 with your actual cleared bank balance across all operating accounts as of Monday morning — not the QuickBooks balance, the bank balance. Then draw your minimum-cash line across all 13 weeks. Set it at the floor below which you cannot operate: at least one full payroll plus your next debt-service payment, commonly two to four weeks of fixed costs. This line is the whole point of the exercise. It is the threshold that, when projected ending cash heads toward it, triggers action.

Sample 13-Week Forecast (first 4 weeks)

Here is the structure in practice for a roughly $3M company. The numbers are illustrative; the shape is what matters — every week ties to the one before it, and you can see week 4 heading toward trouble.

With a minimum-cash line at, say, $80,000, week 4's ending cash of $67,500 breaks the floor — and you can see it three weeks early because the tax payment and a heavy sub week land together while inflows dip. That is the entire value: three weeks of lead time to push a collection, delay a draw, or call the banker.

The Monday update cadence: 30 minutes, every week

A forecast you build once and never touch is worthless within two weeks. The discipline is a fixed Monday-morning routine, about 30 minutes:

1. Enter this morning's actual cleared bank balance as the new week 1 beginning cash.
2. Mark what actually paid last week versus what you forecast — both inflows and outflows.
3. Update the timing on open receivables: anything that slipped moves to its new expected week.
4. Add any new jobs, new bills, and newly approved supplements.
5. Roll a fresh week 13 onto the end so the horizon always stays at a full quarter.

Same time, same seat, every Monday. The point is not perfection in any single week; it is a forecast that stays honest enough to trust when it warns you.

Variance analysis: what actually happened versus what you forecast

Each Monday, the gap between forecast and actual is information, not failure. If a carrier you expected to pay in week 4 slipped to week 7, that is a 3-week variance — and two things follow. First, raise that carrier's lag assumption going forward so the next forecast is more accurate. Second, look downstream: the cash that was supposed to land in week 4 now leaves a hole, and you need to see what it does to weeks 4 through 7. Variance analysis is how the forecast gets smarter every week instead of just older.

Escalation triggers: when to act and what to do

The minimum-cash line exists to be acted on. When projected ending cash is set to break it within the next four weeks, you have three levers — pull them in order:

• Push collections first. Chase your oldest AR, escalate stuck supplements, and call adjusters on approved-but-unpaid files. This is your own money.
• Slow non-critical AP second. Stretch discretionary vendor payments — never payroll, never taxes, never anything that stops the work.
• Call the banker third, and early. Draw on your line of credit before you are desperate. A line sized at roughly 10–20% of annual revenue exists precisely for this gap; using it on a plan, not in a panic, is what keeps your debt service coverage ratio at 1.25x or better and your banker comfortable. For preparing those conversations, see the banker and SBA loan guide and line of credit for restoration companies.

Acting four weeks out gives you every option. Acting the morning payroll is due gives you none.

Common Mistakes

• Forecasting on a generic 30-day lag when your carriers actually pay in 75. Optimistic timing makes every forecast look fine until the week it does not. Build the lag from real history.
• Lumping all collections into one inflow row. TPA, ACV, RCV holdback, retail, supplements, and deductibles each pay on different clocks; one line hides the timing that matters most.
• Forecasting supplements you have only filed, not collected. Forecast approved supplements only, and track the rest — that is the difference between 85–92% and 65–75% collection.
• Using the QuickBooks balance as beginning cash instead of the cleared bank balance. Uncleared items make QBO optimistic; the bank balance is the truth.
• Building it once and never updating it. A static forecast is wrong within two weeks. The 30-minute Monday cadence is the product, not the spreadsheet.
• Leaving owner distributions out to make the forecast look better. If you take draws, forecast them — pretending they are zero just relocates the surprise.
• Ignoring the busiest-month trap. Costs scale with volume now; AR lags a quarter. Plan your draws for peak months, when the gap is widest.
• Waiting until cash actually hits the minimum line to react. The line is an early-warning trigger, not a reporting line.

Frequently Asked Questions

What is a 13-week cash flow forecast?

It is a rolling, week-by-week projection of every dollar coming in and going out over the next quarter. It starts with beginning cash, adds expected inflows by source, subtracts outflows by category, and carries ending cash forward week to week. Thirteen weeks equals one full quarter — exactly how long insurance receivables take to clear.

Why 13 weeks instead of a monthly budget?

Insurance restoration AR runs 60 to 90 days, one full quarter. A monthly budget hides the timing inside it — you can look profitable for the month and still miss a Friday payroll because the cash arrives in week 11, not week 3. Weekly granularity is the only horizon that matches the insurance pay cycle to your weekly payroll.

What data do I need to build the forecast?

Five inputs: an AR aging report by job and collection stage, an AP or unpaid-bills schedule with due dates, your payroll calendar, your debt and equipment payment schedules, and your recurring fixed-expense list. Most of this exports straight from QuickBooks in under an hour.

How do I forecast insurance receivables I have not been paid for yet?

Use your own payment history, not a generic 30 days. Pull 12 months of carrier and TPA payments, calculate the average days-to-pay for each, and apply that lag to each open job by its stage. ACV typically pays first, the RCV holdback after completion is documented, and supplements pay whenever each is approved.

What should my minimum-cash line be?

Set it at the floor below which you cannot operate — generally enough to cover at least one full payroll cycle plus your next debt-service payment, often two to four weeks of fixed costs. The point is not the exact number; it is having a fixed line so you can see weeks ahead of time when projected cash is heading toward it.

How often do I update a 13-week forecast?

Every Monday morning, in about 30 minutes. Enter the actual cleared bank balance, mark what actually paid versus what you forecast, update the timing on open receivables, and roll a fresh week 13 onto the end so the horizon always stays at 13 weeks.

What is variance analysis in a cash flow forecast?

It is comparing what you forecast for the week against what actually happened. If a carrier you expected to pay in week 4 slipped to week 7, that variance tells you to adjust the lag assumption for that carrier going forward — and to look downstream for the cash hole it creates.

What are escalation triggers and when do I act on them?

They are the actions you take when projected ending cash is set to break the minimum-cash line within the next four weeks: call your banker before you need the draw, slow non-critical vendor AP, and push collections hard on your oldest receivables. Acting four weeks early gives you options; acting the week of payroll gives you none.

Why is the cash gap worst in my busiest months?

Because costs scale with volume immediately while AR lags 60 to 90 days behind. Your most profitable months are also your most cash-hungry months — you pay payroll and subs now on jobs you will not collect on until next quarter. This is why busy restoration companies go broke.

Can I build a 13-week forecast in a spreadsheet?

Yes. A spreadsheet with 13 week columns and rows for beginning cash, inflows by source, outflows by category, net change, and ending cash is all you need. You do not need special software — you need the discipline to update it every Monday. A ready-made template is linked in this post.

How does a 13-week forecast help with a line of credit or SBA loan?

Bankers want to see that you understand and manage your cash gap. A maintained forecast shows exactly when and how much you draw and repay, which supports a line of credit sized at roughly 10 to 20% of annual revenue and helps you hold a debt service coverage ratio of 1.25x or higher.

What is the single most common mistake with these forecasts?

Forecasting inflows on a generic 30-day assumption when your carriers actually pay in 75. Optimistic timing produces a forecast that always looks fine until the week it does not. Build the lag from your real payment history, then update the timing every Monday.

Key Takeaways

• Thirteen weeks is one full quarter — the exact length of the 60–90 day insurance AR cycle — which is why weekly, not monthly, is the right horizon.
• Build inflows as five separate rows (TPA, ACV, RCV holdback, retail, supplements, deductibles) each on its own real lag; lumping them hides the timing.
• Forecast inflow lag from your own 12-month carrier payment history, never a generic 30 days.
• The minimum-cash line is the whole point: it gives you four weeks of warning before a crunch instead of finding out the morning payroll is due.
• The product is the 30-minute Monday update, not the spreadsheet. A static forecast is wrong within two weeks.
• Escalate in order — collections first, slow non-critical AP second, call the banker early and third.
• The cash gap is worst in your busiest, most profitable months because costs scale now and AR lags a quarter.

Sources Cited

• RIA Cost of Doing Business Report, 2024 — insurance restoration AR cycle of 60–90 days, median AR-to-revenue near 16.5%, DSO near 60 days, supplement collection rates of 85–92% with tracking versus 65–75% without, average net margin near 14%, and line-of-credit sizing of 10–20% of annual revenue.

Related reading: The 13-week cash flow forecast SOP · The original 13-week cash forecast · Busy but broke: restoration cash flow · Insurance pays in 90 days, payroll is Friday · The CAT season survival guide · The complete guide to restoration financial management