This chapter presents an overview of the Treasury Dashboard and discusses how to configure and display 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Page Name |
Definition Name |
Navigation |
Usage |
Treasury Dashboards, click the Cash Position by Bank link. |
Configure the cash position by bank dashboard. |
||
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. |
||
Treasury Dashboards, click the Cash Position by Currency link. |
Configure the cash position by currency dashboard. |
||
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. |
||
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. |
||
Click the Save and go back to dashboard link on the Dashboard Configuration - Deals page. |
Display the investment mix deals detail and summary data. |
||
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. |
||
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. |
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:
|
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.
|
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. |
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. |
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.
|
Amount |
Select one of these values.
|
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.
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.
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.
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.
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).
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).
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.
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.
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.
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.
|
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. |
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).
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.
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.
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).
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.
|
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. |
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.