How Interior Designers Can Build BOQs Without the Excel Chaos
Every rate change means retyping the sheet, and no one's sure which version is current. Here's a practical breakdown of what makes BOQ-in-Excel break down on real projects, and how to fix it — including where Grovia's BOQ builder actually helps and where it doesn't.
The problem with building a Bill of Quantities in Excel isn't Excel itself — it's that every rate or quantity change means manually re-adding a column of numbers, and there's no reliable way to know which copy of the sheet is the current one three revisions later. On a real interior design project, rates change constantly: a vendor quote comes in different than expected, a client swaps a finish, a fitting gets substituted. Each of those should take thirty seconds. In a spreadsheet, it takes finding the right cell, re-entering the number, manually checking the formula didn't break, and re-sending the file — and that's before accounting for the version confusion when three people have slightly different copies open.
What Actually Breaks Down When a BOQ Lives in Excel
This isn't a criticism of spreadsheets in general — they're genuinely fine for a lot of things. The specific failure mode with BOQs is structural:
- Formulas break silently. A copied row, an inserted line item, or a manually overridden cell can quietly break a SUM formula, and nobody notices until the total looks wrong at the worst possible moment — usually when a client is looking at it.
- Revisions create version confusion. "BOQ_final.xlsx", "BOQ_final_v2.xlsx", "BOQ_final_v2_ACTUAL.xlsx" — every studio has lived this. When a rate changes, the safest habit is to save a new copy rather than overwrite, and that habit is exactly what produces five near-identical files with no clear record of which one the client actually approved.
- There's no link between the BOQ and what was approved. A spreadsheet emailed to a client and approved over a phone call or a WhatsApp message leaves no structured record tying the approval to the specific version and line items the client actually saw.
- Every revision is manual re-entry, not an edit. Change one material's rate and, depending on how the sheet was built, you may need to manually walk through and update every dependent total rather than trusting the sheet to recalculate correctly on its own.
How to Fix This — A Practical Breakdown
Whether you fix this with dedicated software or a more disciplined process, the underlying requirements are the same. Here's what actually needs to be true:
Step 1: Structure Line Items by Category, Not as One Long List
Materials, labour, fittings, and finishes behave differently — rates change at different times, from different vendors, on different schedules. Grouping the BOQ by these categories, rather than one undifferentiated list, makes it far easier to see what changed and to spot when a category has ballooned past the original estimate.
Step 2: Make Every Revision an Edit, Not a Rebuild
The single biggest time cost in Excel-based BOQs is that a rate change means touching the sheet's formulas, not just the number. Whatever tool you use — spreadsheet or dedicated software — the total should recalculate the instant a quantity or rate changes, with zero manual formula maintenance. If you're checking a formula didn't break every time you edit a cell, the tool is working against you.
Step 3: Separate "Draft" From "Sent for Approval"
A BOQ a client hasn't seen yet should be freely editable. Once it's gone to the client for sign-off, that specific version needs to be locked to what was sent, so there's no ambiguity later about what they actually approved. This is where a plain spreadsheet structurally struggles — there's no built-in concept of "this exact state was sent on this date."
Step 4: Record the Approval, Not Just the Verbal Yes
A "go ahead" over a call or a WhatsApp voice note works fine until a dispute happens — a finish looks different at installation, or a client says they never approved that rate. A timestamped record of exactly what was sent and when the client responded turns a he-said-she-said into a two-minute lookup.
Step 5: Keep the BOQ Tied to the Project It Belongs To
A BOQ that lives in a folder disconnected from the project's approvals, invoices, and documents is only half-solved even if the spreadsheet itself is well-built. The real fix is a BOQ that sits inside the same project record as everything else tied to that job.
How Grovia Handles This
Grovia's BOQ builder addresses the recalculation problem directly: you add line items for materials, labour, fittings, and finishes inside a project, and when you change a quantity or a rate, the total recalculates automatically — no formula to check, no manual re-adding. The BOQ lives inside the project record itself, alongside that project's approvals, invoices, and documents, rather than as a standalone file disconnected from everything else.
For the approval side, the Approvals module lets you send BOQ line items (along with design boards and material samples) to a client for structured sign-off, and it records both the date it was sent and the date the client responded — a timestamped record instead of a verbal "yes go ahead" you can't produce later.
Where this doesn't go as far as some studios expect: Grovia does not keep a version history of a BOQ. When you revise a rate, the previous figure is overwritten — there's no built-in "BOQ_v1 vs BOQ_v2" comparison view. If you need to preserve an earlier version for a client dispute or your own record, export or copy the BOQ before making a major revision, the same discipline you'd need with a spreadsheet, just applied less often since day-to-day rate tweaks no longer require a new file. Approving a BOQ also doesn't automatically generate a GST invoice — invoicing is a separate module, and you create the invoice as its own step referencing the project, not a one-click trigger off the BOQ.
Frequently Asked Questions
Can I still use Excel for BOQs and just be more disciplined about it?
Yes, and for a studio doing its first few projects, that's often the right call — the volume doesn't yet justify a new tool. The breakdown tends to happen once you're running several concurrent projects with frequent rate changes and multiple people touching the same BOQ; that's when version confusion and formula errors start costing real time.
Does a BOQ tool eliminate the need to double-check numbers with vendors?
No — a BOQ tool recalculates totals correctly once you enter the right rate, but it doesn't verify that a vendor's quoted rate is accurate or current. That verification is still on you; the tool just removes the manual arithmetic and formula risk once the number is in.
Is there a way to keep old BOQ versions in Grovia if I need them later?
Not automatically — Grovia doesn't retain BOQ version history, so the previous figures are overwritten when you revise a rate or quantity. Export or copy the BOQ before a major revision if you want to keep the earlier version on file.
Does fixing BOQ chaos also fix approval chaos?
Not by itself — they're related but separate problems. A well-structured BOQ still needs a clear record of what a client actually approved and when. That's why Grovia treats BOQ line items as one of the item types that goes through the same timestamped Approvals workflow as design boards and material samples, rather than solving BOQ costing and approval tracking as two disconnected features.
