Joiin vs Fathom vs Spotlight Reporting: Which Is Best for Multi-Entity Dashboards?

Every group that outgrows a single Xero organisation ends up on roughly the same shortlist. Joiin vs Fathom vs Spotlight Reporting, three free trials running in three browser tabs, and a spreadsheet somewhere comparing feature checkboxes that all say "yes."

The checkboxes don't help, because at this level they're all true. All three consolidate multiple Xero organisations. All three do intercompany eliminations. All three handle multi-currency. All three produce dashboards. If you're picking based on whether a feature exists, you'll find the three tools nearly identical and the decision will come down to which trial you happened to start first.

That's the wrong way to run this. The useful comparison isn't feature-by-feature — it's about what each tool was built for, because that's what determines where it stops bending. Here's a third-party take on all three, from someone who doesn't sell any of them.

Before building Cheetah, I spent 3 years building software for an accounting firm to automate their internal processes, and 4 years running product in a venture-backed FP&A software startup. I've evaluated these software for client use, my company's use and done deep dives into their functionality and reporting paradigm.

What all three actually do

Before the differences, the shared ground. This is the 80% that makes any of them a massive upgrade on a spreadsheet:

• Connect multiple Xero organisations and pull data automatically, no export step.
• Map divergent charts of accounts onto a common group structure.
• Eliminate intercompany balances and transactions.
• Translate currencies for groups running entities in more than one.
• Produce dashboards and report packs that look presentable to a board without anyone rebuilding them in PowerPoint.

If your group is five entities, one currency, a handful of intercompany cross-charges, and a chart of accounts that's broadly consistent, any of the three will do the job. Genuinely. Pick on price and interface and stop reading — you'll be fine.

The rest of this is for the groups that aren't that.

Joiin: the entity-count play

Joiin is the most narrowly focused of the three, and that's a compliment. It's a consolidation and reporting tool, not a platform trying to also be your forecasting suite.

What it does well: chart of accounts mapping is flexible, which matters more than it sounds. Divergent account structures across jurisdictions are the single most common reason consolidation projects stall, and Joiin treats mapping as a first-class feature rather than a setup chore. It connects beyond Xero — QuickBooks, Sage, spreadsheets — so a group that's mid-migration or carrying an acquired entity on a different ledger isn't stuck. There's an API for pushing data into Power BI or Tableau if you want to build on top of it.

Pricing scales by number of entities consolidated, with every feature included on every tier and unlimited users. That structure is unusually honest — no discovering that the thing you need lives two tiers up.

Where it fits: growing groups where the entity count is the main complexity, and the reporting requirements are recognisable. Multi-entity dashboards that answer "how did the group do" rather than "how did the group do, sliced eleven ways specific to our business."

Fathom: the analysis play

Fathom has been in the Xero ecosystem longer than most and has the install base to show for it. It consolidates — up to 300 entities in a single group — but consolidation isn't really the centre of gravity. Analysis is.

That's the actual differentiator. Fathom ships with a large library of pre-built KPIs, benchmarking that ranks entities or franchisees against each other, three-way cash flow forecasting, and visual reporting that's genuinely good out of the box. If your multi-entity dashboard's job is comparing performance between entities — which location is underperforming, which franchisee is dragging the average — Fathom is built for exactly that and the other two aren't, quite.

The eliminations model is worth understanding before you commit. Fathom lets you eliminate entire accounts from underlying companies, or apply specific-value adjustments. That covers the common cases cleanly. It's less comfortable when your intercompany activity doesn't sit neatly in dedicated accounts — where an intercompany cross-charge lands in the same revenue account as third-party revenue, and eliminating the account would take real revenue with it. If that describes your ledger, the fix is usually tidying the chart of accounts rather than fighting the tool. Worth knowing which of those two projects you're signing up for. We've written separately about what intercompany eliminations actually require beyond the simple cases.

Pricing is tiered by number of company files, and the steps are meaningful. Model it against your actual entity count before the trial ends, not after.

Spotlight Reporting: the firm play

Spotlight is the one built for accounting firms rather than for finance teams, and the whole product reflects that.

It's modular — reporting, forecasting, dashboards, consolidation, and ESG each as their own piece. Consolidation scales high; the dedicated multi-entity module handles group and franchise structures well past where most SME groups will ever go. Custom report flexibility is generally rated its strongest suit, and for a firm that needs a repeatable branded delivery format across dozens of clients, that flexibility compounds.

