Skip to main content
Best answer

Stripe currency changes to Xero default

  • July 12, 2021
  • 5 replies
  • 71 views

We have a ZAP that imports invoices from Stripe into Xero.

 

However, our client uses multiple currencies, but when the ZAP imports the stripe invoice into Xero, the currency is defaulted to GBP, how can we resolve this please.#

 

thank you

Best answer by GetUWired

You will need to fill out the currency field on the Xero step so that it doesn’t default to GBD. This should be passed dynamically from Stripe. 

If the way Stripe formats currencies is not the same as the way Xero formats currencies. A look up table will be needed to translate the values. More info on using a lookup table can be found here: https://zapier.com/help/create/format/create-lookup-tables-in-zaps 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • July 12, 2021

Hi @hellombw 

Check if there is a setting in the Zap step configuration for specifying the currency.


GetUWired
Forum|alt.badge.img+12
  • Zapier Solution Partner
  • July 12, 2021

Hi @hellombw 

You will need to tell Zapier to dynamically determine the currency when generating the invoice in Xero. I.e pass the currency type returned from the trigger step into the currency type in Xero

If the currency type returned from the trigger step doesn’t match what xero is calling it, you will need to implement a lookup table to translate values 


  • Author
  • Beginner
  • July 26, 2021

There are a number of fields in the Zap that i can select from Stripe, but we are still seeing the default currency when the invoice is created in Xero. Not entirely sure how to use the formatter,


GetUWired
Forum|alt.badge.img+12
  • Zapier Solution Partner
  • Answer
  • July 27, 2021

You will need to fill out the currency field on the Xero step so that it doesn’t default to GBD. This should be passed dynamically from Stripe. 

If the way Stripe formats currencies is not the same as the way Xero formats currencies. A look up table will be needed to translate the values. More info on using a lookup table can be found here: https://zapier.com/help/create/format/create-lookup-tables-in-zaps 


  • Author
  • Beginner
  • September 14, 2021

thanks everyone for your response, the zap is now working as we need it to. it was more a case of selecting the correct field from stripe for the currency