Best answer

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

  • 7 April 2020
  • 2 replies
  • 174 views

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

J.

icon

Best answer by johngreeneroom 8 April 2020, 00:26

View original

This topic has been closed for comments

2 replies

Userlevel 1

https://zapier.com/shared/ec88151c45c79e2b2daf390bfbae999a9258f6a3

 

Resolved I think for now! 

 

Userlevel 7
Badge +10

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