Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Konsolidat

konsolidat.com

  • Free plan
  • Open source
  • Web
  • API
  • Self-hosted
8.0 Club score Visit konsolidat.com

What Konsolidat is

Konsolidat is an MIT-licensed, open-source EPM product for finance teams using SAP or Microsoft Dynamics, with an Excel-native interface. Its consolidation handles multiple entities and currencies, elimination logic, non-controlling-interest attribution, and ownership-tree grouping. The allocation engine supports driver-based, cascading, and reciprocal allocations, with iterative solving and traceability to source pools. The product describes driver-based budgets, scenario management, and variance analysis; rolling forecasts are mentioned as both a capability and a roadmap item. Dynamics 365 F&O and ERPNext connectors are available, while SAP S/4HANA is offered through a paid pilot. SAP ECC, Business Central, and SAP Business One remain roadmap items. An Airbyte, dbt, and ClickHouse pipeline brings in ERP data for the consolidation model, and Excel =EPM() formulas pull results into existing workbooks. Teams can self-host on their own cloud or on-premises infrastructure, or choose a managed service. Self-hosting is free but requires operating the software and infrastructure. Hosted service starts at $3,500 per month; connectors and legal entities may incur additional monthly charges.

Who it suits

Konsolidat is aimed at finance teams using SAP or Microsoft Dynamics that want consolidation and planning in an Excel-centered workflow. Self-hosting may suit teams able to operate their own infrastructure; the hosted plan lists managed infrastructure, upgrades, and monitoring.

Good to know, and what to watch

  • Consolidates multiple entities and currencies
  • Supports elimination logic and non-controlling-interest attribution
  • Excel formulas bring backend results into existing workbooks
  • Self-hosting has no per-user fees
  • Security features include 2FA, access controls, and audit logging
  • SAP S/4HANA is offered through a paid pilot
  • SAP ECC, Business Central, and SAP Business One are roadmap items
  • Hosted plan starts at $3,500 per month
  • Self-hosting requires operating the software and infrastructure

Self-hosted

Free

Hosted

$3,500/mo

4-Week Pilot

$25,000 one-time

Free plan

Getting started

  1. Open the Konsolidat website
  2. Choose self-hosted deployment or the hosted plan
  3. Connect Dynamics 365 F&O or ERPNext, or arrange the SAP S/4HANA pilot
  4. Load ERP data through the available pipeline
  5. Use Excel =EPM() formulas to bring backend results into workbooks

Limits to check

The free self-hosted plan is self-operated and requires approximately 0.3–1 FTE plus cloud infrastructure. It includes Dynamics 365 F&O and ERPNext connectors, while SAP S/4HANA is available through a pilot. The hosted plan starts at $3,500 a month, with extra monthly charges for connectors and legal entities.

The Club's review

Overview

Konsolidat is an MIT-licensed EPM product for finance teams using SAP or Microsoft Dynamics. It suits organizations that want consolidation workflows to feed into existing Excel workbooks and can either manage infrastructure themselves or pay for a hosted service. Its finance capabilities are substantial, but connector coverage and some reporting functions remain gaps to weigh against that flexibility.

Excel worksheet formulas retrieve backend results, while a data pipeline built around Airbyte, dbt and ClickHouse brings ERP data into the consolidation model. The self-hosted option avoids per-user fees and keeps deployment under the customer's control, but shifts operations to the finance or IT team.

Key features

Consolidation and allocations

Konsolidat supports multi-entity, multi-currency consolidation with intercompany eliminations, non-controlling-interest attribution and ownership-tree-driven grouping. Full-method consolidation and audit trails suit group reporting workflows that need a traceable close process.

Its allocation engine handles driver-based, cascading and reciprocal allocations, including iterative solving. Traceability to source pools helps finance teams explain how allocated amounts were produced, rather than treating the result as a black box.

Planning and data flow

Driver-based budgets, scenario management and variance analysis broaden the product beyond consolidation. Rolling forecasts are described as a capability but are also on the roadmap, so teams that depend on them should confirm their availability before committing. Automated cash-flow statements and multi-GAAP parallel reporting are roadmap items as well.

