P&L statement · EUR thousand
Full year: the budget when Budget is selected, otherwise actuals to date plus forecast.
Loading the data…
EBITDA variance to budget by department
profit impact, EUR thousand, closed monthsClick a bar to filter the waterfall and the table; click it again to clear
EBIT variance by account group
all departmentsRaises profitLowers profitEBIT variance
Variance by line
all departments · EUR thousand| Line | Actual | Budget | Variance | Variance % | Status |
|---|
Budget: the closed months only. Variance in display sign, margins in percentage points; on plan within 1 % or 0.1 pp.
Monthly actual, budget and forecast
Department applies here; Year and Months do not: the chart always shows January 2023 to December 2025.
The filters, the tab, the expanded rows and the line are remembered in this browser only.
About this demo
Kaldora Facility Services is a fictional facility-services company in Graz, Austria, with four service lines (Cleaning Services, Technical Maintenance, Security Services, Catering) and two support departments (Administration, Sales & Marketing). The finance team wanted one management P&L instead of the monthly spreadsheet: actuals against budget by department, a forecast for the rest of the year and the variances worth explaining.
Sign convention
The ledger export uses the ledger sign: debit plus, credit minus. The model stores every amount as its contribution to profit: income plus, expense minus. Revenue and cost lines show in display sign, so costs appear as positive amounts. A variance is favourable when it raises profit: more revenue or less cost.
The Power BI report
This page computes the measures of the report in JavaScript from kaldora.json, built by tools/build_replica_data.py through the Python reference. The report also has an Opex page, a department drill-through, a tooltip page and a role Department head that limits each department head to their own cost centres; this replica shows all departments and leaves those out.
Kaldora Facility Services is a fictional company and every number is invented.
Rebuilt from memory as a demo. The original client's name and data are not used.