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

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. When people ask about the consolidation phase, this is the part they mean.

• Consolidated balance sheetThe group's assets, liabilities, and equity after eliminations, with noncontrolling interest shown inside equity but separately from the parent's equity.
• Top-side entryA journal entry posted in the consolidation layer, not in any entity's ledger, such as an elimination or an NCI allocation.
• Consolidated vs consolidating statementsConsolidated 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.

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. 1Confirm scopeList every entity, its ownership percentage, and its method (full consolidation, equity method, or neither) before the close starts.
2. 2Agree intercompany balancesMatch receivables, payables, and charges with each counterparty mid-month and again at cutoff.
3. 3Revalue in each entityEach 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. 4Lock and mapLock each entity's trial balance and map it to the group chart of accounts.
5. 5TranslateTranslate each foreign entity from its functional currency into the reporting currency and calculate the cumulative translation adjustment (CTA).
6. 6CombineAdd the translated trial balances line by line.
7. 7EliminateRemove intercompany balances, intercompany revenue and costs, unrealized profit, and the parent's investment against each subsidiary's equity.
8. 8Allocate NCIGive noncontrolling interest its share of the subsidiary's profit, other comprehensive income, and equity.
9. 9Post top-sidesRecord 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. 10Tie outCheck that the consolidated trial balance balances, intercompany nets to zero, and CTA and NCI roll forward from last month.
11. 11Review and lockThe 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.

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 covers matching and settlement.

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:

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.

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.

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:

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.

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.

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

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.

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:

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 shows debits and credits for the entity-level entries that come before.

Three practical rules keep these entries clean:

• Post at trial balance levelPost 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 bothEither 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-sideTop-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.

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 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 breaks the full close down by company size, and the month-end close calendar lays out the days before consolidation.

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 companiesUnder 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 controlUS GAAP lets private companies elect not to apply VIE guidance to certain entities under common control.
• Intermediate parents under IFRSIFRS 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.

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.

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.

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.

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

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.

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):

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.

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 dateClose 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-sideRecord 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 equityEliminate 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.

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:

These causes show up in month-end close KPIs like post-close adjustments and days to close.

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 ERPsEntities sit on different systems, often after acquisitions, so there's no single instance to roll up.
• Complex ownershipYou have partial ownership, step acquisitions, or ownership that changes during the year.
• Several GAAPsYou report under US GAAP for the group and local GAAP or IFRS for statutory accounts.
• Repeated rerunsLate entity entries force you to rerun the consolidation more than once a close.
• Spreadsheet-only stepsNCI, 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 guide.

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.

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 covers what the evidence says about accuracy.

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.