[Skip to main content](#vessel-content) # Coupon and VAT incorrect ## - **[GB11](/forum/user/20674-gb11 "View GB11's Profile")** - [![GB11's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/20674-gb11 "View GB11's Profile") Topic Author - [ Offline](/forum/user/20674-gb11) Less More - Posts: 94 - Thank you received: 0 - - 8 years 2 months ago [\#296946](#296946) by [GB11](/forum/user/20674-gb11 "View GB11's Profile") *[Coupon and VAT incorrect](/forum/46-discount-coupon/895544-coupon-and-vat-incorrect#296946 "-- HikaShop version -- : 3.5.1 Hi, I've got a coupon set up to give 10% discount The total VAT on the invoice is incorrect. Example: 17.45 - 10% (coupon code) = £16.00 + postage (£2.99) = £18.99 VAT at 20% should be £3.16 but it is showing VAT at £3.41 which is the before discount price. I have tried with automatic taxes = yes, and with automatic taxes as no. Nothing has changed. My taxes are set to apply discounts and coupons = after taxes Thanks")* was created by *[GB11](/forum/user/20674-gb11 "View GB11's Profile")* -- HikaShop version -- : 3.5.1 Hi, I've got a coupon set up to give 10% discount The total VAT on the invoice is incorrect. Example: 17.45 - 10% (coupon code) = £16.00 + postage (£2.99) = £18.99 VAT at 20% should be £3.16 but it is showing VAT at £3.41 which is the before discount price. I have tried with automatic taxes = yes, and with automatic taxes as no. Nothing has changed. My taxes are set to apply discounts and coupons = after taxes Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84OTU1NDQtY291cG9uLWFuZC12YXQtaW5jb3JyZWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 8 years 2 months ago [\#296947](#296947) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Coupon and VAT incorrect](/forum/46-discount-coupon/895544-coupon-and-vat-incorrect#296947 "-- HikaShop version -- : 3.5.1 Hi, I've got a coupon set up to give 10% discount The total VAT on the invoice is incorrect. Example: 17.45 - 10% (coupon code) = £16.00 + postage (£2.99) = £18.99 VAT at 20% should be £3.16 but it is showing VAT at £3.41 which is the before discount price. I have tried with automatic taxes = yes, and with automatic taxes as no. Nothing has changed. My taxes are set to apply discounts and coupons = after taxes Thanks")* Hi, Mmm. I don't understand your calculations. 17.45 - 10% = 17.45 - 1.745 = 15.705 not 16. Why 16 ? Please provide more details (screenshots) of how the product is configured, how the shipping method is configured (since shipping can have taxes too). Note also that changing the "apply coupon" setting might help in the way the taxes are calculated in regards to coupons. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84OTU1NDQtY291cG9uLWFuZC12YXQtaW5jb3JyZWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[GB11](/forum/user/20674-gb11 "View GB11's Profile")** - [![GB11's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/20674-gb11 "View GB11's Profile") Topic Author - [ Offline](/forum/user/20674-gb11) Less More - Posts: 94 - Thank you received: 0 - - 8 years 2 months ago [\#296979](#296979) by [GB11](/forum/user/20674-gb11 "View GB11's Profile") Replied by *[GB11](/forum/user/20674-gb11 "View GB11's Profile")* on topic *[Coupon and VAT incorrect](/forum/46-discount-coupon/895544-coupon-and-vat-incorrect#296979 "-- HikaShop version -- : 3.5.1 Hi, I've got a coupon set up to give 10% discount The total VAT on the invoice is incorrect. Example: 17.45 - 10% (coupon code) = £16.00 + postage (£2.99) = £18.99 VAT at 20% should be £3.16 but it is showing VAT at £3.41 which is the before discount price. I have tried with automatic taxes = yes, and with automatic taxes as no. Nothing has changed. My taxes are set to apply discounts and coupons = after taxes Thanks")* You are right, it is actually not giving 10% off. I didn't even notice that part I was so concentrating on the tax. Best go give some refunds to my customers! I'll sort out various screenshots today. I'll try changing the apply coupon now. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84OTU1NDQtY291cG9uLWFuZC12YXQtaW5jb3JyZWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[GB11](/forum/user/20674-gb11 "View GB11's Profile")** - [![GB11's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/20674-gb11 "View GB11's Profile") Topic Author - [ Offline](/forum/user/20674-gb11) Less More - Posts: 94 - Thank you received: 0 - - 8 years 2 months ago [\#297001](#297001) by [GB11](/forum/user/20674-gb11 "View GB11's Profile") Replied by *[GB11](/forum/user/20674-gb11 "View GB11's Profile")* on topic *[Coupon and VAT incorrect](/forum/46-discount-coupon/895544-coupon-and-vat-incorrect#297001 "-- HikaShop version -- : 3.5.1 Hi, I've got a coupon set up to give 10% discount The total VAT on the invoice is incorrect. Example: 17.45 - 10% (coupon code) = £16.00 + postage (£2.99) = £18.99 VAT at 20% should be £3.16 but it is showing VAT at £3.41 which is the before discount price. I have tried with automatic taxes = yes, and with automatic taxes as no. Nothing has changed. My taxes are set to apply discounts and coupons = after taxes Thanks")* Thank you again, I managed to fix the actual percentage value by applying to product. However, the VAT calculation is still incorrect. I have used both "before taxes" and "after taxes". I'm sure I've just misconfigured something, I just can't see what, so I hope you can help. [ ![hikataxes.jpg](/forum/attachment/44597) ](/forum/attachment/44597 "hikataxes.jpg") [ ![hikacoupon.jpg](/forum/attachment/44598) ](/forum/attachment/44598 "hikacoupon.jpg") [ ![hikavat.jpg](/forum/attachment/44599) ](/forum/attachment/44599 "hikavat.jpg") Screenshots attached. - the last being the VAT calculation on the invoice, which should be £3.20 - [ ![hikataxes.jpg](/forum/attachment/44597) ](/forum/attachment/44597 "hikataxes.jpg") [ ](/forum/attachment/44597?download=1 "hikataxes.jpg") - [ ![hikacoupon.jpg](/forum/attachment/44598) ](/forum/attachment/44598 "hikacoupon.jpg") [ ](/forum/attachment/44598?download=1 "hikacoupon.jpg") - [ ![hikavat.jpg](/forum/attachment/44599) ](/forum/attachment/44599 "hikavat.jpg") [ ](/forum/attachment/44599?download=1 "hikavat.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84OTU1NDQtY291cG9uLWFuZC12YXQtaW5jb3JyZWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 8 years 2 months ago [\#297019](#297019) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Coupon and VAT incorrect](/forum/46-discount-coupon/895544-coupon-and-vat-incorrect#297019 "-- HikaShop version -- : 3.5.1 Hi, I've got a coupon set up to give 10% discount The total VAT on the invoice is incorrect. Example: 17.45 - 10% (coupon code) = £16.00 + postage (£2.99) = £18.99 VAT at 20% should be £3.16 but it is showing VAT at £3.41 which is the before discount price. I have tried with automatic taxes = yes, and with automatic taxes as no. Nothing has changed. My taxes are set to apply discounts and coupons = after taxes Thanks")* Hi, Thanks. So the 3.50 VAT corresponds to the VAT for the subtotal + the shipping => 17.99 + 2.99 = 20.98 => 20% of VAT for 20.98 is 3.50 This means that the coupon doesn't modify the VAT amount. I suppose that it's because you have the "floating tax prices" setting which render the calculations more complex and lead to corner cases that we didn't anticipated. I spent several hours on the problem and was able to find out a few issues with that kind of setup. I've added patches for them, tested them, and generated new packages with the fixes included. So download again the install package on our website and install it on yours and that should help. The following user(s) said Thank You: [GB11](/forum/user/20674-gb11 "View GB11's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84OTU1NDQtY291cG9uLWFuZC12YXQtaW5jb3JyZWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[GB11](/forum/user/20674-gb11 "View GB11's Profile")** - [![GB11's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/20674-gb11 "View GB11's Profile") Topic Author - [ Offline](/forum/user/20674-gb11) Less More - Posts: 94 - Thank you received: 0 - - 8 years 2 months ago [\#297028](#297028) by [GB11](/forum/user/20674-gb11 "View GB11's Profile") Replied by *[GB11](/forum/user/20674-gb11 "View GB11's Profile")* on topic *[Coupon and VAT incorrect](/forum/46-discount-coupon/895544-coupon-and-vat-incorrect#297028 "-- HikaShop version -- : 3.5.1 Hi, I've got a coupon set up to give 10% discount The total VAT on the invoice is incorrect. Example: 17.45 - 10% (coupon code) = £16.00 + postage (£2.99) = £18.99 VAT at 20% should be £3.16 but it is showing VAT at £3.41 which is the before discount price. I have tried with automatic taxes = yes, and with automatic taxes as no. Nothing has changed. My taxes are set to apply discounts and coupons = after taxes Thanks")* Thank you very much. I'll install the update this evening. I appreciate you taking the time to look into this ![:)](/media/kunena/emoticons/3.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84OTU1NDQtY291cG9uLWFuZC12YXQtaW5jb3JyZWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[GB11](/forum/user/20674-gb11 "View GB11's Profile")** - [![GB11's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/20674-gb11 "View GB11's Profile") Topic Author - [ Offline](/forum/user/20674-gb11) Less More - Posts: 94 - Thank you received: 0 - - 8 years 2 months ago [\#297071](#297071) by [GB11](/forum/user/20674-gb11 "View GB11's Profile") Replied by *[GB11](/forum/user/20674-gb11 "View GB11's Profile")* on topic *[Coupon and VAT incorrect](/forum/46-discount-coupon/895544-coupon-and-vat-incorrect#297071 "-- HikaShop version -- : 3.5.1 Hi, I've got a coupon set up to give 10% discount The total VAT on the invoice is incorrect. Example: 17.45 - 10% (coupon code) = £16.00 + postage (£2.99) = £18.99 VAT at 20% should be £3.16 but it is showing VAT at £3.41 which is the before discount price. I have tried with automatic taxes = yes, and with automatic taxes as no. Nothing has changed. My taxes are set to apply discounts and coupons = after taxes Thanks")* Hi, I've downloaded the package and installed (although it is showing as 3.5.1, which I had installed already) and have just placed a dummy order. It is still showing the VAT at the pre coupon rate. Should I change a setting on my coupon or taxes? Or perhaps the package is incorrect? Thanks very much Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84OTU1NDQtY291cG9uLWFuZC12YXQtaW5jb3JyZWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 8 years 2 months ago [\#297073](#297073) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Coupon and VAT incorrect](/forum/46-discount-coupon/895544-coupon-and-vat-incorrect#297073 "-- HikaShop version -- : 3.5.1 Hi, I've got a coupon set up to give 10% discount The total VAT on the invoice is incorrect. Example: 17.45 - 10% (coupon code) = £16.00 + postage (£2.99) = £18.99 VAT at 20% should be £3.16 but it is showing VAT at £3.41 which is the before discount price. I have tried with automatic taxes = yes, and with automatic taxes as no. Nothing has changed. My taxes are set to apply discounts and coupons = after taxes Thanks")* Hi, The package is correct on our website, I've verified just to be sure. Are you sure that you used the correct install package and not the one you had downloaded before ? Check that the build number, next to the version in the HikaShop configuration is 1808231405. That's the build number of the package I generated yesterday. If the build number is not the same, then you didn't install the install package I uploaded yesterday. If you do, then maybe the patch was not applied due to access right issues on some of the files or maybe you have another problem than the ones I was able to find and fix. In that case, I would need a backend and FTP access as well as precise instructions to reproduce the issue on your frontend so that I can debug the issue directly on your website. In that case, you can send all that along with a link to this thread via our contact form: [ www.hikashop.com/support/contact-us.html](https://www.hikashop.com/support/contact-us.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84OTU1NDQtY291cG9uLWFuZC12YXQtaW5jb3JyZWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[GB11](/forum/user/20674-gb11 "View GB11's Profile")** - [![GB11's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/20674-gb11 "View GB11's Profile") Topic Author - [ Offline](/forum/user/20674-gb11) Less More - Posts: 94 - Thank you received: 0 - - 8 years 2 months ago [\#297253](#297253) by [GB11](/forum/user/20674-gb11 "View GB11's Profile") Replied by *[GB11](/forum/user/20674-gb11 "View GB11's Profile")* on topic *[Coupon and VAT incorrect](/forum/46-discount-coupon/895544-coupon-and-vat-incorrect#297253 "-- HikaShop version -- : 3.5.1 Hi, I've got a coupon set up to give 10% discount The total VAT on the invoice is incorrect. Example: 17.45 - 10% (coupon code) = £16.00 + postage (£2.99) = £18.99 VAT at 20% should be £3.16 but it is showing VAT at £3.41 which is the before discount price. I have tried with automatic taxes = yes, and with automatic taxes as no. Nothing has changed. My taxes are set to apply discounts and coupons = after taxes Thanks")* Thank you. I had changed 'apply coupon' to 'after taxes' when checking before and left it that way - and it did not work - going back to my screenshot below (before taxes) it now seems to be working as it should. Thank you so much for your help with it. It is really appreciated. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84OTU1NDQtY291cG9uLWFuZC12YXQtaW5jb3JyZWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[earmaster](/forum/user/35023-earmaster "View earmaster's Profile")** - [![earmaster's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35023-earmaster "View earmaster's Profile") - [ Offline](/forum/user/35023-earmaster) Less More - Posts: 136 - Thank you received: 2 - - 8 months 1 week ago - 8 months 1 week ago [\#370595](#370595) by [earmaster](/forum/user/35023-earmaster "View earmaster's Profile") Replied by *[earmaster](/forum/user/35023-earmaster "View earmaster's Profile")* on topic *[Coupon and VAT incorrect](/forum/46-discount-coupon/895544-coupon-and-vat-incorrect#370595 "-- HikaShop version -- : 3.5.1 Hi, I've got a coupon set up to give 10% discount The total VAT on the invoice is incorrect. Example: 17.45 - 10% (coupon code) = £16.00 + postage (£2.99) = £18.99 VAT at 20% should be £3.16 but it is showing VAT at £3.41 which is the before discount price. I have tried with automatic taxes = yes, and with automatic taxes as no. Nothing has changed. My taxes are set to apply discounts and coupons = after taxes Thanks")* Unfortunately, it seems that coupons and discounts used with floating taxes still don't work. We have tried to make it work for years now, but no luck. So we're running a script to correct the amounts when we import transactions to our accounting software. The issue, I think, is that Hikashop always calculates the coupon/discount value based on the subtotal instead of the grand total including taxes, regardless of the "Before/After taxes" setting or the "Tax Category" option you select. Last edit: 8 months 1 week ago by [earmaster](/forum/user/35023-earmaster "View earmaster's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84OTU1NDQtY291cG9uLWFuZC12YXQtaW5jb3JyZWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.088 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)