IO / QBO integration with multicurrency
Is anyone using the IO / QBO integration with multiple currencies?
We've got an IO account with multiple locations, and we're using the IO-QBO integration. Most of our IO locations use USD, but one (which we're getting ready to debut) uses Euros.
Based on a few tests yesterday, it looks like the integration transfers amounts, but not currency information, between the two platforms. And when the integration is creating a new customer in QBO, it simply follows the default currency for the QBO company. In our case, that's USD.
In QBO, a customer can only be associated with one currency, which is set upon customer creation and cannot be changed after that. QBO transactions (invoices, payments) associated with a given customer must be in the same currency as that customer.
Here's what I found during some initial testing: when I logged an IO Euro-denominated payment for a brand new customer, the integration-created QBO customer, invoice, and payment were denominated in USD. This is obviously not a good outcome.
But, when I created the customer in QBO ahead of time, setting their currency to Euros as I did so, then the integration-created invoice and payment were denominated in Euros, regardless of whether the IO transactions were in Euros or USD. This is slightly promising but still not great.
I need my QBO transactions to be currency-accurate, so one possibility is that I build a process to create Euro-denominated QBO customers for all of our IO customers who will be placing Euro-denominated orders before any payments are made (since the making of the payments is what triggers the integration). This seems like a poor solution, and it doesn't address the challenge of dealing with customers who conduct business with us in both currencies.
Has anyone else faced this challenge before? Were you able to find a solution? Thanks in advance.
The same question
IO Support, do you have any information on how to deal with this?
IO Support, do you have any information on how to deal with this?
I did put in a ticket for this and haven't heard back yet Will check on it and will let you know as soon as I have an update!
I did put in a ticket for this and haven't heard back yet Will check on it and will let you know as soon as I have an update!
Is everything in the one location always Euros?
Is everything in the one location always Euros?
Hi Tim,
Yes. We currently have five locations; four are always in USD, and the fifth (once we debut it) will always be in Euros.
If we're able to make this multicurrency system work, we will probably add a sixth location that is always in CAD.
Hi Tim,
Yes. We currently have five locations; four are always in USD, and the fifth (once we debut it) will always be in Euros.
If we're able to make this multicurrency system work, we will probably add a sixth location that is always in CAD.
I think we would be able to make it work. We would need to know which location has which currency. You would need to make sure the customer records are assigned to the appropriate location. When we send or update the customer in a location other than the US, we would set the appropriate currency.
I think we would be able to make it work. We would need to know which location has which currency. You would need to make sure the customer records are assigned to the appropriate location. When we send or update the customer in a location other than the US, we would set the appropriate currency.
Thanks Tim, that sounds promising.
43887 is the Euro-denominated location. 18801, 21589, 22453, and 28139 are all USD-denominated.
One thing that would help me is to know what the primary (and secondary if applicable) keys that the IO-QBO integration uses when matching an IO customer to an already-existing QBO customer. I believe that it searches by email address but I'm not entirely sure. We're definitely going to end up with customers who work with us both in the Euro location and the USD locations.
According to what you're proposing, I'll need to have two distinct IO customer profiles for those customers; one for their Euro orders and one for their USD orders. I'll need to have this same record separation in QBO, and so I'm guessing that I'll have to take whatever key the integration uses when searching the already-existing pool of QBO customer profiles, and make sure that those values are different for the two IO customer profiles.
Thanks Tim, that sounds promising.
43887 is the Euro-denominated location. 18801, 21589, 22453, and 28139 are all USD-denominated.
One thing that would help me is to know what the primary (and secondary if applicable) keys that the IO-QBO integration uses when matching an IO customer to an already-existing QBO customer. I believe that it searches by email address but I'm not entirely sure. We're definitely going to end up with customers who work with us both in the Euro location and the USD locations.
According to what you're proposing, I'll need to have two distinct IO customer profiles for those customers; one for their Euro orders and one for their USD orders. I'll need to have this same record separation in QBO, and so I'm guessing that I'll have to take whatever key the integration uses when searching the already-existing pool of QBO customer profiles, and make sure that those values are different for the two IO customer profiles.
We actually search by name. So I suppose you would want to put something special in the name field in IO if the customer record is also in another location and you need to make sure we set the right currency. You should only have to change the customer records that are in a location with a currency different that USD, your default in QBO.
We actually search by name. So I suppose you would want to put something special in the name field in IO if the customer record is also in another location and you need to make sure we set the right currency. You should only have to change the customer records that are in a location with a currency different that USD, your default in QBO.
It should be ready. FYI, according to the QBO docs, we cannot change the currency of a customer once it is set.
It should be ready. FYI, according to the QBO docs, we cannot change the currency of a customer once it is set.
It works! Thanks Tim!
It works! Thanks Tim!
Replies have been locked on this page!