Manual Journals or a Consolidation Worksheet: Why Group Eliminations Stay Out of Each Xero Ledger

This article assumes a group of Australian-domiciled entities reporting in AUD, with wholly owned subsidiaries, all on Xero. Foreign subsidiaries add AASB 121 foreign currency translation, and partly owned subsidiaries add non-controlling interests. Both are outside the scope of this article.

The shortcut that looks tidy

Picture an ASX or NSX junior explorer with a listed head company and a wholly owned subsidiary that holds the tenements. Each company keeps its books in its own Xero organisation. The head company has lent the subsidiary $500,000 to fund drilling (an illustrative figure). At the end of the quarter someone needs group numbers, and the loan has to come out.

The shortcut is to open the head company's Xero organisation and post a manual journal that clears the loan receivable. The group figures look right straight away. This article explains why that entry belongs somewhere else, and what the somewhere else needs to hold.

What AASB 10 says the consolidated statements are

AASB 10 Appendix A defines consolidated financial statements as the financial statements of a group in which the assets, liabilities, equity, income, expenses and cash flows of the parent and its subsidiaries are presented as those of a single economic entity. The group is the subject of those statements. Each company in it is still its own legal entity, with its own ledger.

Paragraph B86 then lists the consolidation procedures. Consolidated financial statements combine like items of the parent and its subsidiaries (B86(a)), offset the parent's investment in each subsidiary against the parent's portion of that subsidiary's equity (B86(b)), and eliminate intragroup assets, liabilities, equity, income, expenses and cash flows in full (B86(c)). Paragraph B87 adds that where a group member uses different accounting policies, appropriate adjustments are made to that member's financial statements in preparing the consolidated financial statements.

Read together, these are steps in preparing the group's statements. They describe the group as one economic entity. They do not describe a transaction that either company entered into.

Three things that break when the entry goes into Xero

A manual journal posted in a Xero organisation goes into that organisation's general ledger, and from there into its reports, including its trial balance, balance sheet and profit and loss. So an elimination posted in Xero changes the entity's own records, not just the group view.

1. The entity's own books stop being true

The subsidiary still owes the head company $500,000. That is a real asset of the head company and a real liability of the subsidiary. Once the receivable is cleared in the head company's ledger, the head company's own balance sheet leaves out an amount it is legally owed. Any report run from that organisation no longer shows the entity's own position.

2. The two sides stop agreeing

A journal in the head company's Xero organisation can only post to the head company's own accounts. To clear the receivable, the other side of the entry has to land in another head company account, such as a suspense account. The subsidiary's $500,000 payable is untouched in its own ledger. Next quarter the consolidation starts again from both trial balances, and the intercompany pair no longer ties: the receivable reads zero, the payable reads $500,000, and a $500,000 balance sits in a head company account that means nothing to the head company. Whoever runs that consolidation has to work out why before the elimination can be done.

3. The ledger holds an entry with no source

The rest of the head company's ledger records the head company's own affairs: a bill, a bank transaction, a share issue, a period-end accrual. The elimination does not. It records a fact about the group. Anyone reading that ledger later has to know the group context to understand why the entry is there.

Where each kind of entry belongs

The real transactions have to be in both ledgers for the worksheet to work. The elimination removes a matched pair. If one half of the pair was never posted, there is nothing to match it against. We cover the map in Chart of Accounts Mapping Across Two Xero Organisations.

What the worksheet needs to hold

1. One column per entity. Each organisation's trial balance at the same date, already mapped to the group chart.
2. An eliminations column. Each elimination is a balanced journal with a number, an amount, the paragraph of AASB 10 it applies, and one line on why.
3. A group column. The sum of the entity columns and the eliminations, line by line.
4. Checks at the foot. Every column nets to zero. Every intercompany pair ties before it is eliminated. We explain the zero test in Where a Group Consolidation Starts: The Trial Balance, Not the Profit and Loss.

Because the eliminations live in the worksheet and not in either ledger, each period starts clean. The worksheet takes this period's trial balances and works out this period's eliminations from them. Nothing has to be reversed in Xero, and nothing from last quarter is sitting in an entity ledger waiting to be counted twice.

Keep the worksheet with the working papers

Save each period's worksheet with the date and the two trial balances it was built from. Together with the chart of accounts map, it shows how every group number was reached, entry by entry. The two Xero organisations stay what they should be: a true record of each company, ready to be combined again next quarter.

Syed Samir Ahmad
Founder, Genius Accounting Solutions
CA ANZ | Xero Partner