1. Home
  2. Blog
  3. Financial Consolidation in ERP: IFRS 10, Eliminations and NCI

Financial Consolidation in ERP: IFRS 10, Eliminations and NCI

  • 10 min read
  • Tranquil team

Financial consolidation in ERP starts long before anyone opens the consolidation workbook. A Saudi group with a trading company, a contracting company and a small subsidiary in the UAE can close each set of books on time and still spend two weeks on the group numbers, because the intercompany invoices don’t agree, the charts of accounts differ and nobody recorded which company owns how much of which.

This article covers what IFRS 10 requires, how intercompany eliminations work with a worked example, how non-controlling interests and foreign subsidiaries are handled, and what an ERP has to record in each company so that the group close becomes routine.

The control test and which entities are consolidated

A group consolidates every entity it controls, not every entity it has shares in. Under IFRS 10, an investor controls an investee only when it has all three of the following:

  • power over the investee, usually through voting rights or contractual rights over the activities that affect its returns;
  • exposure, or rights, to variable returns from its involvement;
  • the ability to use that power to affect the amount of those returns.

Ownership percentage is a starting point, not the answer. A 45% holder with a shareholders’ agreement that gives it the right to appoint most of the board may control the company, while a 55% holder whose decisions all need a partner’s consent may not. Consolidation begins on the date control is obtained, so an acquisition in May brings in the subsidiary’s income and expenses from May, not from January.

Associates and joint ventures are not consolidated line by line. IAS 28 requires the equity method, where the investment is one line in the statement of financial position and the group’s share of profit is one line in profit or loss. A holding of 20% or more of the voting power is presumed to give significant influence unless the opposite can be shown.

One chart of accounts and shared master data

Most consolidation delays we see come from data, not from accounting. When each company keeps its own chart of accounts, someone has to map every local account to a group line every month, and the mapping drifts as accountants add accounts. The cleaner design is a single group chart of accounts with the same codes in every company, and branch or department detail held in cost centers rather than extra accounts.

Two other pieces of master data decide whether eliminations can be automated:

  • Each group company is set up as a customer and a supplier in the other companies, with the same partner code everywhere, so that intercompany balances can be listed by counterparty.
  • Intercompany revenue, cost and balances are posted to dedicated accounts (for example “Sales to group companies”), separate from third-party accounts.

IFRS 10 also requires uniform accounting policies for like transactions. If one subsidiary depreciates vehicles over four years and the group policy is five, the difference is adjusted in consolidation every month until the subsidiary changes its policy. The parent and subsidiaries should have the same reporting date. Where that is impracticable, the subsidiary’s own statements can be used if their date is no more than three months away from the group’s, adjusted for significant transactions in between.

Intercompany eliminations with a worked example

IFRS 10 requires intragroup assets, liabilities, equity, income, expenses and cash flows to be eliminated in full, including profits that are still sitting in assets such as inventory. The group cannot earn revenue from itself or owe money to itself.

A hypothetical example. The parent, a distributor, owns 80% of a contracting subsidiary. In March the parent sells goods that cost it 80,000 riyals to the subsidiary for 100,000 riyals plus VAT. By 31 March the subsidiary has used three quarters of the goods on a project and still holds the rest in its store, carried at 25,000 riyals. The profit still inside the group’s inventory is 25% of the 20,000 margin, which is 5,000 riyals.

Consolidation entry Account Debit (SAR) Credit (SAR)
E1 Eliminate the intercompany sale Revenue (parent) 100,000.00
Cost of sales (subsidiary) 100,000.00
E2 Remove unrealized profit Cost of sales 5,000.00
Inventory (subsidiary) 5,000.00

After E1 and E2, group revenue and cost of sales show only sales to outside customers, and the inventory is back at the group’s cost of 20,000 riyals. The VAT on the invoice is not eliminated, because it is a balance with ZATCA, not with the other company.

Balances need the same care. Say the parent’s ledger shows 46,000 riyals receivable from the subsidiary, while the subsidiary shows 34,500 payable, because it paid 11,500 on 30 March and the money reached the parent’s bank on 2 April. The difference is cash in transit. It is recorded first, and only then are the matching 34,500 riyals eliminated. Forcing the difference into an elimination account hides the real cause and comes back next month.

The mistake we see most often is eliminating only the parent’s 80% share of an intercompany transaction. The elimination is always in full. Ownership matters only when the result is split between the parent’s owners and the non-controlling interest, covered below.

Investment, goodwill and non-controlling interests

In consolidation, the parent’s investment in each subsidiary is offset against the parent’s share of the subsidiary’s equity, and the subsidiary’s assets and liabilities replace it line by line. On an acquisition, the amount paid above the fair value of the identifiable net assets acquired is, broadly, goodwill, and IFRS 3 sets the full calculation. IAS 36 requires goodwill acquired in a business combination to be tested for impairment every year.

The part the parent does not own is the non-controlling interest. It is presented within equity, separately from the equity of the parent’s owners, and profit or loss and other comprehensive income are attributed to both. In the example above, if the subsidiary earns 300,000 riyals for the year, 240,000 is attributed to the parent’s owners and 60,000 to the non-controlling interest.

