What is a deviation statement?
A Deviation Statement records the difference between the quantities in the agreement and the quantities actually executed or anticipated, item by item, and lists any extra items outside the original scope. It is the document on which additional payment or revised sanction is approved.
What is in the deviation statement workbook?
- Project Details — project particulars and the original agreement value.
- Deviation Statement — Part I, agreement items with excess and saving; Part II, extra items.
- Summary — net deviation, revised value and deviation percentage, all linked.
- Filled Sample — a worked example with ten agreement items and three extra items.
How does the deviation statement sheet calculate?
- Agreement amount = agreement rate × agreement quantity; executed amount = agreement rate × executed or anticipated quantity.
- Excess = executed − agreement quantity, when more was executed; saving = agreement − executed quantity, when less was. Each is valued at the agreement rate, and an item can show one or the other, never both.
- Extra items (Part II) are not in the agreement, so their whole executed quantity and amount count as excess.
- Net deviation = total excess − total saving; revised value = agreement value + net deviation; and the net deviation is also shown as a percentage of the agreement value.
Worked example from the sample sheet (illustrative rates): excavation agreed at 420 cum but executed at 486 cum is an excess of 66 cum × ₹310 = ₹20,460. PCC agreed at 46 cum but executed at 44.5 cum is a saving of 1.5 cum × ₹4,820 = ₹7,230.
How do you use the deviation statement template?
- Enter the project particulars and the original agreement value on Project Details.
- In Part I of the Deviation Statement sheet, list every agreement item with its rate, agreement quantity, and the quantity executed or anticipated.
- Excess and saving are worked out automatically at agreement rates. An item shows in one column or the other, never both.
- In Part II, list extra items that are not in the agreement at all, with the rate approved for each.
- Check the Summary sheet — it is already linked — and record the reasons for deviation and the sanction reference before routing for signature.
What should you check before relying on the deviation statement?
- Extra-item rates must be derived and approved before the work is done. A rate settled after execution invites dispute and is often disallowed.
- Show anticipated quantities, not just executed ones, if the statement is put up for sanction mid-contract. Label clearly which is which.
- Deviation limits, and the authority competent to sanction them, are set by your agreement or departmental code. Confirm both before relying on this statement.
- Saving on one item does not automatically fund excess on another unless your contract permits it.
- Rates are not supplied with this template. Enter rates from your own schedule of rates or market quotations; any figures on the sample sheet are illustrative only and must not be used for real estimating or billing.
What does each column mean?
| Column | What goes in it |
|---|---|
| S. No. | Item number. Part I lists agreement items; Part II lists extra items outside the original scope. |
| Description of Item | The item as worded in the agreement (Part I), or the approved extra item (Part II). |
| Unit | As in the agreement. |
| Rate (Rs.) | The agreement rate. Both excess and saving are valued at this rate. |
| Agreement Qty | The quantity provided in the agreement. |
| Agreement Amount (Rs.) | Auto-calculated. Agreement quantity x rate. |
| Executed / Anticipated Qty | The quantity actually executed, or anticipated if the statement is put up for sanction mid-contract. Label which. |
| Executed Amount (Rs.) | Auto-calculated. Executed quantity x rate. |
| Excess Qty | Auto-calculated. Quantity above the agreement, if any. |
| Excess Amount (Rs.) | Auto-calculated. Excess quantity x rate. |
| Saving Qty | Auto-calculated. Quantity below the agreement, if any. An item shows in excess or in saving, never both. |
| Saving Amount (Rs.) | Auto-calculated. Saving quantity x rate. |
A bill for payment is only as sound as the take-off behind it. The detailed measurement sheet format is where the quantities on this bill are measured and abstracted, item by item.
The quantities actually executed are the ones you bill. Carry them into the RA bill format in Excel.
Get the quantities from your drawings
The arithmetic in this workbook is the quick part. Reading dimensions off a full drawing set, item by item, is what takes days. Upload your drawings and InstaBOQ measures them for you and abstracts the quantities into this same structure.