Skip to main content
Procore (en-GB)

Update the Bill of Quantities (BOQ) on a Main Contract

  1. Last updated
  2. Save as PDF

Objective

To describe the different ways you can update the line items on a bill of quantities on a main contract. 

Background

Things to Consider

Steps

There are several ways to add and update line items on a main contract's BOQ:

 Note
Procore customers using the ProEst® integration can also import a Main Contract BOQ. For instructions, see Import a Main Contract BOQ from a ProEst® XML File.

Add Line Items to the Main Contract BOQ

  1. Navigate to the project's Main Contracts tool.
  2. Locate the main contract with the BOQ to update.
  3. Click Edit.
  4. Click Bill of Quantities.
  5. Click Add Line.
  6. Complete the data entry as follows:
    1. Budget Code
      Select a budget code from the or click Create Budget Code to create a new one. See What is a budget code?
    2. Description
      Enter a description for the line item. For example, type: Monthly Service Fee
    3. Qty
      Enter in the quantity of units.
    4. UOM
      Select the Unit of Measure (UOM) from the list. See Which units of measure (UOM) are included on Procore's master list? and Add a Unit of Measure to the Unit of Measure Master List.
    5. Unit Cost
      Enter the Unit Cost in the box provided.
    6. Amount
      The system automatically calculates the subtotal for you, based on the Qty, UOM, and Unit Cost entries. 
  7. Repeat the above steps for all line items.
  8. Choose one of these options:
    • Click Save
      OR
    • Click Save & Email.  

Create a Main Contract BOQ from the Project's Budget

If you created a project budget (using the Budget tool), you can use it to quickly build out a Main Contract's BOQ. There are two options for how to create the Main Contract BOQ from the Budget tool. (Note: You can only perform this action if there are zero line items.)

  1. Navigate to the project's Main Contracts tool. 
  2. Locate the main contract that you want to update in the list.
     Note
    To create a bill of quantities from a budget:
    • The budget must be locked. See Lock a Budget. 
    • The main contract must be in the 'Draft' status.
    • The BOQ must be blank (no line items can exist for the options below to be available). 
  3. Click Edit.
  4. Click Bill of Quantities.
  5. Click Edit.
  6. Under Create Bill of Quantities from Budget, choose one of the available options:

    create-boq-from-budget.png
     
    • Option Button 1
      This option creates one line item on the main contract's BOQ for each line item on the project's budget. 
    • Option Button 2
      This option create one line item on the main contract's BOQ for the summaries of each division on the project's budget.
  7. ​Click Create.

Import a Main Contract BOQ from a CSV File

  1. Navigate to a project's Main Contracts tool.
  2. Locate the main contract where you want to import the BOQ. 
  3. Click Edit. 
  4. Click Bill of Quantities.
  5. (Optional) Under Import Bill of Quantities from CSV, download one of the template options:
    • Blank Template
      To download a blank template, click A Blank Template. 
      OR
    • Template with Existing Line Items
      To download a template that includes any existing BOQ line items, click One Showing Existing Line Items. 
      This downloads a template named 'csv_import.csv' to the location on your computer specified in your web browser's settings. 
      Notes:
      • Using your own template or modifying a file to match a template can result in an incompatible format which can lead to import failure and/or import errors.
      • After completing your BOQ data entry in a template, continue with the import process.
      • While using a Procore template is marked (Optional), we recommend that you always download one of these templates to complete your BOQ data entry. 
      • If the combination of the sub job, cost code and cost type are non-budgeted for a line item, this line item will be added directly to the Budget with a "?" next to the line item. See Add a Partial Budget Line Item.
  6. Update the template with your BOQ line items. 
    Notes:
    • Do NOT add, rearrange, remove or rename any of the columns or column headings in the template. 
    • To complete the import successfully, your data needs to be entered using the exact structure specified in the template.  
    • The cost code and cost type entries must exactly match the codes and types defined under Cost Codes in the project's Admin tool. See Add and Edit Project Cost Codes.

      Main Contract example import csv.png

       
  7. Complete the data entry as follows:
    1. Cost Code Name
      The detailed name of the cost code number in the following format:
      'Division-Code - Title' (e.g. 01-100 - Summary)
      Note: if you do not want to use a cost code, you must enter "None" in the Cost Code Name and Cost Code Number fields. 
    2. Cost Code Number
      The cost code number in the following format:
      'Division-Code' (e.g. 01-100)
      Note: if you do not want to use a cost code, you must enter "None" in the Cost Code Name and Cost Code Number fields. 
    3. Description
      (Optional) A more detailed description of the line item.
    4. Line Item Type
      (Optional) The cost type associated with your cost code (e.g., Labour, Materials, etc.). See Default Cost Type List.
      Notes:
      • You can modify the default cost types and add its own definitions to the list.
      • It is important that your data entries match your company's cost type list. For example, if the category type is Materials, use M and not m, materials, or Materials. Below are the Procore's default Cost Types. Invalid entries are listed as Other in the Type column. 
      • The import process is case-sensitive. 
    5. Amount: Enter a numeric value or the contract amount. (The use of commas and/or the pound symbol (£) are not required.) For example, '15000' is correct syntax. If there is no sterling amount to enter, be sure to enter 0.00 (the import will not accept a blank cell). 
      Note: Blank lines still count as lines in the import process, so be sure to delete them from the end of the BOQ file before importing. 
  8. Specify the type of import/upload action to perform.
    • Delete existing line items and add CSV as new items  
    • Keep existing line items and add CSV as new items
  9. Select the modified CSV file.
  10. Click Import.
  11. Wait a few seconds and then click the Bill of Quantities tab.
  12. Verify that the BOQ was imported as expected. 

    Main contract example import verify.png
     
  13. If you need to make further changes to the BOQ, click Edit.
    • Manually add additional line items
    • Delete a line item
    • Change the selected cost code number
    • Edit a line item's description, type and contract amount
  14. Click Save.
    OR
    Click Save and Email if you want to save your changes, as well as forward a copy of the Main Contract using Procore's built-in email feature. You'll also be able to specify recipients and include a brief message about the Main Contract.

See Also