Using the Treasury Dashboard

This chapter presents an overview of the Treasury Dashboard and discusses how to configure and display the Treasury Dashboard.

Understanding the Treasury Dashboard

Organizations face complex challenges in controlling and streamlining financial processes in order to improve the bottom line. The lack of visibility into cash positions and daily operational tasks on the part of Treasury managers has created a need for a dashboard to efficiently manage their return on cash. The Treasury Dashboard will provide managers with a unique view of the cash position for the organization. The dashboard provides the cash position by bank or by currency, investment mix, department mix and payment by source. The Treasury Dashboard is a necessary business intelligence tool that enables managers to effectively manage cash within their organizations, saving them time and money. Dashboards streamline the work of the treasurer by providing enormous value as well as a central place to monitor the cash position, payments and investments.

The Treasury Dashboard consists of a series of components which display cash management, deal management, and operational data in summary, detail and chart formats. These components enable executives and managers to gain a clear visual concept of the financial state of the organization in order to manage and monitor spending in real time. The Treasury Dashboard consists of:

• These cash management dashboards:

  • Cash Position by Bank Dashboard

  • Cash Position by Currency Dashboard

• These deal management dashboards:

  • Investment Mix Dashboard.

  • Debt Mix Dashboard.

  • Fixed versus Floating Rate Investments Dashboard.

  • Fixed versus Floating Rate Debt Dashboard.

  • Open Foreign Exchange Contracts Dashboard.

• These operational dashboards:

  • Payments by Source Dashboard.

  • Payments by Status Dashboard.

  • Payments by Bank Dashboard.

  • Payments by Payment Method Dashboard.

  • Status of Bank Statement Loads Dashboard.

Cash Management Dashboards

The Cash Management dashboards are:

• Cash Position by Bank.

• Cash Position by Currency.

These two options are based on association of selected cash position trees and nodes. To obtain the data that you want to display, you have the flexibility to:

• Set up your banks as tree nodes.

• Set up your banks as source sets.

• Set up one tree node and use bank information as additional criteria in the calculation preferences.

You set up a configuration to determine the data that you want to review on each dashboard. You determine the date to apply to the data and whether you want to control the data that appears for cash position in a chart based on bank code, source set, or tree node. You must also select the exchange rate information to apply to the data, and select the method used to determine the position and amount. If you select tree node or source set, you have the option of indicating that you want to chart the resulting data by bank.

In Treasury Management, a position is the total financial value of a particular set of transactions that are performed on behalf of an enterprise. A cash position analyzes cash flows to determine the amount of cash that is available at a particular time. Once you configure the dashboard and save the page, you can display your organization's cash position summary and detail data in two- or three dimensional-charts based on the configuration.

Cash Position by Bank Dashboard

The Cash Position by Bank Dashboard displays the summary and detail cash position amounts for each bank defined in the cash position tree that you selected in your Dashboard Configuration - Cash Position by Bank page.

Along with grids listing the summary and detail data, you can choose to display the cash position data in a two- or three-dimensional chart.

See Defining Cash Positions.

Cash Position by Currency Dashboard

The Cash Position by Currency Dashboard displays the cash position summary and detail amounts based on each type of currency that you set up for each node in the cash position tree that you select on the Dashboard Configuration – Cash Position by Currency page to measure the currency exposure. Along with grids listing the summary and detail data, you can choose to display the data in a two- or three-dimensional chart.

See Defining Cash Positions.

Deal Management Dashboards

The Deal Management dashboards are:

• Investment Mix.

• Debt Mix.

• Fixed versus Floating Rate Investments.

• Fixed versus Floating Rate Debt.

• Open Foreign Exchange Contracts.

You access the Dashboard Configuration - Deals page to identify the type of data that you want to display on Deal dashboards. This configuration requires that you enter a start and end date and then select a previously defined time interval. You select the time interval and apply a previously defined calendar to this interval. You also enter the number of days that would classify an investment/debt as short term, select the currency that you want to display on each of the Deal Management dashboards, and select the exchange rate information.

Investment Mix Dashboard

The Investment Mix Dashboard is used to compare the amounts of an organization's long and short term investments based on the time interval selected and the number of days that classify an investment as short term entered when you set up the configuration for this dashboard. An organization's investments may include long and short term investment deals in various forms of securities equities, and facilities. These data are derived from investments that are set up for an organization in PeopleSoft Deal Management.

