Financial KPIs Every CFO Should Track in Their Dashboard
By Juan Pedro Zingoni · November 28, 2025 · 5 min read
The CFO role has changed radically over the past decade. It is no longer just about closing the books and reporting to the board: the modern CFO is the primary guardian of business financial health and needs real-time visibility across dozens of variables simultaneously. The right financial KPIs, properly defined and visualized in a Power BI dashboard, are the tool that makes that oversight possible without relying on manual reports that always arrive too late.
In this article we cover the most important financial indicators, their calculation formulas and benchmarks, and how to structure a financial dashboard in Power BI that enables strategic decisions with instantly up-to-date data.
The difference between reporting and analyzing
Many finance teams still spend most of their time building reports: consolidating data from multiple systems, cleaning spreadsheets, running calculations in Excel, and sending a PDF to the board. This model has three fundamental problems: it consumes valuable team time, it produces data that is already days old when it reaches the decision-maker, and it does not enable the interactive analysis that dynamic financial management requires.
A financial dashboard in Power BI connected directly to the ERP (SAP, Oracle, Dynamics, or whichever system the company uses) automates the entire consolidation layer. The finance team stops being a report factory and becomes a data analysis team, dedicating its time to interpreting KPIs and generating actionable insights for the organization.
The essential financial KPIs for the CFO dashboard
Below are the twelve indicators no financial dashboard should omit.
1. Gross margin
The difference between sales revenue and the direct cost of goods or services sold, expressed as a percentage. It is the first indicator of business profitability before considering operating expenses.
Formula: ((Revenue – Cost of goods sold) / Revenue) × 100
2. Operating margin (EBIT)
Business profitability after deducting all operating expenses but before interest and taxes. Measures operational efficiency independently of the capital structure.
Formula: (EBIT / Revenue) × 100
3. EBITDA and EBITDA margin
Earnings before interest, taxes, depreciation, and amortization. The most widely used metric for comparing operating profitability across companies and sectors, as it eliminates the impact of financing decisions and accounting policies.
Formula: EBIT + Depreciation + Amortization / Margin: (EBITDA / Revenue) × 100
4. Net margin
The final profit remaining for shareholders after all costs, expenses, interest, and taxes. The most complete profitability indicator and the one boards focus on most.
Formula: (Net income / Revenue) × 100
5. Current ratio
Measures the company's ability to meet short-term obligations with its current assets. A ratio below 1 indicates imminent liquidity risk.
Formula: Current assets / Current liabilities
6. Quick ratio (acid test)
A more conservative version of the current ratio: excludes inventories (the least liquid current asset) to measure the real capacity to cover immediate obligations.
Formula: (Current assets – Inventories) / Current liabilities
7. Operating cash flow
The cash generated by business operations, independent of investment and financing activities. A company can report accounting profits but face cash problems if it collects receivables slowly or has unfavorable working capital cycles.
Formula: Net income + Depreciation + Working capital changes
8. Days Sales Outstanding (DSO)
How many days it takes the company to collect its accounts receivable. A high DSO can create liquidity problems even when sales are strong.
Formula: (Accounts receivable / Period revenue) × Days in period
9. Days Payable Outstanding (DPO)
How many days it takes the company to pay its suppliers. A high DPO can indicate payment difficulties or a deliberate working capital optimization policy.
Formula: (Accounts payable / Period COGS) × Days in period
10. Return on equity (ROE)
Measures how much profit the company generates for each unit of equity invested by shareholders. The most relevant profitability indicator from an investor's perspective.
Formula: (Net income / Average equity) × 100
11. Return on assets (ROA)
Measures the efficiency with which the company uses its total assets to generate profit, regardless of how those assets are financed.
Formula: (Net income / Average total assets) × 100
12. Net debt / EBITDA
Indicates how many years it would take the company to pay off its net debt if it dedicated all its EBITDA to that purpose. The leverage indicator most used by banks and investors to assess financial risk.
Formula: (Total financial debt – Cash and equivalents) / EBITDA
Reference table: KPIs, formulas, and benchmarks
| KPI | Simplified formula | Reference benchmark |
|---|---|---|
| Gross margin | (Revenue – COGS) / Revenue × 100 | Varies: 20–70% by industry |
| Operating margin (EBIT) | EBIT / Revenue × 100 | 10–20% (healthy) |
| EBITDA margin | EBITDA / Revenue × 100 | 15–25% (healthy) |
| Net margin | Net income / Revenue × 100 | 5–15% (varies by sector) |
| Current ratio | Current assets / Current liabilities | > 1.5 (ideal > 2) |
| Quick ratio | (Current assets – Inventory) / Current liabilities | > 1 |
| Operating cash flow | Net income + Depreciation ± Working capital | Positive and growing |
| DSO | (Receivables / Revenue) × Days | 30–45 days (varies) |
| DPO | (Payables / COGS) × Days | 30–60 days |
| ROE | Net income / Equity × 100 | > 15% |
| ROA | Net income / Assets × 100 | > 5% |
| Net debt / EBITDA | (Debt – Cash) / EBITDA | < 3x (healthy) |
How to build the financial dashboard in Power BI
Power BI connects directly to the most widely used ERP systems: SAP, Oracle Financials, Microsoft Dynamics 365, Odoo, and others. From these connections, DAX calculations can be built for all the financial KPIs described above, with automatic refreshes at the defined frequency (daily, hourly, or near real-time depending on the plan).
One of Power BI's most valuable features for finance is cross-filtering: when the CFO filters the dashboard by a business unit, region, or specific period, all KPIs on the report recalculate simultaneously. This makes it possible to answer questions like "what is the EBITDA margin for the northern division in Q1?" without building a separate report for every possible filter combination. Each analysis is instant and the CFO can drill into any dimension with a single click.
For the financial dashboard we recommend structuring visualizations into three panels: a profitability panel (margins and EBITDA), a liquidity and cash panel (ratios and DSO/DPO), and a financial structure panel (ROE, ROA, and leverage). Each panel can be consulted independently or together, with all filters applied globally.
You can see how our dashboard is structured at finance products for Power BI.
How financial KPIs relate to each other
Financial KPIs are not independent variables: they form an interconnected system that tells a story when analyzed together:
- A high gross margin with a low operating margin indicates that fixed operating costs are eroding the profitability generated by the core business.
- A rising DSO combined with negative operating cash flow confirms collection problems that can threaten liquidity even when sales are strong.
- A high ROE with a high debt/EBITDA ratio may indicate that return on equity is inflated by leverage, not operational efficiency.
- An improvement in DPO that offsets a high DSO can balance the cash conversion cycle, but only if suppliers accept extended terms without affecting commercial conditions.
Want a financial dashboard ready to use?
Explore our finance dashboard for Power BI, with all CFO KPIs pre-configured and connected to your ERP from day one.
See the Finance Dashboard →Frequently Asked Questions
- What are the most important financial KPIs for a CFO?
- The most important financial KPIs for a CFO include gross margin, EBITDA margin, operating cash flow, and the current and quick liquidity ratios. DSO (days sales outstanding), ROE, and the net debt to EBITDA ratio are also essential, as they provide a complete picture of profitability, liquidity, and financial leverage.
- How is the EBITDA margin calculated?
- The EBITDA margin is calculated by dividing EBITDA by total revenue and multiplying by 100. EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization) is obtained by adding depreciation and amortization back to EBIT. A healthy EBITDA margin typically falls between 15% and 25%, though this varies significantly by industry.
- What are the advantages of using Power BI for a CFO financial dashboard?
- Power BI connects directly to ERP systems (SAP, Oracle, Dynamics) and automates financial data consolidation, eliminating the need for manual Excel reports. The cross-filtering capability allows the CFO to filter all KPIs simultaneously by business unit, region, or period with a single click, delivering instant analysis without depending on the IT team.