Retention Management: Tracking Holdbacks Across 50+ Subcontracts

The Retention Problem Nobody Talks About

Every general contractor in the GCC holds retention on subcontractors. Five percent here, ten percent there. On a SAR 200 million project with 60 subcontracts, that is SAR 10-20 million sitting in holdback at any given time. And most GCs track it in spreadsheets.

The result is predictable. Release dates slip. Subcontractors chase payments for months after defects liability periods expire. Finance teams spend days reconciling retention balances before every payment run. And when a subcontractor disputes a holdback amount, nobody can produce the calculation trail in under an hour.

Retention is not complicated in concept. It is complicated at scale. When you are managing 50, 80, or 120 active subcontracts across multiple projects, each with its own retention percentage, release schedule, and defects liability period, spreadsheets stop working. They do not alert you when a retention release is due. They do not tie holdbacks to specific work confirmations. They do not show your CFO how much cash is locked in retention across the entire portfolio.

Why Spreadsheets Fail at Retention Tracking

Spreadsheets fail for three specific reasons that compound as project count grows.

1. No Link Between Retention and Work Confirmations

Retention is deducted from certified progress payments. But in a spreadsheet, the retention line is just a number — it is not tied to the specific work confirmation or payment certificate that generated it. When a subcontractor questions a balance, you have to manually trace back through payment certificates to reconstruct how you arrived at that figure. On a SAR 50 million MEP subcontract with 24 monthly valuations, that reconstruction takes hours.

2. Release Triggers Are Invisible

Most GCC construction contracts follow a two-stage retention release: 50% at practical completion, 50% at the end of the defects liability period (typically 12 months). In a spreadsheet, these dates live in a cell somewhere. Nobody gets an alert when practical completion is certified. Nobody gets a reminder when the DLP expires. The subcontractor calls, your QS digs through files, and weeks pass before the release is processed.

3. Portfolio-Level Visibility Does Not Exist

Your CFO needs to know the total retention liability across all active projects for cash flow forecasting. In a spreadsheet world, someone has to collect files from every project team, reconcile formats, and compile a summary. By the time it reaches the CFO, the numbers are two weeks old.

What Structured Retention Tracking Looks Like

A proper retention management system does four things that spreadsheets cannot.

Automatic Deduction at Source

When a work confirmation is approved and a payment certificate is generated, the system automatically calculates and holds the retention amount based on the contractual percentage. The retention record is permanently linked to the source document — the work confirmation, the payment certificate, and the subcontract terms. No manual entry. No formula errors. No missing deductions.

Contract-Specific Rules

Not every subcontract has the same retention terms. Your structural steel subcontractor might have 10% retention with a 12-month DLP. Your landscaping contractor might have 5% with a 24-month maintenance period. Your MEP contractor might have a retention cap at 5% of total contract value. The system stores these rules per subcontract and applies them automatically. When your QS processes the monthly valuation, retention is handled — correctly, every time.

Milestone-Triggered Release Workflows

Retention releases should not depend on someone remembering a date. When practical completion is certified on a project, the system identifies all subcontracts eligible for first-half retention release and initiates the approval workflow. When the defects liability period expires, the second-half release is triggered automatically. The workflow routes through QS review, project manager approval, and finance processing — with a full audit trail at every step.

Portfolio Dashboard

At any moment, your finance team can see total retention held across all projects, broken down by project, subcontractor, release stage, and expected release date. Cash flow forecasts include retention releases as scheduled outflows. No compilation. No reconciliation. No two-week-old data.

The Cash Flow Impact in GCC Construction

Retention management is ultimately a cash flow problem — both for the GC and the subcontractor.

For the general contractor, retention represents a significant cash position. On a portfolio of five active projects totaling SAR 800 million, retention holdbacks could reach SAR 40-80 million. Releasing that cash late is fine for your bank balance in the short term. But it damages subcontractor relationships, leads to inflated future bids (subcontractors price in the cost of delayed retention), and in extreme cases, triggers contractual disputes and claims for financing costs.

For subcontractors, delayed retention release is a working capital problem. A mid-size MEP contractor with SAR 15 million locked in retention across your projects is effectively financing your risk. When you release on time, consistently, you become a preferred client. Subcontractors give you better pricing, prioritize your projects for skilled labor, and are more flexible on change orders.

The math is straightforward. If structured tracking lets you release retention within 30 days of the contractual trigger instead of 90+ days, you reduce subcontractor financing costs, improve bid competitiveness on future work, and eliminate the administrative overhead of chasing and reconciling balances.

FIDIC and Local Contract Considerations

GCC construction contracts commonly follow FIDIC conditions, which have specific provisions for retention. Under FIDIC 1999 Red Book (Clause 14.9), the employer retains a percentage from interim payments until the retention limit is reached. Half is released with the Taking-Over Certificate, and the remainder upon expiry of the Defects Notification Period.

Saudi construction contracts increasingly incorporate FIDIC provisions with local amendments. The retention percentage, cap, and release conditions vary by contract. Some government projects in Saudi Arabia specify retention terms that differ from standard FIDIC — for example, different DLP durations for different work scopes within the same contract.

A retention tracking system must handle this variability per subcontract, not assume a one-size-fits-all model. The system should store the specific contractual clause references, retention percentages, caps, and release conditions for each subcontract — and apply them correctly during every payment cycle.

Implementation: Start With the Data You Have

You do not need to wait for a perfect system to improve retention tracking. Start with three steps.

First, centralize your subcontract terms. For every active subcontract, record the retention percentage, cap (if any), DLP duration, and release conditions in one place. This alone gives you the portfolio view your finance team needs.

Second, link retention to payment certificates. Every retention deduction should reference the specific payment certificate that generated it. This creates the audit trail that eliminates disputes.

Third, set up release triggers. When practical completion is certified or a DLP expires, the system should notify the responsible QS and initiate the release workflow. No more relying on memory or subcontractor phone calls.

BuildaPay handles all three natively. Retention rules are configured per subcontract. Deductions are calculated automatically from approved work confirmations. Release workflows are triggered by project milestones. And the portfolio dashboard gives your CFO real-time retention liability across every project.

The Bottom Line

Retention is not a back-office accounting detail. It is a SAR 10-80 million cash position that affects subcontractor relationships, bid pricing, and cash flow forecasting. Managing it in spreadsheets works until you have more than a handful of subcontracts. After that, you need structured tracking with automatic deductions, contract-specific rules, milestone-triggered releases, and portfolio-level visibility.

The contractors who get this right do not just avoid disputes. They become the GCs that subcontractors want to work with — and that advantage compounds on every project.