Skip to content
Bitta Apps

Bitta Sheets · Part 7 · 2:38 · YouTube

Business Central Intercompany Eliminations for Consolidation

What this video covers

Eliminate intercompany sales and balances in a Business Central consolidation, and find out why the two sides differ.

Elimination rules, the IC partner map, intercompany accounts on the group chart, Intercompany Matches with Explain down to each company's G/L entries, and an intercompany difference account for what's left.

Transcript

Larkspur billed Larkspur West thirty-one thousand two hundred and fifty. Larkspur West booked thirty-one thousand one hundred. What do the group figures show? Here's the same group consolidation, with the sales between Larkspur and Larkspur

West eliminated, and the difference explained. Sales and balances between group companies cancel out in the group figures. Elimination rules match both sides, flag any difference, and show you why.

The wizard created two default rules: intercompany balances, and intercompany sales and purchases. Account pairs and investment and equity are the other rule types, and Create Default Rules adds the defaults back.

The IC Partner Map ties each company's intercompany partner codes to the companies in the group. Refresh from IC Setup fills it in from Business Central. Mark the intercompany accounts on the group chart:

receivables, payables, sales and purchases. Entries with an intercompany partner on these accounts are matched. Intercompany Matches pairs Larkspur's side with Larkspur West's: thirty-one thousand two hundred and fifty against thirty-one thousand one hundred.

Explain shows both sides, a difference of one hundred and fifty, the status Mismatch, and the likely causes. Larkspur's receivable is two invoices: twelve thousand seven hundred and fifty, and eighteen thousand five hundred.

Larkspur West's side opens in a new tab, in its own company. It booked the September invoice at twelve thousand six hundred: one hundred and fifty short. The difference goes to an intercompany difference account until Larkspur West

corrects its invoice. Set it on the card. The Eliminations tab now shows both matches, the elimination entries for each side, and the one hundred and fifty on

the difference account. The title bar warns that the sides differ. On the Consolidated tab, the Eliminations column takes the intercompany sales and purchases out of the group figures.

Manual corrections go on the Adjustments page: Check Balance tests them, and recurring ones copy to the next period. Use it when your group's companies sell to each other: the group figures show only what you sold outside the group.

Next: review, post and reverse.

More Bitta Sheets videos

All videos

Next step

See Bitta Sheets on your own data