The bill of quantities is the least glamorous document in an interior project and quietly the most important, because it is where design becomes numbers, and numbers become money, so a sloppy BOQ does not just look untidy, it leaks margin on every line. Almost every studio in India builds its BOQ in Excel, which is a fine place to start and a genuinely bad place to stay once you are running more than a project or two, because the same spreadsheet that felt organised in month one becomes a maze of tabs, broken formulas and versions nobody trusts by month six. This post gives you a clean BOQ format for interiors, explains what each column is doing, and shows where Excel stops helping and starts costing you. Let me walk through it.
What a BOQ is really for
A BOQ, a bill of quantities, is a measured, itemised list of everything a project needs, the civil work, the joinery, the finishes, the fixtures, each with a quantity, a unit, a rate and an amount, so that the total is not a guess but a build-up you can defend line by line. That defensibility is the whole point, because when a client questions a number, or a vendor tries to bill above the agreed rate, the BOQ is your evidence, and a BOQ that cannot be traced back to the drawing or the spec is no evidence at all.
The BOQ sits between your proposal and your contract, giving both of them their teeth, because the proposal promises an outcome, the contract makes it binding, and the BOQ is the arithmetic underneath. Keep those three consistent and a project runs on facts, let them drift apart in separate files and it runs on arguments.
The columns a good interior BOQ carries
Here is a clean column structure for an interior BOQ, and the discipline is to fill every column honestly rather than leaving quantities as round guesses or rates as placeholders you forget to update.
| Column | What it holds | Why it matters |
|---|---|---|
| Item code | A reference number per line | Lets you trace a line across quote, PO and invoice |
| Description | Clear, specific item and finish | Removes ambiguity about what is being priced |
| Location or room | Where the item belongs | Ties the number back to the actual space |
| Unit | Sqft, running foot, number, lump sum | Makes the quantity meaningful |
| Quantity | The measured amount | The single most error-prone field |
| Rate | Agreed unit rate | Where margin lives or dies |
| Amount | Quantity times rate | The line total, ideally a live formula |
| Remarks | Assumptions, brand, exclusions | Prevents disputes over what was assumed |
Organise the BOQ by room or by work category rather than as one endless list, because a BOQ that follows the living room, then the kitchen, then the master suite, mirrors how the project is actually built and approved, and it makes checking far easier.
Key takeaways
- The BOQ is where design becomes money, so its accuracy sits directly on your margin
- Every line should trace back to a drawing or spec, or it is not defensible evidence
- Excel is fine to start with and costly to stay on once you run several projects at once
Where Excel BOQs quietly break
Let me be honest about the spreadsheet, because I am not against Excel, I am against relying on it past the point where it helps. A BOQ in Excel breaks in predictable ways, a formula that got overwritten so a total no longer adds up, a rate updated in one tab but not another, a version emailed to a vendor that was already out of date, and a quantity typed as 45 instead of 4.5. None of these is dramatic on its own, and that is exactly why they survive, each one is small enough to miss and costly enough to matter.
That last bar is the real problem, because even a perfect Excel BOQ is disconnected from your quote and your purchase orders, so keeping all three in agreement is a manual chore that depends on someone remembering, and this is precisely the leak I describe in the wider case for choosing the right tools and skipping the ones you do not need.
The BOQ has to talk to the quote, the PO and the invoice
Here is the insight that changes how you think about the BOQ, it is not a document, it is a spine that should run through the whole project, so the same measured quantity that appears in the BOQ should drive the quote the client approves, the purchase order you raise to the vendor, and the GST invoice you eventually bill. When those four share one source, a change in one updates the rest, and when they live in four separate files, a change in one silently contradicts the other three.
That is the difference between a studio that trusts its numbers and one that reconciles them at midnight. When the BOQ feeds the quote and the quote becomes a compliant GST invoice in a click, you have removed the double entry that causes most billing errors, which is the exact flow I walk through in how to turn a quote into a GST invoice in minutes. A clean BOQ also underpins a clean handover, because the snag or punch list at completion checks the delivered work against what the BOQ said would be delivered.
Run the BOQ inside the project, not beside it
The structural fix is to stop treating the BOQ as a standalone spreadsheet and to build it as part of the project itself, room by room, with the furniture, fixtures and equipment and finishes carrying photos, quantities and live costs, so the numbers and the design are the same object. When you do that, the mood board the client approves, the quote you send, and the quantities you procure against all come from one place, which is the whole argument for one connected system over five disconnected tools.
That is how Designa handles quantities, the room-by-room specs are the BOQ, they feed the quote and the client approval, they drive procurement, and they flow into compliant GST billing, so you are never reconciling four versions of the same number. If you are weighing tools on exactly this, the best software for interior designers in India guide puts BOQ handling in the context of the whole studio, and the project timeline template shows how the quantities connect to the schedule.
A BOQ done well is quiet confidence, because every number can be defended and nothing has to be reconciled after hours, and it reaches that state only when it stops being a lonely spreadsheet and becomes part of the connected project. See the room-by-room specs act as a live BOQ on a real project at demo.designa.work, and when it fits your studio, the founding offer is one flat price for the whole team, billed in rupees, with done-for-you onboarding and a 7-day money-back guarantee at go.designa.work.
Frequently asked questions
What is a BOQ in interior design?
A bill of quantities is a measured, itemised list of everything a project needs, with quantities, units, rates and amounts, so the total is a defensible build-up rather than a rough guess.
What columns should an interior BOQ in Excel have?
At minimum an item code, a clear description, the room or location, the unit, the quantity, the rate, the amount, and a remarks column for assumptions, brands and exclusions.
Why do Excel BOQs cause problems?
They break in small, easy-to-miss ways, overwritten formulas, rates updated in one tab but not another, stale versions sent to vendors, and quantity typos, and they stay disconnected from the quote and the purchase orders.
How should a BOQ connect to the rest of the project?
The same measured quantity should drive the quote, the purchase order and the GST invoice, so building the BOQ as part of the project rather than a separate file keeps all four in agreement.