Spread Cash Flow Forecasts in Portfolio Financials and Capital Planning
Objective
To spread cash flows for a Cash Flow Forecast in Portfolio Financials and Capital Planning.
Background
Cash Flow Forecasting is a feature exclusive to the Capital Planning product in Procore that allows you to reforecast budgets as project costs and timelines change over time. The 'Spread' feature for Cash Flow Forecasting provides you with the ability to automatically spread (or generate) cash flows, rather than having to input values manually for all periods. There are four different methods available to choose for the spread: Straight Line, Bell Curve, Front Loaded and Back Loaded.
Things to Consider
- Required User Permissions:
- 'Full Access' to the project or higher.
- Additional Information:
- This feature requires the Capital Planning product added on to your organisation's account in Portfolio Financials. Please reach out to your Procore point of contact with any questions.
Steps
- Navigate to the Cost Tracker section of the Project Page.
- Click the Cash Flow tab.
- Click Edit Cash Flow.
- Click the vertical ellipsis icon for a line item and select Spread.
- Enter the following information in the 'Spread' window:
- Select Spreading Method: Click the forecasting option you want to use:
- Straight Line: An even spread of the Forecast to Complete Value over the selected timeline.
- Front-Weighted Curve: More is spent at the beginning of the selected timeline and less is spent near the end of the selected timeline.
- Back-Weighted Curve: Less is spent at the beginning of the selected timeline and more is spent near the end of the selected timeline.
- Bell Curve: A balanced spread, where less is spent at the beginning and end of the selected timeline, but more is spent in the middle.
- Select Date Range: Select a Start Month and End Month or enter the number of months in the Duration field.
- Amount to Spread: This section shows the spreadable amount, which is equal to the Budget minus (-) all past Actuals. The Forecast to Complete represents the costs that are expected to be incurred in the future, excluding any costs that have already been paid.
- Select Spreading Method: Click the forecasting option you want to use:
- Click Spread.
The values will spread automatically.Important
You can manually adjust values as needed after the automatic spread by clicking into the cells. However, other values in the row will NOT be automatically adjusted. - Click Publish to save this version of the Cash Flow and update the Capital Plan.
- Enter a name and explanation (optional) for the version.
- Click Publish.