Analyzing Trends in the Cash Cycle Dashboard
The Cash Cycle Dashboard displays working capital inputs and cash conversion cycle trends. You can use the Cash Cycle Dashboard to identify working capital trends and analyze primary cash drivers. The dashboard also includes the option to drill into specific trends.
This section includes general instructions on how to use the following interactive subforms in the Cash Cycle Dashboard:
-
Revenue: Cost of Goods Sold – Displays the Total Revenue and Total Cost of Goods Sold trend across the Actual and Budget periods. The subform includes the option to drill into both trend lines.
-
Inventory : AR : AP – Displays the closing balances for Inventory in Stock, Trade Receivables, and Accounts Payable – Trade for the Actual and Budget periods.
-
DSO : DPO : DIO : Cash Conversion Cycle – Displays the Days Sales Outstanding, Days Payable Outstanding, Days Inventory Outstanding, and Cash Conversion Cycle in a trend graph for the Actual and Budgeted periods.
To analyze working capital trends:
You can maximize and refresh each trend graph individually by clicking the Maximize icon 
and Refresh icon in each subform 
, respectively.
-
From the Home page, go to Financials > Balance Sheet Trending.
-
Click Cash Cycle Dashboard at the bottom of the page.
-
In the Point of View, select a Version, Subsidiary, and Currency.
If you use Dashboards 1.0, click the Go icon
to apply the changes to the POV. -
Review the trends within each interactive subform for the selected Subsidiary. You can hover over a series line in the graph to display the series name, period (group), and value.
-
(Optional) In the Revenue: Cost of Goods Sold subform, to drill down further to the individual trend details, click a specific line in the graph. Alternatively, click a trend name in the legend.
Drilling shows a breakdown of the Accounts that make up each trend.