To set up a Labor Budget to Actual Report that shows a comparison of labor hours to budgeted hours for each cost code in the project.
This feature allows users to upload budgeted labor hours from outside the Budget tool. They can view the comparison of Timesheet hours to these budgeted hours in a Labor Budget to Actual Report. The primary value of this report is to see the percentage of hours used for each cost code and includes calculated values like remaining and job to date hours.
Things to Consider
- Required User Permission:
- Admin on the project's Directory tool.
- Supported Import File Type:
- Prerequisites (If Budget tool is enabled):
- The Budget tool must be unlocked. See Unlock a Budget.
- Additional Information:
- You do NOT need to have the Budget tool enabled to create or view the Labor Budget to Actual Report.
- The 'Unit Quantity Based Budget' section in the project's Admin tool is only available to those who have the Timesheets tool enabled.
- It is recommended that you only import your Budgeted Hours once. However, if you choose to import a newer version of the Budgeted Hours, any new items will be added to the report and changes to the “original” Budgeted Hours will be overwritten with the most recent version.
- If your project has the Budget tool enabled:
- Importing a cost code and cost type that doesn't already exist on the budget will create a new Budget Line Item (BLI).
- Navigate to the project's Admin tool.
- In the right side pane under Project Settings, click Unit Quantity Based Budget.
- Under Import Budget CSV, click Download Template.
The system downloads a copy of the import_unit_quantity_based_budgets.csv file to the download location for your web browser.
Important! You must always add your project's budgeted hours into the provided template CSV file. For compatibility reasons, it's strongly recommended that you only use the provided template (import_unit_quantity_based_budgets.csv) for importing your budgeted hours data for the Labor Budget to Actual Report.
- Before updating the CSV file, be aware of the following:
- DO NOT rename any column headings in the CSV.
- DO NOT add, remove, or change the order of the columns in the CSV.
- You do NOT need to delete any unused data rows. Procore will neither import data nor create items for any rows where the Labor Hours field is blank.
- Enter the number of budgeted hours estimated for each cost code in the Labor Hours column (Column E).
- Save your changes to the CSV file.
Important! Always save the file in the Comma Separated Values (.csv) file format.
- Navigate back to your project's Admin tool.
- In the Import Budget CSV area, click Choose File.
- In the window that appears, select your CSV file. Then click Open.
- When the file name appears next to the 'Choose File' button, click Import.
- A banner at the top of the page will appear confirming the line items imported.
- If your project has the Budget tool enabled, the file will only import if the Budget is unlocked.
- Check the import and verify that all the budgeted hours that were entered in the Labor Hours column were properly imported by viewing them on the Unit Quantity Based Budget page or in the Labor Budget to Actual Report.
Note: If you see the message below on your Labor Budget to Actual Report, or are missing certain cost codes after you have imported budgeted hours, you will need to enter time against the missing cost codes in one of the time reporting tools in Procore (Timesheets, Daily Log or Company Timecard).