Non-Controlling Interest on Xero: What Your Consolidation Tool Has to Handle

A group runs five companies on Xero, all wholly owned, and its consolidation works. Each month the tool pulls the five ledgers, maps them to one chart of accounts, eliminates the intercompany and produces a group P&L and balance sheet.

Then the group buys 70% of a sixth company. The founder of the company keeps the other 30% and stays on to run it.

Overnight, the group's reporting needs a number that sits in none of the six ledgers: the non-controlling interest, the founder's 30%. The auditor wants it in equity. The board wants profit split into "ours" and "theirs". Within a quarter, someone is maintaining it in a spreadsheet next to the consolidation tool.

The accounting for non-controlling interest (NCI) is settled. What it demands of your reporting setup is less obvious. This post is about that: the data a partly owned group's consolidation needs, how granular it has to be, and which setups can carry it.

Why non-controlling interest is a data problem

The rule fits in a sentence. A subsidiary the group controls is consolidated in full, every line of it, and the outside owners' share is shown separately, as a line within equity and as a split of the profit. That's IFRS 10 (paragraphs 22 and B94), and Singapore's FRS 110 says the same. In the simple case the arithmetic is one multiplication.

The hard part is everything that multiplication needs.

Xero doesn't know who owns what. A Xero organisation holds its own ledger. It doesn't record its shareholders, and it has no idea it's 70% owned. Xero's own reports, including Xero Analytics, don't combine organisations either. Consolidation could potentially sit in Syft, the reporting app Xero bought in 2024. But it doesn't fix the other gaps.

The percentage isn't one number. It changes on the date a stake is bought or sold, and it multiplies through every tier of holding companies.

The profit the NCI shares isn't the profit in Xero. It's the subsidiary's profit after the group's adjustments, and those adjustments live outside any ledger.

It has a memory. Figures set on the day the group bought in are used every period after.

One structure feeds several reports. The statutory set, a sub-group set and the board's "our share" view all need the same ownership data, cut differently.

So the question for any reporting tool or framework isn't whether it can multiply by 70%. It's whether it can hold all of that.

The granularity a partly owned group needs

Invented figures throughout this section, if you're wondering.

Ownership by link, by date

Start with an ownership register: who holds each company, how much, from when, and how it's treated.

Five rows, and already three things a single percentage per company can't express:

• A change mid-year. HoldCo bought another 15% of SubCo on 1 July, so the NCI takes 30% of SubCo's profit for the first half and 15% for the second. The purchase itself doesn't go through profit at all. IFRS 10 treats it as a deal between owners, settled in equity (paragraph 23).
• An indirect holding. HoldCo controls MidCo, which controls OpCo, so OpCo is consolidated in full. But HoldCo's effective interest is 60% of 60%, which is 36%. The NCI in OpCo is 64%: 40% held directly, plus 24% through MidCo's outside shareholders. IFRS 10 defines the NCI as equity "not attributable, directly or indirectly, to a parent", and "indirectly" does a lot of work.
• A different treatment. JVCo is jointly controlled, so it isn't consolidated line by line. A joint venture is equity-accounted (IFRS 11 paragraph 24): one line on the balance sheet, one line in profit.

The register has to be data the consolidation reads, with dates, and effective interests have to be calculated from it. A typed-in percentage goes stale the first time anything changes.

Adjusted profit, per subsidiary, per period

The NCI's share of profit is a percentage of the subsidiary's profit as the group sees it. Each of these is a separate adjustment, held per subsidiary and carried each period:

• Fair value depreciation. Assets written up when the group bought in are depreciated at the higher amount in the group accounts (IFRS 10 paragraph B88), and the NCI shares the extra charge.
• Unrealised intragroup profit. If SubCo sells stock to HoldCo at a margin and it's still on HoldCo's shelves, the profit is eliminated in full (B86), and most groups take the NCI's share of that elimination off the NCI. Our intercompany eliminations guide covers finding these.
• Losses. The NCI takes its share of losses even when that pushes it below zero (B94), so nothing in the calculation can floor it at nil.

Acquisition memory

Buy into a company and some numbers are set once and used forever. IFRS 3 lets the group measure the NCI at fair value or at its share of the net assets, acquisition by acquisition (paragraph 19), and the choice changes goodwill. Pay 150 for 60% of a company with net assets worth 200, and goodwill is 30 one way and 40 the other. The fair value adjustments behind that 200 then drive the depreciation above for years.

None of this is in any Xero file, and none of it should be re-derived every quarter. The tool has to store it and roll it forward.

One register, several reports

The same ownership data has to produce different reports for different readers:

