BeyondERP.Newsletter
Menu

Job page · Consolidations

Export company balances

A periodic page that produces an export file of company balances for consolidation in another instance or system.

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

1What it is and why

What it isA periodic page that produces an export file of company balances for consolidation in another instance or system.
What you do hereUse this page to select the legal entities to export and set the file path for the output file.
ExampleFor example, BEAT's US subsidiary on another instance exports its October 2026 balances for main accounts 100000 to 899999 into one file for BEAT's consolidation company, and the message reports 412 records saved.
Export company balances 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 in the subsidiary instance, before the parent runs Consolidate with import.
How oftenOnce per consolidation period, and again whenever the subsidiary corrects its balances.
What the output showsOne export file per source legal entity with balances for the accounts, dimensions and period selected. A record count of zero or a missing account usually means the account range, period or consolidation account mapping is wrong.

Source: Microsoft Learn

Setup steps on this page

Export balances for the parent

Use this page to select the legal entities to export and set the file path for the output file.

Steps from Microsoft

  1. Go to Consolidations > Export company balances.
  2. On the Criteria tab, enter the Main account range (blank for all), and set Use consolidation account and Select consolidation account from when the parent uses another chart of accounts.
  3. Enter the Consolidation period dates and turn on Include actual amounts or Include budget amounts with the Budget models.
  4. On the Financial dimensions tab, choose which dimensions to transfer and how (Dimension, Group dimension, Company accounts or Account).
  5. On the Legal entities tab, add each Source legal entity with a file name and Account type of conversion differences, select OK, and check the message for the number of records saved in each file.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Main account rangeThe accounts to export; blank exports all.Microsoft Learn 100000 to 899999
Use consolidation account / Select consolidation account fromExports to the consolidation account on the main account or from a consolidation account group, when the parent uses another chart of accounts.Microsoft Learn Yes, consolidation account group BEAT-CONS
Consolidation periodThe dates of the balances to export.Microsoft Learn 10/1/2026 to 10/31/2026
Financial dimensionsWhich dimensions are transferred and how.Microsoft Learn Dimension
Source legal entity / file nameEach legal entity to export and the file it goes to.Microsoft Learn
Profit and loss / BalanceWhich part to export for each legal entity; one, not both.Microsoft Learn Balance

Common errors and fixes

MessageWhat to do
The message reports zero records for a legal entityCheck the Main account range, the period and the consolidation account mapping. Microsoft Learn

Test checklist

  1. Export one legal entity for one month.
  2. Check the message shows the number of records saved.
  3. Import the file with Consolidate with import in the parent and compare totals.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Export balances for the parentExport once per period after the subsidiary's adjustments, with the consolidation account mapping the parent expects and the consolidated company included in the legal entities.The parent imports exactly what the file holds, mapped by consolidation account and dimensions.Map accounts in the subsidiary or the parent?Exporting before the subsidiary posts its period-end adjustments.Test: Export produces a file per legal entity

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 subsidiary's accountant exports; the parent's accountant imports. No Feature management feature is needed for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyThe legal entities listed on the Legal entities tab, each into its own file, for import into another instance or system. Microsoft Learn
Can it be undoneNothing to undo: The export only reads balances and writes a file; it changes nothing in the ledger. Delete the file and export again if it is wrong. Microsoft Learn
If you change it laterReads balances and writes files; nothing in the ledger changes. Export again after any correction in the subsidiary, because the parent imports what the file holds. Microsoft Learn
Technical architect

6Technical

Menu itemLedgerConsolidate Checked in Dynamics 365
FormLedgerConsolidate Checked in Dynamics 365
Roles to set it up and use itTo use itAccounting supervisor LedgerAccountingSupervisorAccountant LedgerAccountantAccounting manager LedgerAccountingManagerGive people one of these roles. On this system, 3 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=LedgerConsolidate
Data migrationLoad order: Export company balances has no data entity in Data management, so it can't be loaded from a file or a configuration template. The export file is the transfer: import it with Consolidate with import in the parent.Checked in Dynamics 365
Everyone

8Sources