Multi-Entity Consolidation

An entity register and scope memo, group policies, mapping and reporting packs, monthly intercompany matching, eliminations and currency translation, and the acquisitions, disposals and specialist cases that test a group close.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Multi-Entity Consolidation, and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help your team organise its work. It is not financial, investment, tax, accounting or legal advice, and it does not recommend any product, investment or deal. Rules differ between countries, so check decisions that matter with qualified, licensed advisers in the countries concerned. Investing can lose money, and raising or managing other people's money is regulated in most countries.

What it installs.

1

Pillar

1

Area

50

Projects

207

Starter tasks

🧾 Finance & Accounting

Multi-Entity Consolidation

Consolidating results across subsidiaries and regions, eliminating intercompany balances and reporting group figures for growing and international organisations.

  1. Group structure chart and legal entity register
  2. Consolidation scope and control assessment
  3. Functional currency assessment for each entity
  4. Group accounting policies manual
  5. Group chart of accounts and entity mapping
  6. Group reporting calendar with entity deadlines
  7. Entity reporting pack design
  8. Intercompany counterparty codes and account structure
  9. Current consolidation process map and pain points
  10. Monthly intercompany balance matching
  11. Intercompany ageing and settlement routine
  12. Monthly group consolidation run
  13. Standing elimination journals library
  14. Foreign currency translation run each period
  15. Entity pack review and query log
  16. Local GAAP to group policy adjustments schedule
  17. Unrealised profit in intercompany stock
  18. Non-controlling interests schedule
  19. Group equity and reserves roll-forward
  20. Group close timetable performance log
  21. Control and consolidation scope standards study
  22. Foreign currency translation and the translation reserve
  23. Equity accounting for associates and joint ventures
  24. Goodwill and purchase price allocation fundamentals
  25. Intercompany elimination worked examples
  26. Consolidated cash flow statement from entity data
  27. Segment reporting from the consolidation
  28. Consolidation software selection
  29. Spreadsheet to consolidation system migration
  30. Intercompany dispute resolution rule
  31. Cutting the group close by three working days
  32. Entity reporting tiers and query thresholds
  33. Dormant and small entity rationalisation review
  34. Intercompany recharge and invoicing automation
  35. Integrating an acquired subsidiary into group reporting
  36. Disposal and deconsolidation of a subsidiary
  37. Onboarding a newly incorporated entity
  38. Half-year consolidated reporting pack
  39. Year-end consolidated financial statements and notes
  40. Group audit component reporting and confirmations
  41. First consolidation after opening a second entity
  42. New group financial controller's first 90 days
  43. Subsidiary accountant handbook for group reporting
  44. Consolidation team cover and skills matrix
  45. Regional sub-consolidation for a cluster of countries
  46. Entities with different reporting dates
  47. Changes in ownership without loss of control
  48. Intercompany loans forming part of the net investment
  49. Hyperinflation assessment for an operating entity
  50. Deferred tax on consolidation adjustments

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Group structure chart and legal entity register

Consolidation starts with knowing exactly which companies exist, who owns them and in what percentages, and that list is often scattered between the company secretary, the tax adviser and an old slide. A single register with each entity's legal name, registration number, country, owner, ownership percentage, year end and status gives every later project in this area one source of truth.

First tasks

  • Collect the latest entity list from the company secretary, legal team or registered agent
  • Record legal name, number, country, owner and ownership percentage for each entity
  • Calculate effective ownership for every indirectly held company
  • Draw the group structure chart from the register and send it to legal for review
  • Reconcile the register to company registry filings and share registers @recurring(yearly)

Consolidation scope and control assessment

Which entities are consolidated depends on control, not simply on owning more than half the shares: voting agreements, potential voting rights, board appointment rights and structured entities can change the answer either way.

First tasks

  • Pull every shareholder agreement and joint venture agreement into one folder
  • Classify each entity in the register against the control criteria your framework uses
  • Write a short memo on each borderline entity with the evidence considered
  • Send the scope memo to the auditors for comment before the next reporting date
  • Reassess scope against the latest register and agreements @recurring(yearly)

Functional currency assessment for each entity

An entity's functional currency is the currency of the economy it mainly operates in, judged from where it sells, sets prices, incurs costs and raises finance, and it is not automatically the currency of the country it is registered in. Getting it wrong distorts every translation and exchange difference that follows, and changing it later is disruptive.

First tasks

  • List the currency of sales, costs and borrowing for each entity
  • Flag entities whose ledger currency differs from their likely functional currency
  • Write a functional currency conclusion for each entity with its main indicators
  • Review the conclusions with the auditors or your technical accounting adviser
  • Confirm no entity's underlying operations have shifted currency @recurring(yearly)

Make it yours.

Install Multi-Entity Consolidation, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.