BACKLOG QUALITY

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 how the work converts to cash. Quality analysis examines five factors beyond the dollar figure: margin distribution, customer concentration, schedule timing, cash conversion, and execution risk. Your $10M backlog isn't one number. It's 15 to 30 projects with different margins, timing, customers, and risk, and the aggregate hides every bit of it.

The reason this gets skipped is that the single number feels like an answer. It goes to the surety, the bank, and the crew, and everybody nods at it. But a backlog is a portfolio, and nobody would evaluate a portfolio by adding up the positions and stopping there. Breaking it apart takes a spreadsheet and an afternoon at $2M and a real system at $10M, and either way the output is the same. You find out which projects are holding up the year, which customer you can't afford to lose, and which month runs out of cash.

BY JOSH LUEBKERPublished 2026-08-06Updated 2026-08-07
THE DEFINITION

WHAT IT MEANS.

Backlog quality analysis is the review that breaks a single backlog dollar figure into its margin distribution, customer concentration, schedule timing, cash conversion, and execution risk.

Most subcontractors report backlog as one dollar figure, the sum of all signed contracts not yet completed. That figure goes to the surety, the bank, the owner, and sometimes the employees. It feels meaningful because it's a clean aggregate. It's also close to useless for making a management decision.

A $10M backlog could be 12 projects with healthy margins, a balanced customer mix, and good cash conversion timing, which is a strong portfolio. Or it could be 25 projects with one customer at 60% of the total, three projects expected to run negative, schedule timing that produces cash crunches in months 4 and 9, and two projects the business should never have bid, which is a weak portfolio. Same backlog figure, and two very different financial realities. Quality analysis breaks the aggregate into the components that decide the outcome and surfaces the structural problems the dollar figure averages out.

WHAT THE DOLLAR NUMBER HIDES

FOUR THINGS THE AGGREGATE AVERAGES OUT.

01

Margin distribution across the backlog

Healthy backlogs show a fairly tight margin distribution, with most projects inside 200 to 400 basis points of the company's target margin. Unhealthy backlogs show a wide spread, with some projects at 30% or better subsidizing others at 5% or negative. The distribution tells you whether your bidding discipline is consistent or whether the portfolio is being held together by a few exceptional projects that are covering for systematic underbidding everywhere else.

02

Customer concentration

What percentage of backlog dollars comes from the top 3 customers? Concentration above 60% to 65% brings significant risk, because losing one customer changes the whole picture. It also costs you negotiating position. Subs with high concentration tend to accept worse pay terms, more aggressive change order behavior, and tighter retention than diversified subs do, because both sides know who needs the relationship more.

03

Schedule timing distribution

When does the backlog run? A $10M backlog that produces $4M of revenue in the next 6 months and $6M spread across the following 18 months has completely different cash and capacity implications than one where $8M of revenue happens in the next 9 months. Timing analysis tells you whether the backlog matches a capacity ramp the business can execute, and whether the cash coming in matches the expenses going out.

04

Execution risk

Some projects in the backlog were bid wrong, won at the wrong price, or accepted on terms the business should have refused. Those come with execution risk, meaning they're likely to produce sub target margin, cash flow stress, or an operational distraction while they run. Quality analysis flags which projects fit that profile so management can plan for it with extra PM attention, schedule priority, change order discipline, and occasionally a proactive renegotiation.

THE MATH

WHAT IT LOOKS LIKE IN DOLLARS.

Cash conversion timing, by customer type

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

What the surety sees

Quality analysis is what sureties want in front of them when they're evaluating a bonding capacity increase. Subs who produce it get treated differently from subs who only produce an aggregate backlog figure, and the difference in treatment comes through as capacity and rate rather than as a compliment.

HOW BACKLOG QUALITY GETS ANALYZED

THE FIVE INPUTS THE ANALYSIS RUNS ON.

Project by project margin estimates

Expected gross margin on every project in the backlog, refreshed quarterly against current cost data rather than bid time data that's 8 months stale. This is the input people skip, and skipping it's what makes the whole exercise decorative instead of useful.

Customer assignment on every project

Each project gets assigned to its true customer, whether that's the GC, the owner, or a public agency. Concentration percentages then get calculated from project level data and not from somebody's impression of who the big accounts are.

Schedule data, PM validated monthly

Expected start, expected substantial completion, and the expected revenue recognition curve for every project, confirmed by the PM every month. A schedule the PM hasn't looked at is a schedule that describes the plan rather than the job.

Customer pay cycle data from history, not from contracts

Each customer's true pay cycle comes out of your own historical receivables data and not out of the contract terms. Contract terms describe what was agreed. Receivables history describes what happens, and the forecast has to be built on the second one.

Execution risk flagging by the PM and the CFO together

Every project gets a risk category of standard, watch, or problem, assigned jointly by the PM and the CFO function. Those five inputs produce the outputs, and the outputs feed capacity planning, hiring decisions, banking conversations, and surety reporting directly.

