Mapping currency codes with our rules engine
Introduction
Shopify has 2 order currencies. The amount the customer paid and the amount that the store accepts. A U.S. customer buying at a British store pays in USD, but the British store shows EUR.
What if a British customer paid EUR?
The store and customer paid are identical, so the rule will never run. The sale would appear as normal.
How does it look?
Out of box, our tool maps the currency code that the customer used and the amount. This is bad because when you reconcile, the amounts must match your home currency. You would have some sales in USD and some in EUR.
In this example, we will map $415.41 to QuickBooks instead of the 504.10 USD that the customer paid. Here is the Shopify sale:
How do I enable this feature?
You must add a rule. This instructs Connex to map the amount the customer paid in their home currency:
- Login to Connex.
- Click rules > my rules on the left.
- Click add new rule.
- As the action, choose map currency code.
- In the comparison, enter order currency code as the field and map all:
- Leave all other fields blank.
- Finish the rule.
How do I map these sales to different asset accounts?
QuickBooks Online allows only one currency per asset account. In this example, we will map the USD sales to an account called USD asset in QuickBooks:
- In the rules engine, click add new rule.
- As the action, choose map order deposit account.
- In comparisons choose order currency, equals, and USD.
- In map to, enter USD asset.
- Finish the rule.