Skip to main content

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.

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
    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