IPC Calculator: Interim Payment Certificate Calculation
Generate Interim Payment Certificates with BOQ tracking, retention deductions, and advance recovery calculations.
Last updated: October 2026
| Description | Unit | Contract Qty | Rate | Previous Qty | Current Qty | |
|---|---|---|---|---|---|---|
Current Gross Value
$85,000
Current Net Payment
$76,500
Cumulative Certified
$207,000
| Description | Previous Value | Current Value | Cumulative Value |
|---|---|---|---|
| Concrete Works | $70,000 | $35,000 | $105,000 |
| Reinforcement Steel | $75,000 | $50,000 | $125,000 |
| Gross Total | $145,000 | $85,000 | $230,000 |
| Less: Retention (10%) | - | ($8,500) | - |
| Less: Advance Recovery | - | ($0) | - |
| Net Payment Due | $130,500 | $76,500 | $207,000 |
FINANCIAL DISCLAIMER
This calculator provides INDICATIVE FIGURES for reference purposes only.
Important:
1. Results are based on standard formulas and user-provided inputs. Actual contractual amounts may differ based on specific contract terms and conditions.
Embed this calculator on your site
Paste this snippet into your page. The embedded calculator is free to use and links back to this page.
About This Calculator
This Progress Payment Calculator (IPC) helps contractors and consultants prepare accurate Interim Payment Certificates per FIDIC contract requirements. Calculate work done valuations, apply retention deductions, recover advance payments, and track cumulative billing. Essential for construction payment management across UAE and Gulf projects operating under FIDIC Red, Yellow, or Silver Book conditions.
Formula
Item value = quantity × rate (previous, current and cumulative quantities each valued at the same rate)
Gross value = sum of item values (previous, current, cumulative)
Retention to date = cumulative gross value × retention %
Retention this certificate = retention to date − retention on previous gross value
Advance recovery = fixed amount, or current gross value × recovery % if a percentage is chosen
Net payment this certificate = current gross value − retention this certificate − advance recovery
Cumulative net certified = previous net certified + net payment this certificate
Worked example
Inputs
- Concrete: rate 350 per m³, previously certified 200 m³, this period 100 m³
- Steel: rate 2,500 per ton, previously certified 30 ton, this period 20 ton
- Retention 10%; advance recovered as 5% of the current gross value
- Currency AED (a label only)
Steps
- Previous gross: 200 × 350 + 30 × 2,500 = 70,000 + 75,000 = 145,000
- Current gross: 100 × 350 + 20 × 2,500 = 35,000 + 50,000 = 85,000
- Cumulative gross: 145,000 + 85,000 = 230,000
- Retention this certificate: 10% × 230,000 − 10% × 145,000 = 23,000 − 14,500 = 8,500
- Advance recovery: 5% × 85,000 = 4,250
- Net payment: 85,000 − 8,500 − 4,250 = 72,250
- Previous net certified 130,500 + 72,250 = 202,750 cumulative net certified
Result: Net payment due for this certificate: 72,250 AED (cumulative net certified 202,750 AED).
Assumptions and limits
- Interim payment certificate arithmetic only. Contract-specific items such as VAT or tax, materials on site, variations, price adjustment, other deductions, payment-term timing and retention caps or reductions are not modelled.
- Retention is applied as a single percentage of the cumulative gross value. Staged reductions or releases (for example at practical completion) are not applied.
- Previous net certified is derived as previous gross less the same retention percentage, so the previous certificates are assumed to have used the same retention % and no advance recovery or other deductions.
- A percentage advance recovery is taken on the current gross value only. A fixed amount is deducted as entered.
- Quantities are not checked against the contract quantity, and quantities above the contract quantity are valued at the same rate.
- The currency selector changes the label only; no conversion is made. Rates and values in this example are illustrative, not market rates.
- Any entitlement, deduction or payment depends on the actual contract terms and the governing law. This calculator is an arithmetic aid, not legal or contractual advice.
When to Use This Calculator
- Preparing monthly progress payment applications
- Calculating retention deductions per contract terms
- Tracking advance payment recovery schedules
- Verifying consultant payment certificates
- Reconciling cumulative billing with BOQ progress
How to Use This Calculator
Enter contract value
Input total contract amount and any approved variations
Input work progress
Enter completed quantities or percentage for each BOQ item
Apply retention
Enter the retention percentage, limit and release conditions stated in your contract
Calculate advance recovery
Enter advance amount and recovery percentage per certificate
Generate IPC summary
Review gross amount, deductions, and net payment due
Typical Scenarios in UAE & Gulf Projects
Monthly IPC for a 500M AED tower project. Calculator determines gross work done of 45M AED, deducts 10% retention (4.5M), recovers 15% of 20M advance (3M), and calculates net payment of 37.5M AED. Cumulative billing tracked against S-curve baseline.
IPC preparation for a road and utilities contract under FIDIC Yellow Book. Calculator processes 120 BOQ items, applies 10% retention to each certificate until the limit of retention money (5% of the contract sum) is reached, and generates summary with material-on-site values for pending delivery items.
Calculation Methodology
How the IPC Is Calculated
For each BOQ line, previous value = previous quantity × rate, this period's value = this period's quantity × rate, and cumulative value = (previous + this period's quantity) × rate. The gross values are the totals of those columns, so cumulative gross = previously certified gross + this period's gross. The contract quantity is shown for reference and is not used in the arithmetic.
Retention and Advance Recovery
Retention for this period = retention % × cumulative gross − retention % × previous gross, which equals retention % × this period's gross while the percentage stays the same. Advance recovery is either the fixed amount you enter or a percentage of this period's gross, not both. Net payable this period = this period's gross − retention − advance recovery.
What the Calculator Leaves Out
VAT is not calculated, so the net payable is before VAT. "Previous net certified" is previous gross less previous retention only; it does not deduct advance amounts recovered in earlier certificates. Retention release, retention caps, price adjustment, liquidated damages and other contract-specific deductions are not modelled. Check every figure against your contract and the certifier's assessment.
Frequently Asked Questions
What is the standard retention percentage in UAE construction?
The retention percentage deducted from each interim payment and the limit of retention money are both stated in your contract (for FIDIC forms, in the Appendix to Tender / Contract Data); enter your own figures in the calculator. Under FIDIC 1999 Red Book Sub-Clause 14.9 (2017: 14.9), the first half is released when the Taking-Over Certificate is issued and the second half after the Defects Notification Period expires.
How is advance payment recovery calculated?
The start of advance recovery and the recovery rate are set in your contract, and the advance is recovered proportionally from each IPC. For example, a 10% advance with 10% recovery rate means 10% of each gross certificate amount is deducted until the advance is fully recovered.
What documents support an IPC submission?
IPC submissions should include: measurement sheets/survey reports, progress photographs, material delivery notes, site instructions/variation orders, subcontractor invoices, quality test certificates, and a detailed BOQ progress summary. Under FIDIC 1999 Red Book Sub-Clause 14.3 (2017: 14.3), the Contractor submits a Statement after the end of each month, or the period stated in the contract.
Last Updated: October 2026
Standards Reference: FIDIC Conditions of Contract, UAE Federal Law No. 20/2020 on Commercial Transactions
