Konsolidat

Overview

Konsolidat is an open-source EPM system for finance teams using SAP or Microsoft Dynamics. It suits organizations that want consolidation and allocation outputs in familiar Excel workbooks and can manage self-hosting or pay for a managed service. Its finance workflows are substantial, but connector coverage and some reporting capabilities remain unfinished.

Key features

Consolidation and allocations

Konsolidat handles multi-entity, multi-currency consolidation, including intercompany eliminations, non-controlling-interest attribution and ownership-tree-based grouping. Full-method consolidation and audit trails support group reporting workflows where teams need to explain how figures were assembled.

Allocations can be driver-based, cascading or reciprocal, with iterative solving and traceability to source pools. That combination is useful when finance teams need to follow an allocation back to its inputs rather than treat the result as opaque.

Planning, Excel and data flow

Driver-based budgets, scenario management and variance analysis extend the product beyond consolidation. Rolling forecasts are described as a capability but also appear on the roadmap, so teams that depend on that workflow should verify its readiness before committing. Automated cash-flow statements and multi-GAAP parallel reporting are also roadmap items.

Excel =EPM() formulas pull backend results into existing workbooks, giving teams a way to work with model outputs without abandoning Excel. Behind that interface, an Airbyte, dbt and ClickHouse pipeline brings in ERP data and runs the consolidation model. The product describes 44 dbt models, 26 automated data-quality assertions and transformation lineage, which help finance teams trace figures through the data flow.

Integrations and control

Dynamics 365 F&O and ERPNext connectors are available today. SAP S/4HANA is offered through a paid pilot; SAP ECC, Business Central and SAP Business One are roadmap items. That makes the current connector set a deciding factor for SAP estates beyond S/4HANA.

Customers can run Konsolidat on their own cloud or on-premises infrastructure, keeping financial data under their control. Security features include 2FA, role-based access, session management, audit logging, OIDC/SAML SSO including Microsoft Entra ID, and LDAP/Active Directory. Self-hosted users receive community support and a public roadmap; the hosted plan adds an enterprise SLA and priority support from the core team.

Pricing

The self-hosted plan is free and MIT-licensed, with no per-user fees. It includes the Dynamics 365 F&O and ERPNext connectors, with SAP S/4HANA available via pilot. The trade-off is operational: customers run the system themselves, with roughly 0.3–1 FTE of operations effort plus cloud infrastructure, and community rather than priority support.

Hosted pricing starts at $3,500/month for a fully managed platform with infrastructure, upgrades and monitoring. ERP connectors add $500–$1,500/mo each, and legal entities add $300–$800/mo each, so costs can rise materially as deployment scope expands. This plan is a better fit for teams that value managed operations and an enterprise SLA over running the stack in-house.

The 4-Week Pilot costs $25K one-time for a fixed-scope, four-week hosted tenant with GL and entities loaded, Excel =EPM(), and one consolidation scenario. It excludes unlimited entities, a full statutory pack and multi-year support, making it a scoped evaluation rather than a full deployment. There is no per-user fee on the free plan; the paid options have custom scope costs beyond their stated terms.

Platforms

Konsolidat is available as a web product, API and self-hosted deployment. Self-hosting can run on customer cloud or on-premises infrastructure; the hosted plan is fully managed.

Who it's for

Konsolidat is a strong fit for finance teams with Dynamics 365 F&O or ERPNext data, complex entity structures, and a preference for Excel-based analysis. Organizations that need tighter data control and have operational capacity can use the free self-hosted edition; teams seeking managed infrastructure and priority support can consider the hosted service.

It is a weaker fit for organizations whose core requirements depend on SAP ECC, Business Central or SAP Business One connectors, or on automated cash-flow statements, multi-GAAP parallel reporting or ready-to-use rolling forecasts. Those needs intersect with roadmap items rather than current capabilities.

Pros and cons

• Pros: Broad consolidation and allocation logic, including eliminations, ownership-based grouping and traceable iterative allocations, suits demanding group reporting.
• Pros: Excel formulas bring backend results into existing workbooks, while self-hosting offers control over where financial data runs.
• Pros: The free MIT-licensed option has no per-user fees, lowering software cost for teams prepared to operate it.
• Cons: Self-hosting entails roughly 0.3–1 FTE of operations effort plus infrastructure, and community support rather than an enterprise SLA.
• Cons: Hosted pricing can grow with connector and entity surcharges, beyond the $3,500/month starting price.
• Cons: Several ERP connectors and finance reporting capabilities remain roadmap items, limiting its fit for teams that need them now.

Alternatives

Financial Consolidation Software is a useful starting point for comparing options in the category. EMAsphere is another freemium web option to consider if you want a browser-based alternative. Choose AARO CPM if you prefer a product with deployment that can start immediately or be customized, and are comfortable requesting pricing or a demo.

OneStream is worth considering if you need a platform spanning web, desktop, mobile and self-hosted access and are willing to discuss pricing through a demo. Arvexi is a paid web and API alternative. Clausion may suit buyers who want consolidation pricing through a tailored estimate, while IDL Konsis offers pricing by request and a demo.

NDC Financial Consolidation is a paid option to consider if you want standalone deployment or an SAP Analytics Cloud extension, with cloud or on-premise installation. Profitbase Consolidation is another paid alternative with tailored options and prices available by request.

Verdict

Choose Konsolidat if your finance team needs rigorous multi-entity consolidation and traceable allocations in an Excel-centered workflow, and you can support self-hosting or justify managed pricing. Its combination of finance logic, data control and workbook integration is compelling; look elsewhere if your ERP connector or reporting requirement is still on the roadmap, or if hosted add-ons push the total beyond your budget.