Progress Payment Calculator (IPC)
Generate Interim Payment Certificates with BOQ tracking, retention deductions, and advance recovery calculations.
| 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.
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.
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
Specify retention percentage (typically 5-10%) and release conditions
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
Take Your Calculations Further
This calculator reflects the logic built into Arkan's construction management platform.
Last Updated: October 2026
Standards Reference: FIDIC Conditions of Contract, UAE Federal Law No. 20/2020 on Commercial Transactions