Mid-Year Acquisitions and Disposals on Xero: What Your Consolidation Has to Handle
Your group will keep changing. Your consolidation shouldn't need rebuilding each time it does.
A group runs three companies on Xero, and its consolidation works. Every month the model pulls each company's figures, maps them to one chart of accounts, takes out the intercompany and produces a group P&L and balance sheet.
Then the group changes. In March, it sells Retail Co, its smallest company. In August comes a mid-year acquisition: Studio Co, with a June year end and a chart of accounts someone else built. In October the wholesale business moves out of Trading Co into a new company of its own.
None of this changes how a consolidation is done. All of it changes what the consolidation has to know. By December the model has been patched three times, last year's comparative no longer matches the signed-off pack, and nobody is sure the eliminations cover the new company.
This post is about what a changing group demands of your consolidation, whatever it runs on, and how to stop each change turning into a rebuild.
Why a mid-year acquisition breaks a working consolidation
The accounting rule is short. IFRS 10 brings a subsidiary in from the date the group gains control and takes it out on the date control is lost (paragraph 20). Following that rule every month needs data that no single Xero file holds.
Xero doesn't know there's a group. Each Xero organisation holds its own ledger, with no record of when it joined a group or left one, and its file holds the company's whole history, not just the months the group owned it. Xero's own reports, including Xero Analytics, don't combine organisations.
The company's year isn't the group's year. Xero runs each company on its own financial year. Its year-to-date, its budget and the split between Current Year Earnings and Retained Earnings on its balance sheet all follow that company's year end, not the group's.
The company and the Xero file aren't the same thing. A company you buy often moves from the seller's Xero file to the group's, or onto a fresh one with opening balances. A company you sell usually leaves with its file: the subscription transfers to the buyer, and once they remove your users, its history goes with it.
So the question for any consolidation isn't whether it can add up five companies. It's whether it can hold the group's history as data.
What the consolidation has to hold
Invented figures throughout, in thousands.
A register of who was in, and when
Start with a register the consolidation reads, rather than a list someone remembers.
| Company | In the group | Xero file | Year end | Treated as |
|---|---|---|---|---|
| HoldCo | Throughout | HoldCo | 31 Dec | Parent |
| Trading Co | Throughout | Trading Co | 31 Dec | Subsidiary |
| Retail Co | Until 31 Mar 2026 | Retail Co, now the buyer's | 31 Dec | Subsidiary, sold |
| Studio Co | From 1 Aug 2026 | The seller's file to 30 Sep, the group's from 1 Oct | 30 Jun | Subsidiary |
| Wholesale Co | From 1 Oct 2026 | Wholesale Co | 31 Dec | Subsidiary |
For the group's year to 31 December 2026, that register becomes a window per company: twelve months of HoldCo and Trading Co, three each of Retail Co and Wholesale Co, and five of Studio Co, from two files. Xero runs a P&L for any date range, so each window can be pulled exactly. The trouble starts wherever a report leans on the company's own year.
The group's slice of a mid-year acquisition
| Studio Co at 31 December 2026 | Its own Xero file | The group |
|---|---|---|
| Profit for the period | 70, from 1 July | 55, from 1 August |
| Retained earnings | 335, to 30 June | None: all earned before the deal |
| Equity eliminated against the investment | n/a | 400, as at 31 July |
July's 15 of profit belongs to the seller, but Xero counts it in Studio Co's Current Year Earnings, because Studio Co's year started on 1 July. Studio Co's equity at 31 July (50 of share capital, the 335 and July's 15) is eliminated against what HoldCo paid, and the difference, after fair value adjustments, is goodwill.
That acquisition-date balance sheet is set once and used every period after. It can still move: IFRS 3 gives the group up to a year to finalise it, adjusting back to the acquisition date (paragraph 45). So it's stored as data with a history, not typed into a formula.
The June year end causes a quieter problem. IFRS 10 wants Studio Co's figures as at the group's date unless that's impracticable (paragraphs B92 and B93), and with Xero it rarely is: the date is just a setting. What breaks is the monthly pack. Studio Co's year-to-date in Xero runs from July, and so does its budget. The group's runs from January, and the pack mixes the two without saying so.
A disposal, seen from both sides
Retail Co is sold on 31 March for 350. HoldCo set it up with 200 of capital years ago, and Retail Co has kept 60 of profit since, so its net assets on the day are 260.
| HoldCo's own Xero file | The group | |
|---|---|---|
| Proceeds | 350 | 350 |
| Less: cost of the investment | 200 | |
| Less: Retail Co's net assets | 260 | |
| Gain on disposal | 150 | 90 |
The 60 difference is profit the group already reported in earlier years, as Retail Co earned it. IFRS 10 measures the group's gain against the net assets, goodwill included, that leave the group balance sheet on the day (paragraph B98). HoldCo's ledger can't hold that number, so the consolidation calculates it.
The knock-on effects run on dates too:
- The last three months live in a file you're losing. Retail Co's January to March figures sit in a Xero file the buyer now controls. Pull them, or keep a copy, before your access ends.
- Intercompany stops on the day. From 1 April, a loan between HoldCo and Retail Co is a balance with an outside party, and it's no longer eliminated.
- A foreign subsidiary takes its reserve with it. Its translation reserve moves into profit on the sale (IAS 21 paragraph 48). More in our multi-currency reporting guide.
- The comparative can change. If Retail Co was a separate major line of business, its results become one line of discontinued operations, and last year's figures are re-presented to match (IFRS 5 paragraphs 32 to 34).
A chart of accounts someone else built
Studio Co's chart was set up by the seller's bookkeeper. Code 200 might be sales in Trading Co and something else in Studio Co, and "Consulting" might be income in one file and a cost in another. Mapping by name or code alone fails here, so the map has to be held per company.
New accounts appear fastest in the months after a deal. Any account without a mapping has to show up as unmapped, with its value, rather than drop silently out of a total.
A restructure that moves a business, not a company
In October, wholesale moves out of Trading Co into Wholesale Co. In the legal-entity view, Trading Co's revenue falls by a third and Wholesale Co appears from nowhere. In the segment view the board reads, wholesale should run straight through October without a bump.
That only works if the segment is a mapping of its own, keyed by company and account (or tracking category) with dates, not inferred from which company a line sits in. Consolidating by segment and by legal entity are two cuts of the same ledgers, and a restructure is where they part ways. A new holding company put over existing ones is a different case again, a combination under common control, covered in consolidated financial statements in Singapore.
Prior periods as reported
Last year's group figures exclude Studio Co, include all of Retail Co, and were signed off. A setup that recalculates them from today's list of companies quietly rewrites them. A safer one rebuilds from the dated register and checks the result against last year's group balance sheet as reported, so comparatives change only when a rule says so, and visibly.
What hitting the wall looks like
The finance manager adding a tab. The model has one tab per company and SUM ranges across them. Studio Co's tab goes in at the end, outside one range on the balance sheet. The group still balances, because the difference falls into a retained earnings plug. It surfaces months later as a strange line in the consolidated cash flow statement.
The group that removed a sold company. Retail Co comes out of the consolidation the week it's sold. Last year's comparative drops it too, and the board pack's prior year no longer matches the signed accounts. Add-ons handle joining and leaving unevenly, as we found comparing consolidation software for small groups.
The group that bought 70%. The register now needs stakes as well as dates, and the seller's remaining 30% needs its own line from the day of the deal. That's non-controlling interest, and it multiplies everything above.
The workarounds, ranked
- Patch the model for each change. Insert the tab, extend the ranges, post a disposal journal. It works for that change, but every patch is a new place for a formula to miss something, and after a few years of deals the template needs a rebuild nobody has time for.
- Rebuild the template once a year. Restructure the workbook at year end around that year's changes, with comparatives pasted in as values from last year's signed pack. It costs a week of senior time a year, and the months in between run on the patched version.
- A consolidation add-on. Some record acquisition and disposal dates, some use one group start date, some record neither. If yours has the dates and your group changes rarely, it's a good answer. Test it on prior periods, a different year end and a company that changes Xero file.
- A build designed around a register. The group's history held as data, with every report reading from it. That's what we do (below).
What to ask any consolidation setup
- Does each company have a date it joined and a date it left, and does every report respect them?
- Can a company be cut to the group's calendar, whatever its own year end?
- Can one company's year be read from two Xero files?
- Is the acquisition-date balance sheet stored, and can it be revised within the year IFRS 3 allows?
- Does it calculate the group's gain on disposal, and stop eliminating a sold company's balances on the day?
- Does a new account in any company show up as unmapped, with its value?
- Can segments be mapped separately from legal entities?
- Are prior periods kept as reported, and changed only by a rule you can see?
Where Cheetah fits
Cheetah builds consolidated reports on top of Xero, designed around each group, and a group that keeps changing is where that pays off. A register like the one above lives in a configuration sheet your finance team can read and edit, next to one account map that every company's chart of accounts maps into.
The consolidation reads that sheet on every run. Adding a company means adding rows: its line in the register and its account mappings. Until every account is placed, an unmapped block shows what's missing and what it does to profit. Each company is pulled for its own window on the group's calendar. Acquisition-date balances, disposals and dated eliminations are held as data, and last year's closing group balance sheet can sit in the same configuration, so the opening position is the one you signed off. A check tab ties every company to the group to the cent, every month.
It arrives in Google Sheets with plain formulas and an Excel download. If your consolidation needs rebuilding every time the group changes, it might be worth a conversation.
The short version
A mid-year acquisition, a disposal, a different year end or a restructure doesn't change how consolidation is done. It changes what the consolidation has to remember: who was in the group and when, which Xero file holds which months, what a sale really made for the group, and what last year looked like when it was signed off. Xero holds none of that, and a tab-per-company model buries it in formulas. Hold it as data, and the next change to the group is a new row, not a rebuild.
If you're weighing up how to build it, the routes are compared in Xero Custom Reports: 4 Ways to Build Them in 2026.
Frequently asked questions
- How do you consolidate a subsidiary acquired mid-year?
- From the acquisition date, the day the group gains control. The group P&L includes only the subsidiary's income and expenses after that date, so its profit before the deal is left out even though it sits in the company's own books. Its equity at the acquisition date is eliminated against what the parent paid, and the difference, after fair value adjustments, is goodwill. Last year's comparative isn't restated to include it, because it wasn't in the group last year.
- What happens to the consolidation when a subsidiary is sold?
- Its results are included up to the date control is lost, and its assets, liabilities and any goodwill come off the group balance sheet on that date. The group's gain is the proceeds less those net assets, which is usually different from the gain in the parent's own books, measured against the original cost of the investment. A foreign subsidiary's translation reserve moves into profit on the sale, and if the subsidiary was a separate major line of business, its results are shown as discontinued operations with the comparative re-presented to match.
- Can you consolidate a subsidiary with a different financial year end?
- Yes, but under IFRS 10 the subsidiary normally prepares extra figures as at the group's reporting date. Only if that's impracticable can the group use the subsidiary's own statements, adjusted for significant events in between, and then the gap can't exceed three months. With Xero it's rarely impracticable, because any report can be run for any date range. The real risk is in management reports that use the subsidiary's own year-to-date, which starts in a different month from the group's.
- How do you add a new subsidiary to a consolidation model?
- Record the date it joins the group and which Xero file holds which months, map every account in its chart of accounts to the group's structure, set up the intercompany rules for its balances with the other companies, and store its balance sheet at the acquisition date. Then check that the sum of the companies, less eliminations, equals the group for its first month. In a well-built setup that's a few rows of configuration rather than a new tab and a new set of formulas.
- What is the difference between consolidating by segment and by legal entity?
- A legal-entity view adds up the group company by company. A segment view adds it up by business line, region or site, whichever companies those sit in. The two agree until the group restructures. If a business moves from one company into another, the legal-entity view shows one company shrinking and another appearing, while the segment view should carry on unbroken. That only works if segments are mapped separately from companies.
A finance professional turned product builder, Jarvin has built hundreds of reports by hand and knows what financial and operational reporting demands: customisability, auditability, scalability, and security. Having automated that work reliably, he's now helping advisory firms and finance teams do the same.
