Ga naar hoofdinhoud

Calculating a Plan

Once all planning data has been entered, the plan can be calculated.

This is done from the Calculate section in the Planning Module.

Here you determine:

  • Which data is included in the calculation.

  • The reporting period to be calculated.

  • Where the calculated results are stored.

Calculate Screen Layout

The Calculate screen consists of two sections:

  • Left side: Calculation settings.

  • Right side: Data selection, such as scenarios and Cost Centers.

This also allows you to calculate only part of a plan, for example when performing scenario analysis.

Explanation of the Fields

The numbered items on the screen have the following functions.

1. Start and End Year​

Select the planning period.

For example:

  • 2025 to 2025 - Single-year plan.

  • 2024 to 2027 - Multi-year plan.

2. Actuals Through Period​

Select the month up to which Actuals are used.

For example:

  • Through April - Actuals are used for January through April.

  • From May onward - Planning data is used.

3. Save to Dossier​

The calculated plan is saved to the selected dossier.

4. Dataset Assignment​

The calculation results are linked to a Dataset, making them available in reports.

5. Import Set Name​

Specify the name of the Import Set.

  • Checked - Enter a new Import Set name.

  • Unchecked - Use the existing Import Set.

6. Scenarios​

Select which scenarios should be included in the calculation.

Only the selected scenarios are processed.

7. Cost Centers​

Select the Cost Centers to include.

8. Projects​

Select the projects to include in the calculation.

9. Calculate​

Starts the calculation.

While the calculation is running, an animated indicator is displayed at the top of the screen.

If the indicator does not appear, the calculation has not started.

What Happens After the Calculation?

After the calculation is completed:

  • An Import Set is created.

  • A separate Import Set is stored for each year.

  • The Import Set is linked to the selected Dataset.

The calculated results are then available in reports.

Working with Multiple Calculations

Each calculation can be saved under a different name.

Keep in mind:

  • Every unique name creates a new Import Set.

  • This can quickly result in many different versions.

A practical approach is to:

  • Reuse the same Import Set name while developing the plan so it is overwritten.

  • Create a new Import Set only when the planning is final.

Using the Results in Reports

The calculated planning data becomes available in reports through the selected Dataset.

After making changes:

  • Recalculate the plan.

  • Refresh the report.

The latest figures will then be displayed.

Summary

Calculating a plan consists of:

  • Selecting the planning period (year and Actuals period).

  • Choosing the data to include, such as scenarios.

  • Specifying where the results should be stored.

  • Running the calculation.

The result is a complete financial forecast, including:

  • Profit and Loss Statement

  • Balance Sheet

  • Cash Flow Statement

Planning Module: Calculate NL

Planning Module: Reporting with Planning NL