Joiin Help Centre

Joiin provides a standard Cashflow report which is based on the Indirect method and starts with Net Income. You can customise the standard Cashflow Report in many ways. For example, you can change it so that the first row is net profit/loss before tax (operating profit) instead of net income. For general information on how to edit custom reports see our Custom Reports Article. To customise a Cashflow report:

Firstly, create a new custom Cashflow report - this can be done in one of two ways. Either:

• Click on Custom Reports in the left menu.
• Click on the Add report button and select Cashflow

Alternatively:

• Click on Cashflow on the left menu to run the standard Cashflow report - if necessary, select filters to run the report as required.
• Click on the Create Custom Report button.

A new custom Cashflow report will be created. This report consists of hidden groups and formulas from the P&L, such as Revenue and Gross Profit, followed by the visible sections from the Cashflow report, such as Operating Activities and Cash at Start of Period.

TIP: Make sure you have the Show hidden elements toggle selected to see all report elements.

The P&L Net Income group contains the Net Income formula which is calculated from the other P&L groups/formulas (Operating Profit + Other Profit). 

This then is used in the Net Cash formula to derive the Net Cash for the Cashflow report.

You can change either of these formula to use different values from the P&L as required for your reporting purposes.

So, for example, to use Operating Profit instead of Net Profit as your starting point, you could change the Net Cash formula as follows.

• Click on the Net Cash group to bring up the formula edit pane on the right.

• Change the first Operand from Net Income to Operating Profit (which is an existing formula in the P&L).
• Click on Accept.
• Click on Save at the top.

Your Net Cash formula now is made up from Operating Profit rather than Net Income.

When you run your custom report, the Net Cash, and all the other sections that follow on from this, will reflect the change.

You can tidy things up further, should you wish, by hiding the Net Income group and making Operating Profit visible. To do this, click on the Show/Hide button on the P&L Net Income group.

Then click on the Show/hide button on the Operating Profit formula to make it visible.

Remember to click Save once you've made these changes.

For more information on how to edit custom reports see our Custom Reports Article.