The Excel =EPM() formulas pull backend results into existing workbooks, a practical fit for teams that already use spreadsheets in their reporting process. The product describes 44 dbt models and 26 automated data-quality assertions, with transformation lineage to 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 remain on the roadmap. That makes current connector coverage a central selection check for SAP-heavy organizations.

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

Pricing

Self-hosted: free

The MIT-licensed self-hosted plan has no per-user fees and includes Dynamics 365 F&O and ERPNext connectors; SAP S/4HANA access is through a pilot. It fits organizations that want control of their financial data and have the capacity to operate the stack. The trade-off is an estimated 0.3–1 FTE of operations work, plus cloud infrastructure costs, and community rather than priority support.

Hosted: $3,500 a month

From $3,500/month, the fully managed plan includes infrastructure management, upgrades and monitoring, along with an enterprise SLA and priority support. It suits teams that would rather not run the platform themselves. ERP connectors add $500–$1,500/mo each, and each legal entity adds $300–$800/mo, so the base price is not the whole cost for a larger group.

4-Week Pilot: $25,000, paid once

From $25K one-time, the fixed-scope, four-week pilot provides a hosted tenant, loaded general-ledger data and entities, Excel =EPM(), and one consolidation scenario. It can establish fit for a bounded use case, but unlimited entities, a full statutory pack and multi-year support are out of scope.

Platforms

Konsolidat is available as a web product, API and self-hosted deployment. The deployment choice matters: self-hosting gives customers infrastructure control but requires ongoing operations, while hosted access shifts infrastructure, upgrades and monitoring to the provider.

Who it's for

Konsolidat is best suited to finance teams consolidating multiple entities that want Excel-native access to results, need allocation traceability, and use Dynamics 365 F&O or ERPNext today. It is a stronger fit for organizations able to choose between internal operations and a managed service than for teams seeking a low-cost hosted entry point. SAP users should check connector readiness against their specific ERP before relying on it for production workflows.

Pros and cons

  • Pro: Multi-entity, multi-currency consolidation, eliminations and ownership-based grouping cover core group reporting needs.
  • Pro: Excel formulas bring backend results into existing workbooks, reducing the need to leave familiar spreadsheet workflows.
  • Pro: Self-hosting, broad access controls and audit logging support organizations that prioritize control over financial data.
  • Con: Self-hosting carries an estimated 0.3–1 FTE operational burden in addition to infrastructure costs.
  • Con: Connector coverage is uneven: Dynamics 365 F&O and ERPNext are available, SAP S/4HANA requires a paid pilot, and other named SAP and Microsoft connectors remain roadmap items.
  • Con: Hosted add-ons for connectors and legal entities can materially increase the monthly bill.
  • Con: Rolling forecasts, automated cash-flow statements and multi-GAAP parallel reporting are roadmap items, limiting fit for teams that require them now.

Alternatives

Financial Consolidation Software is a useful place to compare the category if Konsolidat's connector coverage or roadmap does not match your requirements.

Consider OneStream if you want to evaluate a paid platform with web, desktop, mobile and self-hosted availability; pricing is discussed through a demo. AARO CPM is another paid option to compare when you want a package that can be deployed immediately or customized, with pricing on request.

Control may suit companies under €1M in annual revenue that want a paid web/API product with a free trial and a €99/month Starter plan. Consolidation.app is another paid, web-based alternative.

IDL Konsis is worth comparing if you want a paid web and Windows option with pricing available by request. NDC Financial Consolidation offers self-hosted or web deployment, including as a standalone product or SAP Analytics Cloud extension, with cloud or on-premises installation.

Planful may be a better comparison for organizations seeking a paid web/API subscription tailored to company size, user count and selected modules. Profitbase Consolidation is another paid web option, with tailored pricing available by request.

Verdict

