← Back to blog

IAS 21 Foreign Currency Translation in QuickBooks Online: A Practical Guide

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 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.

What IAS 21 requires

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:

Functional currency vs. presentation currency

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.

The three translation rates

Under IAS 21, different types of balances translate at different exchange rates:

• Monetary assets and liabilities (cash, receivables, payables, loans) translate at the closing rate — the exchange rate at the balance sheet date.
• Non-monetary assets and liabilities (fixed assets, equity investments, prepaid expenses, deferred revenue) translate at the historical rate — the exchange rate that prevailed when the item was initially recognized.
• Income statement items translate at the average rate for the reporting period. For practical purposes, this is usually a weighted monthly average rate.
• Equity items translate at historical rates.

The foreign currency translation adjustment (CTA)

Because monetary items translate at the closing rate but equity translates at historical rates, the balance sheet will not balance after translation 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.

What QuickBooks Online does and doesn't do

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:

• Records invoices and bills in foreign currencies using the exchange rate at the transaction date
• Records realized exchange gains and losses when foreign currency transactions are settled
• Revalues open foreign currency balances at period-end (if you run the revaluation function)

QuickBooks Online does not:

• Apply the historical rate to non-monetary assets when preparing consolidated financial statements
• Calculate or record the cumulative translation adjustment
• Translate an entity's complete set of financial statements from its functional currency to a presentation currency under IAS 21 rules
• Produce a consolidated balance sheet that correctly reflects entities in multiple functional currencies

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.

A practical IAS 21 translation example

Suppose a Canadian subsidiary (functional currency: CAD) is being consolidated into a US dollar presentation. At December 31, the subsidiary has the following balances:

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	Historical: 0.78	$936,000
Accounts payable	($200,000)	Closing: 0.74	($148,000)
Long-term debt	($800,000)	Closing: 0.74	($592,000)
Equity (retained + CTA)	($1,000,000)	Historical + CTA	($788,000)

The equity balance in USD is derived as a plug — the residual after translating all assets and liabilities at their correct rates. The difference between equity translated at historical rates and equity as a plug is the cumulative translation adjustment, which goes to OCI.

The income statement items translate at the average rate for the year. If the average USD/CAD rate for the year was 0.76, all revenue and expense items multiply by 0.76. The resulting net income in USD feeds into retained earnings, with the difference from the closing rate creating a further CTA movement.

Documentation auditors expect

For any entity translated under IAS 21, auditors expect a translation workpaper that shows:

• Source rates used (closing rate, average rate, historical rates for major non-monetary items), with source documentation (central bank or Bloomberg rate source)
• The full translated trial balance showing each line item, the functional currency balance, the rate applied, and the presentation currency result
• The CTA calculation, showing the movement from opening to closing CTA balance
• Reconciliation of the translated balance sheet — all asset and liability lines plus equity and CTA must balance

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.