SAP Scene

Cash Position and Forecast

The Cash position and forecast enquiry is usually used by the Treasurer or whoever is responsible for ensuring that the company has adequate funds for expected outgoings.

The Cash Position input data is the known balances:

• Postings in cash and bank accounts (any GL account relevant to cash management),the unreconciled entries in the GL bank clearing accounts (uncashed cheques etc), and
• any memo records which may have been manually entered (planning advices) as relevant to a cash position
• cashflows from transactions managed in Treasury Management

Examples are:

• bank balances
• outgoing checks posted to the bank clearing account
• outgoing transfers posted to the bank clearing account
• maturing deposits and loans
• notified incoming payments posted to the bank account
• incoming payments with a value date

The Cash Forecast input data is the summary of the expected financial incomings and outgoings in the subledgers:

• Accounts receivable and Payable open items (as expected incoming and outgoing payments),
• SD Sales Orders and MM Purchase Orders (also as expected incoming and outgoing payments),
• Special GL transactions as required,
• Memo records (planning advices).
• Planned payments of wages and salaries
• Planned payables for taxes on sales and purchases

It is possible to use the one enquiry to cover both position and forecast.  The configuration is the same. For simplicity I will often refer to cash forecast to cover both the cash position and forecast.

A guide covering the following can be purchased at the Knowledge Shop.

Banks

Describes the terminology and set up of banks in SAP, specifically the  relationship between bank accounts, banks, house banks, bank directory, cash management account name and the General Ledger bank accounts.

GL Bank Accounts

Describes how GL bank and bank clearing accounts are used in the Treasury / Accounts Receivable/Payable functionality.  Uses the SAP standard bank accounts as an example to explain the intended purpose of each bank related GL account and what the entries in those accounts should indicate - specifically the uncleared entries.

Running the Cash Position or Forecast Enquiry

Guidelines on executing the cash position and forecast if they have already been configured

Understanding the Business Requirements

Describes the information that you should gather about your company's operations in this area to adequately configure it.

Dates and the Cash Forecast

The Cash position and forecast is all about amounts and dates. The section explains how the dates are determined for the various inputs.

Cash Forecast Terminology

Explains the key terms that are encountered in the configuration.  Must be read before embarking on the configuration section.

Cash Forecast Configuration

Guidelines on configuring the Cash Position and Forecast - presented in two sections - essential and then advanced configuration.

Related Configuration / Processing areas

Describes some of the related configuration and processing areas that impact or feed data to the cash forecast.

Preparing test data

Presents some hints on preparing test data directly without having to run the feeder programs.

This guide can be purchased at the Knowledge Shop.