Skip to content
Bitta Apps

Bitta Sheets · Part 6 · 2:29 · YouTube

Business Central Consolidation: Ownership, Rates and Minority Interest

What this video covers

Consolidate a partly owned company in Business Central and show its minority interest, live in a workbook.

Open the consolidation card, set a company's ownership and method, set the minority interest accounts, and see the Minority column and the split of net income on the Consolidated tab. Double-click any figure to see how it's calculated.

Rates come from Business Central's currency exchange rates, and a rate override needs a reason the audit trail keeps.

Transcript

Larkspur owns eighty percent of Larkspur West. So who gets the other twenty percent of its profit? Here's the same group consolidation, now with Larkspur West eighty percent owned, and its minority interest.

The consolidation card holds the companies and their ownership. Change it there, and the workbook works out the minority interest, at the rates you set. Every consolidation is on the Group Consolidations list.

Open its card. The card holds what the wizard set up. Setup opens the group chart, the account mapping and the rates. Eliminations and History come in the next tutorials.

Home reloads accounts and suggests mappings, copies a group chart, or imports your existing business units. And in any workbook, Insert, then New consolidation, starts the same wizard.

Larkspur owns eighty percent of Larkspur West, so set its ownership to eighty. Full with Minority Interest takes every line in full, and shows the other twenty percent as minority interest.

For that, the group chart needs a minority interest account for equity and one for the result. Set them on the card. The Consolidated tab now has a Minority column.

Twenty percent of Larkspur West's result goes to the minority interest, and net income splits between the minority and the owners of the parent. Double-click a figure to see how it's calculated. Rates come from Business Central's currency exchange rates:

closing for the balance sheet, average for the income statement. When a member reports in another currency, the same step translates it at closing, average and historical rates. Here every company keeps its books in dollars,

so every rate is one. Set Rate Override takes a rate type, a period, a new rate and a reason. The period starts at your work date, so set the consolidation's month.

The audit trail keeps every override; here the rate is one, so cancel. Use it when you own part of a company: Full shows it whole with the minority's share, Proportional takes your share only.

Next: eliminations and intercompany.

More Bitta Sheets videos

All videos

Next step

See Bitta Sheets on your own data