Quantity Survey Software - Why Excel Is No Longer Enough

The bill of quantities is the foundation of every construction project. Pricing, offers, contracts, interim certificates, payment applications - everything starts from the BOQ. Without an accurate and up-to-date quantity survey you cannot price a job correctly, track what has been executed, or invoice with confidence. And yet the vast majority of construction firms still manage their BOQs in Excel, dealing with version chaos, formulas that break, and zero connection to the rest of the paperwork. If this sounds familiar, it is time for a change.

5 Problems with Managing BOQs in Excel

Excel is a powerful tool for tabular analysis. But a bill of quantities is not just a spreadsheet. It is a living document that changes dozens of times over the life of a project and has to stay connected to contracts, certificates, and payments. Here are the five most critical problems you run into when you manage BOQs in Excel.

1. Version Chaos - "BOQ_v3_final_FINAL2.xlsx"

You know the pattern. Your desktop is littered with files like BOQ_Riverside_v2.xlsx, BOQ_Riverside_v3_final.xlsx, and the inevitable BOQ_Riverside_v3_final_FINAL2.xlsx. Three people work on the same bill, each has their own copy, and nobody is sure which one is current.

The problem deepens when the client asks for a variation. You correct the unit rate for reinforcement and send the new file, but your colleague has already made changes in the old version. Merging the two is manual work, and manual work breeds errors.

2. Manual Calculations That Cascade

In Excel the formulas are your responsibility. Change the quantity on one line item and you have to make sure every related formula recalculates correctly: section subtotals, VAT, grand total. One deleted row, one shifted column, and the whole bill can show a wrong figure.

The statistics are telling. A study by the University of Hawaii found that 88% of all spreadsheets contain at least one error. In a bill of quantities with 200 or more line items, the question is not whether there is an error, but where it is hiding.

3. Zero Connection to Contracts and Offers

You prepared a BOQ and signed a contract on the back of it. Two months later the client asks for a change to the concrete rate. You correct the Excel file, but the contract still carries the old rate. So does the offer you sent last week. Who is keeping track of what is current?

In the real world a BOQ does not live in isolation. It is tied to offers, contracts, variations, and price lists. When those links exist only in the estimator's head, the risk of a mismatch is enormous.

4. No Way to Track Progress

The project is underway. The subcontractor claims 80% of the reinforcement work is done. You open the BOQ in Excel and then what? Add a column called "Completed"? Create a new worksheet? How do you track cumulative progress, meaning what has been executed to date, what has been certified, and what is left?

Excel offers no mechanism for accumulating progress line item by line item. Every attempt to build one by hand ends in formulas that grow more complicated and more fragile with every period.

5. No Certificate Without Re-typing

When the time comes to draw up an interim certificate for work executed, you have to move data across from the BOQ, pull out the executed quantities, calculate the values, and format the document. That is manual work that takes hours and is fertile ground for mistakes.

On a project with 10 interim certificates, multiply those hours by 10. Add the corrections that inevitably follow, and you will understand why estimators spend more time in Excel than on site.

What Can Specialized Software Do?

Specialized quantity survey software solves every one of the problems above by turning the BOQ from a static spreadsheet into a connected, living part of project management.

Structured Items Linked to a Nomenclature

Instead of free text in Excel cells, every line item in the BOQ is tied to a single nomenclature. That means "Concrete C25/30" is the same item everywhere: in the BOQ, in the contract, in the certificate, in the warehouse. No ambiguity, no duplicate names, no "Concrete C25/30" sitting next to "Conc. class C 25/30".

Automatic Calculations

Changing a quantity or a unit rate recalculates every related value automatically: section subtotals, grand total, VAT. You cannot accidentally delete a formula or shift a row and break the arithmetic.

Items That Travel Between Documents

Once entered, a line item is never re-typed again. From the BOQ you create an offer in a single action. When a contract is signed, the system builds the bill of quantities that belongs to it. From there the certificates draw on those same items. Re-typing disappears, and with it the most common source of mismatches between documents.

Cumulative Progress Tracking

The software keeps an accumulating record: for every line item on the contract you see how much was agreed, how much has been executed so far, and how much is left. That information is available in real time, with no manual arithmetic and no separate Excel worksheet.

Certificates With the Balance in Front of You

Instead of moving data across by hand, drawing up a certificate starts from line items that are already in the system. For each one you see how much is left against the full contract quantity, and the system will not let you certify more than that. The values work themselves out.

IFC Import from BIM Models

If you work with BIM, specialized software can import data from IFC files and create BOQ line items automatically. Instead of pulling quantities out of the 3D model by hand, the system recognizes the elements and links them to nomenclature items.

