Setup step on the Consolidate online page · Consolidations
Run the online consolidation
Use this page to consolidate daily balances for selected accounts and dimensions into the consolidation company, and to review, rerun or reverse earlier consolidation runs.
SETUP GUIDEHow to set it up7 sections. Choose a role to highlight what matters to you.
Everyone
1What it is and why
What it is
A periodic page in the consolidation company where you run online consolidations of legal entities and keep a history of each run.
What you do here
Use this page to consolidate daily balances for selected accounts and dimensions into the consolidation company, and to review, rerun or reverse earlier consolidation runs.
Example
For example, BEAT's consolidation company runs a template that consolidates its two subsidiaries for 1 to 31 October 2026 with Rebuild balances on, and the Consolidation history tab then shows one line for each of the two legal entities.
The page in Dynamics 365. page title tab to open what to set or check
About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.
Setup steps on this page
Run the online consolidation
Use this page to consolidate daily balances for selected accounts and dimensions into the consolidation company, and to review, rerun or reverse earlier consolidation runs.
Steps from Microsoft
Go to Consolidations > Consolidate online.
On the Action Pane, select Perform consolidation.
In the From and To fields, enter the date range for the consolidation.
In the Template field, select the consolidation template.
Optionally set Rebuild balances during consolidation process to Yes and edit the Description.
To run the consolidation as a batch job, set Batch process to Yes.
Select OK, then review the new record on the Consolidation history tab.
Free-text notes about a run or its review, editable until the record is marked Reviewed.Microsoft Learn
Reviewed with the auditors
Reviewed
Marks a consolidation record as reviewed, after which notes can no longer be entered.Microsoft Learn
Yes
Show reversed
Includes reversed consolidation records in the grid.Microsoft Learn
No
Common errors and fixes
Message
What to do
The consolidation stops with an error because account numbers don't correspond
With a shared chart of accounts set Use consolidation account to No; otherwise set the Consolidation account on each subsidiary main account, or use a consolidation account group, and set Use consolidation account to Yes. Microsoft Learn
The trial balance doesn't show the consolidated balances
Run Rebuild balances for the consolidation period, or set Rebuild balances during consolidation process to Yes when you perform the consolidation. Microsoft Learn
The trial balance of the consolidation company shows doubled balances after a consolidation stopped part-way
Run Consolidations > Detect and recreate missing consolidation transactions for that period, then review and remove the incomplete transactions on Consolidation transactions. Microsoft Learn
Consolidation templates can't be selected on Perform consolidation
Turn on the Consolidate online using templates feature in Feature management, then set up the templates from the Action Pane of Consolidate online. Microsoft Learn
Opening balances are missing in the consolidation company
Only operating balances are consolidated. Run the year-end close in the consolidation company to get opening balances there. Microsoft Learn
Test checklist
In the consolidation company, select Perform consolidation, pick the template and a one-month From/To range, and set Rebuild balances during consolidation process to Yes.
Check that the Consolidation history tab shows one line per legal entity with the template and dates.
Open Transactions > Actuals for one line and compare the total with that company's trial balance for the month.
Select Reverse transaction on a test run and check Show reversed lists it with a Reversed date/time.
Run one template per consolidation company and period, with Rebuild balances during consolidation process set to Yes, and mark each run Reviewed after checking it.The rebuild limited to the From and To dates keeps the trial balance right, and Reviewed records closes the notes for audit while Reverse transaction stays possible.
Consolidate online using templates (Needed for templates)Performance enhancement for large consolidations (Optional, for batch runs)
Licence or add-in
Consolidations is part of General ledger in Dynamics 365 Finance. In this system Accountant, Accounting manager, Accounting supervisor, Chief financial officer and Financial controller hold the consolidation duties. The accountant runs the consolidation and marks it Reviewed; the controller reviews it.
Across legal entities: it runs in the consolidation company and collects the legal entities named on the template, each with its ownership percentage. Microsoft Learn
Can it be undone
Reversible: Reverse transaction removes a run's transactions, even for reviewed records; Rerun consolidation reprocesses it.
If you change it later
Consolidated balances do not follow source changes automatically; you must run the consolidation again whenever the source legal entities change, and a rerun removes and reprocesses the earlier run's transactions. Microsoft Learn
Developer
6Developer
Data migration
Load order: Consolidate online has no data entity in Data management, so it can't be loaded from a file or a configuration template. Consolidated balances are results, not master data: run the consolidation again in the new environment after the source companies' balances are there.Checked in Dynamics 365