How to set up a report in Cash Flow Forecast Premium

Reports will be based on completed forecasts. If there is no completed forecast, the report will be empty.

To set up a report from scratch, go to Reports and click Create Report.

There are template reports available to the right 

These reports have the same rows and time bucket as the submission template. It is a quick way of consolidating the figures into one currency and includingThese have the same rows and timebucket as the submission template. It is a quick way of consolidating the figures to one currency and include multiple Legal entities. Each Legal entitys figures will be consolidated to their home currency. 

To create a new report, click create Report

Start by giving the report a name and expanding the settings section.

Select the template that should be the base of the report. Select the Legal entities and currencies that should be included. 

The only mandatory fields are template, forecast date and time buckets. 

Note! For a subsidiary user, the report will only show the legal entity to which they have permission.

In the field Forecast Dates, type in the date for the forecast you want to include. You can also type in Latest if you want to always show the latest completed forecast. If you would like to see the latest two, please write Latest 2.

If you would like to consolidate the amounts to a certain currency, the default (if it is left blank) is to pick the rates from the Due date of the Forecast available in Treasury Systems, or you can pick a specific fx rate table.

Time buckets is where you design the time buckets you would like to see in the report. It does not have to be the same as in the template. The cash flows will be shown on their specific payment date and if an amount is entered for a specific time bucket it will be split evenly for the chosen time bucket. E.g. Monthly figure of 30 million will be split to 1 million per day. 

You can use different filters for the report. 

If the amount should be consolidated, a consolidation currency needs to be selected. It is also possible to select in which units the amounts should be presented.

The Actual Balances Is used if you would like to compare the forecast with actual imported balances from the bank accounts.

Press save

It is possible to add two graphs to the report. Select the graph type on the icon to the left and choose the content in the graph by clicking on the icon to the right. See marked in print screen below. 

In the pivot grid below, you can add more columns by clicking on the icon to the right (see below). You can also add a calculating field based on other columns to view the difference between 2 columns. 

The Icons in the top left are:    

1. Show grid
2. Show the date in a graph
3. Change sub totals
4. Change grand totals
5. Export data to CSV, Excel and PDF
6. Change the number format and add conditional formatting to highlight specific figures.