Financial Analytics · Reconciliation & Close

Your close waits on a reconciliation done by hand. We make it run on every load.

Your ERPs, the group planning platform and intercompany, reconciled automatically on every load. Each difference is flagged with its source, and the audit evidence is written while the platform runs.

$1Reconciliation tolerance, on every load
4 daysFaster monthly close
50 to 12Hours for the monthly full load
90 daysTo first release
At a global professional services group with 324 legal entities. First release in 90 days, full production in six months.
The situation

Does this sound familiar?

What we build

Reconciliation that runs as a control

Five parts on one governed ledger. Two report views come with them: Statements & Reconciliation, and the Consolidated Revenue Bridge.

One entity key across every source

Each ERP instance, the group planning platform and every entity reporting on files map to one entity key and one chart of accounts. A difference always traces back to the entity that caused it.

A reconciliation control on every load

Each load compares the ERPs with the group planning platform, to the tolerance finance sets. Every row lands in one of four buckets: reconciled, adjustment, consolidation-only or outside the close window.

The revenue bridge, leg by leg

ERP revenue walks to consolidated revenue through close timing, consolidation-only entries, top-side adjustments and intercompany eliminations. The controller sees every reconciling difference, with its source, before signing.

Intercompany matched before the close

Intercompany pairs are matched automatically across entities, and eliminations are computed up the full hierarchy on every load.

Audit evidence as a by-product

Every load, every difference and every adjustment leaves a record, so the evidence an auditor asks for already exists when the audit starts.

What it looks like

From the ERP to consolidated revenue

Illustrative figures, millions. Axis starts at 300400+35+20+25−60420ERP grossClose timingConsolidation-only entriesTop-sideadjustmentsIntercompanyeliminationsConsolidatedrevenue

Close timing

Entries the ERP posted after the group cut-off, or loads that landed in a different period. They normally clear the following period.

Consolidation-only entries

Entries that exist only at group level. They are booked in the group planning platform and appear in no ERP.

Top-side adjustments

Adjustments group finance makes on top of the consolidated numbers, each one kept with its source.

Intercompany eliminations

Sales between entities of the same group, removed so the group reports only revenue earned outside it.

Illustrative figures. Each leg is a reconciling difference with a named source; the sign shows its direction.

Deliverables

What you get

Proof

What changed at two finance groups

Two groups with different starting points and the same pattern underneath. Client names stay under NDA.

Global professional services group

Maconomy and OneStream, reconciled on every load

  • Maconomy and OneStream reconcile on BigQuery on every load, to a one-dollar tolerance.
  • The monthly close runs four days faster.
  • The monthly full load fell from about 50 hours to about 12.
  • Audit evidence accumulates while the platform runs, built to SOX requirements from day one.

Read the full case study

Global manufacturing group

After a major acquisition

  • Month-end from weeks to days.
  • Intercompany eliminations run as rules during ingestion.
  • Daily snapshots make every variance traceable to the movement behind it.

Ask for a reference call under NDA

Platforms in our finance programmes: Maconomy · SAP · OneStream · SAP BPC · BigQuery · Microsoft Fabric · Power BI · dbt · Airflow · Terraform

Five areas, one ledger

Part of one ledger

Reconciliation is the first of five areas on one governed ledger. Once the close reconciles, the P&L, working capital and forecasting read the same numbers. Already run a data platform? We build the reconciliation on it.

Catalogue

Five plays from the catalogue for this area

Every play runs on the same governed ledger. Each one is a small project with its own return.

Payroll-to-GL reconciliation

Payroll reconciled to the general ledger automatically, with only the exceptions sent for review.

Value: recurring cost reduction

Management-reporting upload retirement

The monthly management-reporting upload replaced by a governed feed, loaded and validated automatically.

Value: recurring cost reduction

Close acceleration

Close status live per entity, with the automated reconciliations feeding the close checklist.

Value: recurring cost reduction

Intercompany matching

Intercompany pairs matched across entities, and mismatches flagged before the close starts.

Value: recurring cost reduction

SOX and audit evidence automation

Control evidence captured from reconciliations and workflows while the platform runs.

Value: recurring cost reduction

Questions

Questions a Group Controller asks.

Fit and scope

We already use a reconciliation tool. Why build reconciliation into the data platform?

Because the reports read from the same place. When reconciliation runs inside the governed ledger, the reconciled number is the one in the P&L, in the dashboards and in Excel. A reconciliation tool you keep for account sign-off can read from the same ledger.

We run more than one ERP, and some entities report on files. Does this still work?

Yes. Every ERP instance and every entity on a mapping file is brought onto the same entity key and chart of accounts, so each one reconciles the same way.

Proof and delivery

How do you prove to the auditors that the data matches the source?

Every load is reconciled and every difference is logged with its source, so the evidence builds up while the platform runs. Where a source system limits what can be extracted, consistency can be proven statistically. That is how our largest reference satisfied its SOX criteria.

How soon does the first reconciliation run?

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 last month's reconciliation to a thirty-minute call.

Your systems on the table, and an honest read on where the differences come from and what it takes to reconcile on every load.

We reply within one business day. No newsletter, no sequence.