Analyzing Trends in the Cash Cycle Dashboard
The Cash Cycle Dashboard shows working capital inputs and cash conversion cycle trends. Use the dashboard to identify working capital trends and look at primary cash drivers.
This section gives general instructions for using these interactive subforms:
-
Revenue: Cost of Goods Sold – Shows the Total Revenue and Total Cost of Goods Sold trend for the Actual and Forecast periods. The subform lets you drill down into both trend lines.
-
Inventory : AR : AP – Shows the closing balances for Inventory in Stock, Trade Receivables, and Accounts Payable – Trade for Actual and Forecast periods.
-
DSO : DPO : DIO : Cash Conversion Cycle – Shows the Days Sales Outstanding, Days Payable Outstanding, Days Inventory Outstanding, and Cash Conversion Cycle in a trend graph for the Actual and Forecast periods.
To analyze working capital trends:
Maximize or refresh each trend graph by clicking the Maximize icon and Refresh icon in each subform
.
-
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, choose a Version, Subsidiary, and Currency.
-
Review the trends in each interactive subform for the selected Subsidiary. You can hover over a series line in the graph to see the series name, period (group), and value.
-
(Optional) In the Revenue: Cost of Goods Sold subform, to drill down to individual trend details, click a line in the graph or a trend name in the legend.
Drilling shows a breakdown of the Accounts that make up each trend.