ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Cash Flow Mapping / Mapper


#1

Hi everyone,

I have a problem showing Cash Flow Report using Cashflow mapping and Cashflow mapper.

The report doesn’t show any of the mappings that I added. Thanks!


#2

What do you mean by mapping? Could you explain further so I can better assist you. Thanks.


#3

I just discovered this feature today as I continue on my “Quest for Value”. I still am learning to configure it properly and have the same problem as you do.

A properly configured Cash Flow Statement is one of the platforms (along with the balance sheet) from which robust finance metrics such as EVA™️ can be derived.

ERPNext has this new feature, where you specify which accounts and where they should be “added or subtracted” after the starting point of the cash flow: Net Income.

The poster boy for this is Depreciation Expense.

The idea is that Net Income already has Depreciation Expense removed from it, but this kind of expense is not related to a cash outlay.

First you need to create a Mapper, which will be the name on the line in the cash flow statement representing the value you want. This mapper has to be linked to the account / accounts you wish to include in the Custom Cash Flow Statement.

(I’m still unclear about how this works exactly, I have tried Expense, Liability accounts and have not seen the mapper in the Custom Cash Flow Statement)

Once you have created the mapper, you have to add it to one of the three Mappings as a child. In the case of a Depreciation Expense Mapper, you would add it to the Operations Mapping.
Clarification: Companies Traditionally have Cash Flow from operations, investing and financing.

Once the Mapper is added as a child to your chosen Mapping, you need to configure the Cash Flow report to show the custom data.

Accounts > Account settings
Select the “Use Custom Cash Flow Format” and Save

Now when you open your Cash flow Report, your changes should be shown! In my case, I am also not seeing anything, so I will troubleshoot and reply if I find a solution! I have double checked everything. Made sure the “Use Custom Cash Flow Format” is selected. I have deleted and re-created my mappers and mappings but no luck yet.