Summary Transaction FAQ

Does the Summary support multiple currencies in the same selling channel?

Connex can group orders by their currency code and deposit account.

Connex can group orders by their currency code and deposit account. Each currency needs its own deposit account. In this example, we will summarize four orders. Two of them belong to Amazon FBA, but they use Euros instead of Canadian Dollars. Here is the set-up:

QuickBooks

You must create deposit account:

  1. In QuickBooks, go to the gear box and click chart of accounts.
  2. Click new.
  3. Select other current asset for the type and subtype. Add the currency: 

Connex 

Step 1: Create a rule to map the deposit account based on currency: 

  1. From the Connex Dashboard, on the left,  click Rules Engine.
  2. Add a rule to map deposit accounts for each currency by following the sample below:
  3.  

  4.  

Step 2:  Choose the Customer Type on the Customer Tab in Connex:

On the Connex Dashboard, choose the connection and click Manage.

Next expand the Customers Tab>Matching.  From the drop down, choose Store Name and Currency as the customer mode. Connex will append the currency code to the selling channel name in QuickBooks:

  1. Expand the Orders > Sync Manually to QuickBooks tab to change the sync dates under export settings to a one-day range, such as August 13th 12:00 AM to August 13th 11:59 PM.
  2. Open the Orders>New Order and Product Accounts tab and choose a default deposit account for your home currency. In this case, we will use undeposited funds.
  3. Click Sync Now.