Creating a new forecast
Navigate to Setup > Forecast.
Use the Add forecast button top right to create a new forecast.
Change the Name of the forecast inline.
đĄ Use the duplicate icon on the right hand side to create a new version of your forecast. This way you can organise your forecasts that are related.
Update or delete an existing forecast
Use the pencil and garbage bin icon on the right to update the name or to delete an existing forecast.
Setting up a forecast
Populating a forecast
Step 1: Access your forecasts
Navigate to Setup > Forecast.
Create a new forecast or select your forecast from the list to go into the details page.
Step 2: Choose a structure for your Forecast
You can create forecasts tied to structures beyond the Default structure, allowing you to, for example, tailor budgets for specific business units, regions, or custom reporting views. You can additionally define the granularity (eg. mappings, GLAs, Cost centers) to forecast with a different level of detail.
â
Setup Instructions:
Create a Forecast:
Important Notes: đ¨
Structure updates impact forecasts: Changes or deletions made in Setup > Structure will directly affect associated forecasts.
Reporting Integration: To view forecasts tied to specific structures, ensure the correct structure is selected in the filter in Reporting.
Step 3: Populate Forecasts Per Entity
Choose an Entity
Use the dropdown in the top-right corner to select the entity for the forecast.
Select âAll entitiesâ to create a group-level forecast that covers the entire organization (this aligns with âAll entitiesâ selected in the Reporting filter).
Alternatively, choose an individual entity to populate forecasts specific to that entity.
Choose where to assign the forecast by using the entity dropdown in the top right corner
All entities: Applies to the entire group.
Individual entity: Populate forecasts for specific entities (e.g., FinStack X1, FinStack X2). Iterate over all entities to complete the consolidated forecast.
Populate forecast values:
Enter values manually by selecting a cell and typing.
Copy data row-by-row from a spreadsheet using Ctrl+C and Ctrl+V.
â
Use whole numbers only (negative valuesâe.g. for costsâare indicated by a minus sign).
đĄ You can populate both the Profit & Loss statement and the Balance sheet by selecting the tabs on the top left. The Cash flow statement forecast will automatically be derived from both those statements and the references configured in Setup > Mapping for the CFS.
Summing up forecasts
Step 4: Sum your forecasts (Optional)
After populating forecasts for individual entities, you can enable automatic group forecast calculation:
Notes
Forecast Hierarchy: Forecast mirror the structure of your P&L and Balance Sheet in Setup > Structure.
Dynamic Reporting: In Reporting, aggregated forecasts automatically display when multiple entities are selected in the entity filter.
Manual Entry Option: You can choose to manually populate the âAll entitiesâ forecast instead of using the Sum all entities functionality, if needed.
Selecting another timeframe
Use the calendar icon top right to limit the display to certain months, quarters, or years. Select the timeframe you would like to see, by first clicking on the starting month and next the ending month.
Importing and Exporting
Use the Import and Export button top right to download the sheet to your computer, make changes, and upload the sheet again. Either do a full upload or upload the periods you want to change. Periods that are not in the upload file will retain their previous values.