To import budgeted hours 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' level permission 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).
Video content may not accurately reflect the current state of the system, and/or it may be out of date.
- Navigate to the project's Admin tool.
- Under 'Project Settings' in the sidebar, click Unit Quantity Based Budget.
- Under 'Import Budget Excel document', click Download Template.
The system downloads a copy of the project-name-import-unit-quantity-based-budget.xlsx file to the download location for your web browser.
Important! You must always add your project's budgeted hours into the provided template XLSX file. For compatibility reasons, it's strongly recommended that you only use the provided template (project-name-import-unit-quantity-based-budget.xlsx) for importing your budgeted hours data for the Labor Budget to Actual Report.
- Before updating the XLSX file, be aware of the following:
- DO NOT rename any column headings in the XLSX.
- DO NOT add, remove, or change the order of the columns in the XLSX.
- 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.
- In the XLSX file, confirm you are on the first tab, Budgeted Time
- Select the cost type from the drop-down menu in the Cost Type column (Column D).
- Enter the number of budgeted hours estimated for each cost code in the Labor Hours column (Column E).
- Save your changes to the XLSX file.
Important! Always save the file in the .xlsx file format.
- Navigate back to your project Admin tool's Unit Quantity Based Budget section.
- In the "Import Budget Excel document" area, click Choose File.
- In the window that appears, select your XLSX file. Then click Open.
- When the file name appears next to the 'Choose File' button, click Import.
Note: 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 budgeted hours 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.