Profit & Loss and Balance Sheet

Setup your Profit & Loss Statement and Balance Sheet

Monitr allows you to tailor the Profit & loss statement and Balance sheet entirely to your needs. Go to tab 'Reporting' - 'Profit&Loss' and 'Balance Sheet'. This can either be done by using our industry specific templates, via a CSV upload or in the user interface (see below)

The Profit and Loss and Balance Sheet table contains 3 fields:

• Name: the label that will be shown in dahboards for this line of the report
• Cash flow: this is where you allocate the transactions of your Profit & Loss statement and your Balance sheet to your Cash flow statement. For more details go to this page.
• Top Level: 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 'Reporting' 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 report
• Name [string]: the label shown in the reporting
• Rank [integer]: defines the order in which the items are shown in the report
• Parent [string]: used to define subtotals in the reporting. Enter the ID of the parent.
• Report [string]: the report
• Top [1/0]: Used to indicate what lines should always appear as top level in the reporting (1: top level; 0: not top level)
• CF_ID [string]: this is the ID of the Cash Flow table. It is used to map your balance sheet and cash flow lines to the cash flow statement. Not all lines need to be mapped (e.g. bank will not be mapped)

You can only create a link from a line that is not the parent of another line, and to a line in the Cash flow statement that is not the parent of antorher line

Validation

Make sure these validations rules are respected:

ID needs to be unique
Rank needs to be an integer and unique for the report (BS or PL)
Parent any PartentID used should exist in ID
The value of Parent cannot be the same as ID
The Report of the Parent should be the same as the Report of the line itself
The Report needs to be BS or PL
Top is 0 or 1
A CF_ID should only be entered for lines without children (the ID of the line is not used in Parent) and to ID’s in the table Cash Flow without children

Upload your template

1. Make sure the status of all validation rules in the tabsheet 'Reporting' of the templat 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' - 'Profit & Loss' or 'Balance Sheet'.
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 reports, 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 Profit & Loss statement and Balance Sheet via the Monitr user interface:

1. Go to tab 'Reporting' - 'Profit&Loss' or 'Balance Sheet' depending on the report you want to create.
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 reporting line a name, and if required link it to a line in the Cash flow statement.
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 report 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

To change the ranking of a line in a report you can drag and drop the line you want to move.

Changing your reports

You can always change the stucture of your reports as discribed above. When you delete a line that has mappings linked to it or make this line a parent of another line, the mappings linked to this reporting line will be deleted.

When you have completed and saved the changes to your reporting, go to tab 'Mapping' to check if there are unmapped transactions and map these