Forecasting
The Forecasting module is an optional feature of Martus that allows you to project future budgets across multiple years.
Forecasting Module Basics
The Forecasting module is an optional, standalone feature of Martus that allows you to do three kinds of forecasts:
- Multi-Year Projection - Project future budgets across multiple years
- What-If Analysis - Compare multiple scenarios for possible changes to a full year's budget
- What-If Analysis by Month - Compare multiple scenarios for possible changes to the remaining months in a year
Features of forecasting include:
- The forecast of year-over-year changes to any budget within Martus is based on the dimensions, accounts, or account categories you select.
- Forecasts can be projected for the current year, or up to 9 years in the future – with the years shown side-by-side for easy comparison.
- You can add notes to explain future adjustments and assumptions, and quickly see the results in the form of impact to your bottom line.
- Results can be viewed in the same summary/detail views used throughout Martus. Results can also be exported to Excel.
Forecasts is a selection on the Planner menu. This feature is automatically available to Admin users. Permission to use this feature can also be assigned to any non-admin user, and they will only be able to see budget information and prepare forecasts for the dimensions to which the user has access.
Using the Forecasts List
When you select Forecasts from the Planner menu, you see a list of existing forecasts. The forecasts are listed for the current budget year. An Admin user can see all forecasts. A non-admin user can only see the forecasts that they have personally created.
You can take any of these steps on the Forecasts page:
- Click Add a New Forecast to create a new forecast
- Click Edit to view and change detail for a forecast, or to delete a forecast
- Click Results to proceed to the results report for a forecast
- Click Copy to create a copy of an existing forecast
Creating a New Forecast
When you create a new forecast, you specify a name. When choosing a name, remember that the name can be any length, but the on-screen display of the name is usually limited to 30 characters.
Define the configuration of the forecast with this information:
- number of years for the forecast (this is in addition to the budget year)
- dimensions, accounts, and account categories to use for forecasting
- the source budget (Admin users only); a forecast by a non-Admin user is always based on the default budget for the selected budget year*
*Note: Any budgeted amounts for Excluded accounts will NOT be included when creating a forecast. Use the steps below as a workaround:
- Open a tab in your browser with just the Excluded accounts showing. Then duplicate that tab and make the Excluded accounts not Excluded. Be careful not to do anything to the original tab.
- Create a Forecast from the budget desired, with all accounts now Included.
- Go back to the original tab, select all the accounts, and make them Excluded again.
Once you’ve created a forecast, you can’t change the configuration.
When you are adding a new forecast, click Preview once you’ve specified the configuration in order to see the Forecast Detail screen and enter the adjustments that will shape your projections for that forecast.
Forecast Detail
The Forecast Detail screen summarizes your budget based on the configuration of the forecast (the dimensions and account information that you have selected to show). You can filter the display and report on any of the dimensions that you’ve used in the configuration, but you can’t add or remove dimensions from the configuration.
You can delete any lines that you don’t want to consider in the Forecast, and you can add any lines that weren’t budgeted but that you want to include in your projections.
The Forecast has totals for each type of account (Income, Expense, Other Income, Other Expense, and Cost of Goods Sold). It also shows the impact of your projects for each account type and each year.
Examples of the Forecast Detail with Various Configurations
If you select only to show account category in your forecast, the Forecast Detail would look like this:
If you select to show departments and category, the display might look like this.
Filtering the Forecast Display
You can use the filters at the top of the screen to limit the display. This example illustrates a filter to a specific department.
This example illustrates a filter to a particular account category:
Manipulating the Lines in the Forecast
Adding Lines. You can add lines to the forecast, based on combinations of the dimensions and account information used in its configuration. In this example, the forecast configuration was based on department and account category, so you can select a combination of department and account category that is not presently listed on the forecast. You also must indicate the account type in order to determine the section of the forecast in which the new line will be added.
Deleting Lines. Use the checkbox on the far right to select lines to be deleted, then use the Delete button at the bottom right side of the screen to delete lines from the forecast.
Entering Projections and Notes for the Forecast
The check boxes on the Forecast Detail are a powerful tool for selecting the lines to update with your projections. The check boxes can:
- Select an entire column (all items for a year)
- Select an entire column for a type of account (such as income or expense)
Select all years for a specific line (all years in the forecast)
Once you select some lines to change, click the Adjust Selected button.
Specify whether the increase is flat or a percentage, then add any notes. If you are affecting multiple years and/or lines, the same note will be applied to all years and lines.
After you click Apply, all projections are calculated and displayed as the amount of the change (not as a percentage). Totals for the section are updated. If notes have been entered, you’ll see a bright blue paperclip icon.
If notes have not been entered, the paperclip icon is gray; you can click it to add notes for any specific adjustment.
After you’ve entered your projections, be sure to click Save at the bottom of the Forecast Detail!
Reviewing the Results of the Forecast
The Forecast Detail shows totals for each year, each account type, and overall. More reporting options are available on the Forecast Results page. To access this, you can either select Results from the Forecast List, or select Results from the bottom of the Forecast Detail.
Options for the Rows dropdown include Detail view and summaries by anything used in the configuration of this forecast. You can also limit the display to any dimension or the level of account information included in the configuration. Results can be exported to Excel in order to be printed, for distribution, or for further analysis.
