Cash and Liquidity Forecast

Scenario

One of the main purposes of the Treasury Management System in SAP is to predict the cash flows that will be occuring in future periods. These amounts flow from the Accounts Receivable and Accounts Payable processes and depend on expected payment dates and value dates.

In addition to the embedded cash flow patterns the planner can also include planning levels for other cash flows that will be expected to occur during the planning period.

Looking at the current and expected cash forecast:

MENU PATH

Accounting/Treasury/ Basic functions/ Tools/ Compare cash mgt/ Summary Records

Field name Input Value
Company Code 3000
Cash management position checked
Liquidity forecast unchecked
Value date 01/01/2000 to 06/30/2000
Account Number 113100

Select the Execute Icon

LOOKING AT THE CASH MANAGEMENT POSITION

MENU PATH

Accounting> Treasury> Cash management> Basic functions> Status> Cash management position

Field name Input Value
Company Code 3000
Cash management position checked
Liquidity forecast unchecked
Grouping BANKS US
Display as of Todays date
Display in USD

Select the Execute Icon.

DISPLAYING THE LIQUIDITY FORECAST

MENU PATH

Accounting> Treasury> Cash management> Basic functions> Status> Liquidity Forecast

Field name Input Value
Company Code 3000
Cash management position checked
Liquidity forecast checked
Grouping TOTAL
Display as of Todays date
Display in USD

Select the Execute Icon

Drill down on the bank and subledger lines to see the detail of the source of the data.

Back up to the Summarized Display

Select the New Display Button

Select Delta Display with Balances

Select Continue

Entering a Payment advice for a planned outgoing payment.

You have just received a notice that you must transfer funds to cover computer equipment purchased as outline below in the table. You will enter these payments in the Cash Budgeting system and observe the effect on the plan.

MENU PATH

Accounting> Treasury> Cash management> Basic functions> Input> Payment advices> Create

Field Name Input Value
Company code 3000
Planning Type AB

Select Enter Icon

Field Name Input Value
Value Date 05/XX/2000
Account Name CBMASTER
Amount XX times 1000 and add the minus sign
Text Planned Equipment Purchase XX

Select the Save Icon

Make a note of the Record #

MENU PATH

Accounting> Treasury> Cash management> Basic Functions> Status> Cash management position

Field Name Input Value
Company Code 3000
Cash management position checked
Liquidity Forecast checked
Grouping TOTAL
Display as of 05/01/2000
Display in USD

You should observe the effect of the payment advice that you entered. The forecasted cash balance is shown. Oher students are using this same company code so you see the net advice. A green balance indicates an excess and a red balance indicates a deficiency.