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
1:18OverviewEdit Business Central Tables Live in a Spreadsheet
2:08Part 1Edit Business Central Data in an Excel-Style Sheet
3:08Part 2Business Central Bulk Update Without Export and Import
2:50Part 3Business Central Budget in a Spreadsheet, Written Back Live
2:35Part 4Business Central Budget Entry by Department
2:56Part 5Business Central Consolidation: Companies and Account Mapping