How to Consolidate Multiple SPVs in Xero: Where Property Group Reporting Gets Hard

A property developer runs a holding company, a development manager and nine project SPVs, one per site. That's eleven Xero organisations, and none of them is busy. A typical SPV posts a few dozen transactions a month: the builder's progress claim, a consultant's invoice, a construction loan drawdown, some interest. Any one of them closes in an hour.

The group close takes a week.

If you need to consolidate multiple SPVs in Xero, volume is rarely the problem. The problem is that a property group's economics sit between the companies: in the holdco loans that fund each site, and in the interest and fees each SPV capitalises into the cost of its development. Get those wrong and group profit lands in the wrong year, the wrong asset carries it, and the balance sheet still balances.

This post covers why that's harder than it looks, how the consolidation is built, and where it gets difficult.

Why an SPV group isn't an ordinary Xero group

Xero stops at the organisation boundary. Xero's own reports, including Xero Analytics, don't combine organisations. Consolidation sits in Syft, the reporting app Xero bought in 2024, and in July 2026 Xero started bundling it into Xero Ultra, a new plan launched in Australia at A$500 a month. A UK beta is expected in autumn 2026, and we haven't seen an announcement for Singapore. Within Xero itself, nothing matches the holdco's loan receivable to the SPV's loan payable either: a request to reconcile loans between related entities' Xero organisations has been open since 2013. (The wider gap is covered in our guide to consolidating multiple Xero entities.)

Tracking categories can't stand in for companies. If every project sat inside one company, a tracking category per project would get you most of a project profitability report. SPVs exist precisely so the projects don't share a company. Each site has its own legal entity, bank account, lender, statutory accounts and tax return, so each is its own Xero organisation on its own subscription.

The effort scales with the number of companies, not their size. An SPV with four transactions this month still has to be exported and mapped, and its intercompany balance agreed. Nine small companies cost more close time than one large one.

The group never sits still. A new site means a new SPV. A finished project leaves a dormant one waiting to be struck off, and a sold one leaves the group. A model built as one tab per company gets rebuilt every time.

Most of the intercompany sits on the balance sheet. In a trading group, intercompany is mostly recharges through the P&L. In a property group it's mostly funding. SPVs typically carry nominal share capital and a large shareholder loan from the holdco, plus interest on that loan and fees from the development manager. The SPV usually capitalises the interest and fees into the development rather than expensing them. That's the part that turns an elimination from bookkeeping into accounting.

How to consolidate multiple SPVs in Xero

The consolidation itself is hub and spoke, and five pieces do most of the work.

An entity register, held as data. One list of every company, with its role (holdco, development manager, SPV), its project, its status (active, completed, dormant, sold) and the dates it joined and left the group. The consolidation reads the list, so adding a site means adding a row, not a tab.

One chart of accounts for every SPV. SPVs are near-identical businesses, so they should be near-identical ledgers. Xero can import a chart of accounts from a CSV, so every new SPV can start from the same file. The group account map then barely changes, and when it does, you change one mapping rather than nine.

A column per company, which is a column per project. It's the one thing the structure gives you free: the consolidation worksheet is also the project report. Each column shows a site's costs, sales and margin, standalone for its lender and eliminated for the board.

An intercompany loan matrix. Lenders go down the side and borrowers across the top, and each cell shows both sides' balances and the difference. In a pure hub-and-spoke group it's effectively one row. Once one SPV lends surplus sale proceeds to the next, it becomes a grid, and the grid is where the problems show.

Two kinds of elimination, kept apart. The balances (loan principal, accrued interest, unpaid fees) eliminate against each other, exactly as in our intercompany eliminations guide. The income is different. The holdco's interest income and the development manager's fee income have to be eliminated against wherever the SPV put the other side. In a development, that's usually not an expense. It's the cost of the building.

Here's how that plays out, with invented figures in thousands. HoldCo has lent SPV Riverside 3,000 at 4% for the year, which is 120 of interest. DevCo charges Riverside a development management fee of 90. Riverside is building units to sell, so it capitalises both into development work in progress. Neither has been paid, so both are added to what Riverside owes.

The balances cancel, as they would in any group. The income line is the interesting one. Added up, the three companies made 210 of profit from these charges. The group made none, because nobody outside the group was paid any interest or any fee. So the elimination takes 210 out of group profit and 210 out of the building. IFRS 10 is explicit about this: profits from intragroup transactions that are recognised in assets such as inventory are eliminated in full (paragraph B86).

That makes it the exception to the rule of thumb in our eliminations guide, which says a correct intercompany elimination almost never moves group profit. In a property group, this one should.

The next year, Riverside sells 60% of its units, and 60% of its work in progress goes to cost of sales. That includes 126 of the capitalised interest and fees (60% of 210). The group never carried that 126, so the group's cost of sales is 126 lower than the companies' combined, and group profit is 126 higher. Over the life of the project, the group and the companies recognise the same total profit. Only the timing differs, and the timing is the whole job.

