Within Futrli's Forecasting section you can view, create and edit Forecasts that have been created for any Organisation you have access to. In this guide, you'll find an overview of the Forecasting feature!
Within the top left of your Forecast, you'll find the name, length and the date range of your Forecast displayed. In the top right, your Forecast's view options, including the start date that data will display from and the reporting period (weekly, monthly, quarterly or annually):
You can change the name of your Forecast at any time. To do so, select the currently displayed name by clicking it. This will allow you to edit it as you wish. Simply enter your desired amendments before clicking the black tick to save your changes:
Forecast Date Range
The length and bounds of your Forecast can be seen displayed in the top left of your selected Forecast. The length and bounds of a Forecast can be changed using the forecasting method as explained in this Help Guide.
Report Start Date
In the top right of the window, you'll see which period the current view you have is starting from:
This is the date which dictates when information displays from. For example, if December 2018 is selected, we'll find that Forecast data displays from December 2018 onwards. You can change the start date at any time. To do so, click the calendar icon, a new window will display containing all selectable start dates. The currently selected start date will be highlighted in pink. You can select a new start date by clicking it:
Your Forecast data will display in accordance with your selected reporting period. This can be seen displayed in the top right of your Forecast and can be changed between daily, weekly, monthly or quarterly by hitting the drop down:
The order in which Account Categories and Formulas display within the 'Workings' tab of your Scenario will be dictated by your selected Layout. You can view your layout by clicking 'Edit Layout' on the Forecast control panel. All items will display in order based upon where they have been placed in the layout. To edit your layout, click 'Edit Layout':
You can reorder where items appear within your layout by dragging and dropping them into a new location:
To save changes click 'Confirm'.
Adding/Removing Items from the Layout
Removing a Row
To remove an Item from the layout click the x that appears adjacent to the line within the Edit Layout window. Clicking the x will remove the item from the layout.
Adding an Account
You can add an Account Category to your layout by searching in the search box, then selecting the item you'd like to add:
Adding a Formula
You can add formulas to your layout using the 'New Formula' button:
You can add a Saved formula from your Formula library, or create a new one from scratch by clicking' Formula Builder':
Hiding/Showing items with zero values
Within the 'Workings' tab of your Forecast, you can choose to hide or show Accounts, Formulas, Groups or Forecast items which contain all zero values for your selected reporting period. To do so, click the 'Hide/show rows' button in the control panel of your Forecast, then check or uncheck items you wish to hide with zero values:
Interacting with Data
Drilling into Transactional Movements
You can drill into each Account line to see the detail of your forecasted transactional movements within a period. To do so, click the period value for an Account line. In the example below we've clicked the period value for Double Rooms for December 2016. This reveals the transactional movements which we've forecasted for December for our Double Rooms line. Any Credits or Debits will be listed here chronologically by data:
Using the Scenario Graph
At the top of your Forecast you'll find the Forecast Graph. This offers a visual representation of your Actual and Forecast data in accordance with your selected view options:
Toggling the display of items on the graph
You can toggle items to display on your graph by selecting them from the Chart legend:
For example, you can select Net Income to appear on our Chart by selecting it from the Chart Legend:
To remove a selected item, simply click where it appears on the Chart Legend. This will hide it from the graph:
Searching for items
Using the Search bar in the top right of your Forecast you can search for Account Categories, Lines, Groups, Formulas and Forecasts within your Forecast.
To learn more about forecasting check out the rest of our help guides.