Excel is an excellent estimating tool right up until more than one person needs it. The transition point is not a size of company or a value of contract — it is the moment the bill of quantities stops being one person’s document and becomes the commercial basis of a live job.
The five signs
What a real BOQ module adds
The difference is not calculation — Excel calculates fine. It is versioning, provenance and continuity. A BOQ held in a system carries a revision history, a rate that traces to a source, subtotals per section that cannot be accidentally overwritten, and a direct line from the priced item to the certificate that eventually invoices it.
Preliminaries, contingency and VAT
Three things every fit-out bill needs and almost every spreadsheet handles inconsistently: preliminaries as a percentage or lump sum applied predictably, a contingency line that survives revisions, and 5% VAT calculated on the correct base. Getting these wrong is not an estimating error, it is an invoicing dispute waiting to happen.
Keeping the estimator’s speed
The objection to leaving Excel is always speed, and it is a fair one. A good BOQ module has to accept a paste from a spreadsheet, allow keyboard-only entry down a column, and let the estimator work section by section without a wizard. If it slows the first pass of pricing, it will not be used.
