How to Build a 13-Week Cash Flow Forecast for Contractors

Most contractors find out about a cash shortfall the week it arrives, when payroll is due and the money is not there. A 13-week cash flow forecast fixes that. It is the single most useful financial tool a construction business can run, because it shows you a shortfall three or four weeks before it happens, while you still have time to do something about it. This guide walks through how to build one step by step, what makes a construction forecast different from a generic one, and how to keep it accurate.

What Is a 13-Week Cash Flow Forecast?

A 13-week cash flow forecast is a rolling, week-by-week projection of the cash coming into and going out of your business over the next quarter. Each week shows your expected collections, your scheduled payments, the net change, and the running bank balance. Updated weekly, it turns cash from something you react to into something you manage.

Thirteen weeks is the standard window for a reason. One quarter is far enough out to see trouble coming and to act on it, but near enough that you can forecast with real accuracy. A 12-month projection is useful for planning, but it is too coarse to manage week-to-week cash. The 13-week view is the operating tool.

Why Contractors Especially Need One

Every business has timing differences between spending and collecting, but construction has the widest gap of any industry. You pay for labor and materials now, bill at the end of the period, then wait 30 to 60 days or more to collect, while retainage holds back part of every payment until the job closes. Run several jobs at once and those gaps stack on top of each other.

That is why a contractor can be profitable on paper and still miss payroll. The profit is real, but it is tied up in unbilled work, slow receivables, and retainage. A 13-week forecast is how you see the cash behind the profit. (For the bigger picture on this, see our guide to managing construction cash flow.)

How to Build a 13-Week Cash Flow Forecast: Step by Step

Step 1: Start With Your Current Cash Balance

Open week one with your actual bank balance today, net of any checks already written that have not cleared. Every week after that opens with the prior week's closing balance. This running balance is the number that tells you, at a glance, which weeks are safe and which are tight.

Step 2: Forecast Your Collections, Week by Week

Lay out when you realistically expect each receivable to land, not when the contract says it is due. Use each owner's actual payment behavior. Include:

• Progress billings and draws, placed in the week you expect the cash, not the week you bill
• Retainage releases you expect to collect as jobs close
• Deposits and mobilization payments on new work
• Any other inflows (equipment sales, tax refunds, loan draws)

The draw lag is the part contractors most often get wrong. If your owner historically pays 45 to 60 days after you submit, the cash belongs in week 7 or 8, not the week you billed.

Step 3: Forecast Your Outflows, Week by Week

List every payment by the week it actually leaves your account:

• Payroll and payroll taxes, on your real pay cadence (weekly or biweekly)
• Material purchases and supplier payments
• Subcontractor payments, net of retainage you are holding
• Equipment, rentals, and loan or lease payments
• Insurance, bonding, overhead, rent, and software
• Estimated taxes and any owner draws or distributions

Payroll is usually the largest and least flexible outflow, so anchor the forecast around your pay dates first, then layer everything else in.

Step 4: Calculate Net Change and Running Balance

For each week, subtract outflows from inflows to get the net change, then carry the running balance forward. Any week where the running balance turns negative, or drops below your minimum operating cushion, is a shortfall you can now see in advance.

Step 5: Model the "What Ifs"

A forecast is most powerful when you stress it. What happens if your biggest owner pays two weeks late? If a draw gets rejected and has to be resubmitted? If you win the next bid and have to fund mobilization? Adjusting a few cells shows you how much cushion you really have and which risks would actually hurt.

Step 6: Update It Every Week

The forecast is only useful if it stays current. Each week, roll off the completed week, add a new week 13 at the end, and replace your estimates with what actually happened. Comparing forecast to actual sharpens your accuracy fast, and after a month or two the forecast becomes genuinely reliable. This weekly discipline is a core part of CFO-level financial planning.

What Makes a Construction Cash Flow Forecast Different

A generic cash flow template will not serve a contractor, because it ignores the things that actually drive construction cash. A real construction forecast needs:

