OLAP - CFO Financial Performance Overview
The OLAP - CFO Financial Performance Overview dashboard for Sage 300 lists profitability, liquidity, and leverage indicators year to date. It includes ROA, ROE, OER, and ROCE, working capital and the current ratio, and the debt ratios that make up the balance sheet's leverage.
Sales and Finance OLAP Cubes
You need the Data Management add-on to use this dashboard.
How to use the CFO financial performance overview dashboard
- Read profitability, liquidity, and leverage together in the year to date indicators at the top.
- Compare ROA, ROE, OER, and ROCE to see how assets and capital convert into profit.
- Check working capital, the current ratio, cash, and accounts receivable against short term obligations.
- Follow the debt ratios of the capital structure and the assets month by month.
- Compare financial trends across periods using the monthly charts.
Filters
Use the filtering panel at the top of the OLAP - CFO Financial Performance Overview dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.
Fiscal Year: one value
Fiscal Period: value range
Ledger: one value
Branch: multiple values
Segment 2: multiple values
Segment 3: multiple values
Key performance indicators (KPIs)
The key performance indicators (KPIs) at the top of the dashboard show 16 measures grouped into performance, profitability, liquidity, and leverage, and update based on the filters you apply.
Performance KPIs
| KPI | What it measures |
|---|---|
| Revenue YTD | Total sales generated from the start of the fiscal year to the current period, which shows the cumulative sales of the year. |
| Gross Profit YTD | Cumulative profit after deducting cost of goods sold from revenue year to date, which shows the profit from core operations. |
| Gross Profit YTD Margin % | Percentage of revenue retained as gross profit year to date. A higher margin means more of each sale remains after the cost of goods sold. |
| Net Income YTD | Total profit after all expenses and taxes from the start of the fiscal year. A positive value means revenue exceeded all expenses and taxes. |
Profitability KPIs
| KPI | What it measures |
|---|---|
| Return on Assets (ROA) | Profit generated from total assets. A higher ROA means more profit for each dollar of assets. |
| Return on Equity (ROE) | Profit generated relative to shareholders' equity. A higher ROE means more profit for each dollar of equity. |
| Operating Expenses Ratio (OER) | Operating expenses as a proportion of revenue. A lower ratio means less of each revenue dollar goes to operating expenses. |
| Return on Capital Employed (ROCE) | Operating profit generated from capital employed. A higher ROCE means more operating profit for each dollar of capital employed. |
Liquidity KPIs
| KPI | What it measures |
|---|---|
| Working Capital YTD | Difference between current assets and current liabilities year to date. A positive value means current assets exceed current liabilities. |
| Working Capital LYTD | Working capital year to date for the same period last year, used for comparison. |
| Current Ratio | Current assets divided by current liabilities. A value above 1 means current assets are larger than current liabilities. |
| Working Capital Turnover | Revenue generated from working capital. Higher turnover means more revenue for each dollar of working capital. |
Leverage KPIs
| KPI | What it measures |
|---|---|
| Debt to Capital Ratio | Share of the capital structure funded by debt. Higher values mean a larger share is funded by debt. |
| Debt to Assets Ratio | Proportion of company assets financed through debt. A higher ratio means more of the assets are financed by debt. |
| Debt Ratio | Total liabilities divided by total assets, which shows the overall level of financial leverage. |
| Debt-to-Equity Ratio | Total debt compared with shareholders' equity. Higher values mean more reliance on external financing. |
Visual components
| View name | Type of view | What it shows |
|---|---|---|
| Performance: Net Income Margin % | Combination | Follows revenue YTD, gross profit YTD, net income YTD, and net income margin % month by month to show how performance and margins evolve over the year. |
| Profitability: ROA, ROE & OER Ratio | Combination | Compares net income, sales, ROE, and operating expenses ratio month by month to show how profitability ratios trend over time. |
| Liquidity: Current Ratio, Cash and AR | Combination | Displays cash, accounts receivable (AR), and the current ratio month by month to show how liquidity changes over the year. |
| Leverage: Debt Ratio | Combination | Tracks assets YTD, liabilities YTD, and the debt ratio month by month to show how leverage evolves over time. |