NOTE: This article refers to Layouts which are only available in the latest version of Joiin. Layouts replace Custom Reports in the latest version - if you're on the old version you may want to look at this article.


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 report layouts see our Report Layouts article. To customise a Cashflow report:


Firstly, create or edit a custom Cashflow layout - this can be done in one of two ways. Either:


  • Click on the top right Settings Cog
  • Select Layouts from the drop down menu
  • Click the Name of a Report Layout to open the editing page


Alternatively:


  • Run a Cashflow report via the left side toolbar
  • Click on the Report Layouts box
  • Select Create or Edit


 


A new custom Cashflow layout 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 layout, 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 report layouts see our Report Layouts article.