Skip to Content
User Experience Insights
Author's profile photo Dirk Pelz

Calculating Net Movements for your Cashflow in SAP Analytics Cloud

Managing your cash flow is critical to ensuring that you have sufficient funds.

If you’re familiar with the cash flow concept, you know that an increase in receivables is actually a bad thing because it’s negative cash flow. You’ve sold it, but you haven’t collected the money yet, and that’s the key element of cash flow, because only when you collect the money you have an inflow of funds.

With SAP Analytics Cloud, you can easily create a sales forecast on customers, products. This sales forecast can then be taken to calculate net movements for cash flow, taking into account the payment terms of each customer (or group of customers). In addition, a controlling and steering of the DSO (Days Sales Outstanding and Days Payables Outstanding) in the forecast is possible too.

I would like to explain this in the following examples in SAP Anayltics Cloud.



Figure 1 shows the simplified result of a sales forecast.


The forecast can take place for example on customers, regions and products. The sales are taken over into the cash flow calculation.



Figure 2 shows a view of the numbers taken over from the sales forecast.


Figure 2 also shows the payment terms of the individual customers. These can be maintained in SAP Analytics Cloud and also used for planning. This would also allow a DSO that is not desired to be adjusted in planning.



Figure 3 shows the start of the calculation for Net Balance.


In SAP Analytics Cloud, calculations can be inserted and executed by a Data Action.



Figure 4 shows the result of the Net Movement calculation.


The red arrows in the picture show the shift of the sales to the month in which the payment will take place according to the payment terms of each customer.


At the top of the picture you can see the result of the cash flow as Net Movement.


This type of application and calculations are easy to create in SAP Analytics Cloud with standard functions.


Many thanks for your interest in the topic and I hope you like it. Please share your feedback in the comments and let me know if you have any questions.


Stay tuned and stay healthy,

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Vasileios Zarkadoulas
      Vasileios Zarkadoulas

      Hello Dirk,


      Very useful blog and well explained. Could you share more information about the Data Action which performs the calculations according to payment terms?


      Best Regards,

      Author's profile photo Dirk Pelz
      Dirk Pelz
      Blog Post Author

      Here is an extract how it could be calculated

      IF [d/DPE_Customer].[p/PayTerm] = 90 THEN
      DATA([d/DPE_Account] = "Collection") = RESULTLOOKUP([d/DPE_Account] = "New Receivables", [d/Date] = PREVIOUS(2,"MONTH"))


      The "Payterm" determines where to put the "Collection".