Konsolidat is an open-source (MIT licensed), Excel-native EPM platform for groups running SAP or Microsoft Dynamics. It covers multi-entity IFRS/GAAP consolidation with FX translation, CTA, intercompany elimination and NCI; driver-based, cascading and reciprocal cost allocations; budgeting with seasonal spreads; and variance analysis. Finance teams report in their existing workbooks through =EPM() formulas, while close logic runs on a ClickHouse + dbt backend with full traceability to the source GL and 26 automated assertions on every run. Connectors for Dynamics 365 F&O and ERPNext are available today; SAP S/4HANA is delivered via a 4-week pilot. The application layer adds 2FA, RBAC, audit logging and SSO (OIDC/SAML, Entra ID, LDAP). Self-host for $0 license cost, or choose a fully managed hosted option. Built for 10–500 finance users.
Features
- Multi-entity IFRS/GAAP consolidation with IC elimination and NCI
- FX translation and CTA across functional, presentation and reporting currencies
- Driver-based, cascading and reciprocal cost allocations
- Budgeting and forecasting with seasonal spread profiles
- Actual vs budget and prior-year variance analysis
- Excel-native reporting via =EPM() formulas
- Dynamics 365 F&O and ERPNext connectors; SAP S/4HANA via pilot
- Full audit trail from consolidated figure to source GL
- 2FA, RBAC, audit logging and SSO (OIDC/SAML, Entra ID, LDAP)
- Self-hosted (MIT, $0 license) or fully managed hosting
Project Samples