Pricing is per firm, by number of client organisations, not per user. If you're an advisory practice running monthly reporting for twenty clients, that model is in your favour and the per-client cost gets sensible quickly. If you're a single group with six entities and no client base, you're paying for a shape you don't have.

Where it fits: firms delivering advisory reporting at volume, and franchise groups where the reporting is fundamentally the same pack repeated many times.

The pricing models differ more than the prices

This is the part most comparisons skip, and it's the part that actually bites eighteen months in.

Joiin charges by entities consolidated. Fathom charges by company files. Spotlight charges by client organisations at the firm level. Those sound like the same thing. They aren't, and which one is cheapest depends entirely on the shape of what you're consolidating — and on what happens when that shape changes.

Run the numbers on your structure two years out, not today. A group that acquires an entity a year, or a firm that adds clients steadily, crosses tier boundaries on a schedule. Published prices move; the models tend not to. Check current pricing directly with each vendor before deciding, but do the tier-boundary maths yourself.

So which is best for multi-entity dashboards?

Direct answers, since that's what the question deserves:

• Comparing entities against each other — which site, which franchisee, which market is underperforming — Fathom. The benchmarking and KPI library are built for it.
• Consolidating a growing group cleanly, with messy charts of accounts — Joiin. The mapping flexibility and per-entity pricing suit that trajectory.
• A firm delivering client reporting at volume — Spotlight Reporting. The firm-level pricing and modular structure are designed around exactly that business.

Notice none of those answers is about the dashboard itself. All three produce good dashboards. What differs is the model underneath them, and the model is what you're actually buying.

The question that decides it, and isn't on any feature list

Here's the thing every one of these comparisons dances around: all three tools are built on an assumption about what a group looks like. Entities roll up. Intercompany sits in identifiable accounts. The group P&L is recognisably a P&L. Reporting complexity comes from scale — more entities, more currencies, more clients.

For most groups, that assumption holds and the tools work beautifully.

It stops holding when your reporting complexity comes from logic rather than scale. Some real examples of where the ceiling shows up:

Eliminations that need rules, not account-level flags. Intercompany that's identifiable by reference or counterparty rather than by sitting in a dedicated account. Partial eliminations. Unrealised profit in inventory that has to be backed out on consolidation.

Group layouts that don't look like a standard P&L. Revenue grouped by stream rather than by account. Costs grouped by function. Calculated rows for the margin definitions your business actually runs on — not gross margin as the tool defines it, gross margin as your board defines it.

Vertical-specific economics. Payment gateway fees netted against the right revenue lines. Delivery platform commissions separated from dine-in. Cost of sales that has to move between categories depending on channel. Anything where the number your business cares about doesn't exist as a line item in Xero and has to be derived.

FX handling with judgement in it. P&L at average rates, balance sheet at closing, equity at historical, and the translation difference landing in the right reserve. Most tools handle the standard case; the edges get manual fast. Multi-currency reporting on Xero is its own rabbit hole.

Tracking-category overlays at group level. Slicing a consolidated view by department or location, not just presenting one combined number.

Comparatives that survive structural change. Adding an entity mid-year without breaking the prior-year comparative.

If two or more of those describe your group, the honest expectation for all three tools is that they'll get you a long way and then hand the last stretch back to you. Which is fine — 70% automated beats 0% automated. Just don't budget as though it's 100%, because the remaining 30% is the part that eats the month-end.

Where Cheetah fits

We're not on this shortlist, and this post isn't a stealth pitch to put us there. Joiin, Fathom, and Spotlight are good products, and for most groups on Xero one of them is the right answer.

Cheetah is the answer to the other case: when the reporting logic is the hard part, not the entity count. We build custom consolidated reporting directly on Xero — eliminations by whatever rule your group actually needs, FX translation handled properly, your group layout rather than a template, the calculated lines and margin definitions your business runs on. Because it's built for your structure, there's no ceiling where the standard case ends and yours begins.

The tell is simple. If you've trialled one of the three and found yourself thinking "this does almost everything, except this last painful bit that's probably too bespoke for any software out there" — that last bit is the whole conversation. Worth a look if that sounds familiar.

Otherwise, take the shortlist above, pick the one whose model matches your shape, and get off the spreadsheet. That's the bigger win either way.