ISKRIT / Construction site / Volume reconciliation
Construction site
Reconciling completed work quantities against the design schedule
The tool compares the quantities claimed by the contractor against the design schedule line by line: it finds quantities claimed above the design, the balance left to complete, and the percentage of progress, and flags duplicated lines and work that is not in the design at all. When a unit price is supplied, it values the excess in money terms.
Standards
Lines are matched by unit rate code, or by name plus unit of measure when no code is given. Used in construction control when verifying quantities submitted for payment.
Input
Schedule lines: code, description, unit, design quantity, claimed quantity, unit price. Entered manually or uploaded from Excel using the template.
Output
Balance, quantity above the design, progress percentage, a status per line, a summary of findings, and XLSX export.
What it does
- Quantities claimed above the design quantity, line by line
- Balance left to complete and percentage of progress
- Duplicated lines detected by unit rate code
- Work outside the design flagged with its own status
- Money value of the excess when a unit price is supplied
Free and full version
Free
- Code-based calculations with no run limits
- Input validation and printable results
- Works instantly, no sign-up required
Full version
- Save projects and reconciliation schedules
- Import large schedules from Excel
- Shared access to schedules for the control team
- Reconciliation history per project
Questions
How are duplicates found?
By unit rate code, or by the name and unit of measure pair when the code is blank. Matching lines are flagged as double billing.
What counts as work outside the design?
A line with a claimed quantity where the design quantity is zero. Such lines get their own status.
Is a unit price required?
No, quantities reconcile without prices. A price is only needed to value the excess in money terms.