Guide

Multi-currency bookkeeping: every subsidiary keeps its own currency, and the group still reports in dollars.

Selling abroad, paying overseas suppliers or owning a foreign subsidiary means transactions in more than one currency. The bookkeeping questions are always the same: which currency each company keeps its books in, which rate to use, and how exchange differences are recorded.

The basics

Each Entity Has a Home Currency

Each company keeps its books in its own home currency, usually the currency of the country where it operates. A US company keeps its books in dollars, and a foreign subsidiary keeps its books in its local currency.

  • Set the home currency correctly when the file is created. In most software it cannot be changed later.
  • Record foreign-currency invoices, bills and bank accounts in their own currency, and let the software convert them.
  • Keep one source for exchange rates and use it every month.

Exchange differences

Realized and Unrealized Gains and Losses

Exchange rates move between the date of an invoice and the date it is paid. That difference has to be recorded.

  • Realized gain or loss. Recorded when a foreign-currency invoice or bill is paid at a different rate from the one it was booked at.
  • Unrealized gain or loss. The change in value of open foreign-currency balances, such as unpaid invoices or foreign bank accounts, at month-end.

Both QuickBooks Online and Xero calculate these when multicurrency is turned on and payments are recorded in the right currency. Recording a foreign payment in dollars by hand is the most common reason they come out wrong.

Between entities

Intercompany Balances Across Currencies

When a US parent funds a foreign subsidiary, or the subsidiary bills the parent, both sides record the same transaction, each in its own home currency. Agree in writing which currency each intercompany balance is held in. At month-end, compare the two sides at the same rate. Any difference left after that is an exchange difference or an error, and it should be explained before the month is closed.

Our multi-entity accounting guide covers due-to and due-from accounts and eliminations in more detail.

The group view

Reporting the Group in Dollars

  1. Close each entity in its own currency and reconcile intercompany balances.
  2. Translate each foreign entity’s results into dollars, typically balance sheet items at the month-end rate and profit and loss items at an average rate for the period.
  3. Record the translation difference in equity, not in profit.
  4. Eliminate intercompany balances and transactions, then review the combined reports.

The exact translation rules, transfer pricing between countries, and local tax filings are questions for your CPA and local advisers. The bookkeeping job is to give them clean, closed, reconciled books for every entity, on time.

The software

QuickBooks Online and Xero

Multi-currencyMulti-subsidiary
QuickBooks OnlineMulticurrency setting on eligible plans. Once turned on, it cannot be turned off.One company file per entity, consolidated with a reporting app or spreadsheet.
Intuit Enterprise SuiteSupports foreign-currency transactions.Built for several entities, with multi-entity reporting.
XeroMulti-currency on the higher plan tiers, with unrealized gains shown in reports.One organization per entity, consolidated with a reporting add-on or spreadsheet.

Plan names and features change, so check the current plan details before you buy. Our guides on multi-entity bookkeeping in Xero and QuickBooks Online vs Intuit Enterprise Suite go deeper.

Where we fit

How We Handle Multi-Currency Groups

We keep the books for groups of companies in QuickBooks Online, Intuit Enterprise Suite and Xero, including entities that work in other currencies. Each entity is closed on the same schedule, foreign-currency accounts and intercompany balances are reconciled every month, and group reports are prepared when you need them. Your CPA and local advisers keep tax and structure.

Questions

Common Questions

What is multi-currency bookkeeping?
Recording invoices, bills and bank accounts in the currency they happen in, with the software converting them to the company’s home currency and recording exchange gains and losses.
What is the difference between realized and unrealized exchange gains?
A realized gain or loss is recorded when a foreign-currency invoice or bill is paid at a different rate. An unrealized gain or loss is the change in value of balances that are still open at month-end.
Does a foreign subsidiary keep its books in dollars?
Usually not. It keeps its books in its own local currency, and its results are translated into dollars for group reporting.
Can QuickBooks Online handle multiple currencies?
Yes, with the multicurrency setting on eligible plans. Once it is turned on it cannot be turned off, so plan before you enable it.
Can Xero handle multiple currencies?
Yes, on the plan tiers that include multi-currency. Each Xero organization still covers one entity, so a group needs one organization per company.
Xero Gold Partner Earned through certified advisors and a proven client base.
Intuit ProAdvisor Elite badge QuickBooks ProAdvisor, Elite A team certified in QuickBooks Online, Intuit Enterprise Suite and Workforce.
Xero Asia Partner of the Year Recognised by Xero for delivery, not for sales volume.
13+ years in practice Across accounting outsourcing, ERP and accounting software work.

Running companies in more than one currency?

Tell us how many entities you have, which currencies, and which software each one uses. We will tell you what a monthly close for the group would look like.

Book a free 30-minute call See growing businesses
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.