Using the CFO Balance Sheet Detail Dashboard
The CFO Balance Sheet Detail dashboard consists of tabs which correspond to key performance indicators (KPIs) and a summary of trends for each KPI. On each tab, you can perform dimensional analysis by KPI.
Tab | Description |
---|---|
Accounts Payable | Through column and bar charts, this tab provides a detailed overview of your Accounts Payable. |
Accounts Receivable | Through column, donut, and bar charts, this tab provides a detailed overview of your Accounts Receivable. Accounts Receivable can be analyzed by user-defined dimensions. |
Cash & Equivalents | Through line charts, this tab provides a detailed overview of your Cash & Equivalents. Cash & Equivalents can be analyzed by user-defined dimensions. |
DSO * | Through line charts, this tab provides a detailed overview of your DSO. DSO can be analyzed by user-defined dimensions. |
Days Sales Outstanding is used to measure how up-to-date a company is with their accounts receivable collections. A low DSO value means the company takes fewer days to collect their accounts receivable. DSO is calculated as follows:
(Accounts Receivable balance at end of the period / Revenue for the period) * Number of days in the period.
The number of days is calculated by subtracting the period start date from the period end date, plus 1. For example: (10000 / 5000) * 30 = 60.
Using Dashboard Charts
Each tab displays a range of charts for the corresponding KPI. Click View Details to open further details of a chart, if available. Additionally, you can use the charts in the following ways for further analysis:
Some of the charts displayed on the KPI tabs contain dimension selectors (drop-down menus) where you can select and change the dimensions you want to analyze.
The fields listed in these drop-down menus represent fields from the Financial Balances dataset. For details of these fields, see Financial Balances Input Fields.
When you make changes to dimension selectors, ensure that you use the Save View functionality to avoid losing your settings. You can click Save View on any tab of the CFO Balance Sheet Detail dashboard, however, the currently selected tab is the default tab for the view and is therefore visible the next time you open the view.
In Analytics, faceting is used to link filters between charts. When you click data on a chart with faceting enabled, the connected charts within the dashboard are automatically filtered.
For example, if you click a bar on the Gross Margin by Company (%) bar chart on the Gross Margin tab, the data in the Gross Margin and Gross Margin (%) bar charts changes in response to the relationship specified by faceting.
When you facet, the filters apply to all tabs of the dashboard. As a result, when you change from one tab to another, the data is filtered according to the filters specified by the faceted chart. To remove these filters, clickin your dashboard.
For information about faceting, see the Salesforce Online Help for Analytics.