Skip to main content

Foreign Currencies

How to export a store that sells in a different currency than your books.

If you sell on an Amazon store that uses a different currency than your books (for example, you're in the US and sell on Amazon Canada), you have 2 choices.

Option 1: Keep the store's currency

Turn on multiple currencies in QuickBooks. ConnectBooks then sends Canada sales in Canadian dollars, with the exchange rate.

Option 2: Convert to your home currency

ConnectBooks changes the sales to your currency before sending them. Your QuickBooks only needs 1 currency.

  • Go to Stores & Files and click your Amazon store.

  • On the Accounting tab, under Accounting Settings, click Settings. The QuickBooks tab opens.

  • Find Multi-Currency:

    • QuickBooks without multiple currencies: tick "Convert to other currency", then pick your currency under "Select your home currency".

    • QuickBooks with multiple currencies: tick "Export with home currency".

  • Save.

You can't pick the store's own currency. For example, a UK store can't pick GBP, since there's nothing to convert.

Multi-Currency only shows for Amazon stores whose currency is different from your home currency.

Where the exchange rate comes from

  • Amazon converted the payout for you: ConnectBooks uses Amazon's rate. Example: a CA$5,000 settlement is paid to you as US$3,850. ConnectBooks uses that same rate (0.77).

  • You get paid in the foreign currency (for example, into Payoneer): with Auto Fill Exchange Rate on, ConnectBooks uses a public exchange rate for that payout's date. Auto Fill Exchange Rate is under Advanced Settings on the same tab, and it's on by default.

  • Want your own rate? On Accounting Export, click the exchange rate on the settlement, type the rate or the converted total, and click Save. If you're looking at 1 store, type in the Exchange Rate or Converted Total column, click away, and confirm.

Frequently asked questions

I don't see Multi-Currency.

It only shows when the store's currency is different from your home currency, and only for Amazon stores.

Why do I see Exchange Rate and Converted Total on Accounting Export?

That store's currency is different from your home currency, so each settlement needs an exchange rate. Check that each one has a rate before you export it.

Did this answer your question?