Skip to main content
JOB COSTINGCASH FLOWWIP REPORTINGFRACTIONAL CFOSUBCONTRACTOR FINANCEOVERHEAD RATEPAY APP BILLINGAR RECOVERYCONTROLQORECFOSJOB COSTINGCASH FLOWWIP REPORTINGFRACTIONAL CFOSUBCONTRACTOR FINANCEOVERHEAD RATEPAY APP BILLINGAR RECOVERYCONTROLQORECFOSJOB COSTINGCASH FLOWWIP REPORTINGFRACTIONAL CFO
THE CONSTRUCTION CFO BOOK A FREE CALL

CONSTRUCTION BACKLOG QUALITY ANALYSIS

QUICK ANSWER

Backlog at face value is misleading. Two subcontractors with identical $8M backlogs can have completely different financial profiles depending on margin spread across projects, customer concentration, schedule timing, and cash conversion patterns. Backlog quality analysis examines five factors beyond the dollar number: margin distribution (are 80% of expected gross margin dollars coming from 20% of backlog?), customer concentration (does losing one GC tank the picture?), schedule timing (when does each project actually run?), cash conversion (does the backlog produce cash on the timing the business needs?), and execution risk (are there projects in the backlog the business shouldn’t have bid?).

Your $10M backlog isn’t one number. It’s 15–30 projects with different margins, timing, customers, and execution risk. The aggregate hides the story.

PUBLISHED JUNE 12, 2026 BY JOSH LUEBKER UPDATED JUNE 12, 2026
THE PROBLEM WITH AGGREGATE BACKLOG

WHAT THE DOLLAR NUMBER HIDES

Most subcontractors report backlog as a single dollar number — the sum of all signed contracts not yet completed. The number gets shared with the surety, the bank, the owner, and sometimes employees. It feels like a meaningful metric because it’s a clean aggregate. It’s also nearly useless for decision-making at the management level.

A $10M backlog could be 12 projects with healthy margins, balanced customer mix, and good cash conversion timing — a strong portfolio. Or it could be 25 projects with one customer representing 60%, three projects expected to run negative, schedule timing that produces cash crunches in months 4 and 9, and two projects that the business probably shouldn’t have bid — a weak portfolio. Same backlog number, very different financial reality.

Real backlog quality analysis breaks the aggregate into the components that determine financial outcome and surfaces the structural issues that the dollar number averages out.

FIVE FACTORS

WHAT BACKLOG QUALITY ACTUALLY MEASURES

FACTOR 1

MARGIN DISTRIBUTION ACROSS BACKLOG

Healthy backlogs show relatively tight margin distribution — most projects within 200–400 basis points of the company average target margin. Unhealthy backlogs show wide distribution — some projects at 30%+ margin subsidizing other projects at 5% or negative. Margin distribution analysis surfaces whether the company’s bidding discipline is consistent or whether the portfolio is being held together by a few exceptional projects masking systematic underbidding.

FACTOR 2

CUSTOMER CONCENTRATION

What percentage of backlog dollars come from the top 3 customers? Backlogs with top-3 customer concentration above 60–65% carry significant risk — losing one customer changes the picture materially. Concentration also affects negotiating leverage and project terms; subs with high concentration tend to accept worse pay terms, more aggressive change order behavior, and tighter retention than diversified subs.

FACTOR 3

SCHEDULE TIMING DISTRIBUTION

When does the backlog actually run? A $10M backlog that produces $4M of revenue in the next 6 months and $6M spread over the following 18 months has different cash and capacity implications than a backlog where $8M of revenue happens in the next 9 months. Schedule timing analysis surfaces whether the backlog matches the capacity ramp-up the business can actually execute and whether cash conversion timing matches expense timing.

FACTOR 4

CASH CONVERSION TIMING

Different customer types pay on different cycles. Private commercial GCs typically pay 30–45 days. Public sector pays 60–120. Carrier MSA work pays 60–90. The expected cash conversion of the backlog depends on customer mix more than total dollar value. A backlog heavy in public sector work produces less cash per month than the same dollar backlog of private commercial work.

FACTOR 5

EXECUTION RISK ASSESSMENT

Some projects in the backlog were probably bid wrong, won at the wrong price, or accepted on terms the business shouldn’t have accepted. These projects represent execution risk — they’re likely to produce sub-target margin, cash flow stress, or operational distraction during execution. Quality analysis surfaces which projects fit this profile so management can plan accordingly (extra PM attention, schedule prioritization, change order discipline, sometimes proactive renegotiation).

THE METHODOLOGY

HOW BACKLOG QUALITY GETS ANALYZED

The analysis methodology is straightforward but requires data discipline. The required inputs:

  • Project-by-project margin estimates. Expected gross margin for each project in backlog, refreshed quarterly against current cost data (not bid-time data 8 months stale).
  • Customer assignment. Each project assigned to its actual customer (GC, owner, public agency). Concentration percentages calculated from project-level data.
  • Schedule data. Expected start, expected substantial completion, expected revenue recognition curve. PM-validated monthly.
  • Customer pay cycle data. Each customer’s actual pay cycle from historical receivables data, not contract terms.
  • Execution risk flagging. Each project assigned a risk category (standard, watch, problem) based on PM and CFO joint assessment.

