BLOG ยท CASH FLOW

TWELVE WEEKS OF PAYROLL, VISIBLE BEFORE THURSDAY.

You're running a multi-million dollar company and funding your biggest expense one week at a time. Here is the build that stops that.

BY JOSH LUEBKERPublished February 24, 2026Updated August 8, 20265 min read
QUICK ANSWER

A weekly cash flow forecast predicts payroll by running a twelve week horizon on a cash basis, with payroll entered first and every inflow dated on when the payer will release the money rather than on when you invoiced. The build is four steps: reject accruals and forecast on cash only, establish a cash baseline from your true balance across all operating accounts as line one, enter the non-negotiables with payroll and payroll taxes and benefits mapped out twelve weeks ahead, then project the inflows using each general contractor's own history, so a GC that always takes 45 days on 30 day terms gets forecast at 45. Twelve weeks is the horizon because it's long enough to see where things are heading and short enough to stay accurate. The output you're looking for is the Red Week, any week where the ending cash balance dips below your safety net of roughly two payroll cycles. Seeing one four weeks out gives you four options instead of one.

The reason this works isn't the spreadsheet. It's that payroll is the most predictable number in your business and the collections are the least, so putting the predictable one in first and forcing the uncertain one to be dated against real history turns a vague worry into a specific week with a specific number under it.

THE FULL BREAKDOWN

This post is the weekly build with payroll entered first. Read How to Build the 13 Week Cash Flow Forecast for the complete treatment, worked figures included.

SAY NO TO FRIDAY MORNING ANXIETY.

If you're a commercial subcontractor doing $5M to $10M in annual revenue, you know the feeling. It's Thursday afternoon, and you're staring at your bank balance, waiting for a single ACH from a general contractor to hit so you can fund tomorrow's payroll. You're running a multi-million dollar enterprise, yet you're managing your most critical expense, your people, one week at a time.

This reactive cycle is the silent killer of profitable construction firms. It's time to move from bank balance accounting to a proactive weekly cash flow forecast that gives you total visibility 12 weeks into the future. We don't just give you advice, we install the systems that let you see a cash crunch before it becomes a crisis.

STOP GUESSING AND START GOVERNING YOUR CASH.

Most subcontractors confuse profit with cash. You can have the most profitable job in the history of your company and still go out of business because you couldn't meet payroll in week six. In commercial construction, labor is a weekly, non-negotiable cash outflow, while your inflows are at the mercy of GC payment cycles, architect approvals, and the dreaded 10 percent retention.

To win, you have to implement a rigorous construction cash flow forecasting model. This isn't a look back at what happened last month. This is a forward-looking weapon that tells you where your cash position will be on a Tuesday morning three months from now.

THE 8-WEEK TRANSFORMATION, FROM CHAOS TO CLARITY.

We tell our clients they can transform their financial health in 12 weeks. Why 12 weeks? Because it's the right horizon for a weekly cash flow forecast. It's long enough to see where things are heading and short enough to be accurate.

Here is how you build the system that predicts payroll with surgical precision. It's four steps, and they go in this order for a reason.

STEP ONE, REJECT ACCRUALS FOR FORECASTING.

Say no to your P&L for cash management. Your profit and loss statement is great for taxes and long-term health, but it's useless for payroll planning. If you billed $200k this week, your P&L says you've $200k in revenue. Your bank account says you have zero.

A true cash flow for subcontractors has to be built on a cash basis. You only record money when it physically hits your account and when it physically leaves. That's the only way to be sure your payroll checks don't bounce.

STEP TWO, ESTABLISH THE CASH BASELINE.

Start your spreadsheet with your true cash balance as of this morning, across all operating accounts. This is your line one, and everything below it's arithmetic off that number. If you don't know your starting point, your forecast is a work of fiction.

STEP THREE, THE NON-NEGOTIABLES, PAYROLL FIRST.

Payroll is contractually defined and perfectly predictable. Unlike a material bill that you might be able to stretch an extra seven days, your field crew needs to be paid on time, every time. Enter it before anything else:

Map out your payroll dates for the next 12 weeks
Include the net pay, the payroll taxes, and the benefits
Look at your scheduling to see if labor spikes are coming due to upcoming project milestones

