Financial Consolidation & Multi-Entity Reporting for Business Central

Key Features

Cross-company consolidation within a single Business Central tenant, plus cross-environment collection of separate BC instances via the REST/OData v4 API

Configurable account mapping from each subsidiary chart of accounts to a unified group consolidation chart

Multi-currency translation with per-statement rate types (closing rate for balance sheet, average rate for P&L) and an automatic currency-translation adjustment

Currency revaluation handling for foreign-denominated balances at period close

Rule-based intercompany elimination entries (IC receivables/payables, IC revenue/cost, IC investment vs equity) generated for review before posting

Ownership-percentage and minority-interest (non-controlling interest) calculation per subsidiary

Consolidated balance sheet, income statement and equity-movement statements via Account Schedules / Financial Reporting layouts

Full drill-down from any consolidated line to the source company's posted G/L entries

Job-queue scheduling for automated period-end collection and translation runs

Dedicated permission sets separating consolidation operators, reviewers and administrators

Period-lock and run-versioning so each consolidation cycle is reproducible and auditable

Optional Power BI reporting through Dataverse / Power Platform integration on the consolidated dataset

Delivered as a per-tenant (private) AL extension built with table/page extensions and event subscribers — no shared AppSource multi-tenant app

Reconciliation log highlighting unmapped accounts, missing exchange rates and unbalanced eliminations before sign-off

Built to order, done for you

No DIY setup — a working app, built, installed and supported by ECOSIRE.

You order

Start with a one-time build price. We scope it with you at kickoff.

We build & install

ECOSIRE builds, configures and installs it on your Dynamics 365 Business Central.

Go live + support

You go live in about 2–4 weeks, with a post-launch support window.

About this Product

Group controllers who run more than one Business Central company — or several separate BC environments — usually end up consolidating in spreadsheets every month. This extension moves that work into Business Central itself.

ECOSIRE designs, builds and installs a per-tenant AL extension on your Business Central environment (cloud SaaS or on-premises). It is not a one-click AppSource download — it is a build-to-order solution, scoped to your chart-of-accounts mapping, ownership structure and reporting calendar, then deployed and supported by our team.

The extension collects trial-balance and G/L data across companies in the same tenant and, where entities live in separate environments, pulls them in through the Business Central REST/OData v4 API into a consolidation workspace. Source-currency balances are translated using configurable rate types (closing rate for the balance sheet, average rate for P&L) with a calculated currency-translation adjustment. Intercompany balances and transactions are eliminated automatically through rule-based elimination entries you review before posting. Partial ownership is handled with ownership-percentage and minority-interest calculations per subsidiary.

Output is a set of consolidated financial statements — balance sheet, income statement and equity movement — with drill-down from any consolidated line back to the originating company's G/L entries. Account-schedule / Financial Reporting layouts are provided so finance can refresh figures on demand. Long-running collection and translation runs are scheduled through the BC job queue; access is governed by dedicated permission sets; and consolidated datasets can optionally surface in Power BI via Dataverse / the Power Platform. Everything is delivered as your private extension — no shared multi-tenant app, no data leaving your environment.

What you get

A per-tenant Business Central AL extension (.app) built to your group structure, installed on your sandbox then production environment by ECOSIRE

Account-mapping configuration linking each subsidiary's chart of accounts to your group consolidation chart

Configured currency-translation rate types and intercompany elimination rule set for your entities

Consolidated balance sheet, income statement and equity-movement Financial Reporting / Account Schedule layouts with drill-down

Permission sets and job-queue entries configured for your finance team's roles and period-end calendar

Source-controlled AL codebase, deployment package and technical documentation handed over to you

Knowledge-transfer session for your finance and admin users plus a written run-book for the monthly close

Who this is for

Group Controller / Finance Manager

Runs the monthly group close across several subsidiaries and wants consolidation, eliminations and currency translation done inside Business Central instead of in error-prone spreadsheets.

Group CFO

Needs reliable, drill-down consolidated statements with minority-interest handling for board and lender reporting, and an auditable, repeatable process each period.

Business Central Administrator

Owns the tenant and must keep consolidation logic governed by permission sets, scheduled through the job queue, and delivered as a controlled per-tenant extension rather than ad-hoc customizations.

How Financial Consolidation & Multi-Entity Reporting for Business Central Compares

Criterion	ECOSIRE	Custom Build	Competitor
Automated multi-company & cross-environment consolidation	Included	Partial support	Partial support
Multi-currency translation with closing/average rate types and translation adjustment	Included	Partial support	Partial support
Rule-based intercompany elimination entries with review-before-post	Included	Partial support	Partial support
Minority interest / non-controlling interest by ownership percentage	Included	Partial support	Partial support
Drill-down from consolidated lines to source company G/L entries	Included	Partial support	Partial support
Built, installed and supported on your tenant by the vendor	Included	Not included	Not included
Tailored to your exact ownership structure, account mapping and close calendar	Included	Included	Not included
Delivered as a governed per-tenant extension (permission sets, job queue, source handover)	Included	Partial support	Partial support

Frequently Asked Questions about Financial Consolidation & Multi-Entity Reporting for Business Central

How long does delivery take, since this isn't an instant AppSource download?

This is a build-to-order extension, not a one-click marketplace install. After a short scoping call to capture your entity structure, ownership percentages, currencies and account mapping, typical delivery is around 3 to 5 weeks: we build and test the AL extension in a sandbox, validate a full consolidation run against your data, then install it on production. The exact timeline depends on the number of entities and whether any sit in separate Business Central environments.

What does ongoing support and updates look like after install?

ECOSIRE installs the extension as your private per-tenant app and supports it after go-live. Because Microsoft ships major Business Central updates twice a year, we test the extension against each upcoming release and provide compatibility updates so it keeps working through platform upgrades. Bug fixes, configuration changes (new entity, changed ownership, new currency) and a defined support window are covered under the support arrangement agreed at handover.

Does my financial data leave my Business Central environment?

No. The extension runs inside your own tenant. Cross-environment collection uses the Business Central REST/OData API authenticated against your tenants, and consolidated data stays in Business Central. Optional Power BI reporting flows through your own Dataverse / Power Platform — there is no shared ECOSIRE multi-tenant database and no third-party data hosting.

Can it consolidate companies that live in completely separate Business Central environments?

Yes. Companies within the same tenant are read directly. Subsidiaries in separate BC environments are collected through the REST/OData v4 API into the consolidation workspace, so a group spread across multiple tenants or on-premises instances can still be consolidated into one set of statements.

How are intercompany eliminations and minority interest handled?

You configure elimination rules for intercompany receivables/payables, revenue/cost and investment-versus-equity. Each consolidation run generates proposed elimination entries that finance reviews before posting, with a reconciliation log flagging anything unbalanced. Minority interest is calculated from the ownership percentage you set per subsidiary, so non-controlling interests appear correctly in equity and net income.

Cloud SaaS or on-premises — which Business Central deployments are supported?

Both. The extension is built in AL and installed as a per-tenant extension on Business Central online (SaaS) or on a Business Central on-premises deployment. We confirm your version during scoping and target a currently supported release.