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
- ERP with native consolidation: eliminations, translations, and policies are applied automatically.
- Consolidated reports generated by the system, not built manually.
- Assisted auditing: the ERP maintains a complete trail of every elimination and adjustment.
What a well-executed consolidation looks like
In a modern ERP with native consolidation:
- Each entity records its operations in its functional currency.
- Intercompany transactions are tagged at the time of recording.
- Monthly closes synchronized across all entities.
- Automatic currency translation according to configured policies.
- Automatic elimination of intercompany balances and transactions.
- Consolidated financial statement generated in minutes, not days.
- Complete audit trail: drill-down from a consolidated number all the way to the underlying transactions.
A process that takes 5–10 days in Excel takes 1–2 days with a native ERP.
How cifraHQ solves consolidation
cifraHQ implements native IFRS consolidation with:
- Multi-entity with optional shared charts of accounts.
- Automatic tagging of intercompany transactions.
- Currency translation with centralized rates.
- Configurable automatic eliminations by transaction type.
- Consolidated and individual entity financial statements in the same dashboard.
- IFRS for SMEs and Full IFRS depending on the applicable framework.
If your company consolidates in Excel and you want to escape that graveyard, request a demo — we'll show you what a well-executed consolidation looks like with real data.
Related resources
This article is educational. Consult with your auditor for the specific application of IFRS 10 to your business group.