Accounting Pro Group Consolidation for Odoo 19 Community documentation

Who it is for: holding accountants and group controllers whose companies are several companies of one Odoo database. The add-on reads the journal items of the members. It never posts an entry in their books: a run is a snapshot kept in the add-on's own tables.

The examples: the pictures show the demo group Atlas Holding Group (presentation currency USD). Its parent is Atlas Trading Co. (USD). Three companies were acquired on 31 December 2025: Atlas Gulf Trading LLC (AED, 100 %), Atlas Europe GmbH (EUR, 80 %) and Atlas Logistics Joint Operation (USD, 50 %, consolidated proportionally). The numbers in the text are the numbers in the pictures. Amira Saleh is the administrator you see in the pictures. Today in the demo is the end of October 2026.

Your data must be ready for a consolidation:

1. Unzip the package. Inside is taqnix_accounting_pro_consolidation.zip; unzip it to get the folder taqnix_accounting_pro_consolidation.
2. Copy the folder into one of the addons_path folders of your Odoo server and restart Odoo.
3. Log in as an administrator, activate Developer mode, open Apps and press Update Apps List.
4. Remove the “Apps” filter, search Accounting Pro Group Consolidation and press Install.

# or from the command line
./odoo-bin -c odoo.conf -d YOUR_DATABASE -i taqnix_accounting_pro_consolidation --stop-after-init

After the installation, set up the consolidation in this order:

1. Open Accounting → Configuration → Settings, block Group Consolidation, and choose the average rate and the intercompany tolerance.
2. Create the group in Configuration → Consolidation → Consolidation Groups and add its members.
3. Press Create the group chart, then Map accounts.
4. Open each member and enter or compute the equity at acquisition.
5. Create your first run in Accounting → Consolidation → Consolidation Runs and press Compute.

The add-on never posts a journal entry in the books of your companies. Uninstalling it removes its own data, and also the Accounting Pro favorites and scheduled reports that point to a consolidated report. Your journal entries, journals and accounts are never touched.

