Skip to main content
Best answer

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


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!? 

J.

Best answer by johngreeneroomBest answer by johngreeneroom

https://zapier.com/shared/ec88151c45c79e2b2daf390bfbae999a9258f6a3

 

Resolved I think for now! 

 

View original
Did this topic help you find an answer to your question?
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


AndrewJDavison_Luhhu
Forum|alt.badge.img+10

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