Multi-Currency Accounting: How to Manage Foreign Exchange in Odoo, QuickBooks & Xero

International business means international money. Whether you sell to customers in Europe, pay suppliers in Asia, or employ remote staff across continents, multi-currency transactions introduce complexity that single-currency bookkeeping does not address.

Key Takeaways

• Functional currency is your home currency (typically what you report taxes in); all others are foreign currencies requiring conversion.
• Realized gains/losses are real money — the difference between the rate when you invoiced and when you received payment.
• Month-end revaluation is mandatory for accurate balance sheets — open foreign currency balances must reflect current rates.
• Use one consistent rate source (central bank, OANDA, or your platform's built-in rates) across all transactions.
• Odoo offers the deepest multi-currency ERP integration, Xero includes it on all plans, and QuickBooks requires Plus or Advanced.

How Multi-Currency Transactions Work

Your US company invoices a UK customer for GBP 10,000 at 1 GBP = 1.27 USD. You record $12,700 in revenue. The customer pays 30 days later when the rate is 1.30. You receive $13,000, creating a $300 realized exchange gain. If the rate had dropped to 1.24, you would record a $300 realized loss.

Exchange Rate Best Practices

Use consistent rate sources across all transactions. Update rates daily for high-volume businesses, weekly for moderate volume, monthly at minimum. Perform month-end revaluation on all open foreign currency balances. Separate realized from unrealized gains/losses into distinct GL accounts. Document your FX policy for auditors.

Platform-Specific Setup

Odoo

Enable Multi-Currencies in Accounting settings. Activate needed currencies, set your company currency, and configure automatic rate updates from European Central Bank, Bank of Canada, or a custom source. Odoo provides real-time conversion on invoices, built-in revaluation wizards, multi-currency bank journals, and automatic exchange difference entries.

QuickBooks Online

Available on Plus and Advanced plans. Toggle on Multi-currency in Advanced settings (cannot be disabled once enabled). QuickBooks uses Open Exchange Rates automatically. Limitations include less automated revaluation and limited rate source control.

Xero

Multi-currency on all plans. Add currencies in Settings, and Xero imports daily rates from Open Exchange Rates. Xero offers automatic revaluation, clear separation of realized/unrealized differences, and foreign currency bank accounts. The base currency cannot be changed after setup.

Common Pitfalls

Not performing regular revaluation. Open balances at stale rates misrepresent your financial position and cause material year-end adjustments.

Ignoring tax implications. Realized gains are taxable income; realized losses are deductible. Rules on unrealized amounts vary by jurisdiction.

Mixing rate sources. Bank rates include a spread that differs from mid-market rates. Using different sources for different transactions creates reconciliation problems.

Forgetting foreign currency bank reconciliation. An account that reconciles perfectly in GBP may show variances in USD due to exchange rate movements.

Frequently Asked Questions

Q: Which platform is best for multi-currency? A: Xero offers it on all plans with streamlined revaluation. Odoo provides the deepest ERP integration across purchasing, inventory, and manufacturing. QuickBooks is adequate for simple needs but requires a higher-tier plan.

Q: How do I handle intercompany transactions in different currencies? A: Each entity records in its own functional currency using the transaction date rate. At consolidation, eliminate intercompany balances and recognize exchange differences in other comprehensive income.

Q: Do I need to hedge foreign currency exposure? A: Hedging makes sense when foreign currency transactions exceed 10% of revenue or costs and volatility could materially impact profitability. Common instruments include forward contracts, options, and natural hedging (matching income and expenses in the same currency).

Q: How often should exchange rates be updated? A: Daily for high foreign currency volume. Weekly for occasional international transactions. At minimum, update at each month-end close.

Next Steps

ECOSIRE provides accounting services with multi-currency expertise across Odoo, QuickBooks, Xero, Dynamics, and Sage. Contact us for a free consultation on managing your international financial operations.