Table of Contents

Cash

Applies to: img Planner 5 or later.

Overview

This report gives an insight to the cash simulation and is hence only applicable for plan dataset versions. 3 charts are used to show different degree of detail for cash development from simulating based on plan input on operation, loan, investments.

To use this report:

  1. Make selections and click Refresh-button to draw the report.
  2. Click on the legends below each graph section to toggle on/off individual graph objects.

img

  1. Top Section
    The top sections contain mainly filter choices including selection of which report to presented. The upper right "Forecast start" tells which calendar period the forecast start. Since this may be a rolling forecast this period will be updated as the forecast reach next period. "Data last updated" tells when the input was last simulated to generate the full ledger. This process is normally scheduled to run at certain intervals.

  2. Left Section
    The left section contains the Department filter and gives the ability to slice data according to an organization hierarchy.

  3. Cash Total - shows the total cash from opening balance, contribution from operation and financing activity (i.e. loans and investments).

  4. Cash from Operation - shows cash contribution from operating activities such as sales, purchase, payroll and expenses.

  5. Cash Detail - shows details for cash in and out such as vacation pay, VAT due, salary pay, etc. The Forecast dataset is input data only from the Forecast start period (as shown in the upper right in the report).

Filter Descriptions

Filter selections available apart from Department are:

  • Fiscal Year
    Select start year to look at data.
  • Month
    Select start month to look at data
  • Dataset
    Select a dataset that is a result from processing/simulation. Normally this would be Forecast or Budget.
  • Scenario
    Select scenario for selected dataset.
  • Currency
    Choose which currency to the used in the report. Average rate for each period is used for currency conversion.

Note that optional columns and filter under "Options" is not available for this report.

Graph Descriptions

For all graphs there are a "total cash" line that is sum of all bars. One exception to this is the Cash Total which also contains the opening balance. For a plan dataset (e.g. Forecast), the cash total line contains the aggregated cash from Actual dataset for periods before the forecast start period. All other lines and contributions are from simulations for plan dataset version from Forecast and Budget processes.

In general, for Actual data there will not be sufficient details from the General Ledger to show cash to this level of detail.

Note that you can click on the ledger to toggle on/off any of the graph elements. This can make it easier to see smaller value items since the graph rescale when large values is toggled off.

How to`s


Create new task

Edit this page