Two ownership events are handled differently:

  • Buying more shares in, or selling some shares of, a subsidiary that stays controlled is an equity transaction. No gain or loss goes to profit or loss.
  • Losing control means derecognizing the former subsidiary’s assets and liabilities, recognizing any investment retained at its remeasured amount, and recognizing the gain or loss on the loss of control.

This is why the ownership register is part of the consolidation data. The percentage, the date it changed and the reason have to be recorded, or the split between parent and non-controlling interest cannot be recalculated when the auditor asks.

Foreign subsidiaries and currency translation

A subsidiary keeps its books in its functional currency, the currency of its main economic environment. A UAE subsidiary will usually record in dirhams, and the group presents in riyals. IAS 21 sets the translation rules:

  • assets and liabilities are translated at the closing rate on the reporting date;
  • income and expenses are translated at the rates on the dates of the transactions, and an average rate for the period is often used when rates do not move much;
  • the resulting exchange differences are recognized in other comprehensive income and accumulated in a separate component of equity.

The size of the translation difference depends on how far the two currencies move against each other. For a subsidiary whose currency is stable against the riyal it stays small, while for one in a country with a falling currency the translation reserve can move more than the subsidiary’s profit. The ERP should keep separate rate tables for closing and average rates, so that nobody types rates into the consolidation workbook.

The monthly consolidation close

A group that consolidates only at year-end finds its intercompany differences when they are a year old. A monthly routine keeps them small:

  1. Agree a group close calendar, with the date each company’s books close and the date the intercompany cut-off is fixed.
  2. Each company confirms its intercompany balances with every counterparty before closing, and records cash and goods in transit.
  3. Each company closes its ledger and produces its trial balance on the group chart of accounts.
  4. Group finance applies policy alignment adjustments and translates foreign subsidiaries.
  5. Post the eliminations: sales and costs, balances, unrealized profit, dividends and the investment against equity.
  6. Attribute profit and equity to the parent’s owners and the non-controlling interest, then review the consolidated statements against last month and the budget, using the same pack described in management reporting in ERP.

The consolidation entries belong in a separate consolidation ledger or entity, never in a subsidiary’s own books. A subsidiary’s statutory accounts must stand on their own, and an elimination posted there makes them wrong.

What an ERP must provide for financial consolidation

Whether the consolidation runs in a dedicated module, a separate tool or a controlled workbook, the operating ERP has to supply clean inputs. When we review a group’s setup, these are the questions we ask:

  • Does each legal entity have its own ledger, trial balance and statements, with a fiscal year that can be closed?
  • Do all entities share the same chart of accounts, or is there a maintained mapping to the group lines?
  • Can intercompany customers, suppliers and accounts be tagged, and can balances be listed by counterparty for matching?
  • Does the system hold foreign currency transactions with rate tables, and record realized and unrealized exchange differences?
  • Can reports be run on the same basis in every entity, by account group and cost center, so that the group pack uses the same definitions?
  • Is every posting traceable to its document and user, so that the auditor can follow an elimination back to the invoices behind it?

Tranquil provides several of these inputs in each company it runs. Account groups form a tree with auto-numbered codes, cost centers are kept as a tree, and multi-currency transactions post exchange differences to a currency variation account. The finance reports include a trial balance with group-wise totals, a comparative profit and loss, a balance sheet and a cash flow report, and the financial year is closed with Entry Close. Customers and suppliers have their own accounts under receivables and payables, and Contra offsets a customer against a supplier.

This article describes the consolidation process itself, not a Tranquil consolidation feature, so if your group has several legal entities, bring the group structure to the demo and we will walk through how each company’s books would be set up. The finance module is described on the accounting system page, and the single-company basics are in accounting in ERP.

Frequently asked questions

Do we consolidate a company we own 50% of?

It depends on control, not the percentage. If an agreement gives you the deciding say over the activities that drive the company’s returns, you consolidate it. If decisions need both partners’ consent, it is usually a joint arrangement, and a joint venture is accounted for using the equity method under IAS 28.

Can a subsidiary have a different financial year-end from the parent?

IFRS 10 expects the same reporting date. If the dates differ, the subsidiary prepares additional financial information as of the group date. Only if that is impracticable does the group use the subsidiary’s latest statements, adjusted for significant transactions, and then the gap can be no more than three months and must stay the same from period to period.

Are branches consolidated in the same way as subsidiaries?

No. A branch is part of the same legal entity, so its accounts are part of the company’s own statements and IFRS 10 does not apply. Inter-branch balances and transfers still have to net to zero in the company’s ledger, and that check is worth running every month.

Does every parent company have to prepare consolidated statements?

Not always. IFRS 10 exempts a parent that is itself a subsidiary, when its other owners have been informed and do not object, its shares and debt are not publicly traded, and its own parent publishes IFRS consolidated statements available for public use. Check local filing requirements with your auditor as well.

See what this article covers in Tranquil

In the demo we show what this article covers on Tranquil’s own screens and answer your team’s questions.

Dammam +966 13 848 8080, +966 13 817 7724, Riyadh +966 11 213 1330
[email protected]
Sunday to Thursday, 8 am to 5 pm.