Using multiple forecasts to create scenarios Follow

Within a single LivePlan company, you can create up to ten different forecast scenarios. You can use these forecasting scenarios in several ways. For example, you can create scenarios for your company's best, average, and worst-case scenarios. Or you can explore scenarios for adding staff, increasing marketing expenses, opening a new office, etc. You could even create scenarios for several divisions (or locations) of the same business.

With this feature, you can delete an unwanted forecast and start over with a new one if necessary.

Note: When you have multiple forecasts attached to one company, any change of start date or number of years of monthly detail will affect all the forecasts attached to the company. If you need to create two forecasts with different start dates, we recommend making a copy of the company instead.

This feature is available to LivePlan Premium users. To learn more about LivePlan Premium, please click here

Creating a new forecast scenario

When you set up a company, it will have one default forecast. To create a new forecast scenario, click on the forecast menu located near the top-left of your LivePlan window.

create scenario new.png

You can keep this original forecast as the only one in your company or create up to nine more scenarios.

There are three ways to create a new forecast scenario:

Scroll down for instructions on all three options.

 

Copying an existing forecast

You can create a new scenario using an existing forecast (within the same company) as the starting point:

  1. Click on the Forecast tab in the left sidebar and then click the Create Scenario button:
    create new scenario.png

  2. Choose Copy an existing scenario:
    copy existing scenario.png

  3. Select the scenario you want to copy:
    select scenario.png

  4. Name the new scenario and click Create Scenario:
    name scenario.png

  5. The scenario you just created will be selected as the active scenario, and it will appear at the top of the scenario selection menu:
    best case scenario.png

  6. To switch back to the Original scenario, click on the scenario selection menu to view a dropdown of your available scenarios:
    scenario selection menu.png
Note: The selected scenario will populate the Pitch financials, Forecast, Benchmarks, and Dashboard tabs. You can change the active scenario at any time.

 

Starting a new scenario from scratch

If you want to start with a clean slate, you can create a new scenario that is empty:

  1. Click on the Forecast tab in the left sidebar and then click the Create Scenario button:
    create_new_scenario.png

  2. Choose Start from scratch:
    scenario start from scratch.png

  3. Name the new scenario, then click Create Scenario:
    name_scenario.png

  4. The scenario you just created will be selected as the active scenario and appear at the top of the scenario selection menu. Once you enter data, this scenario will populate the Pitch financials, Forecast tables, financial statements, Benchmarks, and Dashboard.
    best_case_scenario.png

 

Creating a new scenario from your recent accounting data

If you use QuickBooks or Xero as your accounting solution, you can import your actuals into LivePlan. The most recent year of actuals can then be used to build a foundation for new scenarios automatically.

To use this feature, first, connect your LivePlan Dashboard to your QuickBooks Online or Xero account. Then, return to the Forecast tab and proceed through the steps below.

 

  1. Click the Create Scenario button:
    create_new_scenario.png

  2. Choose Use accounting data:
    Create new scenario from accounting data.png

    Note: If you have not yet connected LivePlan to your accounting solution, you will see the note pictured above. In this case, you can click the Go to the Dashboard link to complete the connection and then return to the Forecast tab to create a new scenario.

  3. If you have already connected LivePlan to your accounting solution, you will be prompted to name your new scenario. Click Create Scenario to complete the set-up:
    create new scenario final step.png
    Note: With the automated starting forecast feature, LivePlan uses the most recent year of accounting data to build a starting forecast. The definition of "most recent year of data" is based on the start date you've set for your forecast. If you've set your forecast to start in January 2023, for example, LivePlan will use accounting data from January - December 2022 to build your starting forecast.
    Suppose your forecast start date is set before the current month, and actual results are available for the current and/or prior months from your accounting provider. In that case, LivePlan will use actual results from any available months where it is available to build your starting forecast.

 

Switching to another forecast scenario

The active scenario for a company is shown at the top of the scenario selection menu. The numbers from the active scenario will populate all areas of your LivePlan company (the Pitch financials, Forecast tables, financial statements, Benchmarks, and Dashboard).

To switch the active scenario, click on the scenario selection menu, and choose a different scenario:
scenario_selection_menu.png

 

Comparing forecast scenarios

If you have multiple scenarios in your forecast, you will see a drop-down menu above your forecast chart:

 

2023-05-08_11-15-48.png

 

Select a scenario from the drop-down menu to compare it to your current forecast. The comparison forecast will plot out in the charts along with the data from your current forecast:

 

Select comparison scenario.gif

 

Mouse over any of the monthly or annual figures in the chart to view a detailed comparison:

compare scenario data.png

 

 

Changing the name of a scenario

  1. Mouse over the scenario you'd like to rename from the scenario menu (if it isn't already the active scenario).

  2. Then, choose Edit:
    edit scenario name.png

  3. In the overlay, edit the scenario's name, then click Create New Scenario:
    Name scenario.png

    Note: The name can be up to 60 characters long.

 

Deleting a scenario

At some point, you may discover that you no longer need one of the forecasts in your company. To delete a forecast, follow these steps. Please note: deletion is permanent, and a deleted forecast cannot be recovered.

  1. Select the scenario you'd like to delete from the menu, then choose Delete:
    Delete scenario.png

  2. Click Delete Scenario:
    Delete confirm.png


  3. If the deleted scenario is currently active, an overlay will appear, asking you to select another scenario to work on. Choose the desired scenario, and then click the Go to Scenario button:

    Select new scenario.png

 

Printing a plan with multiple forecast scenarios

When you have multiple forecasts attached to a plan, only one can be included in a download of the plan. You can activate any forecast scenarios before downloading the plan for printing.

LivePlan doesn't currently have functionality for including several forecasts in the same plan. If this option would be helpful to you, please contact us and let us know more about your needs.

Was this article helpful?
22 out of 27 found this helpful
Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.