How the Quantity Survey Module Works in Construction Team

Construction Team offers a full quantity survey module covering the whole life of a BOQ: from creation, through the offer and the contract, to tracking what has actually been built.

A note on names before we go further. In the menu the BOQ module is called Quantity Surveys, the interim certificates for work executed are Acts, the priced proposals you send to a client are Offers, and the catalogue of items is the Nomenclature. The industry still says BOQ, and so does this article in general terms, but the screens carry the labels above.

Create from Scratch or Import

There are two ways to start a new quantity survey:

• Manual creation - you add items from the Nomenclature and set quantities and unit rates. Picking an item from the Nomenclature fills in the unit of measurement and the unit rate for you, and the table sorts by whichever column you choose.

• Import from Excel - you download the template from the import dialog, fill it in, and upload it in one go instead of keying in hundreds of rows.

Importing Existing Items from Excel

The reality is that most firms already have dozens of finished bills of quantities sitting in Excel. Moving to new software should not mean re-typing them row by row.

The import dialog hands you a ready template. You download it, rearrange your data into its columns, and upload it back. The system matches each line item by code against your Nomenclature and shows you the result before it writes anything: which rows found a match, which did not, and what is about to enter the survey.

This path is quick and predictable precisely because it is literal. Matching is done on the code, not on a guess. A line item whose code is missing from your Nomenclature comes in as a new one and you decide what to do with it.

A finished survey can be duplicated for the next site, exported to Excel or PDF, and printed, all from the menu on its detail page.

How the Quantity Survey, the Offer, and the Contract Move Together

Once the survey is ready, its line items travel forward without being re-typed:

• Offer - from the survey detail page you press "Create Offer" and the items carry over ready-made. From that point the offer lives its own life: you correct the prices in it without touching the survey. It works the other way round too. In the new offer form you can import items from an existing quantity survey.

• Contract - when a contract is created, the system builds a bill of quantities for the contract and keeps it in step with every edit to it. That bill, not the original survey, is what governs the Acts and the progress tracking from then on.

The difference against Excel is not that documents synchronize by magic. The difference is that an item is entered once and travels from there, instead of being keyed into three files that you then have to reconcile.

Acts Against the Contract, With the Balance Tracked

The quantity survey module connects to the module for acts of work executed through the contract. The process runs like this:

1. Open the contract and start a new act from it.
2. See the line items with their contract quantities and the balance left to full completion.
3. Enter what was executed in the current act. The system will not let you exceed the balance.
4. Values are calculated automatically and the executed work accumulates per line item.

On the contract detail page every line item shows the progress accumulated so far:

Line Item	Contract Quantity	Executed to Date	Remaining	Progress
Concrete C25/30	500 m3	350 m3	150 m3	70%
Reinforcement B500B	45,000 kg	30,000 kg	15,000 kg	67%
Formwork	1,200 m2	900 m2	300 m2	75%

This picture refreshes with every new act. No moving data across by hand, no risk of an error in the cumulative totals, and no way to certify a quantity that has already been used up.

If the act arrives as a document from outside, the system checks its rates against the contract rates and shows you the discrepancies before anything is written.

IFC Import - From BIM Model to BOQ

If your project includes a BIM model, Construction Team can import an IFC file and generate quantity survey line items automatically. The process runs through several steps:

1. Upload the IFC file - up to 300MB.
2. Element recognition - walls, columns, slabs, beams, services, doors, windows.
3. Quantity extraction - areas, volumes, lengths, counts, taken from the standard buildingSMART quantity sets.
4. Nomenclature matching - vector search and a language model link the elements to your items. Every match carries its own confidence score and alternative candidates, and the uncertain ones are colored in the 3D view as well.
5. Line item generation - the system creates the items with calculated quantities, including derived ones such as reinforcement from the volume of concrete.

This process saves days of manual work on projects with BIM models. Instead of walking the 3D model element by element and writing quantities down by hand, the system does it for you and you only review what it flagged.

From Excel to Construction Team - A Real Scenario

Let us walk through a realistic scenario to show the difference.

Before: "BuildRight Ltd" with Excel

BuildRight Ltd runs 5 active projects. A team of 3 estimators prepares and maintains the BOQs. Here is what a typical week looks like:

• Monday: Estimator 1 picks up a new project. Copies a template from an old BOQ, changes the title, and starts entering line items. Takes 6 hours.
• Tuesday: The client on Project 3 asks for changes to 12 line items. Estimator 2 opens the BOQ, makes the changes, then re-types them into the offer and the contract as well. Takes 3 hours.
• Wednesday: Certificate 4 for Project 2 is due. Estimator 3 moves data from the BOQ into the certificate template and works out the cumulative totals by hand. Finds a mismatch with Certificate 3, because the cumulative sum does not agree. Takes 5 hours, 2 of them spent hunting the error.
• Thursday: A subcontractor sends in their own BOQ. Estimator 1 re-types 180 line items into the company file and then checks them one by one against the contract rates. By hand, row after row. Takes 4 hours.
• Friday: The director wants a report on overall progress across all projects. Three estimators spend 2 hours each gathering data from various Excel files.

Total: around 28 hours a week, of which at least 40% is moving data by hand and checking for errors.

After: "BuildRight Ltd" with Construction Team

The same firm, the same projects, but with Construction Team:

• Monday: Estimator 1 creates a new quantity survey, picks items from the Nomenclature, and enters quantities. Units and rates fill themselves in. Takes 3 hours (instead of 6).
• Tuesday: Changes to 12 line items. Estimator 2 edits the survey and creates the new offer from it in one action instead of re-typing. Takes 45 minutes (instead of 3 hours).
• Wednesday: Act 4 for Project 2. Estimator 3 starts the act from the contract, sees the balance on every line item, and enters only what was executed in the period. Takes 30 minutes (instead of 5 hours).
• Thursday: The subcontractor's BOQ comes in through the import template, the items match by code against the Nomenclature, and the estimator reviews only the ones without a match. Takes 30 minutes (instead of 4 hours).
• Friday: Progress report. The director opens the portfolio view and sees the percentage for each site in real time. Takes 5 minutes (instead of 6 hours).

Total: around 5 hours a week instead of 28. That is 23 hours saved every week, nearly 3 working days.

How Much Time Do You Save?

Here is a summary comparison for the typical quantity survey operations:

Task	Excel	Construction Team	Time Saved
Create a BOQ (100 items)	5-6 hours	2-3 hours	~50%
Change 10 unit rates	1-2 hours	10 minutes	~90%
Carry a BOQ into an offer	1-2 hours	One action	~100%
Draw up an act against the contract	3-5 hours	15-30 minutes	~90%
Progress report by line item	2-3 hours	Real time	~100%
Import items from an Excel template	Manual re-entry	10-15 minutes	~95%
Duplicate a BOQ for a new site	1-2 hours	One action	~100%
Progress across every site	1-2 days	5 minutes	~99%

These numbers are not theoretical. They reflect the real experience of construction firms that have moved from Excel to specialized software. The specific figures depend on how complex your projects are and how experienced the team is, but the trend is unambiguous: specialized software saves between 60% and 90% of the time spent managing bills of quantities.

Beyond the time, you save something more important: errors. Every manual operation in Excel is a potential mistake. A wrong unit rate, a wrong quantity, a wrong cumulative total, and each of them can turn into a financial loss. Software removes those risks by automating the arithmetic and keeping the linked documents consistent.

When Is Excel Still Good Enough?

Let us be honest. Excel may well be enough if:

• You run 1 or 2 small projects a year
• Your BOQs have fewer than 30 line items
• One person does the work and nobody needs shared access
• You do not need cumulative progress tracking
• You do not draw up certificates against contracts

But if you are running several projects at once, if your BOQs are complex, if you work as a team, then Excel is not the tool you need. It was designed for tabular calculations, not for managing construction paperwork.

How Do You Start the Transition?

Moving from Excel to specialized software does not have to be abrupt. Here is the approach we recommend:

1. Start with one project - pick a new project and build its quantity survey in Construction Team. Do not migrate old projects straight away.
2. Import an existing BOQ - if you have one in Excel, rearrange it into the template and upload it. Check the matching by code and make corrections.
3. Create the offer from the survey - instead of writing it from scratch. Feel how much of the work simply falls away.
4. Draw up the first act against the contract - when the moment comes, start the act from the contract. Compare it with one prepared by hand and you will see the difference.
5. Expand - once the team knows the module, start creating every new quantity survey in the system.

Related Articles

If you found this topic useful, we also recommend:

• Construction Cost Control Guide - how to monitor your project budget in real time and prevent cost overruns.
• AI Data Extraction from Construction Documents - how AI technology automatically recognizes and structures data from invoices, BOQs, and certificates.
• What Is Construction Management Software? - a comprehensive overview of the features every construction firm needs.

---

Want to see how Construction Team can transform the way you manage bills of quantities? Get in touch for a demo and a free trial.