•

Has your group outgrown its financial consolidation software? Six checks for multi-entity groups

Default author

Written by Joiin

• 5 min read
  • From pricing and entity limits to report sharing, these six practical checks will help you assess whether your consolidation software can support your group’s next stage of growth.

    Short answer: your group has probably outgrown its financial consolidation software if month-end takes days, intercompany eliminations still happen in Excel, or the tool can’t handle a new currency or a partly owned subsidiary.

     

    Most multi-entity groups choose a reporting tool when the group is small and rarely look at it again. Then the group grows. A new trading company, an overseas subsidiary or an acquisition on a different ledger can turn a tidy month-end into days of spreadsheet work.

     

    The setup that suited three entities may not suit eight. But it’s hard to spot from inside the month-end rush, because the workarounds build up slowly.

     

    Here are six checks to tell whether your reporting still fits your group, whether you use consolidation software for Xero, QuickBooks or Sage today or still stitch reports together in Excel. They’re based on what we see at Joiin, where we build consolidation and reporting software for multi-entity groups and their advisors.

    1. Will your costs stay predictable as you add entities?

    Look ahead 12 months. If you plan to acquire a company, open a new trading entity or bring a subsidiary onto its own ledger, your entity count goes up. Your reporting costs should rise in a way you can plan for, not jump unexpectedly.

     

    There are two common models. Some tools charge per entity, so every new company adds a fixed amount. Others price in tiers, where a band of entities costs the same until you move into the next band. Neither is wrong, but they behave very differently as you grow.

     

    Ask three questions:

    • How will my costs change if I add two or three entities?
    • Are consolidated groups charged separately, or only the underlying companies?
    • Does the price cover everyone who needs the reports, or does each extra user add cost?

     

    And weigh cost against time. A tool that removes days of spreadsheet work from every month-end is worth more than its price tag suggests.

    2. How many entities can your multi-currency consolidation include?

    Headline entity limits can be misleading. A tool may consolidate hundreds of companies in a single currency but allow far fewer in a multi-currency group.

     

    Joiin doesn’t split its limits this way. A multi-currency group in Joiin can include as many entities as a single-currency one.

     

    That matters the moment you add an overseas subsidiary. A UK group with an Irish company and a US company is a multi-currency group, even if everything else reports in sterling.

     

    Find the limit that applies to your structure, not the one on the pricing page. Then check how exchange rates work. Can you use your own rates for budgeting and reporting, or only the tool’s defaults? Your auditors and your board will care about the answer.

    3. How does your software handle intercompany eliminations?

    An intercompany elimination removes transactions between companies in the same group, so the consolidated accounts only show trading with the outside world.

     

    Intercompany transactions are where consolidations go wrong. A management fee from your holding company to a trading company is income in one set of books and a cost in the other. Leave both in, and the group’s revenue and costs are overstated. The same applies to intercompany loans, recharges and sales between group companies.

     

    Your software should remove these automatically, every month, without someone rebuilding the adjustment in a spreadsheet. Ask how eliminations are set up:

    • Can you eliminate whole accounts, specific amounts, or both?
    • Can you save rules so they run every period?
    • What happens when intercompany balances don’t match on both sides?

     

    If your team still exports to Excel to finish the eliminations, the tool isn’t doing the job you’re paying for.

    4. Can it handle partly owned subsidiaries and mixed ledgers?

    Few groups stay simple. A business that started as one company often ends up with a holding company, a property company, a couple of trading subsidiaries and a joint venture. Check that your software can handle what you actually own.

     

    Two areas catch people out. The first is partial ownership. If you own 60% of a subsidiary, your consolidated accounts show a non-controlling interest. That’s the share of the subsidiary’s profit and net assets owned by its other shareholders, and some tools don’t support it natively. That pushes the calculation back into Excel.

     

    The second is mixed ledgers. Acquired companies often arrive on a different accounting system. Your consolidation tool should pull from Xero, QuickBooks and others side by side, and map each entity’s chart of accounts to one group structure.

     

    Xero itself doesn’t consolidate multiple organisations, and in July 2025 it confirmed on its product ideas forum that native consolidated reporting is not currently planned. So the tool you choose here carries the whole job.

    5. Can everyone who needs the reports see them?

    List who uses your reporting today and who should. That usually means the finance team, directors, your accountant, and sometimes lenders or investors. Check whether extra users cost more, and how easily you can share a report pack with someone outside the business.

     

    Think about where the numbers end up, too. If your board pack is still finished in Excel or PowerPoint, find out whether the tool can push data into those formats directly.

    6. How long does your month-end consolidation really take?

    The best test is your own close. Note how long it takes from the last bank reconciliation to a consolidated P&L, balance sheet and cash flow your directors can read. Then note how much of that time is spent outside the tool.

     

    If the answer is days rather than hours, your group has probably outgrown its setup. Most consolidation tools offer a free trial, so you can run last month’s numbers through one and see the difference.

    Your reporting checklist

    • Connections to every ledger in the group
    • Saved, repeatable intercompany elimination rules
    • Multi-currency entity limit for your structure
    • Control over exchange rates
    • Support for partial ownership, if you need it
    • Reports shared with everyone who needs them
    • Predictable costs as you add entities
    • Time from close to consolidated reports

    How Joiin’s consolidation software handles these checks

    Joiin is built for multi-entity groups and the advisors who support them. It connects to Xero, QuickBooks Online, Sage, FreeAgent, Pennylane, Puzzle, Stripe and spreadsheets, so groups on mixed ledgers report in one place.

     

    You map each entity’s accounts to a group chart of accounts, set up intercompany elimination rules once, and consolidate across currencies with control over the exchange rates used. Multi-currency groups aren’t capped at a lower entity count than single-currency ones. And if you only own part of a subsidiary, you set the ownership percentage so reports reflect the non-controlling interest. Joiin then produces a consolidated P&L, balance sheet, cash flow and trial balance, and you can share them with your whole team, because every plan includes unlimited users.

     

    But consolidation is only half the job. Joiin Intelligence helps draft management commentary and flags significant movements across the group, and the Excel plugin pushes Joiin data straight into your own workbooks.

    You can try it on your own entities with a free trial.

    Frequently asked questions

    When should a group review its reporting setup?

    Whenever the group structure changes, such as a new entity, an overseas subsidiary or an acquisition. It’s also worth a yearly check so workarounds don’t build up unnoticed.

     

    Does Xero consolidate multiple companies?

    No. Each Xero organisation is a separate ledger, and Xero has said native consolidated reporting is not currently planned. Groups use a reporting tool that connects to each organisation.

     

    What’s the difference between per-entity and tiered pricing?

    Per-entity pricing adds a fixed cost for each company you connect. Tiered pricing charges one price for a band of companies, so costs rise in steps rather than with every new entity.

     

    How long does it take to switch?

    It depends on the number of entities and how much mapping you need. Connecting ledgers is quick; mapping charts of accounts and setting elimination rules takes the most time, and you only do it once.

    Try Joiin free for 14 days

    See how your own group looks in Joiin. Connect your entities, map your accounts and run last month’s consolidation, with full access to every feature during the trial. No credit card required.

    Start your 14-day free trial