WHAT YOU GET

THE OUTPUTS, NAMED.

Margin distribution chart across the full backlog
Top 3 customer concentration percentages from project level data
Monthly revenue recognition forecast built from the backlog
Monthly cash conversion forecast built from the backlog
Risk flagged project list, categorized standard, watch, or problem
$10.7M+
Client AR Recovered Since 2023
48
Active Trade Specializations
60 DAYS
Average Onboarding Time
PRICING

FLAT MONTHLY FEE. NO SURPRISES.

Three tiers, priced by your trailing twelve month revenue. Which one you're in depends on how much of the work you want off your desk. No hourly billing. No payroll. The one-time onboarding fee is right here in the table.

Last 12 months revenueMonthly feeOne-time onboarding
Up to $1M$1,900 to $2,900$1,000
$1M to $3.5M$2,600 to $3,900$1,500
$3.5M to $6.5M$3,800 to $5,700$3,000
$6.5M to $9.5M$5,100 to $7,100$4,500
$9.5M to $12.5M$6,100 to $8,500$6,000
$12.5M to $15.5M$7,400 to $11,000$7,500
$15.5M to $18.5M$9,400 to $13,500$9,000
$18.5M+Quoted individuallyQuoted individually

The onboarding fee covers migrating your books back to the start of your last taxable year and getting you fully operational in 60 days. It's billed once, with your first invoice. It's the same for all three tiers. Your first month is prorated, and your monthly engagement starts on the first of the first full month.

Range reflects the three tiers below. Which one you're in depends on how much of the work you want off your desk. No payroll. No hidden line items. The onboarding fee is right here in the table.

Core

You stop guessing.

You get the CFO work. Job costing built against the way you estimate, a 13 week cash forecast, monthly WIP, and a meeting every month that ends in decisions and never in a report.

Your bookkeeper still does the books.

Executive

You stop touching the books.

Everything in Core, and we do the bookkeeping and the controllership as well. Your office stops answering coding questions and stops fixing a reconciliation that will not balance on the last day of the month.

We do the books. No payroll.

Strategic

Every job shows its margin while it is still open.

Everything in Executive, plus the job costing and WIP platform set up, loaded with your cost codes, and managed for you every month. You never have to learn it.

We do the books, the job costing, and the software. No payroll.

COMMON QUESTIONS

FREQUENTLY ASKED.

Monthly for active subs, and quarterly at the absolute minimum. The components all move as projects close out, new projects get added, and existing projects take scope changes, so margin estimates, schedule data, concentration, and cash conversion are all live figures. Annual analysis is too stale to drive a decision. Monthly catches the drift while there's still time to do something about it.

For subs at $2M to $5M revenue, top 3 customer concentration of 45% to 60% is normal, and above 65% creates material concentration risk. For subs at $5M to $12M, the healthy range drops to 35% to 55%, and above 60% starts to limit growth options because surety capacity gets capped at concentration thresholds. The right number depends on the customer mix, since a sub heavy in long term carrier MSA work is in a different position than one working with rotating commercial GCs.

Uncertain backlog, meaning signed contracts with material scope uncertainty, and pending backlog, meaning letters of intent or awards not yet contracted, both get tracked separately from confirmed backlog. The analysis runs on confirmed backlog only. Pending and uncertain work gets reviewed on its own because the conversion probability is meaningfully below 100%. Mixing pending into confirmed produces inflated figures and bad capacity decisions.

Yes, though the format is simpler. A $2M sub with 8 projects in backlog can run the analysis as a 30 minute spreadsheet exercise once a quarter. A $10M sub with 30 projects needs a more structured system to do it. The principle holds at every scale. The aggregate figure hides the components that decide the financial outcome, and surfacing those components produces materially better management decisions.

WIP reporting covers active projects and backlog analysis covers projects not yet started or in their early stages, so together they cover the full portfolio. Plenty of subs run basic WIP and skip backlog analysis, which means they lose the upstream view of what's coming and whether the pipeline matches their capacity, their concentration goals, and their margin targets. WIP on its own is reactive. WIP plus backlog analysis is proactive.
WHAT THIS TIES INTO
Josh Luebker, SPM The Construction CFO
Josh Luebker
FRACTIONAL CFO · SPM THE CONSTRUCTION CFO

Josh Luebker is a master electrician turned construction CFO, president of SPM The Construction CFO and author of CONTROL: C.F.O.S. Construction Financial Operating System.

YOUR BACKLOG NUMBER IS HIDING THE PICTURE THAT COUNTS.

You'll spend twenty minutes answering questions about which projects sit in your backlog, which customers they came from, and how the risk spreads. Josh isn't selling anything and no proposal follows. If he can help, you'll book a longer call.

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 call

20 minutes. Nothing gets sold on this call and nothing gets proposed. Josh asks questions to work out whether he can help at all.

OR GET THE WIP SCHEDULE TEMPLATE. NO CALL NEEDED.