Cash Flow

What is a Cash flow statement?

A Cash flow statement gives an overview of the sources and the use of funds for a certain period of time. You can create a Cash flow statement in two ways:

1. Direct Cash flow statement: allocating each transaction in your cash & bank to a category
2. Indirect Cash flow statement: calculated based on the transactions in your general ledger accounts (other then your cash & bank)

Monitr uses the indirect method to calculate the Cash flow. We will allocate transactions from the Profit & loss statement and the Balance sheet to categories in the Cash flow statement. Cash & Bank accounts and accounts that don't have a cash impact.

The Cash statement needs to be defined in order to create your Profit & loss statement and Balance sheet.

Setup a Cash flow statement

Monitr allows you to tailor the Cash flow statement entirely to your needs. Go to tab 'Reporting' - 'Cash Flow'. This can either be done via the user interface or by uploading a CSV file (see below).

The Cash Flow table contains two fields:

• Name: the label that will be shown in dashboards for this line of the cash flow
• Top: toggle this field on in order to indicate that this line should always be displayed as a top level line in your reporting.

Via User Interface

You can either upload a pre-defined template (such as this file) or use tabsheet 'Cash flow' our google sheets template to define your Cash flow statement.

Definition

Complete the folowing fields in the template

• ID [string]: a unique identifier for the line in your cash flow statement
• Name [string]: the label shown in the reporting
• Rank [integer]: defines the order in which the items are shown
• Parent [string]: used to define subtotals in the reporting. Enter the ID of the parent
• Top [1/0]: Used to indicate what lines should always appear as top level in the reporting (1: top level; 0: not top level)

Validation

Make sure these validations rules are respected:

ID needs to be unique
Name is not empty
Rank needs to be an integer and unique
Parent any ParentID used should exist in ID
The value of Parent cannot be the same as ID
Top is 0 or 1

Upload your template

1. Make sure the status of all validation rules in the tabsheet 'Cash flow' of the template is 'TRUE'.
2. Copy the definition (columns with a dark blue header) in to a csv file and save it on your computer.
3. Go to tab 'Reporting' - 'Cash Flow'.
4. Click
5. Browse to the CSV file on your computer and select and click 'Open'.
6. Click
7. If any errors occur they will be highlighted in red. Your report will not be saved.
8. Fix the errors and click untill the report is succelfully saved

If you want to make changes to your Cash flow statement, using our user interface click 'via user interface' above to get more information

Via CSV

The user interface to create a new report is split into two views.

1. Tree view: Shows you how the reporting lines are related to each other in the form of a tree.
2. Report View: Displays you how the report will be visualized in your dashboards, and will change based on the alterations you make in the tree view.

To create a Cash flow statement via de Monitr user interface:

1. Go to tab 'Reporting' - 'Cash Flow'.
2. Add rows by clicking ' insert row' which will add a new row at the top of the list.
3. Drag and drop it to the correct location. When dropping it on an other line, it will add it as a sibling of that line.
4. Give the cash flow reporting line a name
5. Set
   Top Level

   On
   to "On" if you would like to see it in the top of your report view.
6. Repeat this untill you have made the Cash flow statement you need
7. Click
8. If any errors occur they will be highlighted in red. Your report will not be saved.
9. Fix the errors and click untill the report is succelfully saved