• The statutory set: full consolidation, the NCI within equity, and the profit split at the foot of the P&L.
• A sub-group set, when an intermediate holding company owes its own consolidated accounts.
• An "our share" view, where the board sees the group's proportional share of each company's revenue and costs. That's useful for management. It isn't the statutory presentation.

Built in separate spreadsheets, they'll disagree. Built from one register, they can't.

What hitting the wall looks like

The regional group with an 80% Malaysian subsidiary. The consolidation translates the subsidiary at the right rates and posts the whole translation difference to the group's reserve. A fifth of it belongs to the 20% partner, and IAS 21 puts that share in the NCI (paragraph 41). The rates are right and the equity split is wrong. The translation mechanics are in our multi-currency reporting guide.

The founder who sells half their stake on 1 July. The setup holds one percentage per subsidiary, so someone changes 70% to 85% and the first half of the year quietly restates. The premium HoldCo paid lands in goodwill, where IFRS wants it in equity. The cash lands in investing, where IAS 7 wants it in financing (paragraph 42A), which then has to be unpicked in the consolidated cash flow statement.

The intermediate holding company with a lender. MidCo's bank asks for MidCo's own consolidated accounts. In Singapore, an intermediate parent with outside shareholders often can't skip them (see our guide to consolidated financial statements in Singapore). The sub-group set gets built in a second spreadsheet, and its NCI in OpCo never quite matches the group set's.

The property group with a co-investor on one site. Ten SPVs are wholly owned; the eleventh has a 30% co-investor. The co-investor's share is a journal someone types each quarter from that SPV's own Xero profit, which isn't the profit the group reports for it. We cover the rest of that structure in consolidating multiple SPVs in Xero.

The workarounds, ranked

1. A spreadsheet beside the consolidation. The most common route. The NCI is worked out by hand from each subsidiary's Xero figures and posted as a top-side journal. It holds up for one subsidiary at one percentage. It breaks on tiers, dates and adjustments, and it produces the number auditors ask about first.
2. The ownership setting in a consolidation app. Joiin and Spotlight Reporting both document one. You set a percentage per company and reports reflect it: Joiin's help article says reports are calculated "to the percentage stated for the entity", and Spotlight's says revenue, costs and profit "are reflected proportionally". As documented, that's proportional: a solid "our share" view rather than full consolidation with a separate NCI line. Neither help page mentions changing the percentage by date or chaining it through tiers. Good tools, built for a different job, so test any app against the checklist below before you trust it with statutory accounts.
3. A BI or data warehouse build. Flexible, and the register, adjustments and roll-forward can all be modelled. But someone has to design them and keep them right, which is a lot of build for most groups.
4. A build designed around your structure. The register, the adjustments and every report shaped to how your group is actually owned. That's where we come in (below).

What to ask any reporting tool or framework

1. Can it hold ownership per link, with the date each stake starts and ends?
2. Does it calculate effective interests through holding tiers, rather than take one typed percentage?
3. Does it treat each entity by its classification: subsidiaries in full, joint ventures and associates as a single equity-accounted line?
4. Can it store acquisition-date figures (the NCI measurement choice, goodwill, fair value adjustments) and carry them forward?
5. Is the NCI's share of profit calculated on adjusted profit, with each adjustment visible?
6. Does it produce an NCI roll-forward that ties to each subsidiary's net assets?
7. Can the statutory set, a sub-group set and an "our share" view all come from the same data?
8. Can an auditor trace the NCI back to its inputs?

Where Cheetah fits

Cheetah builds consolidated reports on top of Xero, designed around each group, and partial ownership is where that pays off. We start from your ownership register, held as data: every link, every stake, every date. The consolidation reads it. Effective interests are calculated through the tiers, each entity is treated according to its classification, and an ownership change splits the period on the day it happens.

The adjustments the NCI depends on (fair value depreciation, unrealised intragroup profit, translation) sit on their own labelled lines for each subsidiary, carried from one period to the next. The NCI rolls forward on a check tab and ties to net assets, so the number your auditor asks about first is the one you can prove fastest. And because everything runs from one register, the statutory set, a sub-group set and the board's "our share" view agree with each other.

It all arrives in Google Sheets with plain formulas and an Excel download, so anyone can trace a cell back to the ledger.

If the NCI in your group lives in a spreadsheet next to your consolidation, it might be worth a conversation.

The short version

Non-controlling interest is simple accounting and demanding data. The rule is to consolidate in full and show the outside owners' share separately. Doing that every period means holding ownership by link and by date, multiplying it through holding tiers, adjusting the profit the NCI shares, remembering what was fixed at acquisition, and producing every report from the same register. Xero holds none of it, and a percentage-per-company setting holds only some of it. Check your setup against the questions above before the auditor does.

If you're weighing up how to build it, the routes are compared in Xero Custom Reports: 4 Ways to Build Them in 2026.