Where the difficulty actually lives

The elimination has a memory

Capitalised charges build up over two or three years of construction, then release as units sell, in the same proportion the SPV releases cost. So each period's elimination needs to know, for each project, how much has been capitalised to date and how much has already been released. None of that is in any Xero organisation. It has to be carried forward from the last signed-off consolidation, the same way a consolidated cash flow statement needs last year's group balance sheet.

Two variations catch people out. If the SPV keeps the finished building as an investment property at fair value, the eliminated charges come back through the revaluation gain instead of through cost of sales. And the timing difference has a deferred tax consequence, which B86 itself points to (IAS 12 governs it).

Intercompany interest isn't group interest

IAS 23 defines borrowing costs as the costs "an entity incurs in connection with the borrowing of funds". It requires them to be capitalised when they're directly attributable to a qualifying asset, a category that can include inventories and investment properties. From the group's side, the only borrowing that exists is external. If HoldCo funded Riverside from a bank facility, the group may still capitalise the interest HoldCo actually paid the bank, even though HoldCo expensed it in its own accounts.

So the adjustment can run both ways: eliminate the intercompany charge, then capitalise the external cost the group really incurred, at the rate it was incurred. IAS 23 concedes this takes judgement when financing is co-ordinated centrally (paragraph 11), and in some circumstances it allows a weighted average across the parent's and subsidiaries' borrowings (paragraph 15). Decide the policy once, with your auditor, and write it down. If it gets re-decided every quarter, the group's work in progress ends up carrying a number nobody can derive.

The loan balances never agree

Xero won't pair the two sides, and in an SPV group they drift apart for predictable reasons:

• Payments on behalf. HoldCo pays the land deposit, the stamp duty and the architect, often before the SPV has a bank account and sometimes before it exists. HoldCo books a receivable. The SPV books nothing until someone sends it the paperwork.
• Interest on different clocks. HoldCo accrues monthly. The SPV books the year's interest in one journal at year-end. Every interim consolidation has a one-sided gap.
• Sale proceeds swept up. Cash from completions moves up to HoldCo. One side codes it as a loan repayment, the other as a dividend or a transfer.
• SPVs lending to each other. Surplus from a finished project funds the next one directly, and the hub becomes a web.

The matrix is the control. Every difference gets explained before anything is eliminated, because an elimination posted over an unreconciled gap just hides the gap inside the group total.

The entity list keeps moving

A new SPV is the easy case, provided it starts from the standard chart: one new register row, and the map already fits. The harder cases come at the other end of a project's life.

A dormant SPV is still a subsidiary until it's struck off or sold, so it stays in the consolidation. It's usually holding a residual loan and some retained profit waiting to go up to HoldCo. If HoldCo waives the loan instead, that's an expense in one company and income (or a capital contribution) in the other, and it eliminates like any other intercompany charge.

A share sale takes the SPV out of the group, and the group's gain isn't the holdco's gain. HoldCo measures the proceeds against its cost of investment. The group measures them against the SPV's net assets as the group carried them, which is where the per-project memory of eliminated charges gets used one last time.

An SPV with a joint venture partner needs a different mechanic (non-controlling interest or equity accounting), which is beyond this post.

What a reliable build looks like

1. An entity register the consolidation reads, with each company's role, project, status and dates in and out of the group.
2. One chart of accounts across every SPV, imported from a single file at set-up, so the group map stays small and stable.
3. An intercompany matrix every period, showing both sides and the difference for each pair, with every difference explained before elimination.
4. Balance eliminations and income eliminations on separate, labelled lines, so a reviewer can see which ones touch the building.
5. A per-project schedule of capitalised intercompany charges: capitalised to date, released, and still in work in progress, carried forward rather than recalculated.
6. A written group interest policy saying what's eliminated, what external interest the group capitalises, and at what rate.
7. Checks that know about the exception. Balances net to zero. Group profit differs from the sum of the companies only by the capitalised-charge adjustments, and the check shows each one.
8. Plain formulas, so the workbook survives a download to Excel and the auditor can trace any cell.

Where Cheetah fits

Cheetah builds consolidated reports on top of Xero for multi-entity groups, including groups of small, near-identical companies. For an SPV structure, that means an entity list driven by the register, one account map, the loan matrix, and the capitalised-charge schedule carried from one period to the next. Each project gets a column, which doubles as the project report. It all arrives in Google Sheets with plain formulas and an Excel download.

If your group close is a week of agreeing loan balances across a dozen small companies, it's probably worth a look.

The short version

An SPV group is many small companies whose economics live between them. Xero reports each company on its own and won't match the holdco's loans against the SPVs' side. Most of the consolidation is ordinary: add the companies up and eliminate the balances. The property-specific part is the interest and fees each SPV capitalises into its development. They have to come out of both group profit and the building, then come back as the units sell. Carry that per project, write down the interest policy, and let a register, not a tab structure, define the group.

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