Glossary

QuickBooks Multicurrency

QuickBooks Multicurrency is the QuickBooks Online setting that lets a company record transactions in currencies other than its home currency by giving each customer, vendor, and bank or credit card account one fixed currency; once it is turned on, it cannot be turned off.

Also called: QuickBooks Online Multicurrency, turn on multicurrency QuickBooks, QuickBooks multiple currencies, foreign currency customer QuickBooks

14-day free trial · card required · cancel anytime

Definition

A QuickBooks Online file starts out with one currency. Every customer, every bank account and every amount is in the home currency, and a sale in euros has to be converted by hand before it can be entered at all. Multicurrency is the setting that changes that. Intuit offers it on Essentials, Plus and Advanced, and states that it is not available for Simple Start users in the US or for EasyStart users in Canada.

Turning it on does not convert anything. It adds a currency to the things money flows through. From then on, a customer, a vendor, or a bank or credit card account can be assigned one currency, and a transaction with that customer or in that account is recorded in that currency, with an exchange rate that translates it back into the home currency for reporting.

The setting is a one-way door. When you turn it on, QuickBooks asks you to confirm that you understand you cannot undo it, and Intuit is explicit that once Multicurrency is on you can no longer turn it off or change your home currency. Most of what makes a multicurrency file harder to run than a single-currency one follows from those two locks and from one more rule: every record that holds money holds exactly one currency.

Key points

  • +Intuit offers Multicurrency on QuickBooks Online Essentials, Plus and Advanced. It is not available on Simple Start in the US or EasyStart in Canada.
  • +It is turned on under Settings, then Account and settings, then Advanced, in the Currency section, where you also pick the home currency.
  • +Once Multicurrency is on, you can no longer turn it off, and you can no longer change your home currency.
  • +Existing accounts stay in the home currency. A foreign-currency bank or credit card account is a new account you add.
  • +Customers, vendors, and bank and credit card accounts each hold a single currency. Once a customer has transactions, their currency cannot be changed: you make the old profile inactive and create a new one.
  • +Once an account has a transaction posted to it, its currency can no longer be changed.
  • +Income and expense accounts always use the home currency.
  • +Intuit lists QuickBooks Bill Pay and QuickBooks Payments as not compatible with Multicurrency, and says turning it on inactivates the cash flow planner.

What the setting actually changes

The visible change is a Currency column in the chart of accounts and a Currency field on customer, vendor and account profiles. Intuit says existing accounts are put in your home currency by default. Nothing you already recorded is touched.

The real change is in what a record can be. In a single-currency file, a customer is just a name with a balance. With Multicurrency on, Intuit says you can assign a single currency to most types of accounts, including customers, vendors, and accounts in the chart of accounts like bank and credit card accounts or accounts receivable. An invoice to a euro customer is written in euros. A deposit into a euro bank account is in euros. Each of those transactions also carries an exchange rate, which QuickBooks uses to translate it into the home currency, because reports only speak the home currency.

The exchange rate is filled in for you. Intuit says foreign currency values are updated automatically every four hours, and that you can enter your own rate on a transaction or update the rate in your currency list for the day. What QuickBooks never does is restate a foreign balance on its own when rates move. That is the job of the home currency adjustment, covered in the related entries below.

One currency per customer, vendor and account

This rule causes more confusion than the setting itself. A customer has one currency. If a customer who has always paid in US dollars pays you in Canadian dollars, QuickBooks will not let you record that payment against the US dollar customer. Intuit’s instruction for changing an assigned currency is to create a new customer or vendor and assign the new currency, and its customer article adds that once you record transactions with a customer you cannot change the currency in their profile. You make the old profile inactive, and the old transactions stay where they are.

In practice, a business that sells to the same customer in two currencies ends up with two customer records, and Intuit’s own steps suggest adding the currency to the display name to tell them apart. That is not a duplicate to merge. It is how QuickBooks keeps each currency’s receivable separate.

Accounts follow the same logic. Intuit says you need to add a new account for each currency you transact in, and that once an account has a transaction posted to it, you can no longer change its currency. So a Stripe balance held in euros needs its own euro clearing account and its own euro bank account. Re-pointing a US dollar account at euros after the fact is not an option.

The one place currencies never go is the profit and loss. Intuit states that income and expense accounts always use your home currency. A euro sale is a euro receivable and, once paid, euro cash, but the revenue line is booked in home currency at the rate on that transaction.

What to settle before you turn it on

Because the setting is permanent, the decisions that matter are made before you click it.

Confirm the plan. Simple Start and EasyStart files cannot turn it on, so a Stripe business on either plan has to upgrade or keep converting foreign amounts by hand.

Choose the home currency deliberately. It is selected in the same Currency section, and it cannot change afterwards. It should be the currency you report and pay tax in, not the currency most of your Stripe sales arrive in.

Check what stops working. Intuit says QuickBooks Bill Pay and QuickBooks Payments are not compatible with Multicurrency, that Multicurrency will not work if QuickBooks Commerce is connected, and that turning it on inactivates the cash flow planner.

