How to set up a Cash Flow Forecast Template

Step by step guide how to setup a template in the view Manage Template

Mandatory settings

1. Give the template a name
2. Select the entities that should be able to report on the template, in the drop-down list Subsidiaries
3. Select time buckets for the reporting it is possible to combine different timebuckets 
4. Select the currencies in which the reporting should be done. Select all currencies if the reporting should be done in the currencies in which the Subsidiaries have bank accounts. When the Subsidiaries submit the forecast, only the currencies in which they have bank accounts will be viable.
5. Select reporting unit, choose none if the reporting should be in actual numbers.
6. Select a reporting schedule. 
   1. Frequency – Select a frequency and interval. After the first forecast period set in 6b and 6c – the forecast settings will be rolled over to new dates depending on this selection.
   2. Time bucket start date. This sets the first forecast date. 
   3. Submission period - Start date and End date. This will be the first submission period for the first forecast date set in 6b. 

Optional Settings

1. Categories, if the forecast should be on a separate project, real estate or another category.
2. Exclude bank accounts, by default all bank account balances are imported to the forecast, tick the ones you would like to exclude some bank account e.g. fictious or escrow accounts. 
3. Balance Status. Select all if you would like all balances or pick the statuses that suit your purpose best.
4. Exclude Weekends, excludes Saturdays and Sundays in the template
5. Ignore overdue Forecasts, e.g. reporting daily, then an overdue forecast might not be relevant, so they are ignored and not shown as overdue forecasts.

Commercial rows

Add commercial rows that you would like to do your forecasting on

Nameit , give it a name, recommended is to use the same name as the tag name

Tag and map it to a forecast tag that is shown in the drop-down list. 

All tags that are labelled forecast tag and is a list tag will be shown in the drop-down list.

If there should be “sum” rows do NOT map it to a tag. 

Parent: If the row should be summed up, select the Summarizing row as a parent

Forecast Origin If the values should be rolled over the next period or not. E.g. imported values are normally not rolled over so then you should select Ignore.

+/- Default signs on reporting rows (not implemented yet)

You can group the template by currency and category. Default is always currency

Financial rows

In this tab you design which and how the financial flows should be shown in the reporting

Name, name of the row

Then you either select deal type or flow type

Internal /external if you only would like to see the external or internal cash flows.

You can group the template on external / internal and depending on rows selected deal types or flows 

Use the toggle switch to have a preview of the forecast, when satisfied the template should be published, in order for the subsidiaries to be able to view and start working on the forecast.