العربية

IPC Calculator: Interim Payment Certificate Calculation

Generate Interim Payment Certificates with BOQ tracking, retention deductions, and advance recovery calculations.

Last updated: October 2026

BOQ Items
DescriptionUnitContract QtyRatePrevious QtyCurrent Qty
Deductions

Current Gross Value

$85,000

Current Net Payment

$76,500

Cumulative Certified

$207,000

IPC Calculation Summary
DescriptionPrevious ValueCurrent ValueCumulative 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
Your results
Email me this calculation
Leave your email and phone number and the Arkan team will send you this calculation. The calculator stays free and needs no sign-up.

We use your email and phone number to send this calculation and follow up on it. See our Privacy Policy.

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

Two BOQ items, 10% retention, 5% advance recovery

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

  1. Previous gross: 200 × 350 + 30 × 2,500 = 70,000 + 75,000 = 145,000
  2. Current gross: 100 × 350 + 20 × 2,500 = 35,000 + 50,000 = 85,000
  3. Cumulative gross: 145,000 + 85,000 = 230,000
  4. Retention this certificate: 10% × 230,000 − 10% × 145,000 = 23,000 − 14,500 = 8,500
  5. Advance recovery: 5% × 85,000 = 4,250
  6. Net payment: 85,000 − 8,500 − 4,250 = 72,250
  7. 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

1

Enter contract value

Input total contract amount and any approved variations

2

Input work progress

Enter completed quantities or percentage for each BOQ item

3

Apply retention

Enter the retention percentage, limit and release conditions stated in your contract

4

Calculate advance recovery

Enter advance amount and recovery percentage per certificate

5

Generate IPC summary

Review gross amount, deductions, and net payment due

Typical Scenarios in UAE & Gulf Projects

Dubai High-Rise Progress Payment

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.

Abu Dhabi Infrastructure Project

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

Do this inside Arkan

A calculator gives you one number. Arkan keeps the quantities, inspections and payment requests for the whole project in one place, in English and Arabic.

Arkan screen: payment certificates

Need More Than Calculators?

Arkan brings all your construction management together: BOQ tracking, payment certificates, document management, scheduling, and more. All integrated. All in one place.

We Value Your Privacy

We use cookies to enhance your browsing experience, analyze site traffic, and personalize content. By clicking "Accept All", you consent to our use of cookies. Read our Privacy Policy

If you allow Marketing Cookies, OpenAI Ads measures accepted demo requests and relates them to advertising using browser and page signals. When enabled, automatic matching may use hashed contact details. You can withdraw permission in Cookie settings. Your enquiry will still be sent if you reject marketing cookies.