The advanced forecasting import option is available in the 'Budget' tool under the 'Forecasting' tab. To enable this feature, join the Forecasting: Revenue Forecasting, Percents and Actuals-Aware Remaining beta program via Procore Explore.
Importing advanced forecasting for a budget allows project managers and financial teams to bulk import cash flow distribution curves and forecast periods directly into a project's Budget tool using an Excel template or file.
Instead of manually adding budget line items and configuring their forecast start dates, end dates, and distribution curves (such as Front-Loaded, Back-Loaded, Bell, Linear, or Manual) line-by-line in Procore, you can import this data to update multiple line items simultaneously.
Required User Permissions:
'Admin' level permissions on the project's Budget tool.
OR
'Read Only' or 'Standard' level permissions on the project's Budget tool with the 'Import Budget From File' and 'Create and Edit Original Budget Amount' granular permissions enabled on your permissions template.
If a user with 'Read Only' or 'Standard' permissions has only the 'Import Budget From File' granular permission enabled, they can only import a forecast. They cannot manually create or edit the forecast.
If a user with 'Read Only' or 'Standard' permissions has only the 'Create and Edit Original Budget Amount' granular permission enabled, they can only manually create or edit a forecast. They cannot import a forecast.
Prerequisites:
Supported Import File Type:
XLSX
Additional Information:
To create new line items, the import file must contain data in the following columns:
Cost Code
Cost Type
Start Date
End Date
Curve
To import multiple line items with the same cost code, each item MUST have a different cost type assignment. For example:
02-300 - Earthwork, M, $30,000
02-300 - Earthwork, L, $10,500
Do NOT edit, update, or change data in the 'Importer Data Fields' worksheet of the forecast import template. This worksheet is for reference only and shows the options that are available for selection in the drop-down lists on the 'Budget Line Items' tab. These options reflect what was available for selection on your Procore project when you downloaded the import template.
Limitations:
Exported Procore Forecast files are NOT supported. CSV and PDF export files contain additional data columns and cannot be used to re-import a forecast.
The forecast import template does NOT contain a 'Budget Code' column. Instead, Procore automatically creates budget codes on your project when you enter the cost code and cost type combination on your line items in the forecast import template. To learn more about budget codes, see What is a budget code in Procore's WBS?
To import data into Procore, the database requires a 'Description' column in the forecast import template. You can leave this field blank to use the default concatenated description in your company's Work Breakdown Structure, or you can enter a description to import a custom description. To learn more about the Description field, see Edit Budget Code Descriptions on a Project.
The maximum number of line items allowed for an individual forecast import is 500.
Procore recommends importing your forecast only once to prevent overwriting values in a project's forecast. If you need to import an updated forecast, keep the following points in mind:
All line items from the previously imported forecast will be included in the new forecast import template.
Importing an updated forecast will overwrite existing values for matching line items.
For assistance with an import, email: support@procore.com.
Navigate to the Project level Budget tool.
Select the Forecasting tab.
Select a forecasting view from the View drop-down list.
Click Import.
Click Download Excel Template.
The system downloads a copy of the Forecasting Import Template.xlsx file to your web browser's specified download location.
Always enter your forecast data in the Excel template that you downloaded from your Procore project.
Columns in the forecast import template do NOT match the columns in the forecast export file generated with the Export > CSV or Export > PDF menu options. Files from the 'Export' menu cannot be imported into the Budget tool.
Before proceeding with the import, review this important warning:
The forecast import template that you downloaded must be used for the import. In addition, the column layout and headings in the template are required:
DO NOT rename any column headings in the template.
DO NOT add, remove, or change the order of the data columns in the template.
If you plan to import budget line items with cost codes:
Every line item added to the forecast import template must include a cost code.
Cost codes in the forecast import template must exactly match the cost codes in your company's or project's Work Breakdown Structure.
Cost codes must be associated with at least one (1) cost type. See Add Company Cost Types and Assign Default Cost Types To Cost Codes. This ensures you can create budget codes when adding line items. See What is a budget code in Procore's WBS?
You can import one (1) budget line item per cost code/cost type combination. The purpose of a budget line item is to show the total budgeted amount for each budget code on a single line item. Duplicate cost code/cost type combinations are not permitted.
You do not need to delete line items with a blank Cost Type field from the forecast import file. If you keep these line items, Procore will not import any data or create line items for those rows in your forecast.
On your computer, open the downloaded Forecasting Import Template.xlsx file in Microsoft Excel.
Click the Budget Line Items worksheet.
Update the budget line item data on each row as follows:
An asterisk (*) below denotes a required field.
Some columns in the import template will require you to choose a value for your line items from a drop-down list.
Cost Code*. Choose the cost code from the drop-down list: 'Division-Code'. For example, 02-200. See What are Procore's default cost codes? and Add Company Cost Codes.
Cost Type*. Choose the cost type from the drop-down list. For example, L=Labor, E=Equipment, M=Materials, and so on. See What are Procore's default cost types? and Add Company Cost Types.
Description. Leave this field blank to use the default concatenated description in your company's Work Breakdown Structure. Enter a description to import a custom description. To learn more about the description field, see Edit Budget Code Descriptions on a Project.
Why leave the 'Description' field blank? In order to import data into Procore, the database requires the presence of a 'Description' column in the import template. However, because Procore automatically creates a 'Description' for you (after the import), it's important to always leave the data entry rows in the 'Description' column blank.
Start Date*. Enter a start date for the forecast curve that you want to apply.
End Date*. Enter an end date for the forecast curve that you want to apply.
Curve*. Enter the name of the forecast curve that you want to apply in the Forecasting tab of the project's Budget tool. To learn about your curve options, see Apply Advanced Forecasting Curves.
Save your changes.
Note: Always choose the Excel Workbook (.xlsx) file format when saving your data.
Navigate back to your project's Budget tool.
In the Excel File section, click Upload File or drag and drop the updated template.
In the window that appears, select your file. Then click Open.
Click Import.
Review the imported data in the project's Budget tool to verify that the line item data was imported as you expected.
Optional: If you want to edit your budget line items, you have these choices:
Manually add budget line items. See Add a Budget Line Item.
Remove any budget line items. See Delete a Budget Line Item.
Loading related articles...