Konsolidat is an open-source EPM that runs multi-entity financial consolidation on a ClickHouse columnar warehouse, with every close calculation modeled as version-controlled dbt SQL. Foreign-currency translation, intercompany elimination, non-controlling interest and driver-based allocations run as 44 dbt models with 26 automated tests — and the results land in Excel through =EPM() formulas. No proprietary calc engine, no black box.
A columnar analytics database built for billions of rows — consolidation, allocation and variance run in SQL at scale, not in a spreadsheet cell that times out at 50k rows.
Every transformation is version-controlled SQL in Git: 44 models, 26 automated tests. The consolidation logic is readable, reviewable and auditable — the code is the documentation.
Finance never leaves Excel. =EPM() worksheet functions pull live consolidated figures straight from ClickHouse into the workbooks your team already uses.
Unlike every commercial EPM, Konsolidat is open source and self-hostable — the whole application to run on your own infrastructure, inspect, fork and own.
Yes. Konsolidat performs multi-entity IFRS/GAAP consolidation — FX translation, CTA, intercompany elimination, NCI and allocations — directly on ClickHouse, with the logic expressed as dbt models. ClickHouse's columnar engine handles large GL volumes that overwhelm spreadsheet-based models.
dbt makes the entire close logic version-controlled SQL in Git, with automated tests on every run. That gives you transparency (every figure traces to a model), repeatability, and auditability — instead of a proprietary, opaque calculation engine.
Yes — Konsolidat is MIT licensed. You get full source-code access, can self-host, and can fork or extend any dbt model.
Book a 30-minute technical demo — a real consolidation model, not slides.