Along with grids that display detail and summary investment mix data on the Investment Mix Dashboard, you can choose to display either a two- or three-dimensional chart of these data.

Debt Mix Dashboard

The Debt Mix Dashboard is used to compare the amounts of long term and short term debt held by your organization based on the time series that you select and the number of days that you enter that qualify a debt as short term on the Dashboard Configuration – Deals page.

Along with grids that display detail and summary investment mix data on the Debt Mix Dashboard, you can choose to display either a two- or three-dimensional chart of these data.

Fixed versus Floating Rate Investments Dashboard

An investment that earns money based on a fixed interest rate means that the amount of interest earned on the investment by the organization is based on an interest rate that typically stays the same over the life of the investment. An investment that earns money based on a floating interest rate means that the amount of interest earned on the investment over the life of the investment changes periodically.

The Fixed versus Floating Rate Investments Dashboard displays the organization's investments in fixed interest rate earning investments, and floating interest rate earning investments over a specific period of time. This time period is based on a time series that you select for this dashboard on the Dashboard Configuration – Deals page.

Along with grids that display detail and summary data on the Fixed Rate versus Floating Rate Investment Dashboard, you can choose to display either a two- or three-dimensional chart of the data.

Fixed versus Floating Rate Debt

A fixed rate is an interest rate that typically stays the same over the life of the debt instrument. A floating rate is an interest rate the changes over the life of the debt instrument. The Fixed versus Floating Rate Debt Dashboard displays an organization's borrowings on fixed rate basis and floating rate basis over a specified period of time. This time period is based on a time series that you select for this dashboard on the Dashboard Configuration – Deals page.

Along with grids that display detail and summary data on the Fixed Rate versus Floating Rate Debt Dashboard, you can choose to display either a two- or three-dimensional chart of the data.

Open Foreign Exchange Contracts Dashboard

A foreign exchange contract is a commitment to buy or sell a specified amount of foreign currency on a fixed date and rate of exchange. These contracts are used usually by importers as a hedge against exchange rate inflation. The Open Foreign Exchange Contracts Dashboard displays the amount of open foreign currency exchange contract bought or sold by an organization . You can choose to display the currency amount for either buying contracts or selling contracts.

Along with grids that display detail and summary data on the Open Foreign Exchange Contracts Dashboard, you can choose to display either a two- or three-dimensional chart of the data.

See Entering Foreign Exchange Deals Examples.

Operational Dashboards

The operational dashboards are:

• Payments by Source Dashboard.

• Payments by Status Dashboard.

• Payments by Bank Dashboard.

• Payments by Payment Method Dashboard.

• Status of Bank Statement Loads Dashboard.

The dashboards that fall under this category display total payment amounts based on a specified payment source, payment status, bank, and payment method. The last dashboard displays the status of bank statement loads.

Payments by Source Dashboard

The Payments by Source Dashboard enables you to select a business unit and specify a date or range of dates on the Dashboard Configuration - Payments by Source page and display the total amount of payments depending on whether the source of the payments in the system is AP (accounts payable), AR (accounts receivable), BPEL (BPEL source), CM (cash management), DM (deal management), or Expenses.

Along with grids that display detail and summary data on the Payments by Source Dashboard, you can choose to display either a two- or three-dimensional chart of the data.

Payments by Status Dashboard

The Payments by Status Dashboard enables you to select a business unit and specify a date or range of dates on the page and display the total amount of payments based the payment status of each payment.

Along with grids that display detail and summary data on the Payments by Status Dashboard, you can choose to display either a two- or three-dimensional chart of the data.

Payments by Bank Dashboard

The Payments by Bank Dashboard enables you to select a business unit and a date or range of dates and display the total amount of payments based on each bank affiliated with your organization.

Along with grids that display detail and summary data on the Payments by Bank Dashboard, you can choose to display either a two- or three-dimensional chart of the data.

Payments by Payment Method Dashboard

The Payments by Payment Method Dashboard enables you select a business unit and a date or range of dates and display the total amount of payments based on the payment method used such as ACH (Automated Clearing House), drafts, EFT (electronic file transfer), and wire transfer. .

