Best answer

Shopify line item field includes tax and integration with QBO (quickbooks online)

  • 7 April 2020
  • 2 replies

Userlevel 1

Hi Folks, 


I have my zap set up and it works. 


My problem is the ‘line amount’ field in Zapier requires (suggests) a non-taxable line item amount. Shopify’s integrating exports the following field ‘line items Price’ which includes Tax. and does a tax calculation separately. 


Obviously this throws out the Sales Receipt in QBO as it calculates the tax on the ‘line items Price’ and inflates the incorrect price. 

I have tried to do a ‘numbers’ zap to make the line items field ex.vat, but I can’t seem to get that to work either! 


Any ideas!? 



Best answer by johngreeneroom 8 April 2020, 00:26

View original

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

2 replies

Userlevel 1


Resolved I think for now! 


Userlevel 7
Badge +10

That’s great @johngreeneroom  - let us know if you still have issues.