Consolidation Software for Small Groups on Xero: Add-On, Excel or Bespoke?

A group runs four companies on Xero: a holding company, two trading companies and a subsidiary that reports in another currency. Its consolidation lives in an Excel model the previous financial controller built. It takes three days a month, and nobody fully trusts the eliminations tab.

So someone draws up a shortlist: Fathom, Joiin, Spotlight Reporting, Syft. Every sales page ticks the same boxes. Eliminations, multi-currency, account mapping, partial ownership. The trials look alike too.

Choosing consolidation software for small groups isn't decided on those boxes. It's decided in the help centres, in the sentences that start with "only", "manually" and "at the account level". This post goes through where the standard tools draw their lines, in their own words, then how to choose between an add-on, an Excel template and a bespoke build.

The three routes

Xero's own reports, including Xero Analytics, don't combine organisations. Consolidation sits in Syft, the reporting app Xero bought in 2024, or somewhere else entirely. We cover what native Xero does give a group in Can Xero do consolidation? That leaves three routes:

• An Excel template. Export each company's figures every month, then paste, map, eliminate and translate. Every rule is yours, and so is every hour.
• A consolidation add-on. Fathom, Joiin, Spotlight, Syft and others connect to each Xero organisation and do the mechanics. You get their model of a group, set up in their app.
• A bespoke build. A consolidation designed around your group's rules and your layout, running on live Xero data.

For most small groups an add-on is the right answer, and leaving Excel is a big win. Whether your group is one of them depends less on features than on constraints.

Where standard consolidation software draws its lines

Everything below comes from the vendors' own help centres, read in October 2026. They ship often, so check the current docs before you decide. None of it makes these bad tools. Each line is a design choice that keeps the product simple for the groups it's built for.

Eliminations work on accounts

The simplest elimination removes a whole account. Fathom's automated elimination applies "if an account only holds intercompany transaction amounts", and it removes "the entire account value for the current period and all past and future periods". Spotlight "eliminates the full account balance for each month". For anything else, both point you to a manual route: an adjustment account, or a separate eliminations company built in Excel. Fathom's help centre is plain about it: "Eliminations made through an Eliminations Company must be manually entered each period."

Joiin and Syft go further. Joiin can eliminate by account and contact pair, and Syft offers transaction-level eliminations, though not on every plan.

This matters the moment intercompany shares an account with outside business. Say a management fee charged to a subsidiary is booked to the same revenue account as client fees. Eliminating the account takes real revenue with it. If your ledgers look like that, the eliminations tab you were trying to retire comes back, inside the new tool. Our intercompany eliminations guide covers how to make them findable.

Translation is a balancing line

All four can translate the P&L at average rates and the balance sheet at closing rates, and all four let you enter your own rates. Fathom and Joiin default to Open Exchange Rates, and Spotlight uses XE.com.

The difference is where the translation difference goes. Joiin "automatically adds FX adjustments to the report output to counteract these imbalances". Spotlight's FX Reserves line, in its own words, "is needed to balance the report". Fathom has you calculate the adjustment yourself and post it to "a Currency Translation or FX Reserve account" in your Eliminations Company. Syft can post it to an account in equity.

A balancing line is fine for management reporting. A translation reserve that rolls forward from last year's closing balance, and that an auditor can pick apart, is a different piece of work. The method is in our multi-currency reporting guide.

Mapping runs on names

Fathom "consolidates financials based on account name and account classification", and "any changes in account naming must be made in the source accounting software." Joiin merges on account type and name by default (you can switch to codes), and because it "identifies an account by its type, code and name", renaming an account in Xero makes it look like a new one. Spotlight combines accounts by a display name. Syft builds a group for each account and combines groups with the same name.

In a group whose companies were set up by different bookkeepers, mapping becomes a setup project and then a monthly chore: every new account in any company is a line someone has to place.

Ownership is a percentage

Fathom "does not natively support partial ownerships or minority interests". Joiin and Spotlight scale every value in a company by an ownership percentage. Spotlight's can change by date, and Joiin documents no effective date. Syft offers the same proportional method, or full consolidation where "you can add journals in the consolidation to account for goodwill, fair value, and non-controlling interests".

A proportional "our share" view is useful for a board. It isn't how statutory accounts treat a partly owned subsidiary, which is consolidated in full with the outside owners' share shown separately. That gap has its own post: non-controlling interest on Xero.

The group has one shape

Groups change. A company is bought in July, another sold in March, and one subsidiary's year ends in a different month. The tools handle this unevenly:

• Fathom has you choose one financial year for the group, and once you move the group's start date, "you will not be able to add prior periods back to the group."
• Joiin has an acquisition date that "defines when a company becomes active for reporting", but documents no disposal date.
• Spotlight documents neither. You add or remove organisations, and the dated ownership percentage is the only lever.
• Syft has acquisition and disposal dates per entity, again not on every plan.

