Foreign currency translation is one of the most misunderstood parts of multi-entity financial reporting, and one of the most frequently done incorrectly. If your company has entities operating in currencies other than your reporting currency, understanding IAS 21 (or ASC 830 for US GAAP preparers) is not optional. Getting it wrong produces consolidated financial statements that are materially misstated in ways that are difficult to detect without knowing where to look.
This guide, written for controllers consolidating foreign subsidiaries, explains the core IAS 21 concepts, how QuickBooks Online handles (and doesn't handle) foreign currency, and what a correct translation process looks like in practice.
IAS 21 (The Effects of Changes in Foreign Exchange Rates) establishes how to translate the financial statements of entities whose functional currency differs from the presentation currency of the consolidated group.
The key concepts are:
The functional currency is the currency of the primary economic environment in which an entity operates, typically the currency in which it generates and uses cash. A Canadian subsidiary that earns revenue and pays expenses in Canadian dollars has a Canadian dollar functional currency, even if the parent company reports in US dollars. The presentation currency is the currency in which the consolidated financial statements are presented.
IAS 21 covers two separate jobs, and most translation errors come from applying the rules of one to the other:
When translating a foreign operation's statements into the presentation currency under IAS 21.39:
Because assets and liabilities translate at the closing rate, income and expenses at transaction-date or average rates, and equity at historical rates, the translated balance sheet will not balance unless you add a balancing entry. That entry is the cumulative translation adjustment (CTA), which posts to other comprehensive income (OCI), not through the P&L. This is a critical distinction: the CTA is not a profit or loss item. It represents the change in value of the net investment in a foreign operation due solely to exchange rate movements.
Two common errors: The first is mixing the two processes: applying historical rates to fixed assets and other non-monetary assets when translating into a presentation currency. That rule belongs to recording transactions in the entity's own functional currency, and using it at consolidation misstates both the assets and the CTA. The second is translating equity at the closing rate along with everything else. The balance sheet balances, but no CTA appears, and the exchange effect that belongs in OCI disappears into equity. Both produce financials that look right but are misstated.
QuickBooks Online handles multi-currency transactions at the entity level. You can record transactions in foreign currencies, and QuickBooks will record the exchange gain or loss on settlement. This is transaction-level currency handling, which is different from translation-level currency handling.
Specifically, QuickBooks Online:
QuickBooks Online does not:
The QuickBooks multi-currency feature handles transaction recording in foreign currencies within a single entity. Consolidation-level IAS 21 translation is a separate process that happens above the entity level, after the entity-level books are closed.
Fynease Automate applies IAS 21 translation to each foreign entity when it consolidates your QuickBooks Online companies, so the translated statements and the translation adjustment come out of the close rather than a separate workbook.
See how it works → Start free trialSuppose a Canadian subsidiary (functional currency: CAD) is being consolidated into a US dollar presentation. Its books are closed in Canadian dollars. At December 31 the closing rate is 0.74 USD per CAD, the average rate for the year was 0.76, and the subsidiary has the following balances (credits in parentheses):
| Item | CAD balance | Rate applied | USD balance |
|---|---|---|---|
| Cash | $500,000 | Closing: 0.74 | $370,000 |
| Accounts receivable | $300,000 | Closing: 0.74 | $222,000 |
| Fixed assets (net) | $1,200,000 | Closing: 0.74 | $888,000 |
| Total assets | $2,000,000 | $1,480,000 | |
| Accounts payable | ($200,000) | Closing: 0.74 | ($148,000) |
| Long-term debt | ($800,000) | Closing: 0.74 | ($592,000) |
| Total liabilities | ($1,000,000) | ($740,000) | |
| Share capital | ($400,000) | Historical: 0.80 | ($320,000) |
| Retained earnings, opening | ($450,000) | Historical (as translated in prior years) | ($351,000) |
| Net income for the year | ($150,000) | Average: 0.76 | ($114,000) |
| Cumulative translation adjustment (OCI) | $0 | Balancing figure | $45,000 |
| Total equity | ($1,000,000) | ($740,000) |
Every asset and liability, including the fixed assets, translates at the closing rate: net assets are CAD $1,000,000 × 0.74 = USD $740,000. Equity is built up at its own rates: share capital of USD $320,000 at the 0.80 rate when it was contributed, opening retained earnings of USD $351,000 as translated in prior years, and this year's net income of CAD $150,000 × 0.76 = USD $114,000, a total of USD $785,000. The difference between the USD $740,000 of net assets and the USD $785,000 of equity at historical and average rates is a USD $45,000 debit: the cumulative translation adjustment, which goes to OCI. It is a debit (a loss) because the Canadian dollar weakened against the US dollar after the equity was contributed and earned.
Had the fixed assets been carried at a historical rate of 0.78 instead, they would have translated to USD $936,000, overstating assets by USD $48,000 and turning the USD $45,000 CTA debit into a USD $3,000 credit. That is the error of mixing the two processes. The historical rate is right for the subsidiary's own Canadian dollar books when it buys an asset priced in another currency, not for translating those books into US dollars.
The income statement items translate at the average rate for the year. With an average USD/CAD rate of 0.76, all revenue and expense items multiply by 0.76. The resulting net income in USD feeds into retained earnings, and because the net assets it created are carried at the 0.74 closing rate rather than 0.76, the difference forms part of the year's CTA movement.
For any entity translated under IAS 21, auditors expect a translation workpaper that shows:
This documentation does not come from QuickBooks. It needs to be produced in a separate process, whether that is a carefully maintained Excel workbook or an automated transformation layer that applies the rules and documents the outputs.
The functional currency is the currency of the primary economic environment in which an entity operates, typically the currency in which it generates and uses cash. The presentation currency is the currency in which the consolidated financial statements are presented. A Canadian subsidiary that earns revenue and pays expenses in Canadian dollars has a Canadian dollar functional currency even if its parent reports in US dollars, so its statements must be translated before consolidation.
No. QuickBooks Online handles multi-currency at the transaction level within a single entity: it records invoices and bills in foreign currencies at the transaction-date rate, records realized exchange gains and losses on settlement, and can revalue open foreign currency balances at period-end. It does not translate an entity's full financial statements into a presentation currency, apply the rate each account category requires (closing for assets and liabilities, average for income and expenses, historical for equity), or calculate the cumulative translation adjustment. That translation is a separate process above the entity level.
The cumulative translation adjustment is the balancing entry that makes a translated balance sheet balance. Because assets and liabilities translate at the closing rate, income and expenses at transaction-date or average rates, and equity is commonly carried at historical rates, the translated balance sheet does not balance on its own. The CTA posts to other comprehensive income, not through the P&L. It represents the change in value of the net investment in a foreign operation due solely to exchange rate movements.
Fynease Automate connects to QuickBooks Online, runs your prepaid expense, deferred revenue, fixed asset, loan, and lease schedules, and consolidates multiple entities. For entities in another currency, it translates assets and liabilities at the closing rate and income and expenses at the period-average rate, lets you set historical rates per equity account, and posts the difference as the cumulative translation adjustment to other comprehensive income at the group level. It eliminates intercompany and writes adjusting entries back to QuickBooks Online.
See Fynease Automate Start free trial