Skip to main content
Question

How do I handle mixed VAT rates in Xero with Zapier line items?

  • June 10, 2024
  • 1 reply
  • 26 views

I have 2 line items

Item 1 is charged at a vat rate of 23%

Item 2 is charged at a vat rate of 0%

Zapier line item is “inclusive” of vat

 

Shopify calculates total Vat correctly

 

The line items both end up with 23% vat being calculated for both items

Should be

Line 1 -Gross Price €25, Net Price €20.33, Vat rate 23%, Vat amount €4.67

Line 2 -Gross Price €25, Net Price €25.00, Vat rate 0%, Vat amount €0

Xero calculates/displays

Line 1 -Gross Price €25, Net Price €20.33, Vat rate 23%, Vat amount €4.67

Line 2 -Gross Price €25, Net Price €20.33, Vat rate 23%, Vat amount €4.67

 

Any suggestions/ideas/solution

 

Thanks in adavance

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

1 reply

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • June 25, 2024

Hey @Nilsson Denver, welcome to the Community! 🎉

I can see that you also reached out to our Support team and they suggested using a lookup table to match the VAT rates from Shopify with the rates in Xero. Did that resolve things?

Keen to ensure you’re all set on this so please let us know if you’re still in need of any assistance on this at all! 🙂