Concept: Cash Management Dashboard

The Cash Management dashboard is a configurable workspace that contains visualizations and multidimensional reports to help you effectively manage your cash. The consolidated dashboard provides visibility into the daily cash positions and cash forecasts for your organization based on:

Bank account and cash ledger account balances.

Bank fees.

Generated cash forecasts using Worksheets.

Prior day and intraday bank statement information.

Workday automatically populates closing ledger balances in these formats:

BAI2 – Type Code 015

BTRS – Type Code 015

ISO – Type Code CLBD

MT940/942 – Type Code 62F

Workday delivers these report worklets available for use on the dashboard:

Worklet	Description
Bank Fees by Financial Institution	Displays your total bank fees grouped by financial institution. The graph automatically populates the last 3 months of bank fees.
Book to Bank Summary	Compares bank statement balances against the ledger bank balances in a summarized, high-level format. Using key metrics, you can identify the root causes of discrepancies between the balances for a specified company or company hierarchy, period, and bank accounts. Graphical indicators on the report represent the status of your bank account balances. You can quickly distinguish which bank account balances have unexplained differences from those that are fully reconciled.
Cash Balances and Bank Accounts by Financial Institution	Compares your total cash balances and number of bank accounts for the top 5 financial institutions in order by bank account balance. All other financial institutions are grouped under Other in the graph. You can assess your banking relationships by comparing the number of accounts with the amount of fund exposure at each financial institution. This can help you determine where to consolidate your funds to maximize your benefits from the banking relationships.
Cash Forecast: Projected Cash Balance	Displays your forecasted cash balances based on a generated cash forecast and cash forecast outline rows that you select. You can specify the number of days and currency to use for displaying your cash forecast. To view both daily and monthly projected cash balances, you can configure the dashboard with multiple tabs. On the first tab, select a daily cash forecast as the source for this report. On the next tab, add another instance of the report with a monthly cash forecast.
Cash Forecast: Projected Cash Inflows	Displays your forecasted cash receipts based on a generated cash forecast and cash receipt outline rows that you select. You can specify the number of days and currency to use for displaying your cash forecast. To view both daily and monthly projected cash balances, you can configure the dashboard with multiple tabs. On the first tab, select a daily cash forecast as the source for this report. On the next tab, add another instance of the report with a monthly cash forecast.
Cash Forecast: Projected Cash Outflows	Displays your forecasted cash payments based on a generated cash forecast and cash payment outline rows that you select. You can specify the number of days and currency to use for displaying your cash forecast. To view both daily and monthly projected cash balances, you can configure the dashboard with multiple tabs. On the first tab, select a daily cash forecast as the source for this report. On the next tab, add another instance of the report with a monthly cash forecast.
Cash Forecast by Reporting Currency	Displays your daily total forecasted amounts based on a generated cash forecast and reporting currency that you select. You can drill down on the outline row summary amounts to view the sublevel amounts. You can also access the worksheet used to generate the cash forecast.
Intraday Balance by Bank Account	Displays your current day cash position in bank account currency using your intraday bank statements.
Intraday Balance Summary	Displays your current day cash position in reporting currency using your intraday bank statements.
Intraday Cash Pool Balance Summary	Displays the current day cash pool balances in reporting currency using your intraday bank statements. Workday converts the subaccount currencies to the master account currency based on your selected currency rate type. You can use this report to analyze your funding needs and take the appropriate actions. You can select the type codes used for calculating the balance summaries for the master and subaccounts.
Prior Day Balance by Bank Account	Displays your prior day cash position in bank account currency using the latest prior day bank statements. The bank statements have a status other than Canceled .
Prior Day Balance Summary	Displays your prior day cash position in reporting currency using the latest prior day bank statements. The bank statements have a status other than Canceled .
Prior Day Cash Pool Balance Summary	Displays the prior day cash pool balances in reporting currency using your prior day bank statements. Workday converts the subaccount currencies to the master account currency based on your selected currency rate type. You can use this report to analyze your funding needs and take the appropriate actions. You can select the type codes used for calculating the balance summaries for the master and subaccounts.
Prior Day Ending Balance by Bank Account	Displays your prior day cash position in bank account currency using ending balances from the latest prior day bank statements. The bank statements have a status other than Canceled .
Prior Day Ending Balance Summary	Displays your prior day cash position in reporting currency using ending balances from the latest prior day bank statements. The bank statements have a status other than Canceled .
Prior Day Statements by Date	Displays the number of prior day bank statements by financial institution and date. Workday automatically populates bank statements from the last 5 days.
Total Bank Fees by Company	Displays your total bank fees grouped by company. Workday automatically populates bank fees from the last 3 months.
Total Cash Balance by Company	Displays your total cash balances by company. You can view the cash balance for each company as a percentage of the total balance for all companies. You can select the type codes used for calculating the closing ledger and carry forward balances. To view the bank statements and balance summaries for each bank account, you can drill down on the cash balance values.
Total Cash Balance by Currency	Displays your total cash balances by currency. You can view the cash balance for each currency as a percentage of the total balance for all currencies. You can select the type codes used for calculating the closing ledger and carry forward balances. To view the bank statements and balance summaries for each bank account, you can drill down on the cash balance values.
Total Cash Balance by Financial Institution	Displays your total cash balances by financial institution. You can view the cash balance for each financial institution as a percentage of the total balance for all financial institutions. You can select the type codes used for calculating the closing ledger and carry forward balances. To view the bank statements and balance summaries for each bank account, you can drill down on the cash balance values.
Weekly Average Cash Balances	Displays your weekly average cash balance for the last 12 weeks. Workday calculates a simple average of all bank statement ending balances for each week. You can drill down on the total average ending balance to view the bank statement details for each bank account.

Configure the Cash Management dashboard content using the

Maintain Dashboards

report (secured to the Set Up: Tenant Setup - Worklets
domain in the System functional area). You can also add cash management tasks or reports that you frequently use to the dashboard. For quick access, you can add the dashboard as a worklet to the home page.