Skip to content
Bitta Apps

Chapter 3 of 4Page 2 of 4

Financial reports and consolidation

Consolidate companies

Consolidate group companies in one Business Central workbook: set up companies, period and group chart, map accounts, handle ownership, rates and eliminations.

updated: applies-to: 1.0.0.0

A group consolidation brings the companies of a group into one workbook: their trial balances, the account mapping, the eliminations and the consolidated statements. You map each company's accounts once, and every figure stays live from Business Central.

Set up

  1. Search for New Consolidation, or choose it in the role center or under Insert, Workbook. Create a new consolidation and give it a code and a name.
  2. The Companies step lists every company in the environment. Filter it to your group, include the companies, give each a short code, and mark the parent. Import from Business Units fills the list from your business units.
  3. Choose the period: last month, last quarter, year to date, the current month, or custom dates. A blank group currency means the parent's own currency.
  4. Choose where the group chart of accounts comes from: this company, another company, the consolidation accounts, or keep the current one. The wizard suggests mappings by consolidation account, by number or by name.
  5. Keep the default rates and elimination rules for now, and choose Finish.
New Consolidation wizard on the Companies step with Larkspur Supply as the parent and Larkspur West and Harbor Point Services included

One consolidation holds up to 50 companies of the same environment. Other companies are read with your own permissions.

New Consolidation wizard step that copies the group chart of accounts from this company and suggests mappings

Accounts the group chart doesn't have yet are flagged, never dropped. The consolidation workbook opens with six tabs: Companies, Account Mapping, Trial Balances, Eliminations, Consolidated and Audit Trail.

Consolidation workbook on its Companies tab with each company's currency, ownership, method and rate method, and the six tabs below

Map the accounts

Account Mapping links every company account to a group account.

  1. Filter the tab to the unmapped accounts.
  2. Type the group account for each one. If the group chart has no match yet, add the account to the group chart first, then map it.
  3. Choose Review changes, check the changes against Business Central, and apply them.

The same mapping is on the Consolidation Account Mapping page: Suggest proposes matches, and Confirm All Suggestions confirms them in one go. Exclude, Load New Accounts and the Show Unmapped, Show Suggested and Show All views help with large charts.

The Consolidated tab then shows each company side by side, then the eliminations and the group total.

Consolidated tab with the income statement by company side by side, the eliminations and the group total

Ownership and rates

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. Home reloads accounts and suggests mappings, copies a group chart, or imports your existing business units. In any workbook, Insert, New consolidation starts the same wizard.

  1. In the card's Companies part, set each company's Ownership %. Here, Larkspur Supply owns 80% of Larkspur West.
  2. Choose the consolidation method. Full with Minority Interest takes every line in full and shows the other 20% as minority interest. Proportional takes the ownership share of every line.
  3. For the full method, the group chart needs a minority interest account for equity and one for the result. Set them on the card as the Minority Interest Equity Account and the Minority Interest Result Account.
Group Consolidation card with Larkspur West owned 80 percent, the methods and rate sources of each company, and the minority interest equity and result accounts

The Consolidated tab now has a Minority column. Larkspur West's net income is 22,439.39, so 20% of it, 4,487.88, goes to the minority interest. The group's net income splits between the minority and the owners of the parent.

Consolidated tab with a Minority column next to each company, the eliminations and the group
Net income of the group split between the minority interest, 4,487.88, and the owners of the parent

Double-click any figure to see how it's calculated.

Rates

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 consolidation translates it at closing, average and historical rates, with a translation difference line. In this group every company keeps its books in the group currency, so every rate is 1.

Companies tab with each company's ownership, method, rate method and closing and average rates, all 1 in the group currency

To change a rate, choose Set Rate Override in the card's Companies part, and give the rate type, the period, the new rate and a reason. The period starts at your work date, so set it to the consolidation's month. The audit trail keeps every override.

Use the full method when you own part of a company and want it in full with the minority's share, and the proportional method when you take your share only.

Eliminations

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

