Construction Cash Flow Forecasting: How to Build a 13-Week Model

Construction is one of the most cash-intensive industries in the UK. Long contract cycles, staged payments, retention money, and CIS deductions all combine to create a cash position that can swing dramatically from one week to the next, even when a business is profitable on paper.

A 13-week rolling cash flow forecast is the single most effective tool for getting ahead of this volatility. This guide walks through exactly how to build one, what to include, and how to keep it accurate week after week. YRF Accountants builds and maintains 13-week cash flow models for construction businesses across Bolton, Manchester, and Bury as part of our Fractional CFO service.

Why Construction Businesses Need a 13-Week Forecast, Not a Monthly One

Monthly management accounts tell you what has already happened. A 13-week cash flow forecast tells you what is about to happen, in enough detail to act on it. For construction businesses specifically, this matters because:

• CIS deductions reduce cash received from contractors before it ever reaches your account

• Retention money is often withheld for months after work is completed

• Materials and subcontractor payments are frequently due well before the related invoice is paid

• Payroll, PAYE, and VAT deadlines do not move, regardless of when customers actually pay

A monthly view smooths over these swings. A weekly view exposes them, giving you time to act before a shortfall actually arrives.

What to Include in Your 13-Week Cash Flow Model

A robust 13-week model is built from six core components, each updated weekly:

Step-by-Step: Building Your First 13-Week Forecast

Step 1: Start With an Accurate Opening Balance

Pull your actual bank balance(s) directly from your bank feed or statement on the day you start the model. This is non-negotiable — an inaccurate opening balance undermines every week that follows.

Step 2: Map Out Confirmed Inflows Week by Week

List every invoice, application for payment, and CIS or retention release you expect, allocated to the specific week you genuinely expect to receive it, not the week it is invoiced or due.

Step 3: Map Out Committed Outflows Week by Week

Schedule subcontractor and supplier payments, payroll, PAYE, CIS payments to HMRC, VAT, rent, and loan repayments against the week. Each is due to leave your account.

Step 4: Calculate Net Movement and Closing Balance

For each week, subtract total outflows from total inflows to get the net movement, then carry the resulting closing balance forward as next week's opening balance.

Step 5: Track Variance and Roll the Model Forward

At the end of each week, replace forecast figures with actuals, note any variance, and add a new week 13 onto the end of the model, so you always have a rolling 13-week view ahead of you.

Example: A Sample Week-by-Week Snapshot

Here is a simplified illustration of how a construction business's cash position can move significantly within just five weeks, even while remaining profitable:

Notice how Week 5 shows a closing balance of just £1,000 — a position that would have been invisible in a monthly forecast but is flagged clearly several weeks in advance in a 13-week model, giving time to delay a non-critical payment or chase a late invoice.

Stop being surprised by your cash position. YRF Accountants builds rolling 13-week forecasts for construction businesses across Bolton and Manchester, updated weekly.

Book a Free Fractional CFO Consultation

Keeping Your Forecast Accurate: Common Pitfalls

Most 13-week models lose accuracy over time for the same handful of reasons:

• Treating invoice dates as payment dates, rather than realistic collection dates

• Forgetting to build in CIS deductions on amounts owed to you

• Failing to update the model weekly, letting it drift out of date

• Not tracking variance, so the same forecasting errors repeat every quarter

• Building the model in isolation from job costing and WIP data

Tying your cash flow forecast back into your wider management accounts and job costing data is one of the most effective ways to improve weekly accuracy.

Our Specialist Construction Industry Services bring management accounts, job costing, and cash flow forecasting together for construction SMEs across Bolton and Manchester.

Should You Build This Yourself or Bring in a Fractional CFO?

A simple spreadsheet template is a reasonable starting point for smaller contractors. But as turnover grows, the number of active contracts increases, and CIS, retention, and payroll cycles overlap. Manually maintaining an accurate weekly forecast becomes a significant time burden, and errors creep quickly.

This is exactly the gap a Fractional CFO fills: building the model correctly from the outset, updating its weekly, and flagging risks before they become genuine cash crises. For construction businesses turning over £500,000 to £5 million, this is typically the point where outsourcing cash flow forecasting pays itself many times over.

Frequently Asked Questions: Construction Cash Flow Forecasting