BeyondERP.Newsletter
Menu

Job page · Consolidations

Consolidate with import

A periodic page in the consolidation company that imports balances from a source file into the consolidation company.

Business process
Consolidate and eliminate financials
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA periodic page in the consolidation company that imports balances from a source file into the consolidation company.
What you do hereUse this page to consolidate legal entities whose data is held outside this instance: select the legal entities and browse to the source file that contains their data.
ExampleFor example, BEAT's US subsidiary runs on another instance and sends its October 2026 export file; BEAT's consolidation company imports it here as Balance with exchange rate type Average and compares the totals with the file.
Consolidate with import page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

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.

When to run it

When to run itAt each consolidation period end, after the subsidiaries in another instance or system have exported their balances.
How oftenOnce per consolidation period, and again whenever a source company changes its balances.
Batch settingsRun it interactively for a few files; use the background for many legal entities or long periods.
What the output showsConsolidation transactions in the consolidation company for each source legal entity and period, visible on the Consolidations page and in the trial balance. Missing accounts usually mean the Main account range or the file did not include them; translation differences point to the exchange rate type.

Source: Microsoft Learn

Setup steps on this page

Import subsidiary balances

Use this page to consolidate legal entities whose data is held outside this instance: select the legal entities and browse to the source file that contains their data.

Steps from Microsoft

  1. Go to Consolidations > Consolidate with import.
  2. Work in the consolidation company: the legal entity must have Use for financial consolidation process selected, or the page doesn't open.
  3. On the Criteria tab, enter a Description, the Main account range, the Consolidation period, and set Include actual amounts or Include budget amounts (with Budget models and Budget rate type).
  4. On the Legal entities tab, select New, choose the Source legal entity and browse to the file that holds its exported balances.
  5. If the source uses another accounting currency, set the Currency translation tab, select OK, and then compare the trial balance of the consolidation company with the source totals.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Main account rangeThe main accounts to import; leave blank for all.Microsoft Learn 100000 to 899999
Consolidation periodThe from and to dates of the period being consolidated.Microsoft Learn 10/1/2026 to 10/31/2026
Include actual amounts / Include budget amountsWhether actual and budget amounts are consolidated; budgets also need Budget models and Budget rate type.Microsoft Learn Actual
Source legal entity and fileThe subsidiary and the export file that holds its balances.Microsoft Learn
Profit and loss / BalanceWhich part each file holds; select one per file, not both.Microsoft Learn Balance
Currency translationThe exchange rate type used for each subsidiary.Microsoft Learn Average

Common errors and fixes

MessageWhat to do
The consolidation stops with an error because account numbers don't correspondWith 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
Opening balances are missing in the consolidation companyOnly operating balances are consolidated. Run the year-end close in the consolidation company to get opening balances there. Microsoft Learn
The page doesn't openWork in the consolidation company; the legal entity must have Use for financial consolidation process selected. Microsoft Learn

Test checklist

  1. Trial balance totals per source company match the exported file.
  2. Accounts in foreign currency are translated with the expected exchange rate type.
  3. No source legal entity is missing for the period.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Import subsidiary balancesOne file per source legal entity and period, marked Profit and loss or Balance, with the exchange rate type set on Currency translation.Each file can be either Profit and loss or Balance, not both, and the exchange rate type decides the translated amounts.Import, or move the subsidiary to this instance?Importing a file twice for the same period without removing the earlier transactions.Test: Imported balances match the file

Feature management and licence

Licence or add-inConsolidations 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 group accountant imports the subsidiaries' files. No Feature management feature is needed for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyAcross instances: brings legal entities whose data is outside this instance into the consolidation company, one file per source legal entity. Microsoft Learn
Can it be undoneYes, rerun: Select Remove the transactions on the Consolidations page, or run the import again, to replace the consolidated balances. Correct remaining differences with Closing period adjustments. Microsoft Learn
If you change it laterCreates consolidation balances in the consolidation company from the imported file; rebuilding balances during consolidation clears and recreates them. Microsoft Learn
Developer

6Developer

Data migrationLoad order: Consolidate with import has no data entity in Data management, so it can't be loaded from a file or a configuration template. It is itself the way to move balances between instances: export them with Export company balances and import the file here.Checked in Dynamics 365
Everyone

7Sources