---
title: "Month-end consolidation: Steps, entries, and example"
description: "Month-end consolidation, step by step: the order that ties, the monthly entries, a worked CTA and NCI example, ERP steps, and APQC cycle-time benchmarks."
url: https://emptyspaces.ai/resources/blog/month-end-consolidation
language: en
---

[Blog](https://emptyspaces.ai/resources/blog) Guide

# Month-end consolidation: Steps, order, entries, and a worked example

Published November 11, 2026 23 min read

Key takeaways

- Month-end consolidation runs in a fixed order: revalue in each entity, translate foreign entities, combine, eliminate the translated intercompany balances, allocate noncontrolling interest, post top-sides, then tie out.
- APQC's benchmark for the consolidation step is 5 calendar days for top performers, 6 at the median, and 10 for the bottom group, counted from running the initial monthly business-entity trial balance to completing the agreed consolidated statements (more than 10,000 organizations).
- In the worked example below, six consolidation entries of $1,309,000 on each side turn three trial balances into $1,636,000 of consolidated revenue and $256,500 of net income, with $8,000 going to noncontrolling interest.

Month-end consolidation is the step after each entity closes its books, where you combine every subsidiary's trial balance into one set of statements for the group as a single economic entity. Getting it right gives leadership one reliable set of group numbers, catches intercompany balances that don't agree, and keeps your translation and ownership math audit-ready. This guide covers the steps in order, the close calendar, the monthly entries, and a worked example with CTA and NCI. It also shows what NetSuite, Business Central, SAP, Oracle, and QuickBooks do for you.

## What is month-end consolidation?

Month-end consolidation combines the closed trial balances of a parent and the entities it controls into one set of group statements. It translates foreign entities into the reporting currency, removes intercompany balances and profit, records noncontrolling interest, and produces the consolidated balance sheet, income statement, and cash flow statement. The purpose is to show investors, lenders, and leadership the group's finances as if it were one company.

Financial close and consolidation is the full sequence: each entity closes its own books first, and consolidation follows as the group-level phase of the [month-end close](https://emptyspaces.ai/resources/blog/month-end-close). When people ask about the consolidation phase, this is the part they mean.

- **Consolidated balance sheet** The group's assets, liabilities, and equity after eliminations, with noncontrolling interest shown inside equity but separately from the parent's equity.
- **Top-side entry** A journal entry posted in the consolidation layer, not in any entity's ledger, such as an elimination or an NCI allocation.
- **Consolidated vs consolidating statements** Consolidated statements show one set of group numbers. Consolidating statements show the working: a column for each entity, the eliminations, and the consolidated total side by side. Lenders and boards often ask for the consolidating version. Unconsolidated, or standalone, statements show one legal entity on its own, with its subsidiaries carried as investments.

## Month-end consolidation steps, in order

Run month-end consolidation in this order: confirm scope, agree intercompany balances, revalue in each entity, lock and map, translate, combine, eliminate, allocate NCI, post top-sides, tie out, and lock. One fixed sequence keeps every number traceable from the entity ledgers to the group statements:

1. **Confirm scope** List every entity, its ownership percentage, and its method (full consolidation, equity method, or neither) before the close starts.
2. **Agree intercompany balances** Match receivables, payables, and charges with each counterparty mid-month and again at cutoff.
3. **Revalue in each entity** Each entity remeasures its own foreign-currency monetary items, like a euro receivable on a US ledger, at the month-end rate. Any gain or loss lands in that entity's own profit, including on intercompany balances of a long-term-investment nature. For those balances, the consolidation layer moves the difference to CTA (step 9).
4. **Lock and map** Lock each entity's trial balance and map it to the group chart of accounts.
5. **Translate** Translate each foreign entity from its functional currency into the reporting currency and calculate the cumulative translation adjustment (CTA).
6. **Combine** Add the translated trial balances line by line.
7. **Eliminate** Remove intercompany balances, intercompany revenue and costs, unrealized profit, and the parent's investment against each subsidiary's equity.
8. **Allocate NCI** Give noncontrolling interest its share of the subsidiary's profit, other comprehensive income, and equity.
9. **Post top-sides** Record group-only adjustments, such as accounting policy alignment, purchase price allocation amortization, tax effects, and moving FX differences on long-term intercompany balances from profit to CTA in other comprehensive income (IAS 21, paragraphs 32–33; ASC 830-20-35-3).
10. **Tie out** Check that the consolidated trial balance balances, intercompany nets to zero, and CTA and NCI roll forward from last month.
11. **Review and lock** The controller reviews, the CFO approves, and you lock the period.

The table puts each step on a close day with an owner. It's a planning example for a 6-business-day close, not a benchmark. BD1 is the first working day after month-end, and BD-5 is the fifth-to-last working day of the month.

| Step | Close day | Owner | Done when |
| ---------------------------------------------- | -------------- | ------------------ | --------------------------------------------------------- |
| Confirm scope and ownership | BD-5 | Group controller | Entity list, ownership %, and method approved |
| Agree intercompany balances | Day 15 and BD2 | Entity accountants | Differences listed with an owner for each |
| Revalue foreign-currency items in each entity | BD2 | Entity accountants | Revaluation posted in every entity |
| Publish closing, average, and historical rates | BD1 | Treasury | Rates loaded in the consolidation system |
| Lock entity trial balances and map accounts | BD3 | Entity controllers | Every entity locked; no unmapped accounts |
| Translate, combine, and calculate CTA | BD3 | Group accountant | Translated trial balances balance |
| Post eliminations and NCI | BD4 | Group accountant | Intercompany nets to zero |
| Post top-side adjustments | BD4 | Group controller | Each top-side approved by someone other than its preparer |
| Tie out the consolidated trial balance | BD5 | Group controller | CTA and NCI roll forwards agree |
| Review, approve, and lock | BD5–BD6 | Controller and CFO | Period locked; statements issued |

Intercompany reconciliation is the bridge between the entity close and consolidation. Reconciliation proves a balance is right by matching it to a second source, like the other entity's ledger, while consolidation combines entities into group statements. If balances don't agree before you eliminate, the difference lands in your consolidated numbers. The guide to [intercompany accounting](https://emptyspaces.ai/resources/blog/intercompany-accounting) covers matching and settlement.

## Translate first, then eliminate: The order that ties out

Translate each foreign entity before you eliminate, because eliminations only net to zero when both sides are in the same currency at the same rate. Sources disagree on this: some AI answers and guides put eliminations before translation, which leaves FX differences in the consolidated numbers.

The order works in three layers. Revaluation happens inside each entity's own close, so a euro receivable on the parent's US ledger is already restated at the month-end rate. Translation then restates each foreign entity's whole trial balance into dollars. Elimination comes last, on translated balances, so the receivable and payable meet at the same number.

Under ASC 830 (US GAAP) and IAS 21 (IFRS), translation uses three kinds of rates:

| Line | Rate | Why |
| --------------------------------- | ------------------------------------------------------------------------------- | ---------------------------------------------- |
| Assets and liabilities | Closing rate at the balance sheet date | Shows what the balances are worth today |
| Revenue and expenses | Rate on each transaction date; a monthly average is the practical approximation | Matches income to when it was earned |
| Share capital and other equity | Historical rate when contributed | Keeps equity at what owners put in |
| Opening retained earnings | Carried at last month's translated dollar balance | Built up from prior months' translated profit |
| Cumulative translation adjustment | The plug that balances the translated trial balance | Goes to other comprehensive income, not profit |

Translation applies only when an entity's functional currency differs from the reporting currency. If a foreign entity's functional currency is the dollar, or its economy is highly inflationary under US GAAP, you remeasure it instead and the differences go through profit. CTA stays in equity until you sell or substantially liquidate the foreign entity, when it moves to profit.

Under IFRS, the mechanics match, but the CTA is called the foreign currency translation reserve. The FX revaluation of open balances in step 3 is its own close task, with its own entries and checks.

## Month-end consolidation example: A parent, an 80% subsidiary, and a euro subsidiary

The example shows every step on real numbers, so you can trace each consolidated figure back to an entity ledger. Each figure below was recomputed, and debits equal credits at every stage.

Example

A US parent (USD) owns 80% of Sub A, a US company, and 100% of Sub E, which reports in euros. It's November 30, 2026, and you're consolidating the month of November. The setup:

- **Sub A** The parent paid $400,000 for 80% of Sub A's $500,000 of share capital at formation, so there's no goodwill. A minority partner holds the other 20%.
- **Sub E** The parent invested $550,000 for Sub E's €500,000 of share capital at a historical rate of 1.10.
- **Intercompany sale** In November, the parent sold goods to Sub E for €100,000, invoiced in euros. At the 1.09 transaction rate, that's $109,000. Sub E resold all of the goods to outside customers by month-end, so there's no unrealized profit.
- **Revaluation** At the 1.12 closing rate, the parent revalued its €100,000 receivable to $112,000 and booked a $3,000 FX gain in its own close.
- **Rates** Closing rate 1.12, November average 1.09, capital at 1.10, and October's closing rate was 1.08.

### Step 1: Translate Sub E into dollars

Sub E's trial balance translates at three rates, with CTA as the plug that makes it balance:

| Sub E line | EUR | Rate | USD |
| ------------------------------ | --------- | -------------------- | --------- |
| Cash | 250,000 | 1.12 closing | 280,000 |
| Trade receivables | 300,000 | 1.12 closing | 336,000 |
| Other assets | 400,000 | 1.12 closing | 448,000 |
| Trade payables | (100,000) | 1.12 closing | (112,000) |
| Intercompany payable to parent | (100,000) | 1.12 closing | (112,000) |
| Share capital | (500,000) | 1.10 historical | (550,000) |
| Retained earnings, opening | (200,000) | Carried from October | (218,000) |
| Revenue | (400,000) | 1.09 average | (436,000) |
| Cost of goods sold | 280,000 | 1.09 average | 305,200 |
| Operating expenses | 70,000 | 1.09 average | 76,300 |
| CTA (plug) | | | (17,500) |
| Total | 0 | | 0 |

Credits are in parentheses. Translated net assets are €750,000 × 1.12 = $840,000, while capital, opening retained earnings, and November profit add up to $550,000 + $218,000 + $54,500 = $822,500. The $17,500 difference between the two is the cumulative CTA.

You can prove the plug from last month's balance. At October 31, net assets of €700,000 at 1.08 were $756,000, against $768,000 of capital and retained earnings, so opening CTA was a $12,000 debit. November's movement is €700,000 × (1.12 − 1.08) + €50,000 × (1.12 − 1.09) = $28,000 + $1,500 = $29,500. Opening ($12,000) plus $29,500 gives the $17,500 credit, and the $29,500 is November's other comprehensive income.

### Step 2: Combine and post six consolidation entries

The parent's $112,000 receivable and Sub E's translated $112,000 payable now match, because both sit at the 1.12 rate.

| Entry | Debit | Credit |
| -------------------------------------------------------- | --------- | --------- |
| 1. Eliminate intercompany balances | | |
| Intercompany payable (Sub E) | 112,000 | |
| Intercompany receivable (parent) | | 112,000 |
| 2. Eliminate the intercompany sale | | |
| Intercompany revenue (parent) | 109,000 | |
| Cost of goods sold (Sub E) | | 109,000 |
| 3. Eliminate investment in Sub A | | |
| Share capital (Sub A) | 500,000 | |
| Investment in Sub A | | 400,000 |
| NCI | | 100,000 |
| 4. Eliminate investment in Sub E | | |
| Share capital (Sub E) | 550,000 | |
| Investment in Sub E | | 550,000 |
| 5. NCI share of Sub A's opening retained earnings | | |
| Retained earnings, opening | 30,000 | |
| NCI | | 30,000 |
| 6. NCI share of Sub A's November profit (20% × $40,000) | | |
| Net income attributable to NCI | 8,000 | |
| NCI | | 8,000 |
| Total | 1,309,000 | 1,309,000 |

If Sub E had held 25% of the goods at month-end, you'd also remove the parent's margin on that 25% from inventory and cost of goods sold. If Sub E were 80% owned, 20% of its CTA would go to NCI too.

### Step 3: Tie out the consolidated trial balance

The consolidated trial balance shows each entity, the eliminations, and the group total. Credits are in parentheses.

| Account | Parent | Sub A | Sub E (USD) | Elim. debit | Elim. credit | Consolidated |
| ------------------------------ | ----------- | --------- | ----------- | ----------- | ------------ | ------------ |
| Cash | 600,000 | 200,000 | 280,000 | | | 1,080,000 |
| Trade receivables | 300,000 | 250,000 | 336,000 | | | 886,000 |
| Intercompany receivable | 112,000 | | | | 112,000 | 0 |
| Investment in Sub A | 400,000 | | | | 400,000 | 0 |
| Investment in Sub E | 550,000 | | | | 550,000 | 0 |
| Other assets | 800,000 | 400,000 | 448,000 | | | 1,648,000 |
| Trade payables | (250,000) | (160,000) | (112,000) | | | (522,000) |
| Intercompany payable | | | (112,000) | 112,000 | | 0 |
| Debt | (500,000) | | | | | (500,000) |
| Share capital | (1,000,000) | (500,000) | (550,000) | 1,050,000 | | (1,000,000) |
| Retained earnings, opening | (850,000) | (150,000) | (218,000) | 30,000 | | (1,188,000) |
| CTA | | | (17,500) | | | (17,500) |
| Noncontrolling interest | | | | | 138,000 | (138,000) |
| Revenue | (900,000) | (300,000) | (436,000) | | | (1,636,000) |
| Intercompany revenue | (109,000) | | | 109,000 | | 0 |
| Cost of goods sold | 600,000 | 180,000 | 305,200 | | 109,000 | 976,200 |
| Operating expenses | 250,000 | 80,000 | 76,300 | | | 406,300 |
| FX gain | (3,000) | | | | | (3,000) |
| Net income attributable to NCI | | | | 8,000 | | 8,000 |
| Total | 0 | 0 | 0 | 1,309,000 | 1,309,000 | 0 |

The consolidated debits and credits both total $5,004,500, and the group statements read straight from the trial balance:

| Consolidated result | Amount | How it's built |
| -------------------------- | ---------- | ---------------------------------------------------------- |
| Revenue | $1,636,000 | $900,000 + $300,000 + $436,000 of outside sales |
| Net income | $256,500 | $162,000 parent + $40,000 Sub A + $54,500 Sub E |
| Attributable to NCI | $8,000 | 20% × $40,000 |
| Attributable to the parent | $248,500 | $256,500 − $8,000 |
| Other comprehensive income | $29,500 | November's CTA movement |
| Total assets | $3,614,000 | Equals liabilities of $1,022,000 plus equity of $2,592,000 |
| NCI in equity | $138,000 | 20% × ($500,000 + $150,000 + $40,000) |
| Retained earnings, closing | $1,436,500 | $1,188,000 opening + $248,500 |

The intercompany sale nets to zero in profit: it adds $109,000 of revenue and $109,000 of cost, so consolidated net income equals the three entities' profits added up. You own 80% of Sub A, but you still consolidate 100% of its revenue, costs, assets, and liabilities, then show the other 20% as NCI.

## Which consolidation entries do you post every month?

Each month you eliminate intercompany balances, intercompany revenue and costs, unrealized profit, and the parent's investment, then allocate profit and equity to noncontrolling interest. These are top-side entries, posted in the consolidation layer rather than in entity ledgers, and a standard set keeps the controller's review predictable:

| Entry | Debit | Credit | When |
| ---------------------------------------------- | ------------------------------------------ | ---------------------------------------------- | -------------------------------------- |
| Intercompany receivables and payables | Intercompany payable | Intercompany receivable | Every month, on period-end balances |
| Intercompany loans and interest | Intercompany loan payable; interest income | Intercompany loan receivable; interest expense | Every month with loans |
| Intercompany revenue and costs | Intercompany revenue | Cost of goods sold or expense | Every month with intercompany sales |
| Unrealized profit in inventory or fixed assets | Cost of goods sold or gain | Inventory or fixed assets | When goods or assets stay in the group |
| Investment against subsidiary equity | Subsidiary equity at the acquisition date | Investment in subsidiary; NCI | Every month in the consolidation layer |
| NCI share of profit and OCI | Net income attributable to NCI | NCI | Every month with partly owned entities |
| Intercompany dividends | Dividend income | Dividends declared | When declared |
| Purchase price allocation amortization | Amortization or depreciation expense | Intangible or fixed assets | Every month after an acquisition |

The basic consolidation entry is the investment elimination, the one that removes the parent's investment account against the subsidiary's equity, so the group doesn't count the same net assets twice. Exact entries for each intercompany type, including unrealized profit, belong in your intercompany elimination procedures. The guide to [month-end journal entries](https://emptyspaces.ai/resources/blog/month-end-journal-entries) shows debits and credits for the entity-level entries that come before.

Three practical rules keep these entries clean:

- **Post at trial balance level** Post eliminations to the consolidated trial balance, not to the statements, so the statements and notes tie to one set of numbers.
- **Reverse or rebuild, not both** Either reverse balance sheet eliminations on day one of the next month and rebuild them from new balances, or recalculate the cumulative entry each month. Check your system's setting before you add manual entries.
- **Approve every top-side** Top-sides never touch an entity ledger, so give each one a preparer, a separate approver, and support attached, the same as any manual journal entry.

## When does consolidation happen in the close, and how long should it take?

Consolidation starts once every entity's trial balance is locked and intercompany balances agree, so it sits in the back half of the close. APQC measures it from running the initial monthly business-entity trial balance to completing the agreed-upon consolidated financial statements, counting every calendar day, weekends included.

In APQC's benchmark "Cycle Time in Days to Complete the Monthly Consolidated Financial Statements," published May 5, 2025 and based on more than 10,000 organizations, top performers finish in 5 calendar days. The median is 6, and bottom performers take 10. You can read the [APQC benchmark summary](https://www.apqc.org/resource-library/resource-listing/cycle-time-days-complete-monthly-consolidated-financial-0) for the full definition.

More entities add days and errors. Vena surveyed more than 600 US finance and accounting professionals and published the results on October 23, 2026. Teams with more than 10 entities average 8.3 business days to close, against 4.7 for single-entity teams. Among teams with 7–10 entities, 31% had to correct their close numbers more than once in the past year, against 13% of single-entity teams. Vena sells finance software, so read its figures as directional.

The units differ. APQC counts calendar days for the consolidation step only, while Vena counts business days for the whole close. A 6-calendar-day consolidation that starts on BD3 can still finish inside a 6-business-day close.

Track consolidation cycle time as your own internal KPI, from the first locked entity trial balance to approved group statements. Because its start point differs from APQC's, compare it with APQC's figures only as a guide. The guide to [how long month-end close should take](https://emptyspaces.ai/resources/blog/month-end-close-time) breaks the full close down by company size, and the [month-end close calendar](https://emptyspaces.ai/resources/blog/month-end-close-calendar) lays out the days before consolidation.

## What is the basic principle of consolidation, and which entities do you consolidate?

The basic principle is that a parent and the entities it controls report as one economic entity, so economic substance beats legal form. Control decides which entities you pull into the month-end roll-up, so check it before the close starts.

- **US GAAP (ASC 810)** Test the variable interest entity (VIE) model first. If an entity is a VIE, its primary beneficiary consolidates it, whatever the voting split. If it isn't, apply the voting interest model, where control usually means more than 50% of the voting shares. Control can exist with less through contracts, and a majority holder may not control if minority owners hold substantive participating rights.
- **IFRS (IFRS 10)** One control model asks whether you have power over the entity, exposure to variable returns, and the ability to use that power to affect those returns. You can control an entity with less than 50% of the votes, known as de facto control.

US GAAP requires consolidated statements when a parent controls a subsidiary, and parent-only statements don't replace them for general-purpose reporting. Some entities are exempt or follow other rules:

- **Investment companies** Under US GAAP (ASC 946) and IFRS 10's investment entity rules, they generally measure investees at fair value instead of consolidating them, apart from subsidiaries that provide services to the fund.
- **Private companies under common control** US GAAP lets private companies elect not to apply VIE guidance to certain entities under common control.
- **Intermediate parents under IFRS** IFRS 10 exempts a parent that is itself a subsidiary, when its owners don't object, its shares and debt aren't publicly traded, and a higher parent publishes IFRS consolidated statements. US GAAP has no matching exemption.

Consolidation isn't the same as combination. Combined statements add up entities under common control, such as sister companies owned by the same person, when no parent-subsidiary relationship exists. You still remove intercompany balances, but there's no investment to eliminate and no NCI.

## What are the three main types of consolidation?

The three methods are full consolidation, the equity method, and proportionate consolidation, and ownership and control decide which one applies. Knowing which entities fall where tells you which ones join the line-by-line roll-up and which become one entry.

| Method | When you use it | What goes in your statements | Month-end work |
| --------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------- | ------------------------------------------------- |
| Full consolidation | Control, under ASC 810 or IFRS 10 | 100% of every line, with NCI for the share you don't own | Translate, combine, eliminate, allocate NCI |
| Equity method | Significant influence, presumed at 20%–50% of votes (ASC 323, IAS 28), and joint ventures under IFRS 11 | One investment line on the balance sheet and one share-of-profit line | One entry for your share of the investee's profit |
| Proportionate consolidation | Rare: under US GAAP, certain undivided interests in industries like construction and oil and gas; IFRS 11 doesn't allow it for joint ventures | Your share of each asset, liability, revenue, and expense | Combine your share of each line |

Example

Your company owns 30% of a supplier that earns $200,000 in November. Under the equity method, you post one entry: debit investment in associate $60,000 and credit share of profit of associates $60,000. None of the supplier's revenue or costs enter your consolidated lines.

Under IFRS 11, a joint operation is different. You recognize your own share of its assets, liabilities, revenue, and expenses, which looks like proportionate consolidation but rests on your rights to those items.

## How month-end consolidation works in NetSuite, Business Central, SAP, Oracle, and QuickBooks

NetSuite, Business Central, SAP, and Oracle all translate and roll up entities, and most generate some eliminations, but your team still investigates unmatched intercompany differences. Mapping each system's step names shows what it does and what's left for your team. The step names below come from each vendor's help documentation, checked November 10, 2026.

| Step | NetSuite OneWorld | Business Central | SAP S/4HANA Group Reporting | Oracle FCCS |
| ----------------------- | ------------------------------------------------------------------------- | --------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------ | ---------------------------------------------------------- |
| Revalue in each entity | Revalue Open Foreign Currency Balances, per subsidiary | Adjust Exchange Rates batch job in each company | In the entity's accounting before release | In the source ledgers |
| Bring entity data in | Subsidiaries roll up in consolidated reports | Test Database or Test File, then Consolidate into the consolidated company | Release Universal Journals, Validate Universal Journal (Data Monitor) | Entity Input |
| Set rates and translate | Calculate Consolidated Exchange Rates: Current, Average, Historical | Consol. Translation Method on each G/L account | Currency Translation (Data Monitor) | Default Translation, then FX to CTA |
| Eliminate intercompany | Eliminate Intercompany Transactions, posting to an elimination subsidiary | Manual journal lines, tested with the G/L Consolidation Eliminations report | IC Elim Sales, IC Elim Balance Sheet, IC Elim Other Income/Expense (Consolidation Monitor) | Standard Eliminations |
| Ownership and NCI | Not described in the help pages checked | Consolidation % includes a percentage of each amount | Investments/Equity elimin./Cons. of Invest. | Ownership Management sets ownership % and method by period |
| Validate | Consolidated reports for the parent | Consolidated trial balance | Consolidated Data Validation | Final Calculations, then your review |

Here's what each system does for you, and what your team still owns:

| System | The system does | You still do |
| --------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| NetSuite OneWorld | Revalues open balances per subsidiary; calculates current, average, and historical consolidated rates; creates elimination journals for intercompany lines marked for elimination; calculates CTA in consolidated reports; posts elimination FX differences to CTA-E | Clear unmatched and untagged intercompany items; post a manual entry for any currency difference elimination leaves behind; calculate and post NCI; remove unrealized profit |
| Business Central | Tests and imports each business unit into a consolidated company; translates each account by its translation method (Average Rate (Manual), Closing Rate, Historical Rate, Composite Rate, or Equity Rate) | Enter the average rate yourself; post eliminations by journal, since Microsoft calls them a manual process; book NCI by journal if you consolidate at 100%; rerun after late entity entries |
| SAP S/4HANA Group Reporting | Runs translation in the Data Monitor and eliminations, investment consolidation, and NCI in the Consolidation Monitor, per consolidation group | Configure the tasks and rules; investigate intercompany differences; post manual eliminations at the right posting level |
| Oracle FCCS | Translates, posts CTA, proportionalizes at the consolidation percent, and runs standard eliminations; tracks ownership changes by period | Load data from each ERP; set ownership and rules; review and approve the results |
| QuickBooks Online and Xero | Each QuickBooks Online company is its own file. Intuit documents consolidated reports, and removal of designated intercompany accounts, for Intuit Enterprise Suite | Translate and eliminate in a spreadsheet or add-on; remove mixed-use intercompany amounts manually; on Xero, use a partner app or a workbook |

Two details catch teams out. In NetSuite, once you mark Calculate Consolidated Exchange Rates complete, you can't change that period's rates, so check them first. In Business Central, the Consolidation % field includes only that share of each amount, which is proportionate consolidation. For a controlled subsidiary under US GAAP or IFRS, you consolidate 100% and record NCI separately.

On QuickBooks, Intuit's help, updated August 5, 2026, says Intuit Enterprise Suite removes designated intercompany accounts automatically, while mixed-use accounts need manual adjustments that don't post to QuickBooks. On its product ideas forum in July 2025, Xero said native consolidated reporting is not currently planned.

## How do you consolidate in Excel?

A consolidation workbook works when it shows each entity's local currency, the rate, and the translated amount, and then proves its own totals. In Excel, put accounts in rows and entities in columns, and pull each trial balance by group account code.

Here's a layout that handles FX and NCI, described column by column (it's a layout, not a downloadable file):

| Column | What goes in it |
| ------------------------------------- | -------------------------------------------------------------------------------- |
| Group account code and name | One row per account in the group chart of accounts |
| Rate type | Closing, average, historical, or carried |
| Parent (USD) | SUMIFS from the parent's trial balance tab on the group account code |
| Each foreign entity: local, rate, USD | Local balance, the rate looked up from a rates tab, and the translated amount |
| Each US subsidiary (USD) | SUMIFS from that entity's trial balance tab |
| Combined total | Sum of the USD columns |
| Elimination debit and credit | One column each, fed from an eliminations tab with an entry number on every line |
| NCI | The allocation lines for partly owned entities |
| Consolidated total | Combined total plus debits minus credits |

Add four checks at the bottom, and don't sign off until each one shows zero. Each translated entity balances after CTA, eliminations balance, intercompany accounts net to zero, and the consolidated trial balance balances. The worked example above uses this layout.

Move off Excel when entity counts or currencies grow faster than your checks, or when the workbook needs manual rework every month. The section on outgrowing ERP consolidation below covers the signals.

## How do you handle an acquisition or disposal mid-month?

Consolidate an acquired subsidiary from the acquisition date, not from the start of the month. A clean cutoff keeps pre-acquisition profit out of your group results and gives you the opening balance sheet for the purchase accounting.

- **Cut off at the acquisition date** Close the acquired entity's books, or cut them off, on that date. Include only revenue and expenses after it.
- **Record purchase accounting as a top-side** Record acquired assets and liabilities at fair value, with goodwill for the excess, under ASC 805 or IFRS 3. Measure NCI at fair value under US GAAP; IFRS 3 also lets you use NCI's share of net assets.
- **Eliminate pre-acquisition equity** Eliminate the subsidiary's equity at the acquisition date against the parent's investment.

Some groups use the nearest month-end as a convenience date when the difference is immaterial and the auditor agrees. A disposal works in reverse. You deconsolidate on the date you lose control, recognize the gain or loss in profit, and move the entity's CTA into profit. Any interest you keep is measured at fair value.

If a subsidiary has a different year-end, US GAAP allows a lag of up to about three months with disclosure of material events in the gap. IFRS 10 requires the same reporting date unless that's impracticable, caps the gap at three months, and requires adjustments for significant events.

## Why is consolidation so difficult, and how do you speed it up?

Consolidation drags when entity charts of accounts don't map cleanly, intercompany balances disagree, rates arrive late, or an entity posts after the roll-up and forces a rerun. Each problem has a fix that comes before the consolidation days:

| Why it's slow | Fix | When |
| ------------------------------------------------------------ | ----------------------------------------------------------------------------------------- | ----------------------- |
| Entity charts of accounts map to the group chart differently | One group chart, with a mapping table you review when accounts are added | Before the close |
| Intercompany balances don't agree | Match mid-month and at cutoff, with one owner per counterparty pair | Day 15 and BD2 |
| Untagged or one-sided intercompany entries | Require a counterparty on every intercompany line | When entries are posted |
| Rates arrive late or differ by entity | Treasury publishes one rate set for every entity | BD1 |
| Late entity adjustments force a rerun | Lock entity trial balances before translation, and route later changes through a top-side | BD3 |
| Eliminations leave FX differences | Translate first, then eliminate translated balances | Every month |

These causes show up in [month-end close KPIs](https://emptyspaces.ai/resources/blog/month-end-close-kpis) like post-close adjustments and days to close.

## When do you outgrow your ERP's consolidation?

Start with your ERP's own consolidation if every entity runs in one instance with a shared chart of accounts and simple ownership. Look at a dedicated consolidation tool when the roll-up keeps needing manual rework in Excel.

Signs you've outgrown it:

- **Different ERPs** Entities sit on different systems, often after acquisitions, so there's no single instance to roll up.
- **Complex ownership** You have partial ownership, step acquisitions, or ownership that changes during the year.
- **Several GAAPs** You report under US GAAP for the group and local GAAP or IFRS for statutory accounts.
- **Repeated reruns** Late entity entries force you to rerun the consolidation more than once a close.
- **Spreadsheet-only steps** NCI, unrealized profit, or CTA roll forwards live only in a workbook.

Close management tools and consolidation engines solve different problems. Close tools manage tasks, reconciliations, and approvals across entities, while consolidation engines translate, eliminate, and calculate ownership. Compare the options by the work each one does in the [best month-end close software](https://emptyspaces.ai/resources/blog/best-month-end-close-software) guide.

## Can AI do month-end consolidation?

AI can prepare much of month-end consolidation today: matching intercompany balances, chasing differences, drafting elimination and top-side entries, and explaining variances. The consolidation engine in your ERP or tool still does the translation and roll-up math, and a controller still owns scope, judgments, and approval.

| Work | Who does it best | Why |
| ------------------------------------------------------------- | -------------------------------- | ------------------------------------------------------ |
| Translation, roll-up, and system eliminations | Your ERP or consolidation engine | Rules-based math on configured rates and accounts |
| Matching intercompany balances and investigating differences | An AI agent | High volume, with evidence to gather from both ledgers |
| Drafting eliminations, NCI, and top-side entries with support | An AI agent, for approval | Repeatable entries built from period-end balances |
| Consolidation scope, ownership, and accounting judgments | The controller | Requires judgment and accountability |
| Approving entries and signing off the statements | A named approver | Controls require a person who isn't the preparer |

Whatever tool you use, entries should post only after a named person approves the exact lines. The guide to [AI in the month-end close](https://emptyspaces.ai/resources/blog/ai-month-end-close) covers what the evidence says about accuracy.

## How we approach it

Our Close Agent works the intercompany close tasks and multi-currency work that feed your consolidation. It matches intercompany balances, investigates differences with the amount, date, source, and reference, and prepares balanced entries with their workpapers. A named approver approves the exact lines before anything posts to NetSuite, Oracle, SAP S/4HANA, Microsoft Dynamics 365, Business Central, or QuickBooks, and when data is missing, the agent stops and asks. Your ERP or consolidation tool still runs the consolidation itself. To see how it fits your close, explore [our Close Agent](https://emptyspaces.ai/product/close).

Share this article

- [ Share on X ](https://x.com/intent/post?url=https%3A%2F%2Femptyspaces.ai%2Fresources%2Fblog%2Fmonth-end-consolidation&text=Month-end%20consolidation%3A%20Steps%2C%20order%2C%20entries%2C%20and%20a%20worked%20example)
- [ Share on LinkedIn ](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Femptyspaces.ai%2Fresources%2Fblog%2Fmonth-end-consolidation)

## See our agents work through a finance process that matters to your team.

Tell us where the work gets stuck. We’ll walk through how the agents could help.

[Book a working session](https://emptyspaces.ai/contact-us)