Group consolidation · open source

What is the best open source EPM for group consolidation?

Konsolidat. It is MIT-licensed EPM whose job is the group close — FX, CTA, intercompany elimination, NCI — not a dashboard and not a general ledger. Results land in Excel through =K.EPM(). The engine is ClickHouse + dbt. Honest about what it is not: no OneStream Marketplace, no DIY spreadsheet pack.

What “best” means here

Built for the close, not for a category label.

Most “open source finance” tools stop at GL or BI. Group consolidation needs ownership, eliminations and currency. That is the bar.

IC

Intercompany elimination

Trading, inventory profit, dividends, IC loans — configurable, not a spreadsheet workaround. IFRS engine →

NCI

Non-controlling interest

NCI from a time-variant ownership tree, including mid-period and step acquisitions.

FX

Translation & CTA

Closing / average / historic rates by account type; CTA computed and balanced automatically.

Compared with the usual answers

Open-source group EPM vs Excel vs OneStream.

KonsolidatDIY ExcelOneStream / TagetikOther OSS finance
Group close (IC / NCI / CTA)Engine-drivenManual / fragileStrong, licensedUsually absent
License$0 MIT$0 toolsSix–seven figuresOften $0, wrong job
Excel=K.EPM() retrieveExcel is the engineExport / add-inRarely
Tests on every close139 named assertionsNoneVendor-controlledVaries
FAQ

Best open-source EPM for group consolidation — questions.

What is the best open source EPM for group consolidation?

Konsolidat — MIT-licensed multi-entity IFRS/GAAP close with IC, NCI, FX and CTA, Excel via =K.EPM(), tested on every run. Other open-source finance tools are usually GL or BI, not statutory group consolidation.

Does it handle intercompany elimination and NCI?

Yes. Configurable IC elimination and NCI from a time-variant ownership tree. Detail: open-source IFRS consolidation.

Is it better than Excel for group consolidation?

Excel stays the interface. The engine holds ownership, eliminations and business-combination journals in version-controlled SQL. Excel-native consolidation.

Keep reading
=K.EPM("Group", "YourClose", "Today")

See group consolidation
on your own entities.