Create Forecast, Budget, LRP

System Administrator creates a new base -copies data from the existing periods- for the forecast, budget and LRP. Period’s version is created one year at a time.

Create period

Forecast, Budget and LRP is created in the same way. Forecast is used, in the following example.

In the example the forecast lenght is current year (2020) +1. In addition to the main version, one additional forecast version is in use.

If the version entry is closed, its creation is disabled. If necessary open the entry in the version management.

../_images/createfctbud1.png

Base values

The forecast is created with the selected base values (data sources) for the desired companies. If necessary, it is possible to copy, previously defined account-to-account calculations, allocations, multiplications and currency rates, to the forecast version.

../_images/createfctbud2.png

Specifications -If the data source selected as a base for the version, contains specifications, but they need to be excluded form the version, the checkbox is clicked. Only unspecified sum of the account is included.

Entry forms -if entry forms are in use, choose if entry form bases are copied from the selected data source to the base. Entry forms is add-on, thus is not available on all systems.

Define data source(s) -period from which the data is copied to the version. Normally a base for a new forecast version, could be for instance, current year’s budget. If LRP is chosen as a data source, then the LRP year total is divided evenly for the forecast version’s months.

../_images/createfctbud3.png

It is possible to use one or two data sources, from which the data is copied.

Data source 1 -choose Data source 1, by clicking the period which data is copied. If data source 2 is not needed, move on to define company and cost centers.

Data source 2 -it is possible to copy data from two different data sources. For example, data from the beginning of the year is copied from current year’s budget (data source 1), and data for the rest of the year is copied from other period, starting from the selected month (data source 2).

Next the cost centers are selected.

Companies and cost centers

Cost centers which version is created

../_images/createfctbud4.png

Cost center selection is in tree structure. To open / close the tree press + / - sign. Choose desired entities. To select whole company with all cost centers, mark checkbox beside company level. Select individual cost center(s) by opening the tree structure.

Note

  • Forecast base is created one forecast year at a time. In case, rolling forecast is in use, create version for all needed forecast years.Rolling column models are explained in more detail in the chapter: Columns.

If needed, move on to copy, account-to-account steerings, allocations, multiplications or currency rates to the version.

The version can be created without copying. Press OK.

Accounts’ data type

Common data types are set as default, and it is recommended to use only them.

Default selections

Transferred data = saldo data via data transfer

Entry data = entered data

Voucher entry data =data entered using voucher entry

Vain erikoistapauksissa lisävalinnat (Muut datatyypit):

  • Calculated data = data which is calculated; account-to-account, price*quantity

  • Allocated data = allocated data

  • Payroll module data = data transferred from the payroll system (separate application)

  • Other transfer data (DAD) = tailored transfer data, using different file (DAD), than in normal saldo transfer.

  • Muu oma data = muu mahdollinen data, joka on räätälöity

../_images/createfctbud5.png

Account-to-account calculations, Allocations, Multiplications, Currencies

If needed, copy Account-to-account steerings, Allocations (including periods allocation table percentages, if any), Multiplications and Currencies (other than default €), from the selected data source, to the target year.

Huomaa, että Tililaskennat / Vyörytykset / Kertolaskut / Valuuttakurssit, kopioidaan tilikarttakohtaisesti kaikille kustannuspaikoille, myös niille, joita et ole valinnut ‘Kustannuspaikat’ välilehdellä. Jo tehdyt ylläpidot perustettavalle versiolle korvataan kaikilta kustannuspaikoilta, myös niiltä, joita et ole valinnut ‘Kustannuspaikat’ välilehdellä, mikäli ne käyttävät samaa tilikarttaa kuin valittu yritys.

If the the period has no values, it is disabled.

Option NO COPY, is default -no data is to be copied from the source.

Account-to-account calculations -select the time period, from which the data is copied.

../_images/createfctbud6.png

Allocations -select the time period, from which the allocations are copied.

../_images/createfctbud7.png

Multiplications -select the time period, from which the multiplications are copied.

../_images/createfctbud8.png

Currencies -select the time period, from which the currency entries is copied.

Valitulle jaksolle mahdollisesti käsinsyötetyt valuuttakurssit korvataan.

../_images/createfctbud9.png

Vahvista luonti valitsemalla OK

../_images/createfctbud10.png

Finalize the creation by choosing OK

../_images/createfctbud11.png

The forecast version is displayed, e.g. in browsing by selecting it from the forecast monthly columns. If the report has no data, run the version’s reports.

Ennusteversioiden dataa voi muokata samalla tavalla kuin, esimerkiksi budjettiversionkin. Toiminto on selitetty yksityiskohtaisemmin kappaleessa datan muokkaus.