Tracking categories lose the eliminations

Fathom combines divisions with matching names across companies, but "if you have eliminations configured in your Consolidated Group, these will not be reflected in division totals." Joiin merges same-named tracking categories, on the P&L only. Syft says its segments include only accounts "that have transactions allocated to the relevant divisions". A group P&L by region or department is usually a gross view: fine for comparing sites, not for a segment note.

The output is a management report

Fathom says so itself: it "is designed as a management reporting tool for internal reporting, rather than as a statutory reporting tool." That's an honest description of the whole category.

Layouts are flexible within each tool. Joiin's custom layouts take groups and formulas, Syft's take equations, and Fathom builds bespoke tables from KPIs row by row. Exports vary: Joiin's Excel download carries formulas for totals but, with custom layouts, "may include hard-coded values". Rebuilding the exact pack your board already reads, line for line, is where trials tend to get close and then stall.

What an Excel template constrains instead

Excel has no ceiling on logic. Any elimination rule, any FX method, any layout. Its constraints are of a different kind:

• Labour. Each company's reports are exported, pasted and checked every month. Xero's trial balance leaves out accounts with nil balances, so rows move between months and every lookup has to cope.
• Silent breaks. A new account in one company falls outside the SUMIF ranges. Nothing errors; the totals are just wrong.
• One owner. The model belongs to whoever built it. When they leave, it becomes the template nobody trusts.
• No trail. A group figure traces back to a pasted number, not to a transaction in Xero.

A template bought online fixes month one, not month twenty. Excel suits a group of two or three companies with simple intercompany and someone who's happy to own the model. Past that, the hours grow with every company.

Consolidation software for small groups: how to choose

For groups under 10 entities, size is rarely the problem. Complexity is. Count how many of these describe yours:

1. Intercompany that shares accounts with third-party transactions
2. More than one currency, with a translation reserve to roll forward
3. Partly owned subsidiaries
4. Companies joining, leaving, or on different year ends
5. A group view by tracking category that has to be eliminated
6. A report format that can't change: a board pack, a lender's covenant schedule, a statutory set

At two or more, watch for a spreadsheet beside the add-on. Once the tool's output gets finished in Excel every month, you're maintaining both.

For accounting firms with group clients

The best Xero consolidation software for accounting firms answers a slightly different question. A firm wants one tool that staff can run across many clients without the person who set it up, and output that looks the same from client to client. Spotlight is built around exactly that, and we compared it with Joiin and Fathom in Joiin vs Fathom vs Spotlight. Others worth a look, such as Calxa and Konsolidator, plus Mayday for the intercompany side, are in our guide to Xero reporting add-ons.

The catch is the exceptions. Most group clients fit the tool. The two that don't, the one with a 70% subsidiary and the one whose management fees land in revenue, cost the firm unbilled hours every month, which is where margins quietly go. Standardise the clients that fit, and treat the ones that don't as a separate problem rather than forcing them into the tool.

What to test in the free trial

1. Eliminate a cross-charge that sits in the same account as third-party sales. What's manual?
2. Where does the translation difference go, and does it roll forward from last year's closing balance?
3. Add an account in one company and sync. Where does it land?
4. Set up a 70% subsidiary. Is it consolidated in full with a separate non-controlling interest, or scaled to 70%?
5. Add a company from 1 July. Does last year's comparative survive?
6. Split the group P&L by tracking category. Are the eliminations in it?
7. Export to Excel. Formulas or values? Can a figure be traced to a Xero transaction?
8. Rebuild one page of your current board pack exactly. How close does it get?

Where Cheetah fits

Cheetah is for when none of the above fits. We don't sell an app you configure. We build the consolidation around your group's rules, on top of your Xero data.

That means eliminations by whatever identifies your intercompany, whether that's an account, a contact, a reference or a combination. It means a translation reserve carried from one period to the next at the rates you choose, ownership held by date, and companies that join mid-year without breaking a comparative. And it means your board pack's layout, line for line, rather than a version of it. Each run includes check tabs that tie the group back to every company, and it lands in Google Sheets with plain formulas and an Excel download.

If an add-on gets you most of the way and the part it can't do is the part that matters, our consolidation service might be worth a look.

The short version

Most small groups should buy a consolidation add-on and retire the spreadsheet. Before you do, read the help centre rather than the sales page. The lines to look for: eliminations at the account level, translation as a balancing line, mapping by name, ownership as a percentage, one fixed group shape, and tracking categories without eliminations. If none of those touch your group, pick the tool whose model suits you. If two or more do, test them hard in the trial, or look at a bespoke build.

For the wider set of routes, from native Xero to the API, see Xero Custom Reports: 4 Ways to Build Them in 2026.