Along with grids that display detail and summary data on the Payments by Payment Method Dashboard, you can choose to display either a two- or three-dimensional chart of the data.

Status of Bank Statement Loads Dashboard

The loading of bank statement information is an integral part of the reconciliation, bank statement accounting, and cash position processes. The system processes previous day statements that are used for reconciliation and accounting, current day statements for cash position worksheets, and account analysis statements for bank fee analysis. The configuration page allows you to exclude a Bank Statement Type or Bank Information.

Along with grids that display detail and summary data on the Status of Bank Statement Loads Dashboard, you can choose to display either a two- or three-dimensional chart of the data.

Configuring and Displaying Treasury Dashboards

This section discusses how to:

• Configure the cash position by bank dashboard.

• Display the cash position dashboard.

• Configure the cash position by currency dashboard.

• Display the cash position by currency dashboard.

• Configure the Deals dashboards.

• Display the investment mix dashboard.

• Display the debt mix dashboard.

• Display the fixed versus floating rate investments dashboard.

• Display the fixed versus floating rate debt dashboard.

• Display the open foreign exchange contracts dashboard.

• Configure the payments dashboard.

• Display the payments by source dashboard.

• Display the payments by status dashboard.

• Display the payments by bank dashboard.

• Display the payments by payment method.

• Configure the status of bank statement loans.

• Display the status of bank statement loans.

Pages Used to Configure and Display Treasury Dashboards

Configuring the Cash Position by Bank Dashboard

Access the Dashboard Configuration – Cash Position by Bank page (Treasury Dashboards, click the Cash Position by Bank link on the Treasury Dashboard Menu).

Date Option	Allows you to view Cash Position for any date. Select from one of these values: As of Date Select this value and populate the date in As of Date field. Today's Date This value is your current system date.
Chart Control	Cash Position feature offers flexible reporting structure. Chart Control allows you to look up position data according to the Cash Position Structure used by an organization. Select one of these values to determine the data to include and the fields to display on the Cash Position dashboard. Bank Code Select this option if Cash Position data are generated using Bank Code. Source Set You can set up banks as source sets. Select this option and the system will base the cash position data that appears on the charts on one or more selected source sets. Tree Node You can set up banks as a tree node. Select this option and the system will base the cash position data that appears on the charts on one or more selected tree nodes.
Display Currency	Select the currency that you want to appear on the Cash Position by Bank or Cash Position by Currency dashboard.
Chart by Bank	Select this check box to display the data based on each bank associated with the cash position data. If you leave this check box blank, the data displays based on the either the tree nodes or source sets that you select in the Position Source grid. If you select Bank Code as the Chart Control value, this check box does not appear on the page.
Save and go back to dashboard	Click this link to save the configuration and return to the Treasury Dashboards page to display the selected dashboard based on the configuration.
Return to dashboard	Click this link to return to the selected dashboard on the Treasury Dashboards page after the configuration has been saved.
Return to menu	Click this link to return to the Treasury Dashboards menu.

Exchange Rate Information

Position Source

The columns on this grid change based on whether you select the Chart Control as Bank Code, Source Set, or Tree Node. These fields determine the cash position.

Displaying the Cash Position by Bank Dashboard

Access the Cash Position by Bank Dashboard and Details (click the Save and go back to dashboard link on the Dashboard Configuration - Cash Position by Bank page).

This dashboard displays the cash position by the selected bank, tree node, or source set.

Configuring the Cash Position by Currency Dashboard

Access the Dashboard Configuration - Cash Position by Currency page (Treasury Dashboards, click the Cash Position by Currency link on the Treasury Dashboard menu).

You configure the cash position by currency using the Dashboard Configuration - Cash Position by Currency page, which contains the same fields as the Dashboard Configuration – Cash Position by Bank page except that you cannot chart by each bank.

Displaying the Cash Position by Currency Dashboard

Access the Cash Position by Currency Dashboard page (click the Save button and go back to dashboard link or Return to dashboard link on the Dashboard Configuration - Cash Position by Currency page).

This dashboard compares the cash position based on each currency for which the cash position was calculated to the cash position amount in the display currency.

Configuring the Deals Dashboard

Access the Dashboard Configuration - Deals page (Treasury Dashboards, click the Investment Mix link).

