Concept: Treasury Discovery Board
The Treasury discovery board is a configurable workspace that you can use to perform an
enriched data analysis on your cash positions and cash forecasts. You can select and
customize visualizations on the dashboard to gain insights into your cash balances and
treasury operations so you can take necessary actions. Each Workday-delivered
visualization is a graphical or textual representation of selected fields on a report
data source.
The discovery board displays the visualizations on these sheets by category:
- Bank Balances
- Banking Cash Pools
- Banking Relationship
- Cash Forecasting
- Cash Positioning
- Regional Cash Pools
To view and customize the visualizations, copy the Treasury discovery board from the
Delivered Discovery Boards
report to Workday Drive. Secure
domain access to Drive and the report data source for each visualization.Workday delivers these visualizations available for use on the discovery board:
Visualization | Description |
|---|---|
Average Cash Balances in last 10 days
| Displays all your daily average cash balances from prior day bank
statements in the last 10 days. You can determine how your cash positions
are trending by bank account, and by company or company hierarchy. You can
also drill into the bank statement details for each account. The
visualization uses the Bank Statements report
data source. |
Bank Balances and Summaries by Bank
Accounts
| Displays all balance type codes from your prior day bank statements for
each bank account. Example: The Opening Ledger, Closing Ledger, and Total
ACH Debits type codes. You can track the progress of your bank balances
over a specified period. You can also drill into the bank statement
details for each account. The visualization uses the
Bank Statement Balance(All) report data
source. |
Banking Cash Pools
| Displays your total cash balance by cash pool translated into a single reporting
currency. Visual indicators represent the status of your cash balance
compared to a specified target balance on your bank account. Example: A red
diamond indicates when a current balance is less than your target balance of
$1,000,000. You can view the variance between the actual and target
balances. You can also drill into the bank balance details for each
account. Workday automatically populates your total cash balance
across all accounts for the selected company. To display your cash
pools, you must select 1 or more cash pool overrides in the
Data Source panel of the discovery
board.The visualization uses the Bank
Statements report data source.To use this
visualization, you must first set up and create banking cash
pools. |
Cash Balances in last 90 days
| Displays all your daily cash balances from prior day bank statements in
the last 90 days. You can determine how your cash positions are trending by
bank account, and by company or company hierarchy. You can also drill into
the bank statement details for each account. The visualization uses the
Bank Statements report data
source. |
Forecasted Activities by Percentage
| Displays the projected closing cash balances using cash forecasting
with Worksheets functionality. A bar chart displays the projected cash
activity percentages across your specified timespan. You can also drill into
the model worksheets to view the cash forecasting details. The
visualization uses the Cash Forecast Cells 2.0
report data source.To use this visualization, you must first create and generate a
cash forecast using Worksheets. |
Forecasted Activities in Reporting
Currency
| Displays the projected closing cash balances in reporting currency
using cash forecasting with Worksheets functionality. A bar chart displays
the projected cash activity total amounts across your specified timespan.
You can also drill into the model worksheets to view the cash forecasting
details. The visualization uses the Cash Forecast Cells
2.0 report data source.To use this visualization, you must first create and generate a
cash forecast using Worksheets. |
Projected Closing Cash Balances in next 30 days
| Displays the projected closing cash balances in the next 30 days using
cash forecasting with Worksheets functionality. The visualization uses the
forecasted data from your existing cash forecasting worksheet entry area.
You can analyze your current cash position and projected availability
of cash. You can also drill into the model worksheets to view the cash
forecasting details. The visualization uses the Cash
Forecast Cells 2.0 report data source.To use this functionality, you must first create and generate a
cash forecast using Worksheets. |
Regional Cash Pools
| Displays your total cash balance by cash pool translated into a single reporting
currency by region. Visual indicators represent the status of your cash
balance compared to a specified target balance. Example: A red diamond
indicates when a current balance is less than your target balance of
$1,000,000. You can view the variance between the actual and target
balances. You can also drill into the bank balance details for each
account. Workday automatically populates your total cash balance
across all accounts for the selected company. To display your cash
pools, you must select 1 or more cash pool overrides in the
Data Source panel of the discovery
board.The visualization uses the Bank
Statements report data source.To use this
visualization, you must first set up and create banking cash
pools. |
Total Cash (In Reporting Currency) by
Currency
| Displays your prior day closing bank balances in reporting currency
across all bank accounts. You can quickly determine the amount of available
cash in each currency. You can also drill into the details to view the
individual bank account balances from your prior day bank statements. The
visualization uses the Bank Statements report
data source. |
Total Cash (In Reporting Currency) by Financial Institution
and Currency
| Displays a heat map of your total cash balances in reporting currency
for each financial institution. You can determine the order of highest to
lowest cash balances. You can also drill into the details to view the
individual bank account balances from your prior day bank statements. The
visualization uses the Bank Statements report
data source. |
Total Prior Day Bank Statements
| Displays the total number of prior day bank statements that you received in the last
month by statement date. You can track when you record or upload all of your
daily or monthly statements. You can also drill into the bank statement
details for each account. The visualization uses the Bank
Statements report data source. |