I have been trying to figure out if it is possible to combine 2 different taxes into one line item. Some of my products have Sales tax and some have VAT tax. If someone purchase a product that has VAT and a product that has Sales Tax, I'd like to have it show as one line item as opposed to a line item for VAT and a line item for Sales Tax. Not sure if there is a way to do this but would appreciate if anyone could let me know if they have been able to do this.

Comments

rszrama’s picture

Status: Active » Closed (won't fix)

There's no way to do this, because taxes are calculated on a per line item basis, not standalone line items themselves. I don't really get why you'd want to do this, to be honest; it's more or less a requirement in most places to delineate the actual taxes being collected, no?

waltercat’s picture

Sometimes it is best to include tax in the price, this is standard for ticket sales for some reason, and other times you need add sales tax on top of product sales. If you are selling both on your website, like myself, then you use VAT and sales tax. But when the user gets to checkout, the sales tax splits into two line items, something I never see in commerce.

Since I import all my transactions into Quickbooks, via ECC, I need to have the tax broken out before I import into ECC. Otherwise the accounting is a nightmare. For my situation, the ideal way to handle VAT tax would be to not split it out during checkout and just keep it something split out for admins on the backend. For example, using NY State tax, it is confusing to see a product go from $35 on the product page to $32.15 + $2.85 tax on the checkout page. Yes it evens out to the same price, but from a user experience it is slightly disorienting.

I think the same goes for city vs county vs state taxes. While the merchant needs to split out these taxes to pay the proper municipalities, the user does not need to see that they are being taxed for multiple municipalities. It should just be a lump sum.

Unfortunately I only build sites based off the wonderful work that all the developers do, or I'd dig in and figure out a way. Not sure what the best way to do this. I would suggest a rules action that combines two line items, but I would assume that it would then create an entirely new line item and get rid of the separate taxes line items. While this would work for taxes that were the same percentage (like a VAT and Sales Tax situation like my own), it would not work for multiple tax line items that were different percentages, unless there was a way to combine for the user and separate for the admin.

For my current situation, I have decide to just add sale tax to my ticket sales. So my $35 ticket will now be $35 + tax. Not a biggie, people won't notice and I'll make more money off the transaction.