STEP FOUR, PROJECT THE INFLOWS, THE GC GAME.

This is where most subcontractors fail. You can't simply list when you bill the GC, you have to forecast when the GC will pay you. Look at your history with specific contractors. If GC Alpha always takes 45 days despite the contract saying 30, forecast 45 days:

Check your schedule of values
Factor in retention. That 10 percent is cash for next year
Be aggressive with your follow-ups so your projected dates stay accurate

ELIMINATE THE RETAINAGE TRAP.

For a $5M to $10M subcontractor, retention is often the difference between a large cash reserve and a line of credit that's maxed out. If you've $500,000 sitting in retention, that's $500,000 of your profit you can't use to grow your business or fund new equipment.

A construction cash flow forecasting system tracks retention release dates specifically. Build that into the weekly forecast and you can see when those large chunks of cash will hit, which lets you plan a major equipment purchase or a bonus without stressing the weekly operating budget.

HOW TO SPOT A CASH CRUNCH FOUR WEEKS OUT.

The goal of a weekly cash flow forecast is to find the Red Weeks. A Red Week is any week where your ending cash balance dips below your required safety net, which is typically two payroll cycles worth of cash. When you see one coming a month in advance, you have options:

ACCELERATE collections on outstanding invoices
NEGOTIATE terms with material suppliers
ADJUST the work schedule to better align with cash availability
DRAW on a line of credit before it becomes an emergency. Banks hate surprises and they love data-backed requests

If you wait until the week of the crunch, you aren't managing. You're firefighting, and fire is expensive.

SYSTEMIZE IT INSTEAD OF WRESTLING SPREADSHEETS.

You started your business because you're an expert in your trade. Nobody starts one to spend 20 hours a week wrestling with spreadsheets. As you scale toward $10M and beyond, the gut feeling method of financial management will fail you. What replaces it's four things done every week by somebody whose job that is:

Weekly cash flow updates, so you can run the jobs instead of the numbers
Predictive payroll analysis, with your coverage known 12 weeks out
Job costing integrity, so every job is contributing to your cash rather than draining it
Advisory on when to hire, when to buy, and when to pass on a project
WHAT TO DO WITH THIS

THE SHORT LIST.

Build it on a cash basis. The P&L is the wrong document for this question and it will tell you a comfortable lie.
Enter payroll before any inflow, because it's the one number that won't move for you.
Date every collection on what that GC has historically done, not on the payment terms in the subcontract.
Set your safety net at two payroll cycles and treat any week that dips below it as a Red Week that needs a decision now.
Track retention release dates in the same sheet, so the money you've already earned sits on a date instead of someday.
COMMON QUESTIONS

FREQUENTLY ASKED.

Twelve weeks. It's long enough to see where things are heading and short enough that the numbers still hold up, which is the tradeoff you're managing. Anything shorter doesn't give you time to act, and anything much longer starts turning into a budget rather than a forecast.
Because the P&L records revenue when you bill it and payroll clears when the bank says so. Bill $200k this week and the P&L shows $200k in revenue while the account shows zero, and it's the account that has to cover Friday. A cash basis forecast only records money when it physically moves.
Any week in the forecast where your ending cash balance falls below your safety net, which is typically two payroll cycles worth of cash. Finding one four weeks out is the whole point of the exercise, because at four weeks you can accelerate collections, negotiate supplier terms, adjust the work schedule, or draw on a line of credit as a planned decision rather than an emergency.
WHAT THIS TIES INTO
Josh Luebker, The Construction CFO
Josh Luebker
FRACTIONAL CFO · THE CONSTRUCTION CFO

Former commercial project manager and master electrician: 150+ projects worth $2.1B combined, from $50,000 to $300M. Now fractional CFO to commercial subcontractors.

STOP LETTING THE BALANCE SET YOUR STRESS.

The subcontractors we work with, from electricians to concrete contractors, share one trait: they demand visibility. Schedule a strategy call and we will talk about installing a twelve week predictive cash flow engine in your business.

You don't hire a CFO because it's safe, you do it because the real risk isn't having one.
Book a 20 minute diagnostic

20 minutes. No sales pressure. We will tell you exactly what's broken before we talk about anything else.

OR START WITH THE WORKBOOKS. NO CALL NEEDED.