Financial Analytics · Finance Data Warehouse

Your reports disagree because each one reads its own copy of the ledger. We build the one layer they all read from.

A governed finance data warehouse for multi-entity groups, on any ERP, planning system and data platform, with controls that check the numbers on every load.

Controls & Data Quality, one load

Journal balance

Pass

Sub-ledger tie

Pass

Layer integrity

Pass

Elimination integrity

Pass

FX divergence

Pass

Data quality

3 items disclosed

Illustrative statuses for one load. Each control is computed against the warehouse on every load; names and definitions follow the Controls & Data Quality view.

At our largest finance reference, a global professional services group with 324 legal entities

4 daysfaster monthly close (measured)
13,400estimated hours a year of variance commentary, now written by the AI layer
$57Mcash released by a receivables and work-in-progress programme on the platform
90 daysto first release, six months to full production

Read the case study →

What is inside

Eleven report views on one governed layer

AreaWhat the views showReport views

The income statement and balance sheet on each ledger layer with the reconciliation control, and ERP revenue to consolidated revenue, leg by leg.

Statements & Reconciliation, Consolidated Revenue Bridge

Growth and profitability by entity, margin by department and office with the loss-makers in plain view, best and worst jobs with billing realisation, and where the return on capital comes from.

Group Performance, Department & Office P&L, Job & Client Profitability, Entity ROIC

Work in progress that ties to the general ledger and work never billed, receivables ageing with trade separated from intercompany, and payables by vendor tied to the control account.

Work in Progress, Receivables, Payables

Budget, forecast and actual side by side, variance by driver and the full-year outlook.

Budget, Forecast & Outlook

Controls and the AI layer

Six controls computed against the warehouse, and natural-language questions and variance commentary on the certified numbers.

Controls & Data Quality, with the AI layer on top. Tie-Out →

For manufacturers

The same layer carries SG&A with allocations, product and customer margin, order to cash and inventory. See all five areas →

The situation

Where one finance number turns into three

Three values

Every team pulls its own extract from the ERP, so the same number has three values depending on who you ask.

Raw tables

Reports were built straight on raw tables, and when the auditor asks which transformation produced a figure, nobody can say.

Acquisitions

An acquisition means months of mapping before the new business shows up in the group numbers.

The platform

The group already runs a data platform, and finance still does not sign from it. Every team has its own Excel jockeys, rebuilding the same numbers their colleagues in the next entity are rebuilding at the same time.

What the controls prevent

Four ways consolidated numbers go wrong while looking right

Layers added up

The ERP layer and the consolidation layer hold the same transactions, so adding them together counts every transaction twice. Layer integrity catches it.

A plain join

A plain join on entities drops the elimination entities and overstates group revenue. Elimination integrity catches it.

The wrong key

Joining on the wrong account key moves amounts to the wrong lines. One conformed account key prevents it.

Manual adjustments

Leaving out the adjustments made in the group planning platform means the warehouse never matches the signed number. They load as their own ledger layer, reconciled and kept with their source.

The architecture

How the layers fit together

Every ERP and the group planning platform load into the warehouse. A reconciliation control compares them on every load. Reports and the AI layer read only from the presentation layer, so each one starts from the same certified numbers.

ERPsGroup planningplatformEvery instance, plusentities on filesConsolidation and planningReconciliation controlon every loadGoverned ledgerOne entity key across every sourceRawStagingCuratedPresentationLoads from every source, as postedConformed to one entity keyReconciled and checked every dayCertified finance modelsReportsAI layerP&LSG&ABalance SheetWorking CapitalReconciliation & CloseForecastingNatural-language questionsVariance commentaryAudit trail and lineage back to the posting, on every layer

Underneath, every entity carries the same code in every system, with one chart of accounts and column-level lineage generated by the build. Infrastructure is defined in code, every change moves through one deployment pipeline, and access runs on federated identity with no stored secrets. At our largest reference: 500+ tables from six systems, and the monthly full load from about 50 to about 12 hours.

Why build it

More results on the same pattern

Global manufacturing group, after a major acquisition

An estimated 1,570 person-days of manual finance work taken back every year, direct ERP ingestion in place of a manual extract relay, and more than 80% of data objects shared across reporting domains. Read the case study →

Global financial trading institution

Legal entity hierarchies mastered: 500,000+ master data records in 12 weeks, with zero trading disruption. For finance, that meant faster consolidation, KPIs comparable year on year and better financial planning. Read the case study →

The first release is the start. The same layer carries a catalogue of 33 use cases, from one master record for clients, vendors and entities to acquisition onboarding and automated tax reporting, each a small project with its own business case. Get all 33 use cases as a PDF →

Works with

Built on the systems you already run

Nothing needs replacing first.

ERPs

SAP S/4HANA and ECC, Oracle Fusion Cloud ERP and E-Business Suite, Microsoft Dynamics 365, NetSuite, Infor, Sage and Maconomy, plus entities that still report on files.

Planning and consolidation

OneStream, Oracle Hyperion and EPM Cloud, Anaplan, SAP BPC, Workday Adaptive Planning, CCH Tagetik, Board and Jedox.

Operational systems

CRM, warehouse management, project management, and HR and payroll, such as Salesforce, SAP EWM, Jira and Workday.

Data platform

On-premise SQL Server or Oracle, Databricks, Snowflake, BigQuery, Microsoft Fabric, Azure Synapse and Amazon Redshift.

Two ways to build it. We build the governed layer on the platform you choose. Or we build the finance data products inside the platform you already run, in its data catalogue and its deployment pipeline, and test the platform itself independently.

Questions

Questions a CIO asks.

Fit, ownership and delivery

Which systems and platforms do you work with?

The ones your group already runs. ERPs such as SAP, Oracle, Microsoft Dynamics 365 and NetSuite, planning systems such as OneStream, Oracle Hyperion and Anaplan, and data platforms on-premise or on Databricks, Snowflake, BigQuery and Microsoft Fabric. The layers, controls and deployment pipeline follow the same pattern on each.

Who owns the platform after the build?

You do. The hand-over includes the infrastructure code, the deployment pipeline, and the data catalogue and column-level lineage the build generates. The use-case catalogue then becomes your roadmap, and each item is a small project with its own business case.

How do you keep it SOX-compliant?

Infrastructure is defined in code, every change moves through one deployment pipeline, access is federated with no stored secrets, and every load leaves an audit trail. Our largest reference was built to SOX requirements from day one.

How long does it take?

At our largest reference, the first release went live in 90 days and full production followed in six months. The timeline scales with the entity count and the number of source systems.

Next step

Bring your source systems to a thirty-minute call.

We map where each finance number is built today, and what one governed layer underneath it would take. Every engagement starts with a fixed-price assessment of four to twelve weeks, typically EUR 15k to 60k. You talk to Michał Dębski, co-founder. How the assessment works

We reply within one business day.