Liquidity Analysis 

Use

This section shows you the overall liquidity status of your company by displaying together the cash position and the liquidity forecast.

The cash position is used in Cash Management to show the value-date-dependent bank accounts and bank clearing accounts, as well as the planned cash flows (payment advice notes). The liquidity forecast comprises the incoming and outgoing cash flows, as well as the planned items on the sub-ledger accounts.

Procedure

  1. Call up the transaction as follows:
    2.

    Menu Path

    Accounting ® Treasury ® Cash Management ® Information System ® Reports for Cash Management ® Liquidity Analyses ® Liquidity Forecast

    Transaction Code

    FF7B

  2. Enter the following data:
    3.

    Field

    Data

    Company code

    1000

    Grouping

    Total

    Display as of

    Today’s date

    Display in

    EUR

  3. Choose .

    4. The Cash Management and Forecast: Summarized Display screen appears. You see an overview of the liquidity trend for a long period. The increments change from daily for the first week, to weekly for the next two months, and then monthly for the next six months. The values are given in thousands of EUR.

    The formatting of the data was defined in the GESAMT variant, and you can modify it if required.

  4. To show how you can change the display for the analysis period and the classification (scaling), choose New display.
  5. In the New Display dialog box, change the control parameters as follows:
    6.

    Field

    Data

    or week in days

    2

  6. Choose Continue.

    7. You now see the planning data for the next two weeks, displayed in daily increments. Only then is the change made to a weekly, and then to a monthly display

    The data is displayed in accordance with the chosen control parameter as a delta display with a beginning and an ending balance. You also have the option of displaying the data cumulatively.

    The daily ending balance results from the movements in the bank accounts (Banks) and from the expected incoming and outgoing payments according to the receivables and payables in the sub-ledger accounts, payroll accounting and tax calculations (persons).

    Now you want to see an up-to-date overview of the bank accounts according to the value date.

  7. Select the row Banks, then choose Groups.

    8. The Cash Management and Forecast: Display Groups screen appears. You see the short-term liquidity trends through the bank accounts.

  8. Select the bank account DBGIRO, then choose Levels

    9. The Cash Management and Forecast: Display Levels from Group screen appears. You see not only the levels that are automatically supplied with data (FI Banks) but also levels that are used for the manual entry of cash management records (Advice, c., Loans) as well as levels from Treasury Management (TM). The number of and names of such manual levels can be defined in Customizing to meet your requirements.

    The levels show you the business reasons for account movements, that is,. whether they result from true bank postings or were entered manually as memo records in the R/3 System.

  9. To create a new payment advice note, choose Memo record.
  10. Enter the following data:
    11.

    Field

    Data

    Company code

    1000

    Planning type

    AB

  11. Choose and enter the following data:
    12.

    Field

    Data

    Value date

    Current date + 2 workdays

    Cash mgmt. account name

    DBGIRO

    Amount

    25000

    Business area

    0001

    Text

    Confirmed payment advice from the Deutsche Bank

  12. Choose .

    13. The system displays the message Record added under number XXX.

  13. Choose until the Cash Management and Forecast: Display Levels from Group screen appears.
  14. Choose .
  15. Select Banks, then choose Groups.
  16. Select DBGIRO, then choose Levels
  17. In the AB Advice, c. line, select the amount, then choose List Display.

    18. The Memo Records: List screen appears, listing all the memo records that were listed manually under Confirmed advices.

  18. Select one of the milestones, then choose .

    19. The Display Memo Record: Payment Advice Number XXX screen appears containing a detailed display of the advice notes.

  19. To change an advice note choose .
  20. Choose until the Memo Records: List screen appears.
  21. To archive the corresponding advice note, select it and choose Transfer. When you confirm the dialog box, the system archives the advice note.
  22. Choose until the Cash Management and Forecast: Summarized Display screen appears.

    23. Now you want to get an overview of the projection of the incoming and outgoing cash flows in the sub-ledger accounts over a longer period:

  23. Select the row Subtotal, then choose Groups.

    24. In the Cash Management and Forecast: Display Groups screen you can see the medium-term liquidity trend according to the sub-ledger accounts, drilled down to the individual planning groups (such as domestic creditors, foreign creditors, taxes, customer bank collection, domestic customers, major customers etc.).

  24. Select the planning group A1, then choose Levels

    25. In the Cash Management and Forecast: Display Levels from Group screen, you see the assignment of data to the individual planning levels. You see the origin type (for example, Financial Accounting (FI), manual (FI) invoices, FI invoices blocked for payment, purchase orders, manual memo records (planned items), while the planning group displays the source location.

  25. Remain on this screen.