Import a Main Contract BOQ from a CSV File

Download a CSV Template

1. Navigate to the Main Contracts tool. 
2. In the table, click a Number link to open the contract.
3. Under the General tab, click Bill of Quantities.
4. In the Bill of Quantities card, click Edit. 
   This places the BOQ into edit mode
5. Below the table, click Import and choose BOQ from CSV.
   This opens the Import Bill of Quantities from CSV window. 
   
   
    
6. Expand Customise CSV Delimiter.
7. Choose a delimiter for the template file: Comma or Semicolon.
   The system's default option is Comma. 
8. Click Download CSV Template and choose: Blank Template or Template with Existing Line Items. 
   The downloads the selected template to your web browser's configured location. 

Add Line Items to a CSV Template

1. Open the downloaded template in a spreadsheet editor.
2. Enter the line item data using the appropriate accounting method for the main contract. See How do I set the accounting method for a contract or funding?

• How to enter data for amount-based accounting: Show/Hide      
  • To import a main contract using the amount-based accounting method, enter data as follows:
    
    
    • Sub Job. Enter a sub-job code for the line item. This only appears when sub-jobs are enabled. See Enable Sub Jobs for WBS and Which integrated ERP systems support the sub job concept?
    • Cost Code. Enter a cost code for the line item. To learn more, see What are Procore's default cost codes?
    • Cost Type. Enter a cost type for the line item. See What are Procore's default cost types? 

       Important Information about Cost Types

      • If you leave this cell blank, Procore classifies it as Other.
      • This list might be customised for your company. See Add Company Cost Types or ask your Company Admin for a list of valid cost types. 
      • Data entry is required if your integrated ERP system syncs data with Procore. See Which integrated ERP systems support the 'Cost Type' concept?
    • Description. Enter a statement to describe the line item. 
    • Tax Code. Enter the tax code for the line item.

       Important Information About Tax Codes

      • This list might be customised for your company. See Configure Tax Code Settings or ask your Company Admin for a list of valid tax codes. 
    • Amount. Enter a numeric amount without commas or the pound sign (e.g., 15000); enter '0.00' if there is no monetary amount, as blank cells are not accepted.
• How to enter data for unit/quantity-based accounting: Show/Hide      
  • To import a main contract using the amount-based accounting method, enter data as follows:
    
    
    • Sub Job. Enter a sub-job code for the line item. This only appears when sub-jobs are enabled. See Enable Sub Jobs for WBS and Which integrated ERP systems support the sub job concept?
    • Cost Code. Enter a cost code for the line item. To learn more, see What are Procore's default cost codes?
    • Cost Type. Enter a cost type for the line item. See What are Procore's default cost types? 

       Important Information about Cost Types

      • If you leave this cell blank, Procore classifies it as Other.
      • This list might be customised for your company. See Add Company Cost Types. 
      • Data entry is required if your integrated ERP system syncs data with Procore. See Which integrated ERP systems support the 'Cost Type' concept?
    • Description. Enter a statement to describe the line item. 
    • Quantity. Enter a numeric value representing the quantity of the unit.
    • UoM. Enter a UoM abbreviation. See Which units of measure are included on Procore's master list?
    • Unit Price. Enter the unit price for the line item. 
    • Subtotal. Enter the subtotal for the line item. 
    • Override. You have these options, choose one (1) option:
      • To override the automatic subtotal calculation, enter a value here and leave the Quantity, Unit Description and Unit Price fields blank.
        OR
      • To use Procore's automatic calculation, enter values in the Quantity, Unit Description and Unit Price fields, leaving the Override field blank.

         Important information about automatic calculation

        • If your integrated ERP system syncs data with Procore, data entry in the Quantity, Unit Description and Unit Price fields is required. See Which integrated ERP systems support the 'Cost Type' concept?
    • Tax Code. Enter the tax code for the line item. See Configure Tax Code Settings.

Import the Completed CSV Template to Procore

1. Navigate to the Main Contracts tool. 
2. In the table, click a Number link to open the contract.
3. Under the General tab, click Bill of Quantities.
4. In the Bill of Quantitiess card, click Edit. 
   This places the BOQ into edit mode.
5. Below the table, click Import and choose BOQ from CSV.
   This opens the Import Bill of Quantities from CSV window. 
   
   
6. Upload the file as follows:
   • Click Upload File and select the completed template to upload.
     OR
   • Drag-and-drop the completed template to the CSV File area.
7. Depending on the state of your main contract, choose the appropriate option:
   • To add more line items to the main contract, select Add Additional Line Items, then click Import. 
   • To replace all existing line items on the main contract with the template, select Replace Existing Line Items, then click Import.

Procore imports the template and displays a success banner. If you see an error message, click Show Error to learn why the import failed.