IBCS reporting components
One model, many views. Switch the comparison base or retheme - every table and chart re-renders from the same data.
Interactive playground
liveOne filter bar, four linked views. Pick a comparison base, toggle regions and quarters, and stream live data - the KPIs, structure chart, quarter chart and table all re-render from the same filtered model.
| Value | PY | ΔPY | Share | |
|---|---|---|---|---|
| North America | 12.4M | 11.1M | +1.3M | 41% |
| Europe | 8.9M | 8M | +900K | 30% |
| Asia Pacific | 5.6M | 4.2M | +1.4M | 19% |
| Latin America | 2.1M | 1.5M | +600K | 7% |
| Middle East & Africa | 1.1M | 800K | +300K | 4% |
| Total | 30.1M | 25.6M | +4.5M | 100% |
| AC | PY | ΔPY | ΔPY% | |
|---|---|---|---|---|
| Q1 | 6.8M | 6.1M | +700K | +11.5% |
| Q2 | 7.3M | 6.4M | +900K | +14.1% |
| Q3 | 7.6M | 6.7M | +900K | +13.4% |
| Q4 | 8.4M | 6.4M | +2M | +31.3% |
| North America | 12.4M | ||
|---|---|---|---|
| Europe | 8.9M | ||
| Asia Pacific | 5.6M | ||
| Latin America | 2.1M | ||
| Middle East & Africa | 1.1M | ||
| Total | 30.1M |
Revenue +17.5% on PY; margin expansion lifts net income to €8.9M despite a higher tax charge.
| PY | AC | ΔPY | ΔPY% | |
|---|---|---|---|---|
| Product revenue | 16.1M | |||
| Service and other revenue | 9.5M | |||
| =Revenue | 25.6M | |||
| −Product cost | 3.1M | |||
| −Service and other costs | 5.3M | |||
| =Gross margin | 17.2M | |||
| −Research and development | 3.5M | |||
| −Sales and marketing | 4.3M | |||
| −General and administrative | 1.4M | |||
| −Restructuring | 306K | |||
| =Operating income | 7.7M | |||
| Other income, net | 276K | |||
| =Income before income taxes | 8M | |||
| −Provision for income taxes | -111K | |||
| =Net income | 8.1M |
| Current | PY | PL | ΔPY | ΔPY% | |
|---|---|---|---|---|---|
| P1 | 2.3M | 2.2M | 2.3M | +150K | +7.0% |
| P2 | 2.4M | 2.2M | 2.4M | +220K | +10.0% |
| P3 | 2.6M | 2.4M | 2.5M | +170K | +7.1% |
| P4 | 2.5M | 2.4M | 2.5M | +60K | +2.5% |
| P5 | 2.6M | 2.5M | 2.6M | +170K | +6.9% |
| P6 | 2.7M | 2.5M | 2.6M | +210K | +8.4% |
| P7 | 2.7M | 2.6M | 2.7M | +80K | +3.1% |
| P8 | 2.8M | 2.6M | 2.7M | +170K | +6.5% |
| P9 | 2.9M | 2.7M | 2.9M | +230K | +8.5% |
| P10 (FC) | 3M | 2.8M | 2.9M | +190K | +6.8% |
| P11 (FC) | 3.1M | 2.9M | 3M | +190K | +6.6% |
| P12 (FC) | 3.1M | 3M | 3.1M | +170K | +5.8% |
| P13 (FC) | 3.2M | 3M | 3.2M | +180K | +6.0% |
| Value | PY | ΔPY | Share | |
|---|---|---|---|---|
| North America | 12.4M | 11.1M | +1.3M | 41% |
| Europe | 8.9M | 8M | +900K | 30% |
| Asia Pacific | 5.6M | 4.2M | +1.4M | 19% |
| Latin America | 2.1M | 1.5M | +600K | 7% |
| Middle East & Africa | 1.1M | 800K | +300K | 4% |
| Total | 30.1M | 25.6M | +4.5M | 100% |
| AC | PY | ΔPY | ΔPY% | |
|---|---|---|---|---|
| Q1 | 6.8M | 6.1M | +700K | +11.5% |
| Q2 | 7.3M | 6.4M | +900K | +14.1% |
| Q3 | 7.6M | 6.7M | +900K | +13.4% |
| Q4 | 8.4M | 6.4M | +2M | +31.3% |
Gross margin of €20.4M absorbs €10.0M of operating expense, landing operating income at €10.4M.
| Contribution | Running total | |
|---|---|---|
| Revenue | +30.1M | 30.1M |
| COGS | -9.7M | 20.4M |
| Gross margin | 20.4M | 20.4M |
| Opex | -10M | 10.4M |
| Operating income | 10.4M | 10.4M |
| Trend | ||||
|---|---|---|---|---|
| EMEA | 12.4M | |||
| Americas | 9.8M | |||
| APAC | 5.6M | |||
| Other | 2.3M | |||
| Total | 30.1M |
Income statement
IBCS integrated waterfall: comparison column, AC labelled on the bars, Δ (bar) + Δ% (pin) with off-scale arrows.
| PY | AC | ΔPY | ΔPY% | |
|---|---|---|---|---|
| Product revenue | 16.1M | |||
| Service and other revenue | 9.5M | |||
| =Revenue | 25.6M | |||
| −Product cost | 3.1M | |||
| −Service and other costs | 5.3M | |||
| =Gross margin | 17.2M | |||
| −Research and development | 3.5M | |||
| −Sales and marketing | 4.3M | |||
| −General and administrative | 1.4M | |||
| −Restructuring | 306K | |||
| =Operating income | 7.7M | |||
| Other income, net | 276K | |||
| =Income before income taxes | 8M | |||
| −Provision for income taxes | -111K | |||
| =Net income | 8.1M |
Budget vs actual - income statement
Actual against plan (PL / budget): the PL column is the budget, ΔBudget (bar) and ΔBudget% (pin) show the gap. Over-budget costs read red regardless of the comparison toggle above.
| PL | AC | ΔBudget | ΔBudget% | |
|---|---|---|---|---|
| Product revenue | 17M | |||
| Service and other revenue | 11.5M | |||
| =Revenue | 28.5M | |||
| −Product cost | 3.4M | |||
| −Service and other costs | 6M | |||
| =Gross margin | 19.1M | |||
| −Research and development | 4M | |||
| −Sales and marketing | 4.6M | |||
| −General and administrative | 1.4M | |||
| −Restructuring | 0 | |||
| =Operating income | 9.1M | |||
| Other income, net | 290K | |||
| =Income before income taxes | 9.4M | |||
| −Provision for income taxes | 1.9M | |||
| =Net income | 7.5M |
Budget vs actual - by quarter
The same comparison on the quarterly build-up to full-year revenue. Q4 beat budget by the most; the full-year total lands 1.6M over plan.
| PL | AC | ΔBudget | ΔBudget% | |
|---|---|---|---|---|
| Q1 | 6.5M | |||
| Q2 | 7M | |||
| Q3 | 7.4M | |||
| Q4 | 7.6M | |||
| =Full year | 28.5M |
Balance sheet - stock view
A stock statement: each line is an ending balance (a level), not a period movement. Assets balance against liabilities + equity at 37.0M. Expand Non-current assets.
| PY | AC | ΔPY | ΔPY% | |
|---|---|---|---|---|
| Current assets | 14.8M | |||
| Cash and equivalents | 6.5M | |||
| Accounts receivable | 4.9M | |||
| Inventory | 3.4M | |||
| Non-current assets | 19.2M | |||
| =Total assets | 34M | |||
| Current liabilities | 6.6M | |||
| Accounts payable | 3.6M | |||
| Short-term debt | 3M | |||
| Non-current liabilities | 10.7M | |||
| Long-term debt | 9.5M | |||
| Deferred tax & other | 1.2M | |||
| =Total liabilities | 17.3M | |||
| Shareholders’ equity | 16.7M | |||
| Share capital | 5M | |||
| Retained earnings | 11.7M | |||
| =Total liabilities & equity | 34M |
Consolidation - virtualized
~250 rows (10 divisions × 24 accounts). The body scrolls with a sticky header and only the rows in view are mounted, so big consolidations and transaction drill-downs stay smooth. Scroll inside the table.
| PY | AC | ΔPY | ΔPY% | |
|---|---|---|---|---|
| North division | 7.8M | |||
| North · account 01 | 140.7K | |||
| North · account 02 | 332.4K | |||
| North · account 03 | 181.1K | |||
| North · account 04 | 390K | |||
| North · account 05 | 226.1K | |||
| North · account 06 | 452.3K | |||
| North · account 07 | 275.7K | |||
| North · account 08 | 393.9K | |||
| North · account 09 | 252.9K | |||
| North · account 10 | 457.3K | |||
| North · account 11 | 303.7K | |||
| North · account 12 | 525.3K | |||
| North · account 13 | 359.1K | |||
| North · account 14 | 179K | |||
| North · account 15 | 317.9K | |||
| North · account 16 | 173.5K | |||
| North · account 17 | 374.4K | |||
| North · account 18 | 217.4K | |||
Revenue by quarter - AC vs PY
AC columns with the comparison overlapped behind and an impact-coloured variance panel beneath. Switch the mark to pin for the lollipop variant.
| AC | PY | ΔPY | ΔPY% | |
|---|---|---|---|---|
| Q1 | 6.8M | 6.1M | +700K | +11.5% |
| Q2 | 7.3M | 6.4M | +900K | +14.1% |
| Q3 | 7.6M | 6.7M | +900K | +13.4% |
| Q4 | 8.4M | 6.4M | +2M | +31.3% |
Revenue trend - 13 periods
P1-P9 actual, P10-P13 forecast (hatched). PY/PL ride along as reference lines; the panel beneath shows AC/FC vs the comparison.
| Current | PY | PL | ΔPY | ΔPY% | |
|---|---|---|---|---|---|
| P1 | 2.3M | 2.2M | 2.3M | +150K | +7.0% |
| P2 | 2.4M | 2.2M | 2.4M | +220K | +10.0% |
| P3 | 2.6M | 2.4M | 2.5M | +170K | +7.1% |
| P4 | 2.5M | 2.4M | 2.5M | +60K | +2.5% |
| P5 | 2.6M | 2.5M | 2.6M | +170K | +6.9% |
| P6 | 2.7M | 2.5M | 2.6M | +210K | +8.4% |
| P7 | 2.7M | 2.6M | 2.7M | +80K | +3.1% |
| P8 | 2.8M | 2.6M | 2.7M | +170K | +6.5% |
| P9 | 2.9M | 2.7M | 2.9M | +230K | +8.5% |
| P10 (FC) | 3M | 2.8M | 2.9M | +190K | +6.8% |
| P11 (FC) | 3.1M | 2.9M | 3M | +190K | +6.6% |
| P12 (FC) | 3.1M | 3M | 3.1M | +170K | +5.8% |
| P13 (FC) | 3.2M | 3M | 3.2M | +180K | +6.0% |
Revenue by region - composition
The structure of the revenue total: each region's bar, share of the whole, and Δ vs the comparison. Ranked largest-first; AC solid, comparison faded behind.
| Value | PY | ΔPY | Share | |
|---|---|---|---|---|
| North America | 12.4M | 11.1M | +1.3M | 41% |
| Europe | 8.9M | 8M | +900K | 30% |
| Asia Pacific | 5.6M | 4.2M | +1.4M | 19% |
| Latin America | 2.1M | 1.5M | +600K | 7% |
| Middle East & Africa | 1.1M | 800K | +300K | 4% |
| Total | 30.1M | 25.6M | +4.5M | 100% |