Using the Treasury Dashboard

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

Click to jump to parent topicUnderstanding 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:

Click to jump to top of pageClick to jump to parent topicCash Management Dashboards

The Cash Management dashboards are:

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:

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.

Click to jump to top of pageClick to jump to parent topicDeal Management Dashboards

The Deal Management dashboards are:

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.

Click to jump to top of pageClick to jump to parent topicOperational Dashboards

The operational dashboards are:

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.

Click to jump to parent topicConfiguring and Displaying Treasury Dashboards

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Configure and Display Treasury Dashboards

Page Name

Definition Name

Navigation

Usage

Dashboard Configuration - Cash Position by Bank

TR_DASH_01_CFG

Treasury Dashboards, click the Cash Position by Bank link.

Configure the cash position by bank dashboard.

Cash Position by Bank

TR_DASH_CASH

Click the Save and go back to Dashboard link or Return to dashboard link on the Dashboard Configuration - Cash Position by Bank page.

Display the cash position by bank dashboard summary and detail data.

Dashboard Configuration - Cash Position by Currency

TR_DASH_PBC_CFG

Treasury Dashboards, click the Cash Position by Currency link.

Configure the cash position by currency dashboard.

Treasury Dashboards - Cash Position by Currency

TR_DASH_PBC

Click the Save and go back to dashboard link on the Dashboard Configuration - Cash Position.

Display the cash position by currency detail and summary data.

Dashboard Configuration - Deals

TR_DASH_03_CFG

Treasury Dashboards, click one of these links: Investment Mix; Debt Mix; Fixed vs. Floating Rate Investments; Fixed vs. Floating Rate Debt; Open Foreign Exchange Contracts or after displaying the selected dashboard, click the Update Configuration link.

Configure to display the investment mix, debt mix, fixed versus floating rate investments, fixed versus floating rate debt, and open foreign exchange contracts dashboards.

Treasury Dashboards – Debt Mix

TR_DASH_DEAL

Click the Save and go back to dashboard link on the Dashboard Configuration - Deals page.

Display the investment mix deals detail and summary data.

Dashboard Configuration - Time Series

TR_DASH_03_CFG2

Click the Time Series link on the Dashboard Configuration - Deals page.

Select a time series to apply to the Fixed vs. Floating Rate Investments and Fixed vs. Floating Rate Debt dashboards.

Dashboard Configuration - Payments by Source

TR_DASH_02_CFG

Treasury Dashboards, click the Payments by Source link or, after displaying Dashboard, click the Update Configuration link on the Treasury Dashboards page.

Configure the Payments by Source dashboard.

Click to jump to top of pageClick to jump to parent topicConfiguring 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

Market Rate Index

Select the index that determines the exchange rate for the conversion of any currencies that apply to any cash position amounts that appear on the dashboard.

Rate Type

Select the rate type to apply to the conversion of any currencies associated with any cash position amounts that appear on the dashboard.

Currency Effective Date

Select the date that this currency exchange rate information will be applicable to the currencies that appears on the dashboard.

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.

SetID

Select the setID that to which the cash position data applies.

Tree Name

Select the cash position tree that will be used to display the data on the dashboard.

Bank Code

Displays this field only if Bank Code you selected in the Chart Control field. Select the bank code or codes for which you want to include cash position data on the dashboard.

Source Set

Displays this field only if you selected Source Set in the Chart Control field. Select one or more source sets for which you want to include cash position data on the dashboard.

Tree Node

Displays this field only if you selected Tree Node in the Chart Control field. Select one or more tree nodes for which you want to include cash position data on the dashboard.

Partner Bank

Displays this field only if you selected either Source Set or Tree Node in the Chart Control field. It is a prompt field with no edits, so you can enter freeform text that can be used to display chart data.

Position Date

Select one of these values.

  • Calc Date (calculation date)

    The system searches for rows that have a calculation date equal to the specified date option.

  • Value Date

    The system should searches for rows that have a value date equal to the date option.

Amount

Select one of these values.

  • Original

    Enables you to look up the original position amount.

  • Weighted

    Enables you to look up the weighted position amount.

Click to jump to top of pageClick to jump to parent topicDisplaying 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.

Click to jump to top of pageClick to jump to parent topicConfiguring 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.

Click to jump to top of pageClick to jump to parent topicDisplaying 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.

Click to jump to top of pageClick to jump to parent topicConfiguring 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.

Click to jump to top of pageClick to jump to parent topicDisplaying 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).

Click to jump to top of pageClick to jump to parent topicDisplaying 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).

Click to jump to top of pageClick to jump to parent topicDisplaying 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.

Click to jump to top of pageClick to jump to parent topicDisplaying 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.

Click to jump to top of pageClick to jump to parent topicDisplaying 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.

Click to jump to top of pageClick to jump to parent topicConfiguring 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.

Click to jump to top of pageClick to jump to parent topicDisplaying 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).

Click to jump to top of pageClick to jump to parent topicDisplaying 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.

Click to jump to top of pageClick to jump to parent topicDisplaying 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.

Click to jump to top of pageClick to jump to parent topicDisplaying 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).

Click to jump to top of pageClick to jump to parent topicConfiguring 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.

Click to jump to top of pageClick to jump to parent topicDisplaying 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.