Prepare Cost Codes for Import to the Procore Imports App
Objective
To properly format your cost codes for import.
Background
You can use the Procore Imports App to self-import your cost codes in bulk to your company's Admin tool. This will add as many cost codes to your company as you need without having to manually add each cost code in Procore. You can also use the Procore Imports app to update existing cost codes in your company's Procore account.
Things to Consider
- Required User Permissions:
- 'Admin' level permission on the company's Admin tool.
Note: Granular Permissions are not supported in the Procore Imports application.
- 'Admin' level permission on the company's Admin tool.
- Additional Information:
- The import process can be used to add or edit cost codes but cannot be used to delete any existing cost codes.
- This feature is only available to computers running Windows 7 or newer. See Install Procore Imports.
- Important! ERP integrated cost codes are not supported in the Procore Imports App. See Configure Cost Code Preferences for ERP Integrations.
Video
Steps
Download the Cost Codes Import Template
- Download the Cost Codes Import Template: import-cost-codes.xlsx
Format the Cost Codes Import Template
- See below considerations when filling out the template.
- XLSX or CSV File Requirements:
- For general formatting considerations, see How do I prepare my data for import into Procore?
- The XLSX or CSV 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:
- Two (2) Level: Cost Code Level 1, Cost Code Level 2, and Description.
- 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.
- Cost Code Structure:
- Procore supports up to five (5) cost code levels.
Important! In order to support a cost code structure of three (3) or more levels, the Project level Budget tool must also be configured to use the (Multi-Level) Procore Standard Budget view, instead of the Procore Standard Budget View. See Set Up a Multi-Level Budget View.
- Procore supports up to five (5) cost code levels.
- XLSX or CSV File Requirements:
- Complete the import template.
Tip
You can also add cost codes to an existing division or update existing divisions or cost codes in your company's Procore account using the Procore Imports app. Enter the necessary existing information in the template file following the instructions below and then update the applicable information based on the changes you want to make to your company's cost codes in Procore. When you import your completed template file, the Procore Imports app will ask you to confirm the changes to be made that will affect any existing data.-
To add a Level 1 Cost Code
- Enter a value in the Cost Code Level 1 cell only.
- Leave all other Cost Code Level cells blank (for example, levels 2-5).
- Enter a value in the Description cell.
- Repeat steps 1-3 until all your cost codes are entered.
-
To add a Level 2 Cost Code
- Enter a value and a Description in the Cost Code Level 1 cell. Leave the remaining cells blank (e.g., levels 2-5).
Note: This becomes the Division in Procore. - In the next row, complete the following:
Note: This becomes the cost code in Procore.- Enter the same Cost Code Level 1 value.
- Enter a value in the Cost Code Level 2 cell.
- Leave the remaining Cost Code Level cells blank (e.g., levels 3-5).
- Enter a value in the Description cell.
- Repeat step 2 until you have all your cost codes entered for that Cost Code Level 2 set.
- If you want to create an additional Cost Code Level 2 set (Division and Cost Codes), repeat steps 1-3.
- Enter a value and a Description in the Cost Code Level 1 cell. Leave the remaining cells blank (e.g., levels 2-5).
-
To add a Level 3 Cost Code
- Enter a value and a Description in the Cost Code Level 1 cell. Leave the remaining cells blank (e.g., levels 2-5).
Note: This becomes the Division in Procore. - In the next row, complete the following:
Note: This becomes the Sub-Division in Procore.- Enter the same Cost Code Level 1 value.
- Enter a value in the Cost Code Level 2 cell.
- Leave the remaining Cost Code Level cells blank (e.g., levels 3-5).
- Enter a value in the Description cell.
- In the row after, complete the following:
Note: This becomes the Cost Code in Procore.- Enter the same Cost Code Level 1 and Cost Code Level 2 values.
- Enter a value in the Cost Code Level 3 cell.
- Leave the remaining Cost Code Level cells blank (e.g., levels 4-5).
- Enter a value in the Description cell.
- Repeat step 3 until you have all your cost codes entered for that Cost Code Level 3 set.
- If you want to create an additional Cost Code Level 3 set (Division, Sub-Division, and Cost Codes), repeat steps 1-3.
- Enter a value and a Description in the Cost Code Level 1 cell. Leave the remaining cells blank (e.g., levels 2-5).
-
To add a Level 4 Cost Code
- Enter a value and a Description in the Cost Code Level 1 cell. Leave the remaining cells blank (e.g., levels 2-5).
Note: This becomes the Division in Procore. - In the next row, complete the following:
Note: This becomes a Sub-Division in Procore.- Enter the same Cost Code Level 1 value.
- Enter a value in the Cost Code Level 2 cell.
- Leave the remaining Cost Code Level cells blank (e.g., levels 3-5).
- Enter a value in the Description cell.
- In the row after, complete the following:
Note: This becomes the second Sub-Division in Procore.- Enter the same Cost Code Level 1 and Cost Code Level 2 values.
- Enter a value in the Cost Code Level 3 cell.
- Leave the remaining Cost Code Level cells blank (e.g., levels 4-5).
- Enter a value in the Description cell.
- In the next row, complete the following:
Note: This becomes the Cost Code in Procore.- Enter the same Cost Code Level 1, Cost Code Level 2, and Cost Code Level 3 values.
- Enter a value in the Cost Code Level 4 cell.
- Leave the remaining Cost Code Level cell blank (e.g., 5)
- Enter a value in the Description cell.
- Repeat step 4 until you have all your cost codes entered for that Cost Code Level 4 set.
- If you want to create an additional Cost Code Level 4 set (Division, Sub-Division 1, Sub-Division 2, and Cost Codes), repeat steps 1-4.
- Enter a value and a Description in the Cost Code Level 1 cell. Leave the remaining cells blank (e.g., levels 2-5).
-
To add a Level 5 Cost Code
- Enter a value and a Description in the Cost Code Level 1 cell. Leave the remaining cells blank (e.g., levels 2-5).
Note: This becomes the Division in Procore. - In the next row, complete the following:
Note: This becomes the Sub-Division in Procore.- Enter the same Cost Code Level 1 value.
- Enter a value in the Cost Code Level 2 cell.
- Leave the remaining Cost Code Level cells blank (e.g., levels 3-5).
- Enter a value in the Description cell.
- In the row after, complete the following:
Note: This becomes the second Sub-Division in Procore.- Enter the same Cost Code Level 1 and Cost Code Level 2 values.
- Enter a value in the Cost Code Level 3 cell.
- Leave the remaining Cost Code Level cells blank (e.g., levels 4-5).
- Enter a value in the Description cell.
- In the next row, complete the following:
Note: This becomes the third Sub-Division in Procore.- Enter the same Cost Code Level 1, Cost Code Level 2, and Cost Code Level 3 values.
- Enter a value in the Cost Code Level 4 cell.
- Leave the remaining Cost Code Level cell blank (e.g., 5)
- Enter a value in the Description cell.
- In the row after, complete the following:
Note: This becomes the Cost Code in Procore.- Enter the same Cost Code Level 1, Cost Code Level 2, Cost Code Level 3, and Cost Code Level 4 values.
- Enter a value in the Cost Code Level 5 cell.
- Enter a value in the Description cell.
- Repeat step 5 until you have all your cost codes entered for that Cost Code Level 5 set.
- If you want to create an additional Cost Code Level 5 set (Division, Sub-Division 1, Sub-Division 2, Sub-Division 3, and Cost Codes), repeat steps 1-5.
- Enter a value and a Description in the Cost Code Level 1 cell. Leave the remaining cells blank (e.g., levels 2-5).
-