Konsolidat disrupts exactly where legacy EPM hurts — cost, lock-in, implementation drag, and the Excel disconnect. Not a feature-for-feature replacement in every niche, but a compelling, lower-risk alternative for mid-market-to-enterprise finance teams.
If your group runs on SAP, Dynamics, or ERPNext — and closes across dozens of legal entities — you've probably hit this wall already.
Excel isn't the problem. The problem is that Excel has been asked to do the work of a proper backend — and it was never designed for that. Konsolidat separates those concerns.
Finance teams keep the formula-driven experience they know. Konsolidat keeps complex state — ownership trees, intercompany eliminations, allocation pools — out of the workbook entirely.
Consolidation, allocations, and variance calculations run in a columnar analytics database built for billions of rows — not in a spreadsheet cell that times out at 50k rows.
You own the code, the data model, and the logic. Audit every calculation. Extend any module. No vendor holds your close process hostage at renewal time.
Connect SAP (ECC & S/4HANA), Microsoft Dynamics 365 F&O and Business Central, and ERPNext through each system's OData / REST API — orchestrated by Airbyte, not fragile exports. No middleware tax. More sources in the works.
Click any consolidated figure and trace it to the source journal entry. Auditors get the lineage. CFOs get the confidence. FP&A gets fewer last-minute calls.
Developed in the open alongside finance practitioners who have lived with the pain of real consolidation complexity. If something is broken, you can fix it — or we fix it together.
Most EPM tools hide complexity behind a configuration UI until you actually need to model your business — then the limitations surface. Konsolidat is designed around the hard cases first.
Model service-department cross-charges that loop back on themselves. The engine iterates to convergence rather than forcing you to hand-calculate the math or accept an approximation.
Define cost pools that cascade through multiple tiers. Drivers can be headcount, floor area, revenue, custom metrics from your ERP — or combinations. The engine recalculates when drivers change.
Every allocated amount links back to its source pool, driver value, and allocation rule version. Close reviewers and external auditors get the lineage they need, not a black box.
Allocation rules can change mid-year without corrupting prior periods. Support for step-down, simultaneous, and tiered methodologies in the same model.
Ownership percentages can change within a period. Acquisition date consolidation, partial-year weighting, and step acquisitions are handled by the engine — not by your spreadsheet formulas.
IC trading eliminations, upstream/downstream profit-in-inventory, dividend eliminations, and IC loan eliminations — all configurable, all auditable. Not a workaround, a proper IC matrix.
Non-controlling interest calculated automatically from the ownership tree. Changes in NCI during the period are reflected without manual journal adjustments or special-case formulas.
Functional-to-presentation currency translation at closing rates, average rates, or historic rates by account type. Goodwill and acquisition adjustments tracked at entity level.
Pull from SAP ECC & S/4HANA, Microsoft Dynamics 365 F&O and Business Central, and ERPNext through their OData / REST interfaces (BAPI/RFC for SAP), orchestrated by Airbyte. Incremental sync, schema drift, and retries are handled for you. More sources in the works.
Financial dimensions, legal entities, and the COA flow automatically into Konsolidat's consolidation model. Mapping tables harmonize structures across heterogeneous ERPs without manual maintenance.
Incremental syncs keep your consolidation model current through the close period — not dependent on a once-nightly batch. Variance to prior day is always available.
Consolidate a group where one division runs SAP, another runs Dynamics, and an acquisition runs ERPNext. The integration layer normalizes account structures before anything hits the engine.
Designed around what finance teams actually do during a monthly, quarterly, and annual close — not around what looks good in a demo.
Multi-entity, multi-currency consolidation with full elimination logic, NCI attribution, and ownership-tree-driven grouping.
Driver-based, cascading, and reciprocal allocations with iterative solving. Full traceability from allocated cent back to source pool.
Driver-based budget models, rolling forecasts, and scenario management — all accessible via =EPM() in your existing workbooks.
Actual vs Budget, Actual vs Prior Year, and Forecast vs Target — pre-built and customizable across any dimension in your model.
Automated IC matching, elimination rules, and reconciliation status — not a manual matching spreadsheet passed around by email.
Functional, presentation, and reporting currencies. Translation differences, currency adjustments, and rate management built in.
P&L, Balance Sheet, and Cash Flow statement templates. Custom report definitions pull live from the backend via =EPM().
Every consolidation step is version-controlled SQL — 44 dbt models, 26 automated tests. Trace any figure back through its transformation lineage. The code is the documentation.
2FA, role-based access control, session management, and full audit logging built into the application layer. SSO & LDAP ready for enterprise identity.
MIT license. Full source code. dbt models you can fork. REST API for custom integrations. No module gates or add-on fees.
Every other platform is a closed SaaS you rent — the model, the data, the roadmap, all on the vendor’s terms. Konsolidat gives you the whole application to run on your own infrastructure, inspect, fork, and own.
| Ownership & openness | Konsolidat | OneStream | CCH Tagetik | Anaplan | Oracle EPM | SAP BPC | Workday |
|---|---|---|---|---|---|---|---|
| Open source (MIT licence) | ✓ | ✗ | ✗ | ✗ | ✗ | ✗ | ✗ |
| Full source-code access | ✓ | ✗ | ✗ | ✗ | ✗ | ✗ | ✗ |
| Inspect & audit every calculation | ✓ | ✗ | ✗ | ✗ | ✗ | ✗ | ✗ |
| Run on your own infrastructure | ✓ | ⚠ | ✗ | ✗ | ✗ | ⚠ | ✗ |
| Version-controlled in Git (dbt) | ✓ | ✗ | ✗ | ✗ | ✗ | ✗ | ✗ |
| Fork & extend the core engine | ✓ | ✗ | ✗ | ✗ | ✗ | ✗ | ✗ |
| $0 licence · no per-user fees | ✓ | ✗ | ✗ | ✗ | ✗ | ✗ | ✗ |
| No vendor lock-in | ✓ | ✗ | ✗ | ✗ | ✗ | ✗ | ✗ |
Konsolidat is MIT open source. Run it yourself for zero license cost, or let us host and operate it for you. Either way, you're not signing a seven-figure enterprise EPM contract.
Deploy on your own cloud or on-prem. Full source code, every module, no per-user fees — ever.
We run and operate the ClickHouse + dbt backend. Your team just opens Excel. Scoped to your group, your ERPs, your scale.
Honest estimates for a 10–500 user enterprise group over a three-year horizon — licensing, implementation, and time-to-value. You're comparing $0 to seven figures.
| Capability / Cost Factor | Konsolidat | OneStream | Tagetik / SAP | Anaplan | DIY Excel |
|---|---|---|---|---|---|
| 3-Year Licensing Cost | $0 (MIT) | $1.5M–$4M | $1.2M–$3.5M | $900K–$2.5M | $0 |
| Implementation Cost | Low–Moderate | $500K–$1.5M | $600K–$2M+ | $400K–$1.2M | $0 (in-house) |
| Time-to-Value | Weeks–3 months | 12–24 months | 12–18 months | 6–12 months | Immediate (limited) |
| Excel-Native UX | ✓ Native | ⚠ Limited add-in | ⚠ Limited | ✗ No | ✓ Native |
| Reciprocal Allocations | ✓ Built-in solver | ✓ | ✓ | ⚠ Complex config | ✗ Manual |
| ERP-Native Integration | ✓ SAP · Dynamics · ERPNext | ⚠ Connector needed | ⚠ Connector needed | ⚠ ETL required | ✗ Manual export |
| Dynamic Ownership / NCI | ✓ Engine-driven | ✓ | ✓ | ⚠ Limited | ✗ Manual |
| Full Audit Traceability | ✓ To source GL | ✓ | ✓ | ⚠ | ✗ |
| Source Code Access | ✓ Full MIT | ✗ | ✗ | ✗ | ✓ |
| Vendor Lock-in Risk | None | High | Very High | High | Person risk |
Self-hosted Konsolidat has no license fee. Your real cost is operational — roughly 0.3–1 FTE of a data engineer plus cloud infrastructure (ClickHouse + Airbyte). For a 10–500 user group that typically lands in the low five figures per year, versus seven figures in licensing alone for legacy EPM. The hosted option folds that operational cost into one predictable fee.
Cost estimates based on publicly available information and customer conversations. Actual costs vary by scope, user count, and negotiation. Implementation costs reflect typical enterprise deployments.
No proprietary black box. Every layer is best-in-class open source you can inspect, run, and own — from the application UI down to the warehouse.
Every close runs against an automated assertion suite. Green means the numbers reconcile. Red tells you exactly which row broke, and why — before anyone signs off.
data-quality assertions across eight categories, run on every pipeline build. Not a promise of correctness — a continuous proof of it.
Parent and subsidiary balances roll up correctly across every level of the ownership tree. Group totals equal the sum of their parts — no rounding drift, no double-counting, at any node of the hierarchy.
Cumulative Translation Adjustment — the FX gain or loss from translating foreign subsidiaries into the group's reporting currency lands in equity and balances, so the consolidated balance sheet still ties out after currency conversion.
Intercompany sales, loans, and dividends between group companies are fully removed on consolidation, so internal trading never inflates group revenue, profit, or assets.
Every cost pool distributes completely to its targets — the total allocated equals the total in the pool, with nothing lost, stranded, or counted twice as it cascades through multiple tiers.
Annual budgets spread across the twelve periods sum back exactly to the yearly figure — whether using an even split or a seasonally-weighted profile.
Actual-versus-budget and actual-versus-prior-year differences are computed with the correct sign and favorable / unfavorable logic for each account type.
Every entity's books stay balanced — total debits equal total credits in each period, before anything is consolidated.
Year-to-date balances accumulate consistently month over month, and posted journal entries reconcile to the movements they create.
Enterprise groups — 10 to 500 finance users — running SAP, Microsoft Dynamics, or ERPNext, with genuine consolidation complexity and a finance team that deserves better tooling.
You're not interested in EPM theory. You care about whether your team can produce consolidated financials that hold up under scrutiny, without a six-month implementation project every time the group structure changes.
You've inherited a set of Excel models that work — until someone leaves, or the entity count changes, or the board asks for a new cut of the data. You need a system that handles the complexity you have, not the complexity that's convenient to demo.
Your clients ask about EPM and you're stuck recommending a seven-figure tool that takes 18 months to implement — or admitting the gap. Konsolidat gives you an open, extensible EPM layer you can deploy, customize, and own. Your clients benefit. So does your margin.
These are concrete, scoped builds — not a vendor's "maybe next year." And because it's open source, you can build them yourself, or we build them with you.
The architecture is modern. The experience is familiar. You don't need to rebuild your finance team's workflow.
OData, BAPI/RFC & Airbyte pull actuals, dimensions, COA, and entity structure. Incremental syncs keep it current through close.
SAP · Dynamics · BC · ERPNextdbt models normalize data and build the consolidation model, ownership tree, IC matrix, and allocation pools in ClickHouse.
dbt · ClickHouseConsolidation, eliminations, currency translation, NCI, and allocations execute in the engine — not in your spreadsheet.
Consolidation · Allocation Engine=EPM() formulas pull live results into your existing workbooks. Format, chart, and distribute as you always have.
=EPM() · Excel Add-inA repeatable implementation path — design the output first, model the data, wire up the ERPs, then configure, extract, and verify. Most of it is version-controlled SQL, so every step is reviewable and repeatable.
Start from the output. Define the target trial balance — chart of accounts, entity structure, and reporting hierarchy your consolidation must produce.
Model the analytical layer: fact tables (GL entries, balances), dimensions (entity, account, period, cost center, currency), and the =EPM() measures finance will query.
Wire up source connectors — SAP, Microsoft Dynamics, Business Central, ERPNext — via OData, BAPI/RFC, and Airbyte. Map each ledger's COA and dimensions into the model.
Define consolidation groups, ownership periods, IC elimination rules, allocation rules & drivers, scenarios, and budgets in the app — a secure web UI with 2FA, role-based access, and audit logging. The app generates the dbt pipeline for you.
Run the initial Airbyte sync to pull actuals, dimensions, and structures into ClickHouse. Schedule incremental syncs to keep the model current through close.
Reconcile consolidated outputs against known balances, validate eliminations and allocations, and run the automated dbt test suite. Sign off before go-live.
Finance owns the model. Every rule, structure, and input is managed through the application's web UI — no hand-edited files, no developer in the loop for day-to-day changes.
Yes. Konsolidat is MIT open source, so the self-hosted edition has no license fee — run it on your own infrastructure with full access to the source code. A fully managed hosted option is also available; contact us for pricing.
SAP (ECC & S/4HANA), Microsoft Dynamics 365 Finance & Operations and Business Central, and ERPNext — connected through each system's OData / REST API and orchestrated with Airbyte. More sources are in progress.
It's open source and Excel-native, built on a ClickHouse + dbt backend, with roughly 90% lower total cost of ownership and no vendor lock-in. It isn't a feature-for-feature replacement in every niche — it's a lower-risk alternative for most mid-market-to-enterprise finance teams.
Yes. Results are delivered through =EPM() worksheet functions, so your finance team keeps the spreadsheets and workflow they already use — there's no new UI to relearn.
Multi-entity IFRS / GAAP consolidation (FX translation, CTA, intercompany elimination, NCI), driver-based and reciprocal cost allocations, budgeting with seasonal spreads, and variance analysis — all validated by 26 automated tests on every run.
Yes. The application layer provides 2FA, role-based access control, session management, and full audit logging, and is SSO & LDAP ready for enterprise identity providers.
Book a 30-minute technical demo. We'll show you a real consolidation model — including reciprocal allocations and NCI — not slides.