Consolidating financial statements for a business group is one of the most demanding tasks in the accounting close. IFRS 10 establishes the principles; practice is where errors occur. This article identifies the 5 most common mistakes we see in Panamanian and LATAM businesses when consolidating 2+ entities, and how to prevent them.
Important: the specific consolidation for your group must be validated by your auditor. This article presents common patterns, not recommendations specific to your situation.
What is IFRS consolidation?
IFRS 10 requires that a parent company consolidate its subsidiaries (entities over which it has control). The consolidated financial statement presents the group as a single economic entity:
- Assets and liabilities added line by line.
- Income and expenses added.
- Elimination of intercompany transactions and balances.
- Translation of currencies if subsidiaries operate in different currencies.
- Recognition of non-controlling interests (NCI).
Sounds simple. Practice generates recurring errors.
Mistake 1: Incomplete intercompany eliminations
Intercompany transactions (between group companies) must be eliminated upon consolidation. The most obvious:
- Sales/purchases between group companies.
- Intercompany receivables/payables.
- Intercompany loans.
- Dividends paid between group companies.
Where it breaks down
- Inventory with intercompany margin: when subsidiary A sells to subsidiary B with a margin, B's inventory includes an "unrealized gain" from the group's perspective. The unrealized margin must be eliminated from inventory and cost of goods sold.
- Fixed assets transferred between group companies: subsequent depreciation must be adjusted to reflect historical cost from the group's perspective.
- Intercompany services: management fees, royalties and similar items are eliminated.
- Currency differences on intercompany balances: adjustments that appear in one entity but not the other.
How to prevent it
- Tag intercompany transactions in the ERP at the time of recording (not at close).
- Related party catalog maintained and validated.
- Monthly intercompany reconciliation (not annual) between each pair of entities.
- Reports that list all intercompany transactions with their counterparties.
Mistake 2: Currency translation applied incorrectly
When subsidiaries operate in currencies different from the group's functional currency, their financial statements must be translated. IAS 21 establishes the rules:
- Assets and liabilities: closing rate.
- Income and expenses: average rate for the period (or transaction-date rate if practicable).
- Equity: historical rate.
- Translation differences: to Other Comprehensive Income (OCI), not to profit or loss.
Where it breaks down
- Applying the closing rate to income and expenses: a technical error that distorts the consolidated result.
- Failing to recognize translation differences in OCI, incorrectly taking them to the period's profit or loss.
- Inconsistent rates across subsidiaries in the same group.
- Subsidiaries in hyperinflationary economies (IAS 29) treated as normal economies.
- Intercompany balances that don't eliminate correctly due to different rates on each side.
How to prevent it
- Documented rate policy applied consistently.
- Centralized rates in the ERP (a single source for all entities).
- Translation difference reporting that classifies them by origin.
- Review by a specialist accountant for groups with hyperinflationary economies.
Mistake 3: Inconsistent accounting policies across entities
IFRS 10 requires that the group apply uniform accounting policies. Each subsidiary may operate with local practices, but these must be harmonized upon consolidation.
Where it breaks down
- Different inventory methods (FIFO in one entity, weighted average in another).
- Different useful lives for similar assets across different subsidiaries.
- Different capitalization thresholds (different monetary thresholds).
- Different treatment of foreign currency.
- Allowances for doubtful accounts with different policies.
How to prevent it
- Group accounting policies manual documented.
- Unified chart of accounts (or mappable) across entities.
- Internal audit verifying consistent application.
- ERP with centralized policy configuration.
Mistake 4: Subsidiary reporting periods and closes
IFRS 10 allows a subsidiary to have a different fiscal year-end from the parent, but not more than 3 months' difference, and adjustments must be made for significant events.
Where it breaks down
- Subsidiaries with a June fiscal year-end consolidating with a December parent without adjustments for events in the second half.
- Delayed monthly closes: the subsidiary closes 15 days after the parent, creating rework in the consolidation.
- Inconsistent cut-offs: each subsidiary closes its books on a different day, creating differences in intercompany balances.
How to prevent it
- Unified group closing calendar.
- Synchronized monthly closes (all entities close on the same day).
- Commitment to subsequent event adjustments when applicable.
Mistake 5: Doing consolidation in Excel
Excel is the graveyard of consolidations. We see groups with 5+ entities consolidating in spreadsheets with hundreds of tabs, fragile formulas, and dependency on one person "who understands how it works."
Where it breaks down
- Numbers that don't balance and no one knows why.
- Broken formulas when a new entity is added.
- Multiple versions of the same consolidation with differences.
- Bus factor of 1: only one person understands the file.
- Costly audits: the auditor needs to trace every number and documentation is poor.
How to prevent it
- Centralized consolidation: one place where the group number gets built, not one spreadsheet per person.
- Consolidated reports generated from that one place, not rebuilt by hand every close.
- Per-entity statements as the source: each company closes its own books, and those statements feed the consolidation without reprocessing figures.
What a well-executed consolidation looks like
With a centralized consolidation process:
- Each entity closes its operations in its own functional currency and its own fiscal calendar.
- The group companies you want included connect into a single consolidation point.
- Monthly closes synchronized across the entities that connect in.
- The consolidated statement is generated from those statements, without exporting to spreadsheets.
- Traceability: you can trace which entity contributed each figure in the consolidated number.
A process that takes 5 - 10 days in Excel takes 1 - 2 days centralized.
How cifraHQ solves consolidation
In cifraHQ, consolidation lives in the consolidated reports portal, included with your license, not inside the ERP itself:
- Each company in the group provides its API key, which you register in the portal.
- You decide which companies connect: if an entity doesn't connect, it doesn't enter the report.
- The portal pulls together the statements of the connected companies and generates the group's consolidated reports.
- cifraHQ does not post elimination entries in your companies' books: each entity keeps closing on its own figures.
- The specific accounting treatment (eliminations, minority interest, IFRS notes) is defined by your auditor or implementation partner for your group's situation.
If your company consolidates in Excel and you want to escape that graveyard, request a demo - we'll show you how your companies connect to the portal and how the group numbers come out.
Related resources
- How cifraHQ's consolidated reports portal works
- IFRS for SMEs vs Full IFRS
- Cloud ERP vs On-Premise
- ERP Implementation in 90 Days
This article is educational. Consult with your auditor for the specific application of IFRS 10 to your business group.