Site Templates / Billing & Measurement
Billing & Measurement — measured work, through the full Indian billing chain.
A 9-sheet Excel workbook that takes work from the measurement book to a paid RA bill the way Indian construction actually bills it: joint measurement under IS 1200, abstract against the BOQ, then a running-account bill with retention, TDS and GST worked correctly — and a tracker that follows every bill to close.
Takes measured work through the full Indian billing chain — joint measurement, abstract against BOQ, RA bill with retention/TDS/GST, payment tracking to close.
Codes
The problem
The dispute is almost never the rate. It is the measurement.
By the time a project is billing, the rates are already agreed in the contract. What people actually fight over is quantity: how much brickwork, measured which way, with which openings deducted. IS 1200 exists precisely because “how you measure” is not obvious — it sets the method of measurement for each item, including the deductions for openings, that both sides are meant to follow. Bill without it and every running-account bill becomes a negotiation from scratch.
The second place money leaks is the bill build-up itself. A running-account (RA) bill is not just quantity × rate — it is this bill’s value less the previous bill, less retention, less TDS, plus GST, adjusted for any secured advance and materials-at-site. Get the sequence wrong and you either overpay a contractor you can’t claw back from, or underpay one who then stops work. This workbook encodes that chain once, so each RA bill is arithmetic, not improvisation.
What's inside · 9 linked sheets
Every sheet, and what it does
Nine linked sheets that mirror the real billing sequence — measure, abstract, bill, track — with the contract terms set once and pulled through every bill:
Full sheet list
Project & Contract, IS 1200 Deductions, BOQ & Rates, Measurement Book, Abstract, RA Bill, Payment Tracker, Dashboard.
The MB: item, location, and the number × length × breadth × depth entries that make up a measured quantity — the primary record of what was actually done, ready for joint signature.
The method-of-measurement rules that decide what comes off — door and window openings in brickwork and plaster, and the other standard deductions — so measured quantities are computed to code instead of by habit.
Rolls the measurement book up against the BOQ items and their agreed rates, giving the value of work done to date, item by item — the bridge between what was measured and what gets billed.
The running-account bill: gross value this period, less previous bills, less retention, less TDS under Section 393, plus GST — the full statutory build-up, computed rather than typed in.
The contract schedule of items and rates, set once, that both the abstract and the RA bill draw from — so a rate lives in exactly one place.
Every RA bill by status — submitted, certified, paid — with retention held to date and outstanding balances, so nothing certified goes unpaid and no retention is quietly forgotten.
Who it's for
For whoever raises or certifies the bill.
Billing sits between two parties with opposite incentives, and the workbook serves either side of the table:
- —Contractors and subcontractors raising RA bills who want them measured to IS 1200 and built up correctly the first time, so certification is fast and undisputed.
- —Owners, PMCs and site engineers certifying bills who need to check a contractor’s measurement and deductions against the code before releasing money.
- —Quantity surveyors and billing engineers who want the measurement book, abstract, and RA bill chain in one auditable workbook.
- —Homeowners on a large custom build who are paying against progress and want to see retention, TDS and GST handled properly.
Worked example
A 9-inch wall with two windows, and the ₹18,000 that hangs on the method.
Scenario
A ground-floor brick wall measures 8 m long and 3 m high — 24 sqm gross. It carries two windows of 1.2 m × 1.2 m. The contractor’s first cut bills the full 24 sqm; the site engineer says deduct the openings. Who is right depends entirely on the method of measurement, not on either person’s confidence.
The IS 1200 Deductions sheet settles it: the two openings are 2 × 1.44 = 2.88 sqm, so the net measured area is 21.12 sqm. At a brickwork rate of, say, ₹850/sqm that is the difference between billing ₹20,400 and ₹17,952 on this one wall — about ₹2,450 here, and multiples of that across a whole floor of walls and plaster.
The RA Bill sheet then takes that net value into the running account: it adds this period’s work, subtracts the previous bill and the retention, deducts TDS under Section 393 and adds GST — and the Payment Tracker carries the certified figure through to paid. The contractor gets paid for exactly what was built, measured the way the contract already agreed to measure it.
Get the toolkit
Billing & Measurement — ₹1,499
Delivered as an Excel (.xlsx) workbook in a .zip via a secure download link — shown here and emailed to you after checkout. Need all six? See the Site Operations Suite bundle.
Secure payment by Razorpay. This toolkit is delivered as an Excel (.xlsx) file, packaged as a .zip, via a secure download link shown here and emailed to you after checkout.