Quick answer: A measurement book (MB) records the work done on site, item by item:
- the date, the BOQ item number and the location
- Nos, length, breadth and depth (or height)
- the quantity = Nos × L × B × D in the item’s unit
Deductions such as door and window openings are entered with a minus number. The item totals are then priced in an abstract of cost against the BOQ.
Download a free measurement book format in Excel below.
Key takeaways
- BOQ Items: up to 40 items with unit, BOQ quantity and rate.
- MB Entries: up to 500 lines. A blank dimension counts as 1, and a minus Nos is a deduction.
- Unit picked up from the BOQ, and an item total after the last line of each item.
- Abstract of cost: done to date, % done, amount to date and the amount for this running bill.
- A warning when any item goes over its BOQ quantity.

Abstract of cost

How to use the template
- BOQ Items: type the name of work, agreement, contractor and MB number, then copy the BOQ items with unit, quantity and rate.
- MB Entries: record each measurement with the item number and the running bill it goes into (RA-1, RA-2 …).
- Abstract: type the running bill number to see its amount, and check the % done for each item.
Tips for MB entries
- Write the location clearly (grid, floor, wall) so the checking officer can find it on site.
- Record deductions on the same day as the work they belong to.
- Watch the % done. An item near 100% needs a deviation or extra-item approval before you go on.
Download the free Measurement Book Format
There are three sheets: BOQ Items, MB Entries and Abstract. Fill in the yellow cells; everything else is worked out.
Get updates and new free templates
Your download below doesn’t need this. Leave your WhatsApp number or email and I’ll send you fixes for this file and new free templates. No spam, unsubscribe anytime.
Was this template useful?
Related free templates Free Excel files people download with this one
FAQs
How do I enter steel in kg?
Enter the weight from the bar bending schedule in Nos and leave the dimensions blank. The quantity is then the weight.
Can I use it for road or electrical works?
Yes. Use the units in your BOQ, for example rmt, nos or km.
Does this replace the official MB?
No. Government works need the official MB. Use this to prepare and check measurements before they are recorded.









Leave a Review