How do I map the currency code of the store, instead of what the customer paid?

Mapping currency codes with our rules engine

What systems support this feature?

We support Magento and Shopify. If you use another system, please contact us.

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:

  1. Login to Connex.
  2. Click rules > my rules on the left.
  3. Click add new rule.
  4. As the template, choose start from scratch.
  5. As the action, choose map currency code.
  6. In the comparison, enter order currency code as the field and map all:
  7. Leave all other fields blank.
  8. 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:

  1. In the rules engine, click add new rule.
  2. In the template field, enter map deposit account.
  3. In comparisons choose order currency, equals, and USD.
  4. In map to, enter USD asset.
  5. Finish the rule.