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.
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.
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:
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:
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:
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:
