Menu Close

Bill of Quantities Excel Template UK

bill of quantities excel template uk

A bill of quantities is a critical document in construction projects. It provides a framework for cost planning and aids in passing important construction tenders. It is usually prepared by a quantity surveyor.

A bill of quantities must be prepared according to a standard methodology. This helps avoid ambiguities and misunderstandings during the tendering process.


A bill of materials (BOM) is a list of all the raw materials or components that are needed to create a product. It also includes the prices of these materials and the amounts that are required. It is often used to obtain quotes from suppliers and contractors for construction projects. It helps project owners manage costs, and ensures that all parties are on the same page. A well-written BOM can reduce the risk of misunderstandings, disagreements, or miscommunications between parties.

A BoQ is normally prepared by a cost consultant such as a quantity surveyor. The document provides project-specific measured quantities of the items identified in drawings and specifications for a built asset such as a building. The quantities may be measured in terms of number, length, area, volume or weight. The document also includes work that might be required to deal with unforeseen obstructions, or to complete variations to the contract. The document is normally prepared in a standard format so that contractors can compare quotations on a rate-for-rate basis.

The preparation of a BOM requires careful consideration and planning, and it is important that the details are clear and correct. Inaccuracies may result in a large variation in final costs, and can be costly to the contractor and client alike. Typical errors include incorrect measurement of quantities, arithmetic mistakes, omissions and inaccurate assumptions. It is important to check the bill of quantities thoroughly for these types of errors before submitting it to the client.

While it is possible to use a manual process to prepare a bill of quantities, there are many advantages to using software for the purpose. For example, it can speed up the process by reducing the time spent on manually entering data. It can also save on labor and material costs. Additionally, it can allow multiple people to work on a project at the same time.

Several different types of software are available for the preparation of a bill of quantities, including spreadsheets and building information modelling (BIM) systems. Some of these can even generate the document automatically based on the data contained in the model. However, it is important to choose a system that will integrate with other project management and construction systems, so that data can be cross-referenced and discrepancies avoided.


Having an accurate bill of quantities helps to reduce overruns and ensure that the construction process runs smoothly. It also enables contractors to quote competitive prices for the work and provides a basis for comparison between tenders. It is especially helpful for projects that involve many stages or subcontractors. It also saves time by avoiding costly disputes.

The preparation of a bill of quantities is an essential stage in the pre-construction phase of any project. It is created using a process known as ‘taking off’, which involves identifying elements of construction works that can be measured and priced. This document can then be used by suppliers to prepare their tenders.

To produce a detailed and accurate bill of quantities, it is important to consider all the factors that may affect your estimate. This includes the cost of labour, materials and equipment. You should also consider the type and size of any buildings or structures that may be required. Finally, you should consider the time frame for the project and the weather conditions.

A good bill of quantities is a crucial document for estimating the cost of a building or civil engineering project. It will allow the estimator to calculate the correct cost of each individual element, including labour, material and plant. The document should be presented in a clear and concise manner.

Creating a bill of quantities in Excel is a straightforward task. However, the template may require some editing before it is ready for use. Depending on the version of Excel you use, it might have pre-set formulas and formatting that you should change. It is important to edit these settings so that the document is easy to read and understand.

A free template for a bill of quantities is available online. Nevertheless, it will require some advanced practical knowledge of Excel to be used effectively. It is also necessary to understand the differences between Excel 2003, 2007, and 2010. These versions have different features, such as keyboard shortcuts, lookup functions, and reference functions. A good bill of quantities template will be able to automatically calculate costs and include an index and table of contents. It will also be able to calculate unit rates based on a number of sources, including current rates, past projects, market rates, and price libraries.


A bill of quantities (also known as a BOQ or BQ) is documentation that defines the quality and quantity of work that will be required to complete a construction project. It is prepared by a quantity surveyor or cost consultant and is a vital tool in the tendering process. A bill of quantities outlines all the elements needed to complete a project, including materials, labour and plant requirements. It also lists allowances for contingencies and provides a basis for the valuation of variation.

It’s important that the scope of work is clearly defined, as this will reduce misinterpretation and ambiguity. It will also help avoid waste in time and money and make it easier to monitor costs. This is why it’s best to follow the extensive guidance outlined in RICS NRM2 when preparing a bill of quantities.

Bills of quantities are usually prepared in the pre-construction phase through a process called ’taking off’, where construction work that can be measured is identified. This is a standard process that should be carried out by the client’s quantity surveyor or cost consultant. The resulting document is then used to inform the project team of what’s required, and by when. It’s then central to the tendering process as it enables construction contractors to prepare competitive price proposals.

A well-prepared bill of quantities will be based on the information provided by the architect and engineer, along with detailed drawings and specifications. It will be broken down into work sections that reflect likely sub-contract packages. This makes it easier for a contractor to obtain prices from their subcontractors and helps ensure that the work is done correctly, efficiently and on time.

Increasingly, software is being used to assist with the preparation of bills of quantities. These are often part of a building information modelling (BIM) system and can make the process much faster and more accurate. This will reduce the amount of time that quantity surveyors and civil engineers spend estimating, which can be invaluable on projects with tight deadlines.

Excel is a popular tool for preparing a bill of quantities, although it does require more advanced practical knowledge than some other specialised software. Nonetheless, it is a good option for small-to medium-sized projects, where the level of detail involved is limited.


A bill of quantities, or BoQ, is a document that lists measured quantities of work identified in the drawings and specifications for a project. It is prepared by a cost consultant, such as a quantity surveyor, and includes the details of each item of work. It is used as a basis for contractor pricing during the tender process. It is a vital part of the design and construction process, ensuring that everyone involved has the correct information. It reduces the risk of misunderstanding, disputes, or cost overruns by providing a clear and concise reference point for each work package. It also ensures that all parties are aware of the work to be carried out and prevents waste in time, money or materials.

A typical BoQ is a tabular form with column headings including item number, description, unit of measurement, quantity, rate and amount. The items of work are then split into packages for different contractors and the total amount of each package is calculated by multiplying the rate per unit by the quantity. The resulting total is the amount payable to the contractor.

If there is insufficient information available to prepare a full Bill of Quantities, then it will be necessary to create an approximate one. This is usually done in the early stages of a project and the details will be remeasured as the project progresses. During this stage, it is important to use software that allows for detailed and precise estimates. This will reduce favouritism, human error and speed up the estimating process.

Another section of a bill of quantities is the provisional sums, which are work that may be required in the event of unexpected obstructions or unforeseen difficulties on site. This can include work to deal with changes to a design, or to complete variations. It is important to set a cost against these risks to avoid a dispute with the client at the end of the project.

Using the right spreadsheet to create a bill of quantities will save valuable time for the quantity surveyor and the project manager. It will also reduce the possibility of errors and misinterpretation by contractors. The Excel templates are easy to use and can be customised to match the exact requirements of each project.