Connex for QuickBooks Online supports multi-currency with QuickBooks Online CA, UK, and AU.
If your order management system sends us a currency code, we can assign it to a QuickBooks vendor or customer. All transactions under this vendor or customer will have the order's currency code. Otherwise, we use the default currency code for your 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. To enable this feature, expand the transaction area of our configure page. Check multi-currency.
QuickBooks will display the exchange rate on top and the amount in both currencies on the bottom. Here is an example using GBP and USD:
Should I allow customers to pay in multiple currencies?
QuickBooks Online only supports one currency code per customer. Connex will sync all orders using the home currency of QuickBooks. If the customer pays with a different currency, then the order will show the exchange rate.
You must set-up multi-currency in QuickBooks. On the left, click currency center. Click the blue button asking for set-up, then add your currencies.
If your customers and vendors are using USD instead of your currency, you cannot update the record directly. You must make the record inactive and add it again as a new vendor:
- Click name link on the customer or supplier.
- On the top, click edit.
- On the bottom of the dialog box, click make inactive.
- Add the customer or vendor with the same name again, but change the currency.
- You will see no bills or order under the new vendor, since all transactions are associated with the old vendor.
- Rerun the same transactions through QuickBooks Online again. This will associate the transaction with the vendor you just created.
Our system will add new customers and vendors with the home currency of QuickBooks, unless your order management system sends us a different currency code. These systems send us currency codes:
Deposit Accounts for Multi-Currency
Each account is associated with a currency code. You cannot deposit CAD orders into a USD account. Undeposited Funds is associated with your home currency. If there is a currency mismatch between the order and deposit account, you will get this error:
Order XX has failed to export into QuickBooks. Business Validation Error: You cannot use XX account. The currency of the account must either match the transaction currency or be your home currency.
If your company charges in multiple currencies, you must deposit orders into currency specific accounts. Here are the steps:
- At the my connections page of Connex for QuickBooks Online, hover over the gear and click rules engine.
- Click add new rule.
- Add a rule similar to this one:
You may now use multi-currency with multiple deposit accounts.
If you sync customers with the wrong orders, you must click on the customer in QuickBooks. Click edit and mark the customer as inactive. See this image below this paragraph.
Once complete, run a manual sync.
My order has a currency code, but still synced over with a different currency
Most likely, there was an issue with matching to your desired customer, and instead, the order was placed in your Single Customer "Web Store".
- Please ensure that Billing and Shipping addresses were filled out correctly.
- Customers in QuickBooks Online will sync using ONLY the default currency listed for that specific customer. (If your first order to Smith, John was in Russian rubles, every order synced to that customer will also be in rubles)
- Unfortunately, there is no way to change customer's default currency at this time. (reference: Intuit Support) The customer must be deleted, renamed, or made inactive (orders associated with the customer will also have to be deleted. Make sure you document which orders were deleted, that way you can enter them via manual sync!).
- You must then create a new customer with your desired currency (or map a rule that will send a currency with the first order), and then resync the orders.