Consolidate financial data from multiple companies
Company consolidation in Business Central: combining general ledger data from subsidiaries or business units into a consolidated company. It answers questions about what consolidation supports (different charts of accounts, currencies, fiscal years, environments) and how to set it up, simply or in advanced mode.
- 2Learn pages
- 2videos
- 6AL objects
Path: Business functionality > Finance > Multi-site and international organizations > Consolidate financial data from multiple companies · tier official · system finance · narrative reviewed (checked by Opus)
Overview
Company consolidation lets you bring financial data from several subsidiaries or business units into one consolidated company. It handles differences between the source companies, including charts of accounts, currencies, fiscal years and environments. Related topics include eliminations, currency exchange rates, G/L account mapping and file-based transfer.
The section has two pages. The first, “Consolidate data from multiple companies”, explains the concept and what the process supports. The second, “Set up company consolidation”, covers configuration, with either a simple assisted setup or an advanced manual setup that includes business units, account mapping, exchange rates, currency translation and dimension consolidation.
Start with the overview page to understand the scenario and its capabilities. Then use the setup page to configure consolidation through either the assisted setup or the advanced manual setup.
Key points
- Consolidates general ledger entries from multiple subsidiaries or business units into a consolidated company.
- Supports different charts of accounts, currencies, fiscal years and environments.
- Setup can be a simple assisted setup or an advanced manual configuration.
- Advanced setup covers business unit setup, G/L account mapping, exchange rates and currency translation.
- Dimension consolidation is part of the setup.
- Eliminations are part of the consolidation process.
- File-based transfer is one of the supported consolidation options.
Learn pages
- Consolidate data from multiple companies: This article explains how you can consolidate the general ledger entries of two or more separate companies (subsidiaries) into a consolidated company.
- Set up company consolidation: Learn how you can configure how data from different companies in Business Central is reported into a consolidation company.
Videos and posts
Linked by a Haiku matcher with a grounding quote from the item’s summary (link/topics.ts); machine-generated.
- What’s New: Financial Management - Consolidation Improvements (2024 release wave 1) (video): “consolidation; currency exchange rates; consolidation status; balance sheet revaluation; multi-subsidiary”
- What’s New: Cross-Environment Consolidations (2023 release wave 2) (video): “Cross-environment consolidation; Consolidation wizard; API endpoint configuration”
Business Central pages and reports
The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.
- Page 240 “Business Unit List” · captioned “Business Units” · on Table 220 “Business Unit”
- Page 1827 “Business Units Setup Subform” · on Table 1827 “Business Unit Setup”
- Report 16 “G/L Consolidation Eliminations”
- Report 17 “Consolidated Trial Balance”
- Report 18 “Consolidated Trial Balance (4)”
- Report 4410 “EXR Consolidated Trial Balance” · captioned “Consolidated Trial Balance (Excel)”
Learn also names 1 object with no object page: page/1826.
Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.