Skip to main content
Procore

Use the "Forecast to Complete" Feature

Objective

To actively manage your budget over the lifetime of a project. 

Background

It's important to actively manage the budget to ensure that all cost projections are both accurate and consistent. It's common for the person in charge of managing a project's budget (e.g. Accountant or Project Manager) to provide a detailed report on a weekly/monthly basis that clearly accounts for all billable and projected costs where one of the key data metrics is explaining the forecasted total cost to completion.

One of the key features in the Budget tool is the "Forecast to Complete" column, which allows you to more accurately estimate the Projected Over/Under for each line item in the budget, so that the total estimated cost at completion is both accurate and consistent with previous weekly/monthly projections. You can either have the column automatically calculate the remaining costs based on the difference between "Projected Budget" and "Projected Costs" in order to maintain a net zero ($0) Over/Under value for each budget line item, or you can manually add items and amounts to define a more realistic forecasting number based upon key job insights.  Additionally, you can also record a helpful note that documents the reasoning for the forecasted value for each budget line item.

Things to Consider

  • Required User Permissions: 'Standard' or 'Admin' on the Budget tab
  • The "Forecast to Complete" column setting (manual or automatic) is configured on a per line item basis.
  • A lightning bolt icon () in the "Forecast to Complete" column denotes an automatic net zero calculation.
  • A forecasting note can be added to each line item and will be preserved if you switch from automatic to manual entry (or vice-versa).
  • If you switch from manual to automatic entry, all previously added items will be deleted.
  • An 'admin' user can configure the "Forecast to Complete" column to have an automatic net zero calculation under the Budget tool's configuration settings. However, this setting will only affect new line items that are added to the budget. 
  • Line items with a "?" will not allow a user to edit the Forecast to Complete. See "Add a Partial Budget Line Item" in the See Also section below.

Steps

Automatic Entry

Follow the steps below to the auto-populate the "Forecast to Complete" column with the difference between "Projected Budget" and "Projected Costs" in order to maintain a $0 Over/Under value for each line item.
 


 

  1. Click the hyperlinked value for a line item under the "Forecast to Complete" column.
  2. Select the "Automatically calculate $xxxx" option.
  3. (Optional) Leave a descriptive note about the change.
  4. Click Update.
  5. View your changes on the budget. In the example above, you should see the lightning bolt icon next to the value in the "Forecast to Complete" column and a net zero "Projected Over/Under" value.

Manual Entry

Follow the steps below to manually create line items for the "Forecast to Complete" column.

  1. Click the hyperlinked value for a line item under the "Forecast to Complete" column.
  2. Select the "Manual Entry" option.
  3. Click the + Add new line item text link and the required information.
     


 

  • Description - Provide a helpful description about the new line item.
  • Quantity - Add a number.
  • Units - Add a unit label. This is an arbitrary value. (e.g. ls, lump sum, hr, hours, etc.)
  • Unit Cost - Add a per unit cost. (e.g. 100) (Default = 0)
  • Subtotal - Total cost of line item. (Units * Unit Cost)

Monitored Resources

Follow the steps below to forecast a line item with your monitored values. 

Monitored resources allows you to forecast projected costs based on resource rates and time by introducing resources, applying a time and date and adding a unit cost and utilization rate for resources within a cost code. Procore will automatically draw down the forecast to complete amount as time passes. 

  1. Click the hyperlinked value for a line item under the "Forecast to Complete" column.
  2. Select the "Monitored Resources" option. 
  3. Click Add new line item to add a new resource to the selected line item. 

    forecast-to-complete-9-26.png
    • Description: Enter in a Description for the new resource line item. Some examples include the following:
      • Project Manager Level 1, Level 2
      • Office Trailer Rental
      • Temporary Toilet Facilities
      • Temporary Storage Container Rental
    • Start Date: Select a Start Date for the resource line item.
    • End Date: Select an End Date for the resource line item.
    • Units Remaining: Under Units Remaining, select Week or Month. Procore will use today's date to automatically calculate the Units Remaining and continue to draw down the remaining amount at the end of each unit (week or month). 
    • Unit Cost: Enter in the Unit Cost associated with the resource line item. 
      • Utilization: Enter in the percent for Utilization to signify the amount of the resource that is utilized within the given duration of the line item.
        The Calculated Unit Cost, Forecast to Complete, and Planned column will populate based on what you've entered in the previous columns.
        • Calculated Unit Cost = Utilization Rate x Unit Cost
        • Forecast to Complete = Calculated Unit Cost x Units Remaining
        • Planned = Calculated Unit Cost x Total Units (based on the full duration calculated from Start to End Date).
          Note: You will not be able to pro-rate costs (e.g. 8 days=2 weeks, not 1.14 weeks).
  4. Click Done to save your changes and return to the main budget.
  5. (Optional) Leave a descriptive note about the change.
  6. Add more line items, as necessary.
  7. Click Update.
  8. View your changes on the budget.

See Also

  • Was this article helpful?