Capital Planning Table
Background
The Capital Planning table provides a centralized view of both active and concept projects, organized in a hierarchy of programs. This tool allows you to manage high-level budgets, track project stages, and forecast spending across your entire portfolio.
Things to Consider
Required User Permissions:
'Standard' or 'Admin' level permissions on the Company level Capital Planning tool.
Additional Information:
The table displays projects in all stages from Concept through Course of Construction. Closed, archived, and inactive projects do not appear.
To view or edit data, ensure you have the appropriate Standard or Admin level permissions on the Company level Home page.
The Remaining to Spread column is automatically calculated using the following formula:
$ Planned Amount - $Job to Date Costs - $Sum of Future Monthly Forecasts.All budget values are displayed in Arabic numerals. Negative values are indicated by parentheses. For example, $10,000.00.
Prerequisites
Navigate to the Capital Planning company-level menu item located under Financial Management in the Procore menu.
Steps
Set a Planned Amount
Locate the project row you want to modify.
Click the Planned Amount cell.
Enter the budget value.
Active Projects: If no amount is set, Procore defaults to the Revised Budget from the project's Budget tool.
Concept Projects: If no amount is set, Procore defaults to the Estimated Budget from the Project Admin tool.
Programs: Each program rolls up the project budgets beneath it, and higher-tier programs roll up the budgets of every program below them.
Create Detailed Budget Line Items
Click the Planned Amount for a specific project.
Select High Level Budget Items.
Add line items. For example, Hard Costs, Soft Costs.
Choose one of the following methods to enter values:
Enter a lump sum amount.
OREnter a quantity and unit cost to perform a unit-and-quantity calculation (quantity x unit cost).
Enter a %markup to perform a % calculation to add tax or contingency.
Click Save to update the total Planned Amount.
View Budget Data for Active Projects
Review the read-only columns pulled from the Procore Standard Budget View:
Original Budget
Revised Budget
Job to Date Costs
Estimated Cost at Completion
Forecast to Complete
Optional: To view how a column is calculated, hover over the column header to see a tooltip.
Optional: Click the Budget icon to open the project's Budget tool in a new window.
Enter Forecasts
Scroll to the desired year, quarter or month Forecast column.
Click into the cell for the specific year, quarter, or month and project you want to forecast.
Enter the forecasted spend amount.
The Remaining to spread column will update to show unallocated funds and automatically subtracts job-to-date costs and future monthly forecasts from the planned amount.
For example: <$ Planned Amount> - <$Job to Date Costs> - <$Sum of future Monthly Forecasts>.Program rows and the Grand Total row will roll up these forecasts automatically.
Yearly and quarterly forecasts are spread linearly across the month forecasts corresponding to each year or quarter.
Use the 'Configure' panel to turn on additional columns from your Procore Standard Budget View for comprehensive reporting.