Skip to main content

How Consolidation Adjustments Are Calculated

GATHER.nexus automatically calculates the adjustments required to prepare consolidated financial information. These calculations take into account acquisitions, ownership percentages, changes in ownership, Non-Controlling Interest (NCI) and foreign currency.

The platform generates the relevant consolidation journals automatically, applies the adjustments and presents the resulting figures in the Group's consolidated financial information.

1) Acquisitions

When an existing company is acquired, GATHER.nexus uses the information recorded on the Company screen, including:

  • Acquisition Date

  • Purchase Consideration

  • Shareholding Percentage

  • Effective Ownership Percentage

  • The company's net assets and financial position at the acquisition date

Using these details, GATHER.nexus calculates the Non-Controlling Interest (NCI) at acquisition and the resulting goodwill.

The calculations are based on:

  • NCI at Acquisition: Net Assets at Acquisition × (100% − Effective Ownership %).

  • Goodwill: Purchase Consideration + NCI at Acquisition − Net Assets at Acquisition.

These calculations are performed in the Group's reporting currency using the applicable acquisition-date exchange rate.

GATHER.nexus then generates the Pre-Acquisition Journal, which eliminates the parent's investment in the subsidiary and records the corresponding goodwill, opening NCI and pre-acquisition equity adjustments.

Where the calculation results in negative goodwill, the amount is recorded under Capital Gain on Bargain Purchase instead of Goodwill.

For a newly formed entity, the Pre-Acquisition Journal is not generated because there is no purchase consideration or pre-acquisition equity to eliminate. The other applicable consolidation calculations still apply.

Mid-Period Acquisitions

When an existing company is acquired part-way through a month, GATHER.nexus obtains additional financial information to calculate the relevant adjustments.

The acquisition-date Balance Sheet is used to determine the subsidiary's net assets, opening NCI and pre-acquisition earnings. The subsidiary's Profit & Loss for the remaining part of the acquisition month is also retrieved.

In the Working Paper:

  • The subsidiary's Profit & Loss is included from the day after acquisition through to the end of that month.

  • The subsidiary's Balance Sheet position is included from the acquisition month-end onwards.

For example, if a subsidiary is acquired on 14 February, its post-acquisition Profit & Loss activity is included from 15 February to 28 February (or 29 February in a leap year).

2) Minority Interest After Acquisition

After a subsidiary has been acquired or formed, GATHER.nexus calculates the portion of its earnings attributable to shareholders outside the Group.

For an acquired subsidiary, the NCI Journal starts calculating from the day after the acquisition date.

  • For example, if a company is acquired on 14 February, the post-acquisition NCI calculation starts on 15 February.

GATHER.nexus handles minority interest in two ways:

  • Profit & Loss Minority Interest

The platform calculates the outside shareholders' share of the subsidiary's Net Profit After Tax using its effective ownership percentage.

  • For example, if the Group effectively owns 80% of a subsidiary, the remaining 20% represents the minority interest.

Where applicable, configured intercompany Profit & Loss accounts are also taken into consideration when determining the profit attributable to minority shareholders.

These amounts are calculated separately for each subsidiary and each reporting month. They appear directly in the Consolidated column of the Working Paper rather than being posted through a separate Profit & Loss journal.

Balance Sheet NCI

GATHER.nexus also generates an automatic NCI Journal to record the minority's share of post-acquisition earnings in the relevant Equity attributable to the minority account.

The journal is calculated monthly, taking into account the subsidiary's accumulated post-acquisition earnings and the effective ownership percentage applicable to each period.

Each reporting month, the platform updates the accumulated NCI balance using the applicable month-end exchange rate. Previous earnings increments are also retranslated at the current reporting month's rate.

The resulting balances are carried forward and reflected in the consolidated Balance Sheet.

3) Changes in Ownership

When the Group purchases additional ownership in a subsidiary or sells part of its existing ownership while retaining control, GATHER.nexus automatically updates the effective ownership and NCI percentages from the date of the transaction.

For example, if the Group initially owns 80% and subsequently acquires another 10%:

  • Original ownership: 80%

  • Additional ownership acquired: 10%

  • New ownership: 90%

  • Revised NCI: 10%

The same principle applies when part of the ownership is sold, with effective ownership decreasing and NCI increasing.

GATHER.nexus generates a separate automatic journal for each ownership change:

  • Step Acquisition Journal: Records the adjustments resulting from additional ownership acquired.

  • Disposal Journal: Records the adjustments resulting from a partial disposal of ownership.

The revised ownership percentage affects the NCI Journal and Profit & Loss minority-interest calculations from the transaction date onward. Previously reported periods retain the ownership percentage applicable at that time.

