Create missing Procore budget codes while importing change events
Have you ever stopped a change event import halfway to add three budget codes to the project in Procore, then refreshed everything and started over?
Paste the lines, see every budget code the project doesn’t have yet, create them all in Procore in one step, then sync the change events.
To create missing Procore budget codes during a change event import, open the Sandspit extension in Excel, choose Create Change Events, and paste your lines onto the import sheet. Sandspit lists every budget code the project doesn’t have yet, with the cells that use it. Leave the codes checked, click Create, and they are added to the project in Procore. Then sync the change events.
Paste the change event lines into Excel
Open the Sandspit extension in Excel and choose Create Change Events. Paste your lines onto the Change Event Import sheet, one line item per row, with the budget code each line should land on.
Let Sandspit check the budget codes
The Bulk Import tab checks every budget code against the project. Codes the project doesn’t have yet are listed once each above the review, with links to the cells that use them, and those rows wait under Needs attention.
Note: only codes built from a real cost code and cost type on the project can be created. Anything else stays in the row review, where you map it to an existing budget code.
Choose which codes to create
Every listed code starts checked. Click a cell link to jump to the row that uses it, and clear the checkbox on any code you would rather map to an existing one.
Create them in Procore
Click Create, for example Create 3 budget codes. Sandspit adds the checked codes to the project in Procore in one step, updates the budget code columns on Picklists, and the rows that used them move to Ready to sync.
Note: creating a budget code adds it to the project WBS only. It does not add Original Budget line items.
Sync the change events
Click Sync. Each change event is created in Procore with all of its lines, on the budget codes you just added. Synced rows show Synced on the sheet.
Why missing codes stop an import
Every change event line in Procore sits on a budget code that exists on the project. Scope that is new to the job, like door hardware on a tenant fit-out, often needs a code the project was never set up with. The usual fix is to leave the import, add each code in Procore, refresh, and come back to finish.
What changes in Excel
- Listed once. Each missing code shows once, however many rows use it, with links to those cells.
- Created together. One Create adds every checked code to the project in Procore.
- Ready to sync. The flags clear and the new codes are in your Picklists, so the import carries on.
Frequently asked
Which budget codes can Sandspit create?
A code that combines a cost code and cost type the project already has, but that isn’t a budget code on the project yet. A typo or a cost code that isn’t on the project can’t be created; map that row to an existing budget code instead.
Does creating a budget code add it to the budget?
No. The code is added to the project so change event lines can use it, but no Original Budget line items are created. To add budget lines, use the Original Budget module.
How many codes can I create at once?
Up to 500 unique budget codes per Create, from up to 10 Sub Jobs. A code used on several rows is listed and created once.
What happens to my Picklists?
Only the budget code columns on the Picklists sheet are updated with the new codes, so the dropdowns offer them right away. The other picklists and the original pull time are left as they were.
Why can’t I create budget codes?
Budget code creation can be turned off for your company. When it is, Sandspit says so, and you can still map each row to an existing budget code. Procore also applies your own permissions when the codes are created.
Does this work for vendors too?
Yes, but one at a time. Missing vendors are listed in the same place, each with its own Create action.
Procore Project Financials. Needs Standard or Admin on the Change Events tool. Adds budget codes to the project WBS, up to 500 at a time; it does not add Original Budget line items.
Step-by-step mechanics, every column, and every error message are in the documentation.
0:50 Pull Procore data into Excel for custom reports
Have you ever rebuilt the same cost report from a fresh Procore export every Monday morning?
0:32 Compare a Procore budget to last month’s snapshot in Excel
Have you ever exported the Procore budget at month end, pasted it beside last month’s, and remapped the columns just to see what moved?