• Retainage rows: retainage withheld from your billings (reducing current collections) and retainage you expect to release back to subs, tracked separately
• Draw timing lag: collections placed in the week the draw actually funds, often 45 to 90 days out
• Per-job visibility: the ability to see which jobs are bringing cash in and which are consuming it
• Payroll cadence vs. billing cadence: weekly payroll against monthly billing is the core mismatch the forecast has to expose

Most free templates online are built for generic service businesses and have none of this. A construction-specific forecast that models retainage, draws, and per-job cash is what turns the tool from interesting into indispensable.

A Simple Worked Example

Say you open the quarter with $80,000 in cash. Weeks 1 through 4 look comfortable: draws are landing and payroll is covered. But in week 5 a $120,000 draw you expected slips because the owner is slow, while payroll, a large material order, and a sub payment all hit the same week. Your running balance dips to negative $15,000 in week 5 before recovering in week 6 when the draw finally lands.

Without a forecast, week 5 is a crisis. With one, you saw it in week 2 and had options: accelerate a different billing, push the material order a week, draw on your line of credit deliberately, or call the owner to expedite the draw. Same facts, completely different outcome. That is the entire value of the forecast.

Common Forecasting Mistakes

Using Invoice Dates Instead of Expected Payment Dates

Placing cash in the week you bill rather than the week you collect makes the whole forecast wrong. Forecast collections on real payment behavior.

Forgetting Retainage

If your forecast shows full billing amounts as collections, it overstates cash by the retainage percentage on every job. Model the withholding. See our guide to retainage for how it flows.

Not Updating It

A forecast built once and left alone is worthless within two weeks. The weekly roll-forward is what keeps it accurate and useful.

Building It on Bad Books

The forecast is only as good as the data behind it. If your receivables, payables, and retainage are not current, your forecast is a guess. Accurate construction bookkeeping is the foundation.

Tools: Building It in Excel

Most contractors build the 13-week forecast in a spreadsheet, fed by data from their accounting system. QuickBooks or your construction accounting software supplies the AR aging, billing, and payables that drive the forecast, while the forecast model itself lives alongside in Excel. The tool does not need to be sophisticated. A clean spreadsheet updated every week beats a complex system nobody maintains.

How FinTruction Builds and Maintains Your Forecast

At FinTruction, the 13-week cash flow forecast is one of the tools we build and run for contractors as part of our CFO services. We start with accurate, current books so the receivables, payables, and retainage feeding the forecast are real, then build a construction-specific model that captures draw timing, retainage, and per-job cash. We update it every week and walk you through it, so you always know which weeks are tight and what to do about them. The result is simple: you stop being surprised by cash, because you can see it coming. It pairs directly with knowing how much working capital you need and how to get paid faster.

Frequently Asked Questions About the 13-Week Cash Flow Forecast

Why 13 weeks specifically?

Thirteen weeks is one quarter, which is the sweet spot for managing cash. It is far enough out to see a shortfall with time to act, but near enough that your week-by-week estimates are accurate. Longer projections (six or twelve months) are useful for planning but too coarse to manage operating cash, while a shorter window does not give you enough warning.

How often should I update the forecast?

Weekly. Each week you roll off the completed week, add a new week at the end to keep the 13-week window, and replace estimates with actuals. This roll-forward is what keeps the forecast accurate. A forecast that is not updated weekly is out of date almost immediately.

What is the difference between a cash flow forecast and a WIP report?

A WIP report shows profit: how much revenue you have earned versus billed on each job. A cash flow forecast shows cash: when money will actually move in and out. A job can look profitable on the WIP and still be draining cash, which is exactly why you need both.

Can I build a 13-week forecast in QuickBooks?

QuickBooks supplies the data (AR aging, open invoices, bills, retainage balances), but the 13-week forecast itself is usually built in a spreadsheet alongside it so you can lay out collections and outflows by week and model scenarios. The key is that the QuickBooks data feeding it is accurate and current.

What should I do when the forecast shows a shortfall?

Because you see it weeks ahead, you have options: accelerate a billing or follow up on a slow receivable, delay a discretionary payment or large material order, negotiate timing with a supplier, or draw on a line of credit deliberately rather than in a panic. The whole point of the forecast is to convert a future crisis into a manageable decision you make early.