How do I map different accounts receivable accounts in QuickBooks?

How to map multiple currencies to QuickBooks

Introduction

If you use a selling channel like Amazon or WooCommerce, our tool receives the order in the currency the customer paid. In this case, you must map accounts receivable accounts for each currency and instruct Connex to map currency codes to QuickBooks.

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:

Enable QuickBooks Multi-Currency

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.