Choose Konsolidat if your finance team needs multi-entity consolidation and traceable allocations in an Excel-native workflow, and you can either run the software or budget for managed hosting. Its strongest case is the combination of financial controls, data ownership and deployment choice. Look elsewhere if you need a connector that is still on the roadmap, a confirmed rolling-forecast workflow, or hosted pricing that stays predictable as entities and connectors are added.

The verdict

Konsolidat brings consolidation and allocation workflows into an Excel-native setup, with self-hosted and managed options. Check connector availability and the roadmap gaps, and account for hosted add-ons or self-hosting operations.

Questions people ask

Is Konsolidat open source?

Yes. It is MIT-licensed and open source.

What does self-hosting cost?

The Self-hosted plan is free, with no per-user fees. Customers operate the software and infrastructure.

Which ERP systems connect today?

Dynamics 365 F&O and ERPNext connectors are available. SAP S/4HANA is offered through a paid pilot.

Does it support intercompany elimination and multi-currency consolidation?

Yes. Its consolidation supports both intercompany eliminations and multiple currencies.

What is the hosted price?

The Hosted plan is $3,500 a month, with connectors and legal entities priced separately.

What the maker publishes

Allocations
Its allocation engine supports driver-based, cascading, and reciprocal allocations with iterative solving and traceability to source pools. source
Allocations
Allocation models support driver-based, cascading and reciprocal pools with iterative solving and traceability to source pools. source
API
The documentation describes REST endpoints exposed through Frappe whitelisted methods and registry-validated fact tables and measures. source
Architecture in README
The documented data flow is ERP to Airbyte to ClickHouse to dbt to Cube.js to Frappe API and authentication to Excel. source
Automated testing
The project README describes 44 dbt models and 26 automated tests. source
Backend stack
The architecture combines Airbyte, dbt, ClickHouse and Frappe before serving results to Excel. source
Budgeting
Budgeting includes driver-based models, seasonal spread profiles, rolling forecasts and scenario management. source
Consolidation
It supports multi-entity, multi-currency consolidation with elimination logic, non-controlling-interest attribution, and ownership-tree-driven grouping. source
Consolidation
Its consolidation engine supports multiple entities, currencies, ownership trees, intercompany eliminations and non-controlling interest. source
Data control
The maker says customers can run the application on their own infrastructure, including cloud or on-premises, to keep financial data under their control. source
Data stack
The product describes an Airbyte, dbt, and ClickHouse pipeline that pulls ERP data and runs the consolidation model. source
Deployment method
A Docker-based deployment is documented, with services including Frappe, Cube.js, ClickHouse and Caddy. source
Deployment requirements
The deployment guide specifies a fresh Ubuntu 22.04 host with at least 4 vCPUs, 8 GB RAM and 80 GB SSD. source
Documentation depth
Documentation includes a roughly 15-minute quickstart, setup and architecture guides, user guides, REST API reference, data dictionary, dbt extension guidance and troubleshooting help. source
ERP connectors
Dynamics 365 Finance and Operations and ERPNext connectors are available, while SAP S/4HANA is handled through a paid pilot. source
ERP integrations
Dynamics 365 F&O and ERPNext connectors are available today; SAP S/4HANA is offered through a paid pilot, while SAP ECC, Business Central, and SAP Business One are on the roadmap. source
ERP roadmap
SAP ECC, Dynamics 365 Business Central and SAP Business One are listed as roadmap items rather than self-service connectors. source
Excel interface
Excel =EPM() worksheet formulas pull results from the backend into existing workbooks. source
Excel interface
The product delivers live figures into Excel through =EPM() formulas. source
Extensibility
Developers can add dbt gold models, seeds and tests, then register fact tables so the models become queryable through the API and Excel. source
Financial reporting
Report templates cover profit and loss, balance sheet and cash flow statements, with custom definitions queried through Excel. source
Founded
Grynn's site displays an establishment year of 2016. source
FX and CTA
The system translates functional currencies and calculates cumulative translation adjustments. source
Headquarters
Grynn lists Zürich, Switzerland as its location and gives Neuweg 24, 8222 Beringen, Switzerland as its legal address. source

Checked against the maker's pages on 15 Oct 2026.