Skip to content
English
Customer portal Sign in
  • There are no suggestions because the search field is empty.

Transactions can have only one foreign currency at a time.

In QuickBooks, each customer can only pay in one currency. If your customer already exists in QuickBooks and paid in US Dollars, then future orders must be paid in US Dollars.

Problem

Your sales fail to sync and you receive a currency mismatch in QuickBooks.

Description

Your order's currency code and deposit account are different from the customer's currency code.

Solutions

There are two ways to fix the issue.

Map all currencies to a single currency

We recommend that you map all currencies to a single currency in QuickBooks. In this example, all orders appear from Shopify and they use GBP.

  1. In QuickBooks, create a customer. Call it Shopify orders.

  2. In the currency field, enter the desired currency for all sales.

  3. In Connex, go to rules engine.
  4. Under rule templates, choose Shopify.
  5. Go to rule 17 and use the Map Store Currency rule.
  6. Go to finance settings in Connex.
  7. Under deposit account and A/R account, choose an account that matches your home currency.

Find the customer currency code

  1. In QuickBooks, find the customer.

  2. Click edit.
  3. Scroll down to payment:

The QuickBooks Online customer currency is read only. You must open the customer rename him. Recreate the customer and set the proper currency code:

  1. In QuickBooks, open the customer record.
  2. Click edit.
  3. You can do one of two things. You can mark the customer as inactive. Connex will recreate the customer. In the billing first and last name fields, enter old_ before each value: