Building the 13-week rolling forecast
A 13-week rolling cash-flow forecast is a week-by-week projection of every confirmed inflow and committed outflow over the next 91 days. It rolls forward — each week you drop the oldest week and add a new 13th week at the far end — so it stays forward-looking rather than backward-looking. For subcontractors, the three inflow buckets are open pay applications (aged by submission date), retainage holdbacks (not available until a release milestone is contractually triggered), and upcoming draw dates (from the construction loan or GC pay schedule).
The outflow side is built from the hard floor items that cannot move: payroll runs every Friday regardless of whether a draw cleared. Materials purchase orders and delivery schedules, equipment rental, and fixed overhead sit on top of payroll. Together, these outflows set the minimum cash requirement for each week. The forecast then answers: in which week do confirmed inflows fall short of committed outflows? That is the gap week, and identifying it three or four weeks out is the entire point of the exercise.
Not all expected cash is the same. The forecast only works when each bucket is staged correctly:
- Open pay applications— submitted but not yet paid. Age each one by submission date and estimate the expected payment week from the GC's typical 20-35 day approval-to-payment window. Move to confirmed only when the GC issues written approval.
- Retainage holdbacks — shown on the G702 retainage-to-date line. This is NOT available cash until a release milestone is contractually hit (substantial or final completion). Book it into the forecast only in the week the release is triggered.
- Upcoming draw dates — the disbursement schedule from the construction loan or GC pay cadence. These feed the inflow column for the week the payment is expected to clear, not the week the pay app was submitted.
Spotting the gap before payroll hits
The gap line is outflows minus confirmed inflows for each week. A negative gap line in week N means your committed outflows in that week exceed the payments confirmed to land by that week. To find the critical gap, read the gap line from left to right and find the first week where the cumulative gap turns negative and payroll is a line item — that is the week your business hits a hard cash floor without additional inflows.
The advance warning window is the number of weeks between today and that critical gap week. If the gap hits in week 4, you have weeks 1-3 to act: pull forward a retainage conversation with the GC, factor a receivable, draw on a line of credit, or delay a discretionary materials order. The mistake most subs make is reading the gap line at the draw date rather than at the payroll date — the draw date is when money is expected in, but the payroll date is the hard floor that cannot flex. Reading the wrong date makes the gap appear one to two weeks later than it actually is, which collapses the warning window exactly when you need it most.
Outflows minus confirmed inflows
Negative gap in week N = your committed outflows in that week exceed confirmed inflows. Find the first week it turns negative and payroll is on the line — that is your critical gap week.
Weeks 1–3 before critical gap
The weeks between today and the critical gap week are your action window. Three weeks lets you pull forward a retainage conversation, factor a receivable, or draw a credit line. One week is too late for most options.
Forecasting mistakes that distort the numbers
A distorted forecast is worse than no forecast — it gives false confidence that covers the gap until it's too late to act. Four mistakes account for most subcontractor cash-flow forecast errors:
Double-counting pending draws not yet approved
Counting a submitted pay app as a confirmed inflow before the GC has issued written approval. Pending draws can slide by one full approval cycle (5-20 business days) if the GC kicks back for a G703 line-item error or missing waiver. Move a pay app to confirmed only on written GC approval.
Ignoring lien-waiver processing delays (2–5 business days)
Modeling the payment date without accounting for the waiver-processing window. The typical flow — sub submits pay app → GC requests conditional lien waiver → sub prepares and delivers waiver → lender releases funds — adds 2-5 business days to the payment date on a well-run project.
Treating retainage as available cash
Booking accumulated retainage (the G702 retainage-to-date line) as a near-term inflow before a release milestone is contractually triggered. Retainage held in escrow is not liquid until substantial or final completion — treating it as available cash overstates inflows by the entire retainage balance.
Not aging open pay applications
Treating all outstanding pay apps as equally likely to pay on the next draw date, regardless of how long they have been sitting unapproved. A pay app aged 45+ days without GC approval is effectively a disputed receivable — it should be removed from the near-term inflow column until the dispute is resolved.
How admin support keeps the inputs current
A 13-week cash-flow forecast is only as good as the inputs that feed it, and the inputs decay fast — a pay app submitted Monday can be kicked back Wednesday; a draw date moves when a lender inspection is rescheduled; a retainage release gets pushed when punch-list drags. Weekly admin support at $45/hour, billed to the exact minute through Clockify, keeps the forecast live by running four update tasks every week.
- Pay app intake— logging every new G702/G703 submitted, aging the open ones against the GC's approval-to-payment window, and moving approved pay apps into the confirmed-inflow column the day written GC approval arrives.
- Retainage log— checking each project's G702 retainage-to-date against the contractual release milestone, so retainage moves into the confirmed-inflow column only when the trigger is actually hit, not when the sub estimates completion.
- Lien-waiver status — confirming which conditional waivers are outstanding and adding the 2-5 business-day processing window to the corresponding draw date so the forecast reflects actual payment timing.
- Clockify-tracked updates — every minute spent refreshing the forecast is billed accurately at $45/hour to the exact minute, with the time entries visible on the invoice before the line amount is printed.
Weekly admin support on the forecast sits inside the same hourly Clockify-tracked engagement as pay app prep, lien-waiver tracking, and A/R follow-up — the same $45/hour rate, the same per-minute billing, no retainer or minimum. Most requests are accepted within one business day.
Frequently asked questions.
What is a 13-week cash-flow forecast and why do subs need one?
A 13-week rolling cash-flow forecast is a week-by-week projection of every confirmed inflow (draw payments, retainage releases) and every committed outflow (payroll, materials, equipment, overhead) over the next 91 days. Subcontractors need one because construction payment cycles are slow and uneven — a progress draw approved today typically takes 10-30 days to hit the bank, while payroll runs every Friday regardless. Without the 13-week view, a sub can appear cash-healthy on paper while running into a payroll-week gap three weeks out. The rolling refresh (you advance one week at a time, dropping the oldest week and adding a new 13th week at the far end) keeps the forecast forward-looking rather than backward-looking, so the gap shows up before it becomes a crisis.
What are the inputs to a subcontractor's 13-week forecast?
Three buckets drive the inflow side of a subcontractor's 13-week forecast. (1) Open pay applications — every G702/G703 submitted but not yet paid, aged by submission date so you can estimate the expected payment week based on the GC's typical approval-to-payment window (often 20-35 days). (2) Retainage holdbacks — the accumulated retainage shown on each project's G702 retainage-to-date line; this is NOT available cash until a release milestone is hit (substantial or final completion), so it goes into the forecast only in the week that release is contractually triggered. (3) Upcoming draw dates — the disbursement schedule from the construction loan or GC's pay schedule; these are the weeks the next progress payment is expected and feed the inflow column directly. The outflow side is built from payroll (hard floor, never movable), materials purchase orders and delivery schedules, equipment rental and mobilization, and fixed overhead.
How do you spot a cash-flow gap before payroll hits?
The gap line is outflows minus confirmed inflows for each week. A negative gap line in week N means your committed outflows in that week exceed the payments you have confirmed will land by that week — that is the gap. To spot it before payroll hits, you read the gap line from left to right looking for the first week where the cumulative gap turns negative AND payroll is a line item. That week is the critical gap week. The advance warning window is the number of weeks from today to that critical gap week — if payroll hits in week 4 and you have a gap, you have weeks 1-3 to act: pull forward a retainage conversation, factor a receivable, or draw on a line of credit. The mistake most subs make is reading the gap line only at the draw date, rather than at the payroll date, which is the actual hard floor.
What is the biggest forecasting mistake subs make with pending draw dates?
Double-counting a pending draw is the most common distortion in a subcontractor cash-flow forecast. It happens when a sub counts a draw as a confirmed inflow in the forecast before the GC has approved the pay app — the pay app is "submitted" and the sub mentally books it as money on the way. In practice, a pending draw (submitted but not approved) sits in an approval limbo that can stretch 5-20 business days, and if the GC kicks it back for a correction (a G703 line-item error, a missing conditional lien waiver, a schedule-of-values dispute), the draw date slides by one full approval cycle. The fix is to bucket every pay app into one of three states — submitted/pending, approved/in-process, or funded/cleared — and only move it into the confirmed-inflow column when the GC has issued written approval, not when the sub has submitted the paperwork.
Why does ignoring lien-waiver delays distort a forecast?
Lien-waiver processing is a hidden timing gap that distorts subcontractor cash-flow forecasts because most subs model the payment date without accounting for the waiver-processing window. The typical flow is: sub submits pay app → GC requests conditional lien waiver → sub prepares and delivers waiver → GC processes waiver against the lender's schedule → lender releases funds → GC issues payment. The waiver-preparation and processing step alone takes 2-5 business days on a well-run project; on a project where the lender requires wet-ink originals or a notarized waiver, that window extends further. A sub who builds the forecast assuming payment on day 25 when the actual lien-waiver-adjusted window is day 30-32 will show a false positive in weeks 3-4 — the gap will appear later than modeled, and the payroll-gap detection fires too late.
How does admin support keep the forecast numbers current?
A 13-week cash-flow forecast is only as good as the inputs that feed it, and the inputs decay fast — a pay app submitted Monday can be kicked back Wednesday; a draw date moves when a lender inspection is rescheduled; a retainage release gets pushed when punch-list drags. Weekly admin support keeps the forecast live by running four update tasks: (1) pay app intake — logging every new G702/G703 submitted and aging the open ones against the GC's approval-to-payment window, (2) retainage log — checking each project's G702 retainage-to-date against the release milestone so retainage moves into the confirmed-inflow column only when the trigger is actually hit, (3) lien-waiver status — confirming which conditional waivers are outstanding and adding the 2-5 day processing window to the corresponding draw date, and (4) Clockify-tracked updates so every minute spent refreshing the forecast is billed accurately at $45/hour to the exact minute.
The 30-second version.
- A 13-week rolling cash-flow forecast shows outflows minus confirmed inflows week by week — the first negative week where payroll lands is the critical gap week.
- Three inflow buckets feed the forecast: open pay apps (aged by submission date), retainage holdbacks (NOT liquid until a release milestone is hit), and upcoming draw dates from the GC or lender schedule.
- The biggest distortions are double-counting pending draws before GC written approval, ignoring the 2-5 day lien-waiver processing window, and treating retainage as near-term available cash.
- Read the gap line at the payroll date, not the draw date — payroll is the hard floor that cannot flex, and reading the wrong date collapses the warning window.
- Weekly admin support keeps the inputs current: pay app intake, retainage log, lien-waiver status, and Clockify-tracked updates at $45/hour billed to the exact minute.