Start Date and End Date	Select a start and end date to apply to the data that appears on the Fixed Rate vs. Floating Rate chart.
Time Interval	Select the appropriate time interval for which you want the chart to display data.
Define Time Series	Define monthly, quarterly, half-yearly or yearly time intervals based on business calendars.

Important! Open Foreign Exchange Contracts do not use time intervals.

Displaying the Investment Mix Dashboard

Access the Investment Mix dashboard page (click the Save button and go back to dashboard link or the Return to dashboard link on the Dashboard Configuration - Deals page).

Displaying the Debt Mix Dashboard

Access the Debt Mix dashboard page (click the Save button and go back to dashboard link or Return to dashboard link on the Configure Dashboard - Deals page).

Displaying Fixed Versus Floating Rate Investments Dashboard

Access the Fixed Versus Floating Rate Investment dashboard page (click the Save button and go back to dashboard link on the Dashboard Configuration - Deals page).

This dashboard displays the fixed rate versus the floating rate investment amounts based on a selected time series.

Displaying Fixed Versus Floating Rate Debt Dashboard

Access the Fixed vs. Floating Rate Debt dashboard page (click the Save button and go back to dashboard link on the Dashboard Configuration - Deals page).

This dashboard compares the total amount of debt accumulated based on a fixed interest rate versus a floating interest rate within a selected time series.

Displaying the Open Foreign Exchange Contracts Dashboard

Access the Open Foreign Exchange Contracts dashboard page (click the Save button and go back to dashboard link on the Dashboard Configuration - Deals page).

This dashboard displays the amount of open foreign currency exchange contract bought or sold by an organization on a given date. In this example this was a buy contract.

Configuring the Payments by Source Dashboard

Access the Dashboard Configuration - Payment by Source page (click the Payments by Source link on the Treasury Dashboards page).

Date Options	Select one of these values. Today Payments by source display on the chart based on your system's current date. Specific Date Select this option and the Start Date and End Date fields are enabled. Select the start and end dates to which the payment data applies.
Business Unit	Select one or more business units to which the payment data that appears on the dashboard applies. Leave this field blank and the system will display payment data on the dashboard for all business units in your system.
Payment Source	Select one or more payment sources to which the payment data that appears on the dashboard applies. Leave this field blank and the system will display payment data on the dashboard for all payment sources.

Displaying the Payments by Source Dashboard

Access the Payments by Source dashboard page (click the Save button and go back to dashboard link or Return to dashboard link on the Dashboard Configuration - Payments by Source page).

Displaying the Payments by Status Dashboard

Access the Payments by Status dashboard page (click the Save button and go back to dashboard link or Return to dashboard link on the Dashboard Configuration - Payments by Source page).

This dashboard uses the same Dashboard Configuration - Payments by Source page. When you return to the dashboard after defining the configuration, the system displays the total payment amount based on the status of the payments.

Displaying the Payments by Bank Dashboard

Access the Payments by Bank dashboard page (click the Save button and go back to dashboard link or Return to dashboard link on the Dashboard Configuration - Payments by Source page).

This dashboard uses the Dashboard Configuration - Payments by Source page to configure the data for Payments by Bank. When you access the dashboard it displays the total payment amounts for each of your organization's banks that have payments associated with them.

Displaying the Payment by Payment Methods Dashboard

Access the Payments by Payment Method dashboard page (click the Save and go back to dashboard link or Return to dashboard link on the Dashboard Configuration - Payment by Source page).

Configuring the Bank Statement Load Dashboard

Access the Dashboard Configuration - Bank Statement Load page (click the Status of Bank Statement Load link on the Treasury Dashboards page).

Date Options	Select one of these options. Today Displays statement loads as of your current system date. As of Date The As of Date field is enabled so that you can select the date that the statement loads that appear on the dashboard start from.
Exclude Types	Add and select the types of bank statements that you want to exclude from displaying on the Bank Statement Load dashboard.
Exclude Banks	Add and select the bank codes and bank accounts that you want to exclude from displaying on the Bank Statement Load dashboard.

Displaying the Bank Statement Load Dashboard

Access the Bank Statement Load dashboard page (click the Status of Bank Statement Loads link on the Treasury Dashboards page).

This dashboard displays the number of statements loaded based on the banks you selected on the Dashboard Configuration - Bank Statement load page.