Rules and partners

  • The wizard creates two default rules: IC-BAL for intercompany balances, and IC-PL for intercompany sales and purchases. Account Pair and Investment and Equity are the other rule types, and Create Default Rules adds the defaults back.
  • The Consolidation 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.
  • On the group chart, mark the intercompany accounts: receivables, payables, sales and purchases. Entries with an intercompany partner on these accounts are matched.

Match and explain

Consolidation Intercompany Matches compares each pair of companies for each rule. Here, Larkspur billed Larkspur West 31,250.00, and Larkspur West booked 31,100.00: a Mismatch of 150.00.

Explain shows both sides, the difference, the status and the likely causes: goods or cash in transit, exchange rates, or a missing IC partner code.

Explain for intercompany match 1: Larkspur 31,250 against Larkspur West -31,100, a difference of 150, the status Mismatch and the likely causes

Each side drills down to its G/L entries. Larkspur's invoice ICS-1002 is 12,750.00. Larkspur West's entries open in a new tab, in its own company: it booked the invoice as ICP-1002 at 12,600.00, 150.00 short.

Clear the difference

Each match becomes a balanced set of elimination lines. The difference goes to the card's Intercompany Difference Account, here 91100, until Larkspur West corrects its invoice. If no difference account is set, Bitta Sheets warns you. Don't raise the tolerance to hide a difference: correct the entry instead.

The Eliminations tab shows both matches, the elimination entries for each side, and the 150.00 on the difference account. The title bar warns that the sides differ.

Eliminations tab with two intercompany matches flagged Mismatch, the elimination entries for each side and the 150.00 difference on account 91100

On the Consolidated tab, the Eliminations column takes the intercompany sales and purchases out of the group figures.

Consolidated tab with an Eliminations column that takes the intercompany sales and purchases out of the group figures

Manual corrections go on the Consolidation Adjustments page: Check Balance tests them, and Copy Recurring to Next Period copies the recurring ones to the next period.

Review and post

Review the consolidation in its workbook, post the eliminations with a preview first, and reverse them with Business Central's Reverse Register if you need to.

Review the workbook

The workbook has six tabs: Companies, Account Mapping, Trial Balances, Eliminations, Consolidated and Audit Trail. Columns with a pencil write back to Business Central, and nothing is written until you open Review changes and apply them.

Companies tab of the consolidation workbook with the period, the posting status Not posted, and each company's ownership, method and rates

Post the eliminations

  1. On the Consolidated tab, open the block's ... menu and choose Post.... Posting also starts from Post Eliminations... on the Consolidation Posting Log.
  2. While exceptions are open, posting shows why it won't post, for example the intercompany mismatches. With Block Posting On Exceptions on the card, they stop the posting. Here the difference sits on the intercompany difference account, so you can clear the block, post now, and correct it later.
  3. Posting simulates first. Preview Changes lists every line before anything is written, and rolls the simulation back.
  4. Apply Changes posts into the consolidation company only, through its CONSOL journal batch, once per period.
Eliminations tab with the intercompany matches, the elimination entries and the difference on the intercompany difference account

The Posting Log shows the document and its G/L register. G/L Register and G/L Entries open what was posted, on the last day of the period.

Consolidated tab with each company, the eliminations and the group, and the warning that the intercompany sides differ

Reverse and move on

  • To take a posting back, run Business Central's Reverse Register on that register. It posts the correcting entries. The Posting Log then shows Reversed, the period shows Not posted again, and it can be posted again.
  • The Audit Trail tab and the Consolidation Audit Trail page keep every change: the block switched off and on, and every refused and simulated posting. Writes back to Business Central go through the Security Guard and the Studio Audit Log of Bitta Apps Studio.
  • When the period is done, Next period on the Companies block's ... menu moves the workbook on, with the same companies, mapping and rules. Or, in the New Consolidation wizard, choose Open an existing consolidation for the next period.

Post once the review is clean and the period is final. Until then, review and simulate as often as you like.

TIP

Save a finished consolidation as a template with Use as Template, so another group starts from the same layout.

Next step

Ready to try Bitta Sheets?