Financial dashboard example: turn revenue into management KPIs
See how revenue, costs and staffing form a management report. This example uses entirely fictional data, in euros, from January through August 2026.
August 2026 KPIs
Gross margin
64.3%
(Revenue − direct costs) / revenue × 100
Days sales outstanding
17.0 days
Closing receivables / credit sales × 31 days
Operating margin
35.2%
(Revenue − direct costs − payroll − housing) / revenue × 100
Revenue per FTE
€14,353
Revenue / average FTE for the month
August: €122,000 revenue, €43,500 direct costs, €31,000 payroll and €4,500 housing. Operating profit is €43,000. Closing receivables are €67,000 and average staffing is 8.5 FTE.
DSO assumes all revenue is credit sales, excluding VAT, on the same basis as receivables. This is a simplified reporting example; your chart of accounts and KPI definitions may differ.
Financial dashboard example: turn revenue into management KPIs| Month | Revenue | Operating profit | Closing receivables |
|---|
| 2026-01 | €85,000 | €20,500 | €48,000 |
|---|
| 2026-02 | €92,000 | €24,500 | €52,000 |
|---|
| 2026-03 | €98,000 | €28,500 | €55,000 |
|---|
| 2026-04 | €105,000 | €33,000 | €58,000 |
|---|
| 2026-05 | €110,000 | €35,500 | €61,000 |
|---|
| 2026-06 | €115,000 | €39,000 | €63,000 |
|---|
| 2026-07 | €118,000 | €41,000 | €65,000 |
|---|
| 2026-08 | €122,000 | €43,000 | €67,000 |
|---|
Download financial sample data (CSV)Build your report in Power BI or Excel
- Power BI Desktop: choose Get Data → Text/CSV. Excel: choose Data → From Text/CSV.
- Use UTF-8, a comma delimiter and a decimal point. Set numeric types using English (United States) locale; keep month as text.
- Open Transform Data → Add Column → Custom Column. Name it OperatingProfit and use [revenue] - [directCosts] - [payroll] - [housing]. Choose Close & Apply (Power BI) or Close & Load (Excel). Use month as the axis and revenue and OperatingProfit as values in a column chart.
- Select one month for the KPI cards and apply the formulas above. Across months, add revenue and costs; use only the closing balance for receivables and an appropriate average for FTE.
This CSV is a starter model of monthly totals, not a full ledger or a ready-made Power BI file. For automated reporting, connect your source through DigiData and configure field mappings, relationships and calculations for your accounts.