Split VAT on static bundle products
It would be nice to have VAT splitted in static product bundles extension if products have not same VAT rates.
Product bundles extension is almost great for what I want to do, but I cannot use it because of accountancy issues:
I would like to create a static bundle product with a physical book and cards, and of course a discount.
The issue is that in France (and not only), books and other products have different VAT rates.
Book : VAT = 5.5%
Cards (or other products, even downloadable book) : VAT = 20%
Book = 30 € (incl VAT 5.5%)
Cards = 20 € (incl VAT 20%)
Bundle product Book + Cards = 40 € instead of 50 €
I don't care about displaying or not the single products prices, even it could be an option to display them or not.
What I suggest is that in the bundle product, we add the prices of single products INSIDE the bundle on the product page.
Thus, it would be easy for you to calculate the VAT amounts.
- Book = 26 € (incl VAT 5.5%)
- Cards = 14 € (incl VAT 20%)
Total = 40 €
and in cart:
VAT 5.5% = 1.35 € (corresponding to the book)
VAT 20% = 2.34 € (corresponding to the cards)
Of course, we could have several products with same VAT amount inside the bundle product :
- book A (VAT 5.5%)
- book B (VAT 5.5%)
- cards (VAT 20%)
- pen (VAT 20%)
then the VAT amounts would be calculated like this:
VAT 5.5 = VAT Book A + VAT Book B
VAT 20 = VAT cards + VAT pen
exactly the same as if we add different products with different VAT rates in cart.
Reading the answer I'm still not sure if and how this can be done. Can I have a bundle with several items each with a different VAT rate? And will it show on the invoice / reports so that the Finance Dept. knows exactly what VAT amount of different tax rates is?
Thanks for chiming in here! As mentioned in the extension docs, when you enter a base/static price the container/parent line item gets its own totals + taxes, which are calculated from the entered static/base price.
There are many uses cases of bundling based on the need to sell a "base item" along with a set of required items or add-ons, which may need to be priced individually. In these cases, the static/base price component cannot be (and should not be) transferred from the parent to the children. Furthermore, even if this was possible, your assumption that the "static" cost should be shared among all items according to the ratio of their standalone prices is very limiting and limited in scope, even if this functionality was implemented as a "feature plugin".
If you need to maintain the tax rates of the individual items contained in a bundle, you should use the "Priced Individually" option and define a Discount for each item to bring down the total price -- instead of defining a "base" bundle price. If you don't want to display the individual (line) item prices/totals, you can even use the provided Price Visibility options to hide them in all templates.
I understand that this has an overhead for the store owner, in the sense that you need to calculate the individual Discount amounts in a way that brings the total bundle price where you want it to be, but doing these sort of calculations is a routine operation for all businesses selling taxed goods.
In short -- if you want to calculate tax rates / totals at bundled item level, you'll need to check the Priced Individually option and work from there.