Skip to main content
Procore (en-GB)

Import Commitment BOQ Line Items from a CSV File

Objective

To import the Bill of Quantities (BOQ) line items for a purchase order or subcontract using a Comma Separated Values (CSV) file. 

Background

To save time from manually adding line items to a purchase order's or subcontract's BOQ, you can download a CSV file from your project, add your line items to that file and then import it into Procore. 

Things to Consider

  • Required User Permissions:
    • 'Admin' level permissions on the project's Commitments tool. 
      OR
    • 'Read Only' or 'Standard' level permissions on the project's Commitments tool with the 'Update Purchase Order' and ''Update Work Order Contract' granular permissions enabled on your permission template.
  • Additional Information:
    • If the 'Enable Always Editable Bill of Quantities' setting is turned OFF in the Commitments Tool's Configure Settings page, the purchase order or subcontract must be in the Draft status. This is Procore's default setting. 
    • If the 'Enable Always Editable Bill of Quantities' setting is turned ON in the Commitments Tool's Configure Settings page, the commitment contract can be in any status. However, you cannot replace line items that have been payment application when performing an import. To learn more, see What is the 'Enable Always Editable Bill of Quantities' setting? 
  • For companies using the icon-erp-synced2.png ERP Integrations tool: Show/Hide  

Steps

Customise the Delimiter & Download a Blank Template

  1. Navigate to the project's Commitments tool. 
  2. Under the Contracts tab, click the Number link for the commitment to open. 
  3. Click the Bill of Quantities tab. 
  4. At the bottom the Bill of Quantities page, click Import BOQ from CSV
  5. In the Import Bill of Quantities from CSV window, choose these options:
    • Click Customise CSV Delimiter to reveal the options. 
    • Under Choose CSV Delimiter, choose one of these options:
       Tip
      What is a delimiter? A delimiter is a character used to separate values or text strings. It marks both the beginning and end of a unit of data.
      • Comma. Separates data using a  comma (,). This is Procore's default option. 
      • Semicolon. Separates data using a semicolon (;). 
  6. Click the Download Blank CSV Template button.
    Procore downloads a blank template file named 'Subcontract BOQ Template' the download location specified for your web browser.  

Add Line Items to the Blank Template

  1. On your computer, open the template that you just downloaded. 
  2. Follow one (1) of these steps to add line item(s) to your blank template:
     Tip
    Which accounting method is configured for the commitment, contract or funding? Look at the headings in the blank template. If you see an 'Amount' column, it is configured for amount-based accounting. If you see 'Unit', it is configured for the unit-based accounting. To learn how to set the accounting method on a commitment, contract or funding, see How do I set the accounting method for a contract or funding?

Amount-Based Accounting Method

When a contract is using the amount based accounting method (see How do I set the accounting method for a contract or funding?), enter line items in the downloaded template file as follows:

  • Sub Job Code
    If sub jobs are enabled on your project, enter the sub job code. This column only appears when sub jobs are enabled. 
     NoteS
  • Budget Line Item
    The budget line item number from the Main Contract BOQ. It is not necessary to fill this out, since Procore will tie all Cost Code/Category Combinations together automatically and place them on the Budget tool.
  • Cost Code Name
    The detailed name of the cost code number in the following format: 'Division-Code - Title'. For example, 01-100 - Summary.
  • Cost Code Number
    The cost code number in the following format: 'Division-Code'. For example, 01-100.
  • Description
    Optional: A more detailed description of the line item.
  • Line Item Type
    Enter the appropriate cost type abbreviation for the cost code.
     Notes
    • If your company is using Procore's default cost types and abbreviations, see What are Procore's default cost types? for a list of abbreviations.
    • If you do NOT enter a valid abbreviation, the system will automatically classify the entry under 'Other'.  If your company's Procore Administrator has created a list of custom cost types, enter one of those abbreviations here. See Add Company Cost Types.
    • If your project is NOT being synced with an integrated ERP system, this entry is optional. 
    • If your project is being synced with an integrated ERP system that supports the 'Cost Type' concept, this entry is required.  See Which integrated ERP systems support the 'Cost Type' concept?
  • Amount
    Enter a numeric value or the commitment amount. Do NOT enter commas and or the pound (£) symbol. For example, '15000' is the correct syntax. If there is no monetary amount to enter, be sure to enter 0.00. The import will NOT accept a blank cell. 
    NoteBlank lines still count as lines in the import process, so be sure to delete them from the end of the CSV file before importing. 

Unit/Quantity Based Accounting Method

When a contract is using the unit/quantity-based accounting method (see How do I set the accounting method for a contract or funding?), enter line items in the downloaded template file as follows:

  • Sub Job Code
    If sub jobs are enabled on your project, enter the sub job code. This column only appears when sub jobs are enabled. 
     Notes
  • Subtotal Override
    To override the automatic calculation of the subtotal, enter a value here. If you enter a value here, always leave the Automatic Calculation fields ('Quantity', 'Unit Description' and 'Unit Price') blank. Do NOT complete both.
    OR
  • Automatic Calculation
    To use Procore's automatic calculation feature, enter a value in these fields. Do NOT complete the fields if you entered a value in the 'Subtotal Override' field. 
     Note
  • Optional: Description
    Enter a detailed description of the line item.
  • Cost Code Number
    Enter a cost code number in the following format: 'Division-Code'. For example 01-100.
  • Cost Code Name
    Enter a detailed name of the cost code number in the following format: 'Division-Code - Title'. For example 01-100 - Summary.
  • Budget Line Item
    Enter a budget line item from the main contract's BOQ. It is not necessary to fill this out, since Procore will tie all Cost Code/Category Combinations together automatically and place them on the Budget tool.
  1. Save your data entry in completed template.

Import the Completed CSV Template to Procore

  1. Return to the Import Bill of Quantities from CSV window. 
  2. Click the Upload File button. 
    import-sov-from-csv-window.png
  3. Navigate to the completed template on your computer and upload it. 
  4. Choose from these options:
    • If the commitment's Bill of Quantities has zero (0) line items, simply click the Import button. 
      OR
    • If the commitment's Bill of Quantities has existing line items, choose one (1) of these options:
      • Add Additional Line Items. This option adds the line items in the template to the existing line items in the Bill of Quantities. Then, click the Import button.
        OR
      • Replace Existing Line Items. This option removes all existing line items from the Bill of Quantities and replaces them with the line items in the template.  Then, click the Import button. Note: If the 'Enable Always Editable Bill of Quantities' setting is turned ON in the project's Commitments tool, this option is greyed out and unavailable for use once a payment application is created and line items are billed. To learn more, see What is the 'Enable Always Editable Bill of Quantities' setting? 
 Tips
  • How do I know if the import was successful? A GREEN success banner appears when the import process is successful. 
  • How do I get details about a file error? A RED error banner appears where there is a file error. Click the Show Errors button pictured below to reveal more specific information about the error to correct. 
    show-errors-button.png

 

If you would like to learn more about Procore's commitments software and how it can help your business, please visit our construction financials tool product page icon-external-link.png.