Plan the accounts. Each foreign currency you will hold needs its own bank account, and for a Stripe balance, its own clearing account.

Expect journal entries to get stricter. In its Canadian help, Intuit notes that QuickBooks Online blocks journal entries that mix currencies for customers or suppliers.

If any of those is a blocker, the alternative is to stay single-currency and let Stripe convert every foreign charge into your default currency before it reaches your books. The post linked below walks through what that looks like when a foreign Stripe balance already exists.

When a Stripe business actually needs it

Charging customers in other currencies is not, on its own, a reason to turn Multicurrency on. If your Stripe account has one balance, Stripe converts foreign charges into that balance’s currency, and if that currency is your QuickBooks home currency, every amount that reaches your books is already in home currency.

The setting becomes necessary when the books need to show the foreign amount itself. The common cases are a Stripe account that holds balances in more than one currency and pays each one out to a bank account in that currency, invoices issued in a currency other than home currency that you want QuickBooks to show in the customer’s currency, and a business that wants foreign customer balances kept in the currency the customer owes.

In each of those, QuickBooks has to hold money in a currency other than home, and that is only possible with Multicurrency on. A Canadian business that adds a US dollar bank account to Stripe so it can keep US dollar sales in US dollars is the textbook example.

How Acodei works with QuickBooks Multicurrency

Acodei has two levels of multicurrency support. Multicurrency Support handles foreign-currency sales: when a Stripe transaction’s currency does not match the existing QuickBooks customer’s currency, Acodei creates a second customer record in the format "CustomerName - CUR", for example "Acme - CAD", and it fills in the exchange rate from Stripe at payment time, or from QuickBooks’ daily rate when Stripe does not provide one. QuickBooks assigns one currency per customer, so the second record is designed behavior, not a duplicate to clean up. Invoice Multicurrency goes further: it creates QuickBooks invoices in the Stripe invoice’s currency and applies the exchange rate later, when the payment, refund or payout is recorded. A payout in a currency other than home currency is recorded as a Transfer.

Both levels are turned on by the Acodei team on request, not by a self-serve toggle, and QuickBooks Online’s own Multicurrency setting has to be on first: if Multicurrency Support is on in Acodei and the QuickBooks setting is not, syncs will error. Acodei’s multicurrency features can be switched off later, but the QuickBooks setting cannot.

For a Stripe account with more than one balance, Acodei recommends a separate holding account and deposit account for each balance, using regular clearing accounts rather than Undeposited Funds, and Invoice Multicurrency is not permitted when the holding account is Undeposited Funds. Zero-decimal currencies such as JPY are not supported today.

Want to see this on your own Stripe data?

Start a free trial

14-day free trial · card required · cancel anytime

Frequently asked questions

Can I turn off Multicurrency in QuickBooks Online?

No. When you turn it on, QuickBooks asks you to confirm that you understand the change cannot be undone, and Intuit states that once Multicurrency is on you can no longer turn it off. The home currency is locked at the same moment, so choose it before you enable the setting.

Which QuickBooks Online plans include Multicurrency?

Intuit offers Multicurrency on QuickBooks Online Essentials, Plus and Advanced. It is not available on Simple Start in the US or on EasyStart in Canada. A business on either of those plans has to upgrade before it can hold a foreign-currency customer, vendor or bank account in QuickBooks.

How do I change a customer’s currency in QuickBooks?

Once a customer has transactions, you cannot. Intuit’s instruction is to make the existing customer profile inactive and create a new customer with the new currency. Earlier transactions stay on the old profile. Adding the currency to the new display name, such as "Acme - CAD", keeps the two records easy to tell apart.

Do I need QuickBooks Multicurrency if I charge in other currencies through Stripe?

Not necessarily. If Stripe converts every foreign charge into one balance in your home currency, your books only ever see home currency. You need Multicurrency when QuickBooks has to hold a foreign amount itself: a Stripe balance and bank account in another currency, or invoices kept in the customer’s currency.

Does Acodei need QuickBooks Multicurrency turned on?

Only to sync transactions in a currency other than your home currency. Acodei’s Multicurrency Support and Invoice Multicurrency are enabled by the Acodei team on request, and QuickBooks Online’s Multicurrency setting must be on first, or syncs will error. Zero-decimal currencies such as JPY are not supported today.

What customers say about running Stripe through Acodei

Stripe Verified Partner BadgeIntuit QuickBooks
★★★★★
“If you're testing out all the different Stripe/QuickBooks integration apps right now, let me save you some time. This one is the best one by far.”
RyanOwner at Indie Music Academy
★★★★★
“Works well and is really helpful for massive transactions. The support is really fast and helpful. 100% recommended.”
AndresCo-founder and CEO at Kanguro Collections and Reinsurance

Related reading

More glossary terms

See the full glossary

Ready to try Acodei?

Connect Stripe to QuickBooks Online in minutes and let the fees, refunds, and payouts land where your accountant expects them.

14-day free trial · card required · cancel anytime