“50 Down, 40 Progress, 10 Retention” — Why Staged-Payment Tracking Breaks in Your Head, Not Your Spreadsheet

If your high-ticket jobs bill in stages — say 50% down, 40% on progress, 10% retention — staged-payment tracking breaks because the schedule lives in your head, a notebook, and a spreadsheet only one person updates. The money you’ve already earned but not yet collected slips through the cracks not from bad math, but because nothing flags each milestone the moment it falls due.

You closed the deal. You did the work. And somehow the cash still arrives late, or not at all, on the back half of the project. If that sounds familiar, you are not disorganized. You are running a quote-to-cash-to-delivery business on milestone billing — and the milestones are quietly outrunning your memory.

The pattern, in their own words

An owner who installs industrial air systems put it plainly: “We have a 50/40/10 split on most jobs, but half the time it’s just tracked in my head or scribbled on a notebook when I’m on site. When the guys in the office ask me who’s paid what, I have to go back through my messages to check.”

A commercial HVAC contractor described the same fog from the other side of the office: “We don’t have a centralized dashboard. I’m looking at a spreadsheet, my foreman is looking at his notes, and the client is calling about a different set of figures entirely. It’s too easy for a milestone payment to get missed when you’re managing five different jobs at once.”

This is the quote-to-cash-to-delivery seller’s blind spot. Across the businesses we work with, 20–50% of revenue is exposed to missed follow-up and uncollected milestones — not lost to competitors, just never chased in time.

Retention is where it bleeds quietest

The downpayment is easy: no money, no start. It’s the back end that leaks. Retention — usually the final 5–10% of contract value — is held 30 to 90 days past completion, which is precisely when everyone has moved on to the next job.

The same installer was blunt about it: “Tracking retention is the biggest headache. We finish the install, but then we’re waiting on that last 10% for months. I don’t have a system that flags when that money is actually due, so it just slips through the cracks until I happen to remember to ask for it.”

On a mid-size installer running several large contracts at once, a single forgotten 10% retention can be a five-figure sum sitting uncollected for a full quarter — financing your client’s cash flow for free, without anyone deciding to.

Why it slips — and it’s not the math

Owners assume the problem is complexity. It isn’t. The arithmetic of 50/40/10 is trivial. The problem is that the schedule isn’t connected to anything that acts.

And the schedule rarely holds still. A custom metal fabricator explained: “Our terms change mid-deal constantly — a client will ask to delay a shipment, and then we have to manually adjust the payment schedule in Excel. If the project manager isn’t updating the sheet, the accounting team has no idea what’s actually owed.” Two to three revisions per deal is normal in this work, and every revision is another chance for the spreadsheet and reality to drift apart.

Then there’s the speed of the chase. The same fabricator: “We’re losing money because we aren’t chasing the next payment fast enough. We complete the fabrication milestone, but we don’t send the invoice until a week later because we’re waiting on a manual update from the shop floor.” A milestone invoice sent a week late is a week of financing you handed your client at zero interest.

What fixing it actually looks like

The fix is not more discipline. Discipline is exactly the thing that runs out when you’re managing five jobs and standing on a roof. The fix is a system that does the repetitive 90% so your memory only has to handle the exceptions.

Concretely, every deal carries its own payment schedule — downpayment, each progress stage, and retention — tied to the delivery milestones. The moment a milestone is hit, the next payment surfaces as due: the invoice drafts itself, the reminder goes out, and the client’s figures, your foreman’s figures, and the office’s figures are the same figures, in one dashboard. When terms change mid-deal, you adjust once and everyone sees it.

This is the back half of the Revenue Protection System™: the same logic that follows up on a quote until it’s answered, pointed at the money you’ve already earned. One HVAC owner described the manual version of this as “If I forget to send that message, they certainly aren’t going to send the money on their own” — which is the whole problem in one sentence. Follow-up that depends on you remembering isn’t a system.

Who this is for

If you sell high-ticket projects — the kind that need a quotation, a downpayment, and staged payments through delivery — and you can’t answer “who owes me which milestone right now” without scrolling through your messages, this is for you. Solar, HVAC and air systems, fabrication, construction materials: the money shape is the same, and so is the leak.

We build the system first and you only keep paying if you keep it. If milestone money is slipping past you, see how the build-first install works.

Persons anonymized for data privacy and confidentiality compliance.

Frequently Asked Questions

How do you track staged or milestone payments without losing money?

Attach a payment schedule to each deal — downpayment, progress, retention — with a due trigger on every milestone, so the next collection surfaces automatically instead of relying on memory or a spreadsheet one person updates.

What is retention in progress billing, and why does it slip?

Retention is the final 5–10% of contract value held until completion or a warranty period. It slips because it falls due weeks or months after the work is finished, long after anyone is actively watching the deal.

Why isn’t a spreadsheet enough for staged-payment tracking?

A spreadsheet stores numbers but doesn’t act. It can’t flag a due milestone, send the reminder, or update everyone at once — so it drifts the moment one person stops maintaining it.

How fast can a high-ticket B2B seller fix milestone-billing leakage?

With a build-first install, the payment workflow is set up for you first and you only keep paying if it works. Most owners see every open milestone in one dashboard within a few weeks.

Related Reading

• By the Time Your Quotation Is Ready, They’ve Already Said Yes to Someone Faster — the front of the same quote-to-cash funnel.
• “We’re Using Google Sheets, Viber, and Memory” — The Frankenstein CRM That’s Killing Your Revenue — why the spreadsheet-and-chat stack can’t hold the schedule.
• ₱4 Million Lost to Late Follow-Ups: The Real Cost of Manual Sales — the same leak, measured.
• “I Cannot Monitor My Proposals”: Why B2B Owners Are Flying Blind — the visibility gap behind missed milestones.
• Best CRM for B2B Companies (2026 Comparison) — how to choose a system that actually tracks the money.
• Every Rep Is Quoting From Their Own Spreadsheet — and No One Can See the Whole Board — why your team needs one pipeline
• You Already Did the Work — So Why Can’t You Tell Which Invoices Are Still Unpaid? — the uncollected-receivables blind spot.
• You Sent the Quote — Then Silence: Why Half Your Quotations Go Quiet — what happens after you hit send, and how to win silent quotes back.
• You Won the Project — Then It Disappears: The Handoff From Deal Won to Delivered — where revenue leaks after the sale.
• Solar Demand Isn’t Your Bottleneck — Your Sales Engine Is — for Philippine solar installers scaling on 2026 demand.
• Solar Prices Change Every Two Weeks — But Your Quote Doesn’t — how price volatility eats installer margin.