Where a transaction takes place part-way through a month, GATHER.nexus splits the relevant calculation period so that the previous ownership percentage applies up to the transaction date and the revised percentage applies afterwards.

This ensures that the correct ownership percentage is applied to each period when calculating the minority interest.

4) Foreign Currency

When a subsidiary's reporting currency differs from the Group's reporting currency, GATHER.nexus translates its financial figures using the applicable exchange rates.

The platform applies different rates depending on the type of financial information:

  • Profit & Loss: Translated using the applicable average monthly exchange rate.

  • Balance Sheet: Translated using the applicable month-end exchange rate.

For a mid-month acquisition, the Profit & Loss is translated using the average rate for the post-acquisition period only, rather than the average rate for the entire month.

Because the same earnings are translated using two different exchange rates, a foreign exchange difference can arise.

To address this, GATHER.nexus generates Auto FX 1, which calculates the difference between the average-rate and month-end-rate treatment of earnings.

Auto FX 1 considers both the foreign exchange difference relating to Current Year Earnings and the corresponding difference relating to minority interest. It then accounts for the Group's share of the difference to avoid double-counting the minority's portion.

The resulting adjustment is posted between Current Year Earnings and FX in reserves (1), ensuring that the translation difference is reflected appropriately in the consolidated Balance Sheet.

Foreign exchange differences are also incorporated into the relevant Pre-Acquisition, NCI, Step Acquisition and Disposal journals where applicable. These differences are posted within the respective journals rather than through a separate journal for each type of adjustment.

5) Year-End

At the end of the Group's financial year, GATHER.nexus updates the relevant earnings and minority-interest balances to reflect the completed financial year.

There are two main year-end treatments:

  • Pre-Acquisition Earnings

Pre-acquisition earnings are initially recorded against Current Year Earnings.

When the Group's financial year ends, these amounts are transferred to Retained Earnings.

The related foreign exchange adjustments continue to be recorded in FX in reserves (Pre-Acquisition).

Non-Controlling Interest

During the financial year, accumulated NCI is recorded against Current Year Earnings.

When the financial year ends:

  • The accumulated NCI moves from Current Year Earnings to Retained Earnings.

  • A new NCI Journal starts for the new financial year, again against Current Year Earnings.

  • Two separate NCI calculations then operate: one for Retained Earnings and another for Current Year Earnings.

Both continue to be recalculated using the applicable reporting month's exchange rate, including the foreign exchange movements relating to completed financial years.

Auto FX 1 at Year-End

Auto FX 1 also follows the year-end movement. Once Current Year Earnings move into Retained Earnings, the corresponding foreign exchange adjustment is reflected between Retained Earnings and FX in reserves (1) using the same two-rate calculation.

6) Review the Result

GATHER.nexus generates six automatic Balance Sheet consolidation journals to support the Group's consolidated financial information:

  1. Pre-Acquisition Journal – Records goodwill, opening NCI and pre-acquisition adjustments while eliminating the parent's investment in the subsidiary.

  2. NCI Journal – Current Year Earnings – Records the minority's share of post-acquisition earnings for the current financial year.

  3. NCI Journal – Retained Earnings – Records the accumulated minority interest relating to completed financial years.

  4. Step Acquisition Journal – Records the adjustments resulting from additional ownership acquired in an existing subsidiary.

  5. Disposal Journal – Records the adjustments resulting from a partial disposal of ownership.

  6. Auto FX 1 – Records the foreign exchange difference arising from the different translation rates applied to earnings.

Not every journal applies to every subsidiary. For example, the Pre-Acquisition Journal is not generated for a newly formed entity because there is no acquisition to account for. The other five journals and applicable calculations still apply.

In the Working Paper, GATHER.nexus brings together the individual company figures in the Aggregated column, applies the relevant automatic consolidation journals and presents the resulting figures in the Consolidated column.

Each applicable journal is displayed separately, allowing users to review the adjustments made to the consolidated figures.

Although these journals are generated automatically, users can edit the journal amounts where corrections are required.

The Profit & Loss minority-interest calculations are also reflected directly in the Consolidated column, separately from the six Balance Sheet journals.

This allows finance teams to review how acquisitions, ownership changes, minority interest and foreign currency affect their consolidated financial results.

Important Notes

  • Keeping acquisition or incorporation dates, purchase consideration, ownership percentages and subsequent ownership changes up to date helps ensure accurate consolidation calculations.

  • Effective ownership percentages are derived from the Group ownership structure and are used when calculating NCI.

  • For mid-period acquisitions, only post-acquisition Profit & Loss activity is included in the consolidated results for that month.

  • The platform supports the Full Consolidation method for these calculations.


Need help? Visit gather.nexus, click the chat icon in the bottom-right corner, or email us at [email protected] for assistance.

Did this answer your question?