Konsolidat¶

Open-source Enterprise Performance Management for Dynamics 365 Finance & Operations

44 dbt Models

26 Data Tests

1 Excel Function

6 API Endpoints

For 27 years, CPM vendors have tried to move financial analysis out of Excel and into web browsers. We think they're wrong. Excellent analysis thrives on Excel — not on the web. Konsolidat keeps it there.

Multi-entity consolidation, budgeting, allocations, and variance analysis — powered by =EPM() in the spreadsheet your finance team already knows.

Consolidation FX Translation Allocations Budgeting Variance Excel Native IFRS / GAAP MIT License

Book a Demo

How It Works¶

REPORTING

Excel-Native Financials¶

=EPM("USMF", 2024, "Q1", "401100")
=EPM("USMF", 2024, "FY", "601100")
=EPM("GRP", 2024, "Q1", "401100")

CONSOLIDATION

Multi-Entity IFRS Close¶

Entity trial balances
  → FX translation (closing/average)
  → CTA calculation
  → NCI split (ownership %)
  → IC elimination
  → Consolidated TB

ALLOCATION

Driver-Based Cost Allocation¶

Step 1: IT costs   → by headcount
Step 2: Facilities → by sqm (+cascade)
Step 3: Management → by revenue (+cascade)

BUDGET

Layered Budgeting & Variance¶

base + challenge + management + board
  → Spread profiles (even, seasonal)
  → 12 monthly periods
  → Actual vs budget variance
  → Write-back from Excel (EPMSAVE)

Architecture¶

graph LR
    D365[D365 F&O<br/>OData] -->|Airbyte ELT| CH[(ClickHouse<br/>Columnar DW)]
    CH -->|dbt Core| Bronze[Bronze<br/>14 models]
    Bronze --> Silver[Silver<br/>8 models]
    Silver --> Gold[Gold<br/>22 models]
    Gold -->|Frappe API| Frappe[Frappe / Konsol<br/>Settings & Auth]
    Frappe -->|HTTP JSON| Excel[Excel VBA<br/>=EPM formulas]
    Frappe -->|Office.js| Taskpane[Excel Task Pane<br/>Pipeline Control]

D365 F&O Airbyte ClickHouse dbt Core Frappe Excel VBA Office.js

vs. Commercial CPM¶

	Tagetik	OneStream	Anaplan	Konsolidat
Consolidation	Native	Native	Add-on	Native
FX + CTA + IC elim	Native	Native	Manual	Native
Budget write-back	Native	Native	Native	Native
Variance analysis	Native	Native	Native	Native
Excel-native	Plugin	Plugin	No	=EPM()
D365 integration	Connector	Connector	Via API	Native OData
Workflow/approvals	Native	Native	Native	Native
SOX / regulatory	Yes	Yes	Yes	No (not targeted)
Web UI	Full	Full	Full	Admin only
3-Year TCO (~50 users)	$200–500K	$300–700K	$700K–1.4M	$20–55K

Full comparison with pricing sources and gap analysis →

See How You Save 90% — Book a Call

Security¶

IDENTITY

Authentication¶

Microsoft Entra ID (Azure AD) SSO
  → OAuth2 / OpenID Connect
  → MSAL.js for Excel Add-in
  → Frappe 2FA (TOTP) per role
  → API key + Bearer token

ACCESS

Role-Based Control¶

Reader     → view reports only
Planner    → submit budgets
Controller → edit rules, approve
Admin      → full config + users

NETWORK

Transport & Isolation¶

TLS everywhere (auto Let's Encrypt)
ClickHouse: private network only
CORS whitelist for Office 365
Rate limiting: 100 req/min/user

AUDIT

Compliance & Logging¶

Field-level change tracking
Budget approval workflow trail
API access logging per user
Encryption at rest + in transit

Book a 30-Min Demo

Explore the Docs¶

Features Everything Konsolidat does — consolidation, allocations, budgeting, reporting Quickstart Zero to first =EPM() value in 15 minutes Setup Guide Full deployment with D365, Airbyte, dbt, Frappe Configuration All settings, env vars, dbt variables Excel VBA Guide =EPM() function, macros, report patterns Consolidation FX translation, CTA, NCI, IC elimination API Reference 3 endpoints — epm_value, epm_batch, health Data Dictionary 44 dbt models, 11 seeds, full lineage Developer Guide Extending models, macros, API, contributing Deployment Production setup, monitoring, operations Cost Comparison vs Tagetik, OneStream, Anaplan Security Architecture, auth, data protection

Ready to cut your CPM costs by 90%?

30-minute call. No slides. We'll show you the live stack.

Book Your Demo Now