1. Member trial balances. For every member, the posted journal items up to the period end, per account, in the member's currency. Balance sheet accounts carry everything since the beginning. Profit and loss accounts count from the start of the group's fiscal year (the parent's), or from the day after the acquisition date for a member acquired during the year. The profit of earlier periods is put on the member's undistributed profits account, where Odoo's own balance sheet shows it. If the Closing add-on of Accounting Pro is installed, its closing entries dated in the year being consolidated are left out (they would zero the profit of the year); those of earlier years are kept.
2. Translation. Each member account is mapped to an account of the group chart. That account says how its balance is translated: at the closing rate, the average rate or the historical rate. Each line is rounded to the cent of the presentation currency. The Translation reserve of a member is the amount that makes its translated trial balance balance; a check table shows how it arises.
3. Proportional members contribute their share of every translated line, rounded line by line.
4. Intercompany. For every pair of members, balances (receivable and payable accounts) and income and expenses (profit and loss accounts) are matched and eliminated. The difference between the two sides is never hidden: it goes to its own line.
5. Investment elimination. For every member except the parent, the investment is removed from the investor's books, the equity at acquisition is removed from the group's equity, and the balancing figure is the goodwill (at book values). A negative goodwill is a bargain purchase.
6. Non-controlling interests for full members below 100 %: their share of the net assets, split into their lines.
7. The check. The consolidated trial balance must balance to the cent. The balance sheet must tie, and the profit of the period in the balance sheet must equal the profit attributable to the owners in the profit and loss.

The classes of translation:

The period of a run is always the group's fiscal year to date. Members whose fiscal year ends on another date are aligned: their profit and loss is read for the group's fiscal year from their own journal items, and the run says so. The standards behind these steps are listed in How the figures are computed.

Buttons and smart buttons. Create the group chart (Update the group chart once it exists) and Map accounts are at the top of the form. The smart buttons show the group chart (78 accounts in the demo), the mapped accounts (221), which turns red when some accounts are unmapped, and the runs (4).

Who sees a group. A group and everything under it are visible only to users who have the parent and every member company among their allowed companies. You can keep several groups, for example one for each holding.

The demo example. Atlas Europe GmbH: share capital 1,000,000 EUR plus reserves 350,000 EUR, so equity at acquisition is 1,350,000 EUR. At the historical rate of 1.0763463209 that is 1,453,067.53 USD. The group's share (80 %) is 1,162,454.02 USD. The investment in the parent's books is 1,250,000 USD. Goodwill = 1,250,000 - 1,162,454.02 = 87,545.98. The 20 % of the minority owners is the non-controlling interest.

Press Create the group chart on the group. The add-on copies the chart of accounts of the parent. Press Update the group chart when the parent adds accounts. Open it with the smart button Group chart, or in Configuration → Consolidation → Group Charts.

The add-on adds consolidation accounts of its own. The filter Consolidation accounts shows them:

The accounts with the roles Share capital (in the demo 301000 Capital) and Retained earnings (999999 Undistributed Profits/Losses) receive the equity of the members, at the historical rate.

Press Map accounts on the group. For every account of every member that has no mapping yet, the add-on looks for:

1. an account of the group chart with the same code (Same code);
2. otherwise an account of the same account type (Same account type).

The list is in Configuration → Consolidation → Account Mapping (smart button Mapped accounts), grouped by member. The column Mapped by shows Same code, Same account type or By hand. Managers can change the consolidated account of a line. A choice made By hand is kept when you map again, and shown in italics.

Unmapped accounts. An account with posted entries and no consolidated account blocks the validation of a run. The smart button Mapped accounts turns red and the report Consolidation Status counts them.

The demo. The showroom sales account 400500 of Atlas Gulf Trading LLC has no equivalent in the group chart: it was mapped by account type to 400000 Product Sales. Its bank fees account 620000 was chosen by hand and goes to 600000 Expenses.

All rates are expressed as 1 unit of the member currency = x units of the presentation currency. They come from Odoo's currency rates of the parent company: the rates of the company first, then the shared rates, the last rate on or before the date.

The September run of the demo. AED is pegged: 0.272294 for closing, average and historical (3.6725 AED per USD). EUR: closing 1.072719, average 1.075380, historical 1.076346. The run keeps its own copy of the rates, in the tab Rates.

Overriding a rate. A consolidation manager can override a rate of a run in the tab Rates. A reason is mandatory. The override is kept when the run is computed again.

Open Accounting → Accounting → Consolidation → Consolidation Runs and press New: choose the group and the Period end. The period starts on the first day of the group's fiscal year. There is one run (not cancelled) for each group and period end.

On the form. The consolidated figures are at the top. The smart buttons open the Balance sheet, Profit and loss, Worksheet, Intercompany, the Lines (67 in the demo) and the Adjustments (11). The tabs are:

The check table. For each foreign member it shows the translation reserve as: historical-rate balances × (closing - historical) + average-rate balances × (closing - average) + rounding. For Atlas Europe GmbH: -4,897.54 + -641.91 + 0.00 = -5,539.45. For Atlas Gulf Trading LLC, whose rate is the same on all dates, only a rounding of -0.01 remains. Together with the 20 % share of the non-controlling interests (1,107.89) this gives the consolidated translation reserve of -4,431.57.

The snapshot. A run stores its lines, rates and adjustments. When somebody posts an entry later, a validated or locked run does not change. A computed run shows the notice To compute again when a manual adjustment or a rate changed after the computation.

The tab Adjustments of a run lists them. The automatic ones are rebuilt each time you compute:

The demo's intercompany lines. The parent's September invoice to Atlas Gulf of 38,000 USD is booked by Atlas Gulf only on 5 October. So the September run shows Difference twice (38,000.00 on balances, -38,000.00 on sales and purchases). Atlas Europe's pairs are Within tolerance (-8.49 and 196.90, the tolerance is 500.00) and the pairs of the joint operation are Matched.

Manual adjustments. Open Accounting → Accounting → Consolidation → Manual Adjustments, or the tab of the run, and add one. It has a run, a reason (mandatory) and debit and credit lines on accounts of the group chart, in the presentation currency. It must balance to the cent. It can never touch the translation reserve. It is kept when you compute the run again. Use it for:

• unrealised profit in inventory or fixed assets sold inside the group (the demo books 2,000 for goods of the parent still in Atlas Gulf's stock);
• dividends paid by a subsidiary;
• loans between members on other balance sheet accounts, and transfers of fixed assets;
• an impairment of the goodwill.

Reading the demo. Total assets are 5,196,721.15. They include the goodwill of 199,040.19 and the line Intercompany differences to clear of 37,991.51. The investments of the parent (750,000, 1,250,000 and 215,000) are eliminated. Liabilities are 2,652,931.08. Equity is 2,543,790.07: the owners' part is 2,202,407.60, with the profit of the period 1,161,850.55 and the translation reserve of -4,431.57, and the non-controlling interests are 341,382.47. Total liabilities and equity are 5,196,721.15, equal to the assets.

The two warnings at the top are the intercompany differences of the run. At the bottom of the report the notes give the method, the rates, the simplifications and what is not included. A click on an amount opens the journal items behind it (Intercompany Reconciliation says what the switcher needs).

Open Accounting → Reporting → Management → Consolidated Profit and Loss. The options are those of the balance sheet. The columns are Eliminations and adjustments and Consolidated, and Member columns adds one column for each member. With Compare with: Previous run an extra column shows the earlier run (here 30 June 2026).

Reading the demo. Revenue is 6,175,323.15 after eliminating 703,460.46 of sales inside the group. The eliminations also reduce the cost of revenue (-627,559.54) and the operating expenses (-36,097.82). The line Intercompany differences (-37,803.10 in other expenses) carries what the two sides do not agree on, and the manual adjustment of 2,000 reduces the net profit. Net profit is 1,213,727.41 (787,522.97 at the end of June). Under it: Profit attributable to the owners of the parent, 1,161,850.55, and to the non-controlling interests, 51,876.86.

Open Accounting → Reporting → Management → Consolidation Worksheet. Each line is an account of the group chart. The columns are:

Click the arrow of an account to unfold each member. The demo's accounts receivable 121000 are 1,040,288.39 before eliminations, and 931,970.43 after removing 108,317.96 of intercompany receivables (74,000.00 for the parent, 26,817.96 for Atlas Europe, 7,500.00 for the joint operation). Every column adds up to the statements.

Open Accounting → Reporting → Management → Intercompany Reconciliation. It has two sections: Receivables and payables (balances at the period end) and Sales and purchases (the year to date). In each, the matrix shows what the member of the row books with the member of the column, in the presentation currency (for a proportional member, in the share of the group). Under the matrix, Pairs and differences lists each pair:

The demo. The parent's invoice of 38,000 to Atlas Gulf is booked by Atlas Gulf only on 5 October, so at 30 September the parent shows 38,000.00 and Atlas Gulf shows 0.00: difference 38,000.00. In sales and purchases the same invoice gives -38,000.00. Atlas Europe's pair is within tolerance (-8.49 and 196.90, from the exchange rates). The pair with the joint operation is matched (0.00).

Drill-down. A click on an amount opens the journal items of both sides. Odoo shows the journal items of the companies active in the company switcher: activate the parent and every member company, or the list stays empty. The report says so.

With a proportional member, both sides are eliminated up to the smaller of the two shares. Each direction of a pair has to match on its own: two differences that offset each other still raise a warning.

Open Accounting → Reporting → Management → Consolidation Status. It lists every group, its members and its runs:

In the demo there are no unmapped accounts and no missing rates. The runs are: 31 March 2026 (locked, net profit 336,171.21), 30 June 2026 (validated, 787,522.97), 30 September 2026 (validated, 1,213,727.41, two intercompany differences) and 31 October 2026 (computed, 1,344,388.84).

• The PDF carries the header (company, group, run, members), the warnings, the columns that are on screen, the notes about the method and a footer with the user and the date.
• The Excel file has the same header and notes. Amounts are numbers, not text, and the accounts can be folded.
• In Arabic, the PDF and Excel files are right to left.
• The files follow the options on screen: group, run, preview date, member columns, comparison, hidden empty lines.

It uses the default group of the settings. It shows the consolidated net profit, the name and period end of the run, the share of the owners, and a trend over the runs. In the demo: 1,213,727, run 30 September 2026, owners 1,161,851.

The card is shown only to users who are allowed in every company of the group. Others do not see it, and see no figure.

Open Accounting → Configuration → Settings, block Group Consolidation (after the block Accounting Pro).

The settings belong to the parent company: with several parent companies, choose the company first. A change to the average rate or the tolerance applies to the runs you compute afterwards; a validated run keeps its figures.

Record rules. A group and everything under it (members, runs, lines, adjustments, rates, log) are visible only to users who have the parent and every member company among their allowed companies, whatever is active in the company switcher. So a partial consolidation never leaks: a user who lacks one member company sees no group, no run, no figure and no dashboard card. The journal items of the members are read as the user, with the record rules of Odoo.

The name of the default group (kept on the parent company) can be read by a user who lacks a member company. Its figures cannot.

The standards. The method was checked against overview pages of the IFRS Foundation, an IFRIC agenda decision, the summaries of ICAEW and the Australian copy of IAS 21 (AASB 121), which reproduces it. These points could not be verified in a primary text, and are applied as common practice, not quoted: IFRS 10 B92-B94 (attribution of profit to the non-controlling interests, members with another reporting date), IFRS 3.34-36 (bargain purchase), IAS 36 (goodwill is not amortised, it is tested for impairment) and the use of the historical rate for equity. IAS 21.47, which translates goodwill at the closing rate, is not followed (see What it does not do).

The proof. The automated tests compute a worked example with exact figures and check them to the cent: two foreign members, a proportional member, an intercompany difference, a translation reserve of 194,250 and 61,500, goodwill of 170,000, non-controlling interests of 195,200, a consolidated net profit of 315,250 and total assets of 2,696,000 equal to liabilities and equity. 113 tests belong to the add-on.

Replace the folder with the new version, restart Odoo and run -u taqnix_accounting_pro_consolidation. Your groups, members, mappings, runs and manual adjustments are kept.

A run you validated is a snapshot: an update does not change its figures. A run that is only computed can be computed again after the update.

Installation help and bug fixes are included for 6 months, with lifetime updates. Contact us through the marketplace page where you bought the module or write to support@taqnix.com with your Odoo version and a screenshot.