IMPORTANT! In order to protect the integrity of your company’s data, Procore Employees are restricted from modifying the data that clients submit in all Procore Import Templates. This restriction applies to all data modifications, including correcting typographical errors. If Procore determines that errors are present in any Procore Import Template that you submit to Procore, it will be returned to you for correction. Please note that the import process may take up to 72 hours to process.
To import multi-level cost codes to the Project level Admin tool.
The Project level Admin tool provides users with 'Admin' level permission with the ability to create multi-level cost code structures that can be used to manage, report, and track budgets associated with a Procore construction project. The cost code structure in Procore supports up to five (5) levels (a.k.a., tiers, levels of detail, codes, and so on). This hierarchical structure provides Procore's clients with a significant amount of flexibility for defining company and project cost code structure(s).
Most Procore customers create a two (2) level cost code structure. To learn how to import custom cost codes with two (2) level, see Import Custom Cost Codes to a Company and Import Custom Cost Codes to a Project.
In Procore, cost codes structures that contain three (3) or more levels are referred to as multi-level. To learn how to import multi-level cost codes, you have these options:
- To import codes to the Company level Admin Tool, see Import Multi-Level Cost Codes to the Company Admin Tool.
- To import codes to the Project level Admin Tool, see the Steps below.
Cost Code Structure
Procore customers create varied cost code structures to use for budget and cost accounting. The specific cost code structure that your company chooses to use in Procore will depend upon your company's specific accounting methods, practices, and requirements. Procore's cost code structure supports up to five (5) levels. However, most customers choose a two (2) or three (3) level structure for simplicity. The table below shows some commonly used terminology that corresponds to Procore's supported cost code levels.
|Procore (2 Level Template)||Procore (3-5 Level Templates)||CSI MasterFormat||Project Accounting|
|Division||Cost Code Level 1||Division||Project|
|Cost Code||Cost Code Level 2||Subdivision||Subsidiary|
|Unused||Cost Code Level 3||Section||Work Breakdown Structure (WBS)|
|Unused||Cost Code Level 4||Subsection||Actual Work Activities|
|Unused||Cost Code Level 5||Subsection||Labor, Equipment, Material (LEM)|
Things to Consider
- Required User Permissions:
- 'Admin' level permission on the Project level Admin tool.
- Cost Code Structure:
- Procore supports up to five (5) cost code levels.
Important! In order to support a cost cost structure three (3) or more levels, the Project level Budget tool must also be configured to use the (Multi-Level) Procore Standard Budget view. This is instead of the Procore Standard Budget View.
- Procore supports up to five (5) cost code levels.
- CSI Master Format:
- Procore's default standard cost code list consists of 17-divisions. See What are Procore's default cost codes?
- CSV File Requirements:
- For general formatting considerations, see How do I prepare my data for import into Procore?
- The XLSX file must be formatted as a table.
- The first line of the table must include the header, which defines the fields in the table.
- The table in cost code import template must contain the following header row:
- Three (3) Level: Cost Code Level 1, Cost Code Level 2, Cost Code Level 3, and Description.
- Four (4) Level: Cost Code Level 1, Cost Code Level 2, Cost Code Level 3, Cost Code Level 4, and Description.
- Five (5) Level: Cost Code Level 1, Cost Code Level 2, Cost Code Level 3, Cost Code Level 4, Cost Code Level 5, and Description.
- Additional Information:
- Typically, most companies use a two (2) level structure. To learn more and to download a template, see Import Two-Level Cost Codes to a Company and Import Two-Level Cost Codes to a Project.
- Many companies also choose to work with a three (3) level structure. Less commonly, Procore customers do choose to use more complex four (4), or five (5) level structures. Typically, these are only when there are specific company or project reporting requirements.
- If you want to import a multi-level cost code to the Project level Admin tool for use on a single project, see Import Multi-Level Cost Codes to the Project Admin Tool.
Complete the following steps in the order below:
- Set Up a Multi-Level Budget View
- Download a Multi-Level Import Template
- Update the Multi-Level Import Template
- Request a Multi-Level Cost Code Import
- Perform the Multi-Level Cost Code Import
- Validate the Multi-Level Cost Code Import
Set Up a Multi-Level Budget View
If you will be using a cost code structure with three (3) or more cost cod levels on one (1) or more projects in your company's Procore account, you'll need to set up a Budget View for those project(s) at the Company level.
- Navigate to the Company level Admin tool.
This reveals the Company Settings page.
- Under Tool Settings, click Budget.
This reveals the Budget Views page.
- Click Set Up New Budget View.
This reveals the Setup Budget View window.
- Under Standard Views, click (Multi-Level) Procore Standard Budget.
On the right side of the Set Up New Budget View window, note that each Cost Code Level in Procore has a corresponding Column Name.
- Click Create.
This creates the new budget view. You can now name, configure, and adjust the columns in your new view as desired.
Important! If your company has enabled the Company level ERP Integrations tool and if you are planning to use the (Multi-Level) Procore Standard Budget view on projects that will be syncing data with a integrated ERP system, you will also need to update the Direct Cost and Job To Date columns. See How do I create a direct cost column on a configurable budget for ERP-Integrated projects?
To learn more detailed information about budget views, see these topics:
Download a Multi-Level Import Template
To create cost code structure for use with your company account or a Procore project, you must always download and completely fill out one of Procore's cost code import templates below. Note: Procore's import templates are designed for use with Microsoft Excel. For best results, it is recommended that you only update these templates with Microsoft Excel and avoid using other spreadsheet programs (e.g., Google Sheets, Smartsheets, and so on).
|If you are using this multi-level cost cost structure…||Download this template…|
|Cost Code Level 3||import-cost-codes-three-level.xlsx|
|Cost Code Level 4||import-cost-codes-four-level.xlsx|
|Cost Code Level 5||import-cost-codes-five-level.xlsx|
Note: To obtain the two (2) level import template and instructions, see Import Two-Level Cost Codes to the Company Admin Tool and Import Two-Level Cost Codes to the Project Admin Tool.
Update the Multi-Level Import Template
To update the multi-level import template, do the following:
Request a Multi-Level Cost Code Import
After you update the template, include it in your request. To request a multi-level cost code import for a project, you must have 'Admin' level permission on the Project level Admin tool.
- Send an email to email@example.com.
- Attach the completed cost code import template to your email message.
- When your request is received, your Procore point of contact will ask you to ensure:
- You have defined the number of levels in your company's cost code structure.
- You have downloaded the appropriate cost code import template.
Note: Depending on the number of levels in your company's or project's cost code structure, you will need to download the appropriate cost code import template and follow the appropriate instructions. See Import Cost Codes to Procore.
- You have updated the cost code import template and your data is prepared and formatted in compliance with the import requirements.
- When the import requirements above are met, your Procore point of contact will perform the import process for you.
Perform the Multi-Level Cost Code Import
After your request is received, a member of the Procore Imports Team will verify that your completed import template meets the formatting and data requirements. After the import template is accepted for processing, Procore will perform the import for you. This process can take up to 72 hours. You will be notified when the import is complete, so you can validate the imported data. See Validate the Multi-Level Cost Code Import.
Validate the Multi-Level Cost Code Import
- Navigate to the company's or project's Admin tool.
- In the right pane, click the Cost Codes link.
- In the page that appears, validate that the imported cost code structure displays as expected.
As shown in the illustrations below, cost codes imported at the company level appear in the left side of the page in the Admin tool, while cost codes imported at the project level appear in the right side of the page.
Company Level Admin Tool: After a Cost Code Import
Project Level Admin Tool: After a Cost Code Import