Update the Schedule of Values on a Funding

 Limited Release
flag-us.png The Funding tool is available as a limited release for Procore customers in the United States who have implemented the Procore for Owners point-of-view dictionary. To learn more, see What tool names and terms are different in Procore for general contractors, owners, and specialty contractors?

Objective

To describe the different ways you can update the line items on a funding's Schedule of Values (SOV).

Background

After creating a funding, you can choose from three (3) methods to add line items to the SOV: 

Things to Consider

Prerequisites

Steps

There are several ways to add and update line items on the SOV:

Add Line Items to the SOV

  1. Navigate to the project's Funding tool.
  2. Locate the funding to update and click its Number link. 
  3. Click the Schedule of Values tab.
  4. Click Add Line.
  5. Complete the data entry as follows:
    1. Budget Code
      Select a budget code or click Create Budget Code to create a new one. See What is a budget code in Procore's WBS? 
    2. Description
      Enter a description for the line item. For example, type: Monthly Service Fee
    3. Qty
      Enter the number of units.
    4. UOM
      Select the Unit of Measure (UOM) from the list. See Which units of measure 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 cost per unit in this box. You'll notice that the value in this column contains four (4) decimal points (for example, $0.0000) to allow you to enter the specific value required to calculate accurate pricing. 
      Example
      If you are buying 50,000 units for $1,006,625.00, you would enter a unit price of $20.1325. 
    6. Amount
      The system automatically calculates the subtotal for you, based on the Qty, UOM, and Unit Cost entries. 
  6. Repeat the above steps for all line items.
  7. Choose one of these options:
    • Click Save
      OR
    • Click Save & Email.  

Create the SOV from the Project's Budget

 Note

If you will be creating the SOV from the project's budget as described below, ensure the SOV is blank. You can only use these steps below when the SOV has zero (0) line items. You must also:

  1. Navigate to the project's Funding tool. 
  2. Locate the funding to update. Then click its Number link.
  3. Click the Schedule of Values tab.
  4. ​Below the 'Schedule of Values' table, click Import. Then choose SOV from Budget from the drop-down menu.

    import-sov-from-budget.png
     
  5. In the 'Import Schedule of Values from Budget?' window, click Import. 
    • If the SOV is blank, the following message appears. 

      import-sov-blank.png
    • If the SOV has existing line items, all existing line items will be replaced with the line items in the budget.
      import-sov-from-budget-window.png

      Procore replaces any existing line items on the Schedule of Values with the line items current in the project's budget. This can take several minutes. Once the import is complete, a GREEN banner appears to indicate the action was successful and the line items appear in the 'Schedule of Values' table. 

Import the SOV from a CSV File

Customise the Delimiter & Download a Blank Template

  1. Navigate to the project's Funding tool. 
  2. In the table, click the Number link for the funding to open. 
  3. Click the Schedule of Values tab. 
  4. At the bottom the Schedule of Values page, click Import SOV from CSV. 
  5. In the Import Schedule of Values from CSV window, choose these options:
    • Click Customise CSV Delimiter to reveal the options. 
    • Under Choose CSV Delimiter, choose one of these options:
      customize-delimiter.png
       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 SOV 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
    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.

Amount-Based Accounting Method

  1. 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:
    • #. Enter the line item number. 
    • Budget Code. Enter the budget code for the line item. 
    • Tax Code. Enter a tax code for the line item. 
    • Amount. Enter the line item amount. 
    • Billed to Date. Enter the amount billed to date for the line item, if applicable. 
    • Amount Remaining. Enter the amount remaining for the line item, if applicable. 
  2. Save your data entry in the completed template. 

Unit/Quantity Based Accounting Method

  1. 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:
    • #. Enter the line item number. 
    • Budget Code. Enter the budget code for the line item. 
    • Description. Enter a description for the line item. 
    • Tax Code. Enter a tax code for the line item. 
    • Qty. Enter the unit quantity for the line item. 
    • UOM. Enter a Unit of Measurement (UOM) for the line item. 
    • Unit Cost. Enter the unit cost for the line item. 
    • Amount. Enter the total amount for the line item. 
    • Billed to Date. Enter the amount billed to date for the line item, if applicable. 
    • Amount Remaining. Enter the amount remaining for the line item, if applicable. 
  2. Save your data entry in completed template.

Import the Completed CSV Template to Procore

  1. Return to the Import Schedule of Values 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 Head Contracts's Schedule of Values has zero (0) line items, simply click the Import button. 
      OR
    • If the Head Contract's Schedule of Values 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 Schedule of Values. Then, click the Import button.
        OR
      • Replace Existing Line Items. This option removes all existing line items from the Schedule of Values and replaces them with the line items in the template.  Then, click the Import button. Note: If the 'Enable Always Editable Schedule of Values' setting is turned ON in the project's Head Contracts tool, this option is greyed out and unavailable for use once a progress claim is created and line items are billed. To learn more, see What is the 'Enable Always Editable Schedule of Values' 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

See Also