With these inputs, the analysis produces: margin distribution chart, concentration percentages, monthly revenue recognition forecast from backlog, monthly cash conversion forecast from backlog, and risk-flagged project list. The outputs feed directly into capacity planning, hiring decisions, banking conversations, and surety reporting.

WHAT IT DRIVES

DECISIONS THAT BACKLOG QUALITY INFORMS

  • Bidding discipline calibration. Are recent bids landing in the target margin range or drifting? Backlog quality analysis surfaces drift before it shows up as completed-project margin compression.
  • Customer diversification strategy. Where is concentration risk building? Which customer relationships need to be developed to reduce exposure? Quality analysis surfaces concentration trends before they become single-customer dependency.
  • Capacity ramp-up timing. When does the backlog actually need additional capacity? Schedule distribution surfaces whether hiring should happen now, in 3 months, or whether the company already has too much capacity for the work coming.
  • Working capital and banking strategy. Cash conversion timing surfaces months where the business needs additional working capital. Banking conversations happen on the timeline the cash needs require, not in crisis mode.
  • Surety capacity conversations. Quality analysis is what sureties actually want to see when evaluating bonding capacity increases. Subs that produce it get treated differently than subs that only produce aggregate backlog numbers.

The aggregate backlog number is a lagging indicator of bidding activity. Backlog quality analysis is a leading indicator of financial outcomes.

FREQUENTLY ASKED

Monthly for active subs, quarterly minimum. The components (margin estimates, schedule data, customer concentration, cash conversion) all change as projects close out, new projects get added, and existing projects experience scope changes. Annual analysis is too stale to drive useful decisions; monthly catches drift in time to act on it.
For subs at $2M–$5M revenue, top-3 customer concentration of 45–60% is normal. Above 65% creates material concentration risk. For subs at $5M–$12M, the healthy range drops to 35–55%; above 60% concentration starts to limit growth options because surety capacity gets capped at concentration thresholds. The right concentration depends on the customer mix — a sub heavy in long-term carrier MSA work has different concentration considerations than a sub working with rotating commercial GCs.
Uncertain backlog (signed contracts with material scope uncertainty) and pending backlog (LOIs, awarded but not contracted) should be tracked separately from confirmed backlog. The analysis is done on confirmed backlog; pending and uncertain backlog get reviewed separately because their conversion probability is meaningfully below 100%. Mixing pending into confirmed produces inflated numbers and bad capacity decisions.
Yes, although the format is simpler. A $2M sub with 8 projects in backlog can do the analysis in a 30-minute spreadsheet exercise quarterly. A $10M sub with 30 projects needs more structured systems. The principle is the same at every scale: the aggregate number hides the components that actually determine financial outcomes, and surfacing those components produces materially better management decisions.
WIP reporting handles active projects; backlog analysis handles projects not yet started or in early stages. Together they cover the full project portfolio. Many subs do basic WIP but skip backlog analysis, missing the upstream view of what's coming and whether the pipeline matches capacity, customer concentration goals, and margin targets. WIP without backlog analysis is reactive; both together is proactive.
Josh Luebker, The Construction CFO
JOSH LUEBKER
THE CONSTRUCTION CFO · SULPHUR PRAIRIE MANAGEMENT

PM and master electrician turned CFO. Managed 150+ projects, $300M+ in volume — Google data centers, military bases, hospitals — before building the financial control system that saves subcontractors from running out of cash. SPM runs the financial function for $1M–$12M commercial subs across 24 trade specializations. Read the methodology at runoncfos.com.

RELATED SYSTEM PAGES
CFOS MODULE
CEO Reporting & Forecasting
How backlog quality flows into management reporting
CONTENT
Bonding Readiness for Subcontractors
How backlog quality affects surety evaluation
CFOS MODULE
Operating Model Definition
The framework that integrates backlog quality into management cadence

YOUR BACKLOG NUMBER IS HIDING THE PICTURE THAT MATTERS.

30 minutes. We’ll analyze your backlog the way your surety wishes you did.

BOOK A FREE CALL OR RUN YOUR FREE CEO REPORT FIRST
SYSTEM CONNECTIONS
CFOS SPINE + MODULES
Run on CFOS — Full System Index Operating Model Definition Cash Control System Job Profitability System
RELATED SYSTEMS
CEO Reporting System Bonding Readiness Operating Model Definition
SERVICE LAYER
Fractional CFO for Construction Construction Bookkeeping Construction Controllership
THE CONSTRUCTION CFO
Run on CFOS Fractional CFO Cash Control Book a Call CONTROL Book → Josh@ConstructionCFO.net
© 2026 SULPHUR PRAIRIE MANAGEMENT · SULPHUR ROCK, AR
0
Josh Luebker, The Construction CFO
JOSH LUEBKER
FOUNDER & CFO

Master electrician and former project manager, 150+ projects and $2.1B+ in commercial work. Now runs the numbers for subcontractors instead of standing on the job site.

LinkedIn About
Stewart Bohrer, The Construction CFO
STEWART BOHRER
VP OF OPERATIONS

Keeps the system running day to day: job costing, WIP, monthly financial reviews, and the follow-through between calls. Josh handles onboarding.

LinkedIn About
LinkedIn YouTube About Run on CFOS CONTROL Book →
© 2026 SULPHUR PRAIRIE MANAGEMENT · SULPHUR ROCK, AR