Cash Flow Analyzer
The Cash Flow Analyzer app is the central entity to analyze cash flows over days, weeks, months, quarters, or years for all bank accounts and liquidity items.
With the Cash Flow Analyzer, you can monitor the cash position and liquidity forecast in your company, and analyze the details with the following functions:
Use various dimensions and filters.
View hierarchical structures for bank account groups and liquidity items, with amounts for a specific time period.
View currency comparisons between display currency and transaction currency (or account currency).
Integrate dynamic data sources from memo records, payment orders, payment requests, and some of the source applications that are stored in One Exposure from Operations.
Switch between the balance view and delta (cash flows only) view.
Finally, the Cash Flow Analyzer gives you a combination of cash position details, liquidity forecast details, and actual cash flow functions.
The Cash Flow Analyzer is integrated with several other apps. Cash pool structures defined in the system can be used for analysis with this app. If you have identified the need for funds transfer, you can also navigate to the Make Bank Transfer app directly from the Cash Flow Analyzer app.
Further integration points are available with the Check Cash Flow Items app. Here, you can drill down to the single items that make up the balance shown on the Cash Flow Analyzer.
Using the Cash Flow Analyzer app, you can branch out to several other apps to find more details or further processing options for cash items.
One of the options within the Cash Flow Analyzer app is to display the individual cash flow items for the aggregated sum displayed. Select the item you require further information for and choose Display Cash Flow Items to find more details on the amount.
When using the integration from the Cash Flow Analyzer to display cash flow items, the system navigates to another app that shows the single items making up the total sum shown in the Cash Flow Analyzer.
To drill down further and view more information on a single item, choose the Details button on the right of each item. This brings you to the Check Cash Flow Items app, where the filters are already populated to show the information required.
You can also use the Check Cash Flow Items app to analyze cash flow item details after you check the liquidity forecast and cash position reports. You can track and trace all the cash flow items from different source applications that are integrated with cash management.
You can also see line item details of the original documents, such as journal entries, banks and account assignments. This provides you with a comprehensive overview of the cash flow and liquidity status in your company.
Depending on the role to which you are assigned, you can perform the following tasks:
Display a list of the aggregated cash flows from various source applications, such as confirmed payments and bank statements, and so on.
Filter cash flow items by various filter dimensions, such as company code, bank account, grouping and summarization terms, and so on.
Monitor payment statuses of payment batches in Bank Communication Management (BCM).
Check the original document information from source applications.
Navigate to the source applications of the original documents, such as bank statements, sales orders, scheduling agreements, and so on.
Manually adjust the account assignments, such as liquidity item, transaction amount, cost center, and so on.
Navigate from cash position and liquidity forecast to check the line item details.
Share payment details and other information by email.
This function only works for cash flows from accounting documents (journal entries).
With this app Manage Liquidity Item Transfer, you can process life-cycles of liquidity item transfer documents like Create, Change, Copy, and Delete. You can directly create and transfer liquidity items in this app, or create the liquidity item transfer in the Cash Flow Analyzer app.
When the liquidity item transfer is created, all the items will generate actual One Exposure flows. During the liquidity item transfer, the original liquidity items will not necessarily be changed, and the shifts between liquidity items will be documented.
You can use this app to do the following:
- Create new liquidity item transfer.
Specify the necessary information on the transfer data and line item to create new liquidity item transfer. Company Code and Transfer Currency are mandatory header fields. You need to specify at least two line items with Liquidity Item, Amount, and Value Date. Total balance for the transfer must be zero. You can add more fields in the line item using the Settings function.
- Copy existing liquidity item transfer
- Edit liquidity item transfer
Company Code and Transfer Currency cannot be edited
- Delete liquidity item transfer
Liquidity item transfer with the status Invalidated cannot be deleted
The Manage Liquidity Item Transfer app is integrated with the Blocked Date Range feature.
Another possibility to create a Liquidity Item Transfer is from the app Check Cash Flow Items. The app links allow you to create a transfer from the selected liquidity item.
After the saving of the entries during the liquidity item transfer, it could be viewed in the Cash Flow Analyzer and Check Cash Flow Items apps.
Another feature is to display the report in bank account groups hierarchy and liquidity item hierarchy. The bank account groups are defined in the Manage Bank Accounts app.
The result is displayed in the Cash Flow Analyzer according to the individual structure that was defined in the bank account group. In this way, the user can, for example, check their area of responsibility. They could also cluster the information in relation to countries or mirror the external structure of the bank accounts.
The data presented in the app can be used to give a high-level overview and detailed insight into the cash flow status to management. Using this flexible setup, the Cash Flow Analyzer only shows the required information without the need to manually calculate subtotals.
The Cash Flow Analyzer app comes with three predefined variants. As the Cash Flow Analyzer app provides functionality in terms of the cash position details, liquidity forecast, and the actual cash flow for all of these scenarios, a variant is shipped.
These variants in the Cash Flow Analyzer enable you to display the cash position, liquidity forecast, and actual cash flows with more organizational units, in addition to the company code. Additional organizational units are as follows:
Depending on which certainty level is set in the Cash Flow Analyzer app, a different set of information is presented.
The certainty level describes the reliability, and therefore, the likelihood of a flow in One Exposure. The certainty level ACTUAL is the most reliable one and is used to represent a fact, which means an event that has happened.
Good examples for actual cash flows that happened would be accounting line items from bank statements or accounting line items with G/L accounts representing cash.
If the Actual Cash Flows variant is picked, only this subset of information is considered for the output.
The Cash Position Details variant contains the certainty levels that make up the cash position of the day. These include actual cash flows, self-initiated cash in transit, or values from distributed cash management. When you choose the cash position variant, all of the required certainty levels are preset.
If the certainty level field is blank, this means that the liquidity forecast is output. All of the information from different sources, for example, finance, material management, or sales, is taken into account when calculating the liquidity forecast.
In SAP S/4HANA Cloud, cash management allows the end user to check cash flows with a historical version. For example, the user can check the cash position with a defined historical timestamp so that he or she can understand what have been forecasted in cash position at that point of time.
The Cash Flow Analyzer and Check Cash Flow Items apps in SAP Fiori allow the end user to select historical time stamps in SAP S/4HANA Cloud. For all other processes and apps, the system always gets the current version of cash flows from One Exposure.
The Snapshot function is only supported in Advanced Cash Management, and by default, it is switched off. You can switch it on at any point in time in the Manage Your Solution app. Go to Configure Your Solution → Define Basic Settings.
However, after the system has created snapshot data, switch snapshot off again. You then need to follow the instructions to clean up snapshot data from all systems.
The following source applications can be integrated into One Exposure from Operations for real-time updates, and the transaction data can be used for the snapshot functionality:
In the Cash Flow Analyzer, in the Snapshot Time field, you can specify your desired snapshot time. On execution of the Cash Flow Analyzer report, it shows the information from that timestamp.
One Exposure always displays a new version when a change of cash flows is triggered by source applications.
In the example, a vendor invoice is logged to the FQM_Flow table at the time of creation. The invoice is then changed and a new entry is saved to the table.
When the payment run is performed, a new entry with the relevant timestamp is generated. In the last step, the bank statement, the information is updated once again.
You can also clean up or delete snapshot information from One Exposure if it is no longer required. For example, snapshot data that is one year and older. You can clean up the snapshot information with the Delete Data from One Exposure SAP Fiori app. Be aware that the data will be deleted physically and can not be rolled back.