Ownership and NCI · Track 5 · Tutorial 1 of 3

Read the NCI Report month by month

The NCI Report shows how every NCI figure for a subsidiary was worked out: what it started from, the percentage applied, the rate, and the account it went to. Read it each month to explain the NCI before you report it, and whenever a figure on the balance sheet or profit and loss looks wrong.

You will needA subsidiary with an NCI, set up as in the Set up ownership track, and its figures loaded for the month. The NCI Report is in the Free and Pro editions.
By the endCompany B’s NCI for October 2026 read component by component, year to date and for the month, and tied to the balance sheet and profit and loss.

1Open the report

  1. Open Ownership & Equity → NCI Report.
  2. Choose Actual as Scenario. Budget and Forecast show the NCI on those figures instead.
  3. Choose YTD as Basis, and Oct-2026 as As at period.
NCI Report, Actual, YTD, Oct-2026: the filters, the three headline figures, NCI movement by subsidiary with Company B and Company F at 20% NCI, and Company B’s card with How each figure was worked out: rows for net assets, share of profit, share of CTA and share of other reserves, each with its formula, base, NCI %, amount and posting account
The selection (1), the subsidiaries (2), and the components (3).

The report covers every subsidiary with an NCI, as at the end of the month you choose. Company B reports in AUD, so its bases are translated into SGD before the NCI % is applied.

2Read NCI movement by subsidiary

Above the table, NCI in the balance sheet, Profit attributable to NCI and Changes from share sales and purchases give the group’s totals. The table has a row for each subsidiary with an NCI: NCI % now, the NCI at the opening date, its Share of profit, Share of CTA and Share sales / purchases, and the NCI at the closing date. Subsidiaries the group owns outright are named under the table as wholly owned.

Start here. If NCI % now for Company B isn’t 20%, every figure for it is wrong for the same reason: an ownership record. Correct it on the Ownership page, not here: Open in Ownership → on Company B’s card takes you there.

3Read each component

  1. Click Company B’s row. Its card opens below, showing how its NCI got from the opening to the closing balance.
  2. Open How each figure was worked out.

Each row has a Component, a Source period, a Formula, a Base, an NCI %, an Amount and a Posting account.

ComponentFormulaWhat the base is
NCI Net Assetsequity_closing_balance × NCI% × closing_fxOne row for each of Company B’s equity accounts — share capital, retained earnings, dividends paid — at its closing balance. The year’s profit isn’t here; it is the next component.
NCI Share of Profitpnl_movement × NCI% × monthly average_fx (segmented by ownership period)One row for the profit for the year to date, each month at that month’s average rate, as it is posted. If the NCI % changed during the year, each part of the year uses its own percentage.
NCI Share of CTActa_movement × NCI% (already in presentation currency)The translation reserve posted for Company B. It is already in SGD, so no rate is applied. A second row, with the formula cta_cye_translation_gap × NCI% (already in presentation currency), shares the translation difference on the year’s profit.
NCI Share of Other Reservesother_reserve_balance × NCI% × closing_fxCompany B’s other reserves, such as revaluation, at their closing balance.

In the month of a purchase or a sale, the report also has the rows for that transaction, as in Read the acquisition entries line by line, and a later purchase or a sale is worked out under Share sale and purchase workings.

4Switch to the month

  1. Click MTD.

The table now opens at 1-Oct, and the share of profit is October’s movement only, at October’s average rate. This is what changed this month: use MTD to explain the month’s movement in the NCI, and YTD to explain the balance.

5Follow one row

With MTD, Company B’s NCI Share of Profit row reads:

ComponentNCI Share of Profit
BaseCompany B’s profit for October, already translated at October’s average rate
NCI %20.00%
Amount20% of the base
Posting account3610 NCI - Share of Profit

Each row is that simple: base times NCI % gives the amount. Add the rows of a component, and you have the NCI’s share for it. The same amount is the Share of profit, Oct 2026 line in the card’s bridge, with the sum beside it.

6Tie it to the statements

  1. Open Journal lines posted for Oct 2026 in Company B’s card, or open Review → Elim. & Journals Report for Oct-2026 and open Auto NCI P&L Oct 2026 (Company B).

Check

With MTD, the report’s NCI Share of Profit amount equals that entry’s total: Company B’s NCI share of profit posted for October. With YTD, it equals the Auto NCI P&L entries for Company B from January to October. The NCI lines in equity on Reports → Balance Sheet include Company B’s NCI Net Assets, CTA and other reserves components.

Export the report with the PDF or Excel icon at the top for the audit file. To show NCI figures in a pack, a cell report can read them from the NCI calculation source.

7If something looks wrong

What you seeWhat to do
Every NCI % is wrongAn ownership record is wrong. Check Company B’s Share purchases and sales on the Ownership page.
One base is wrongCompany B’s own figure is wrong, or its account is mapped wrongly. Drill into it on Company B’s own reports.
The amounts don’t match the rate you expectCheck the closing and average rates for the month in Settings → Global Settings → Exchange Rates.
No NCI Share of CTA rowsCompany B’s CTA isn’t enabled, or NCI - share of CTA isn’t set.
No NCI calculation lines found as at this period.The month is before the acquisition, or Company B has no NCI.
The page shows an upgrade messageThe NCI Report isn’t in the Standard edition.

Want more detail? See the documentation