Jimmy Wong, CPA ← All tools
Multi-Entity Consolidation
USD · CAD · GBP → Consolidated USD
IAS 21 · IFRS 10 · 100% Local
Sample data ↓ entity_a_usd.csv entity_b_cad.csv entity_c_gbp.csv intercompany_eliminations.csv View on GitHub ↗
FX Rates
CAD/USD
Avg (P&L)
Close (B/S)
Hist (Equity)
GBP/USD
Avg (P&L)
Close (B/S)
Hist (Equity)
Entity A · USD
🇺🇸
Entity A — USD Parent
entity_a_usd.csv  ·  cols: account_code, account_name, account_type, debit, credit, currency
Entity B · CAD
🇨🇦
Entity B — CAD Subsidiary
entity_b_cad.csv  ·  cols: account_code, account_name, account_type, debit, credit, currency
Entity C · GBP
🇬🇧
Entity C — GBP Subsidiary
entity_c_gbp.csv  ·  cols: account_code, account_name, account_type, debit, credit, currency
IC Eliminations
⇌
Intercompany Eliminations
intercompany_eliminations.csv  ·  cols: description, account_code, account_name, account_type, entity, elim_debit_usd, elim_credit_usd
Upload all 4 files to begin
USD
CAD
GBP
Upload trial balances for all three entities to consolidate
All processing runs in your browser. No data uploaded to any server.  |  FX translation per IAS 21. IC elimination per IFRS 10. Consult a CPA for final reporting.