Import Installed Production Quantities for the Labour Productivity Cost Budget View
Objective
To import an installed quantities CSV for the Procore Labor Productivity Cost budget view.
Background
The 'Procore Labour Productivity Cost' budget view provides project teams with the ability to include production quantities on the project's budget. This allows team members to leverage real-time productivity data from your project's field personnel to improve your team's ability to forecast labour hours and costs at project completion. Using the steps below your team can import installed quantities to your project's Budget tool. To do this, first download a Microsoft Excel template from the budget tool. Then complete the data entry in the spreadsheet and upload it to your budget.
Things to Consider
- Required User Permissions:
- 'Admin' level permissions on the project's Budget tool.
- Supported Import File Type:
- CSV
- For companies using the ERP Integrations tool: Show/Hide
- The installed production quantity values are NOT synced with integrated ERP systems.
- Your project's budget can be in either a locked or unlocked state.
Prerequisites
- Assign the 'Procore Labor Productivity Cost' budget view to your Procore project. See Set Up the Procore Labor Productivity Cost Budget View.
- Set up your project's budget. To learn more, see Add a Budget Line Item or Import a Budget.
- Add budgeted production quantities to the budget using the options below:
Steps
- Download the Installed Production Quantities Template
- Update the Installed Production Quantities Template
- Import the Installed Production Quantities Template
Download the Installed Production Quantities Template
- Navigate to the project's Budget tool.
- Under the Budget tab, select the 'Procore Labour Productivity Cost' view from the View drop-down list.
- Under Import Installed Quantities, click the Download Excel Template link.
- On your computer, open the downloaded file named installed_production_quantities.xlsx.
The illustration below shows you the download file:
- Continue with the next steps.
Update the Installed Production Quantities Template
- In the installed_production_quantities.xlsx file, complete the data entry as follows for the installed production quantities that you want to update:
Important
Do NOT add new line items or change existing values in the Microsoft Excel file. It is designed only to import 'Quantity Installed' values for your existing cost codes.- Cost Code
Shows the cost code that corresponds to the installed production quantity that you want to update. Cost codes are managed in Procore's Work Breakdown Structure. - Description
Shows the cost code description. Cost codes are managed in Procore's Work Breakdown Structure. - Quantity Installed
Enter the quantity installed for that cost code using whole numbers. - Production UOM
Shows the Unit of Measure (UOM). To learn about the default selections in this list, see Which units of measure are included in Procore's master list? and Add a Unit of Measure to the Unit of Measure Master List. - Date Installed (MM/DD/YYYY)
Enter the installation date that corresponds to the 'Quantity Installed' entry using the MM/DD/YYYY format.
- Cost Code
- Save your Microsoft Excel file in the CSV format.
Import the Installed Production Quantities Template
- Navigate back to the project's Budget tool.
- Under the Budget tab, select the 'Procore Labour Productivity Cost' view from the View drop-down list.
- Under Import Installed Quantities, click the Choose File link.
- On your computer, navigate to the installed_production_quantities.csv file that you just saved and upload it.
- Click Import.