Set-up multi-currency in Connex for QuickBooks

How to map multiple currencies to QuickBooks

Introduction

In this section, we will sync sales to QuickBooks Desktop in USD and CAD. This guide is interchangeable between QuickBooks Online and Desktop. This guide maps the amount the customer paid, which is USD. If you want to map all sales to the same currency with an exchange rate, read this guide.

Prerequisites

We will sync sales orders and payments to QuickBooks. We will set-up an A/R in USD and CAD. We will set up a bank account in USD and CAD.

Accounts

Here are the steps:

1. In QuickBooks, go to lists > chart of accounts.
2. Go to account > new.
3. Select type bank.
4. Create two accounts. One called CAD Shopify account and the other USD Shopify account.
5. Go to account > new.
6. Select type accounts receivable.
7. Call the accounts Accounts Receivable - USD and Accounts Receivable - CAD. Assign the proper currency code.
8. Here is the end result:

Connex Settings

You must enable multi-currency in Connex:

If multi-currency is enabled in your QuickBooks, then Connex will enable it. To set-up the feature later, follow these steps:

1. Login to Connex.
2. Click settings.
3. Order Settings and go to Transaction Type
4. Check the multi-currency field.
   

Connex Rules

You must map USD and CAD sales to the proper accounts.

Map to A/R account for CAD Sales

Here are the steps:

1. Go to the Rules Engine and click Add New Rule

2.Choose map field or Selling Channel and as the action, choose map order A/R account.

3.In the rules name, enter these values: Currency Code, Equals, CAD. and in the last field, enter Accounts Receivable - CAD then click save.

Map to A/R account for USD Sales

Here are the steps:

1. Go to the rules engine and click add new rule
2. Choose map field or Selling Channel and as the action, choose map order A/R account.

1. In the rules field, enter these values: Currency Code, Equals, USD and in the last field, enter Accounts Receivable - USD and click save.

Map to deposit account for USD Sales

Here are the steps:

1. Go to the rules engine and click add new rule. Choose map field or Selling Channel and as the action, choose map order A/R account.

1. In the rules field, enter these values: Currency Code, Equals, USD and in the last field, enter Shopify Account USD then hit save.

Map to deposit account for CAD Sales

Here are the steps:

1. Go to the rules engine and click add new rule.
   
2. Choose map field, based on condition and s the action, choose map order deposit account.
   
3. In the rules field, enter these values: Currency Code, Equals, CAD and in the last field, enter CAD Shopify Account then hit save.
   
   

What is the end result?

Here is the end result:

I receive this error that currency of the customer and Accounts Receivable account must be the same

This means the customer is one currency, like CAD, and the A/R account is USD. Your A/R account and customer currency must match. Violette, shown above, is CAD. The A/R account must be CAD.

Error 3140 : While trying to Add a(n) ReceivePayment with name or order number of WS#1303, QB responded There is an invalid reference to QuickBooks AR Account "Accounts Receivable - USD" in the ReceivePayment. QuickBooks error message: The currency of the customer and Accounts Receivable account must be the same.    

Can Connex send an exchange rate to QuickBooks Online?

If your ordering solution sends a currency code, then we send it to QuickBooks. Connex for QuickBooks Online can enter the exchange rate between your home currency and the order's currency. Connex uses the exchange rate on the order date, so you can sync historically. 

QuickBooks will display the exchange rate on top and the amount in both currencies on the bottom. Here is an example using EUR and GBP: