MBook vs Spreadsheets
MBook vs spreadsheets — for a contractor, not just a calculator
Spreadsheets are not the enemy. Every contractor got here on them, and for a small job with one bill they are hard to beat. The trouble starts when the same BOQ lives in six workbooks, the measurement book is a seventh, retention is an eighth, and the RA bill re-keys all of them. Nobody can say, on any given day, what has been measured, what has been billed and what is still to certify — because the answer is spread across files that never quite reconcile.
Where spreadsheets are genuinely fine
Say it plainly: for a single small job, a spreadsheet BOQ and a manual RA bill work. They are free, everyone can use them, and they bend to any format a client asks for. If you run one project at a time and the measurement is simple, you may not need more.
Be honest with yourself about scale before spending on anything. The question is not whether spreadsheets can hold the numbers — it is whether they can keep them reconciled once there is more than one project, one subcontractor and one State involved.
Where they leave a contractor exposed
A spreadsheet records numbers. It does not enforce a control. On a live project that shows up as:
No frozen baseline
Nothing stops the BOQ being edited, so the original contract value is lost the first time scope shifts and someone adds a tab.
Measurement and billing drift
The measurement book and the RA bill are separate files, so cumulative executed quantity is re-computed by hand and rarely matches.
No back-to-back margin
Subcontract rates are not tied to the client rate on the same line, so let-work margin is a guess found out at the end.
Material overrun hides
Cement and steel consumed against the rate analysis is not tracked, so overrun surfaces only when the store runs dry.
Tax split is manual
Place of supply, CGST/SGST/IGST and SAC 9954 are worked out by hand every bill, and errors are quiet.
What MBook does instead
MBook is built the other way round. The BOQ is frozen in the database; the measurement book feeds progress, the RA bill and earned value from one entry; subcontract margin is computed against the client rate on the same line; and place-of-supply tax is set by the site State. The numbers cannot drift apart, because measuring, billing and posting the ledger are the same action.
It does not throw away what spreadsheets are good at — every register exports to Excel. It just stops the numbers living in six files that never agree.
Honest comparison
| Capability | Spreadsheets | MBook |
|---|---|---|
| Frozen baseline BOQ | Editable — no control | Locked in the database; variations only |
| Measurement book | A separate workbook | Central; L×B×D feeds progress and the bill |
| RA billing | Rebuilt by hand each cycle | Priced off cumulative executed quantity |
| Retention & escalation | Side spreadsheet | Inside the bill, from contract terms |
| Back-to-back margin | Guessed at the end | Computed against the client rate |
| Material reconciliation | Not tracked | Against the rate analysis, per store |
| GST place of supply | Worked out manually | Set by site State; SAC 9954 |
| Audit trail | Whoever saved last | Every figure traces to its document |
When to choose which
Stay on spreadsheets if
You run one small project at a time, the measurement is simple, and one person keeps every file. Do not let anyone talk you out of what works at that scale.
Move to MBook when
You run more than one project, subcontractors, retention and escalation, or work across States — and the reconciliation between measurement, billing and cost has become a monthly grind.
Common questions
Can I still export to Excel?
Yes. Every register in MBook — BOQ, progress, earned value, GST summary, material reconciliation, ageing and more — exports to Excel, filtered to the project.
Is MBook overkill for a single small job?
It can be. For one small project with simple measurement, a spreadsheet may be enough. MBook earns its keep once there is more than one project, subcontractors, retention or multi-State tax to keep reconciled.
What is the one thing spreadsheets cannot do?
Enforce a control. A spreadsheet will happily let the BOQ be edited, the measurement drift from the bill, and margin go untracked. MBook freezes the baseline and ties measurement, billing and cost to it.
Get started
See MBook on your own project
₹49,999 + GST/year — all modules, unlimited projects, cloud included. Explore the live demo or take a 15-minute walkthrough.