[Skip to main content](#vessel-content) # Faulty invoice and tax calculation! - Solved ## - **[Eppo](/forum/user/973-eppo "View Eppo's Profile")** - [![Eppo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/973-eppo "View Eppo's Profile") - [ Offline](/forum/user/973-eppo) Less More - Posts: 16 - Thank you received: 0 - - 15 years 9 months ago [\#7110](#7110) by [Eppo](/forum/user/973-eppo "View Eppo's Profile") Replied by *[Eppo](/forum/user/973-eppo "View Eppo's Profile")* on topic *[Re: Faulty invoice and tax calculation! - Solved](/forum/4-how-to/5847-faulty-invoice-and-tax-calculation-solved?start=20#7110 "Hello, now, near the lunch of my shop and some ordering testing, I ran into a big problem. The tax calculation and shipping-tax calculation makes some mistakes. I did a testorder and took some screenshots (all from the same order) to explain it. and the tax for germany is 19%. Here you see a screenshot of the cart in the frontend. Here is the first mistake: - the "Zwischensumme" (sum) incl. the tax is 44,-€ -> thats ok. - the "Versand" (shipping) incl. the tax is 5,95 -> thats ok. - the "Steuern" (tax) is wrong. If 49,95€ is the endprice with tax, than 41,97€ is the endprice without tax and the tax is 7,98€ (not 7,95€). Next screenshot. This time from the email the user will get: Here the user gets an email with the price without tax. Ok, I think this could be changed in the emailsettings, but also here the price calculation is wrong. Because the price without tax from 44,-€ is not 37,-€, it should be 36,974789915966386554621848739496€ or better 36,97€. Next screenshot from the invoice in the backend: Here are some more mistakes: - the 37,-€ without tax is wrong, as I allready said in the second picture. - The MwSt. is wrong. Why only 7,-€? In the cart is was 7,95€ (that was allready wrong) and now its only 7,-€ (more wrong) but we allready told the user in the mail that it was 7,95€? I am confused about this. - the rest is ok. Ok, last screenshot. Now from my own invoice-program I use for a long time and do the calculation right: Here you see the price per pcs. of 0,44€ with tax. So for 100 pcs. 44,-€. Then the shipping with 5,95€ incl. tax and the endprice incl. tax is 49,95. And now the big difference at the tax, with 7,98€ its right in this calculation. So what do do? I think I know where is the big problem. At the product page I type in the price incl. tax. and I type there the price of 0,44€ incl. tax at min. 100pcs. When I leave the "price incl. tax" field it automatic write at the field "without tax" the value 0.37000€. And thats the mistake I think. Regards, Benny.")* Problem fixed! Thanks for your very quick support! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU4NDctZmF1bHR5LWludm9pY2UtYW5kLXRheC1jYWxjdWxhdGlvbi1zb2x2ZWQ/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eppo](/forum/user/973-eppo "View Eppo's Profile")** - [![Eppo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/973-eppo "View Eppo's Profile") - [ Offline](/forum/user/973-eppo) Less More - Posts: 16 - Thank you received: 0 - - 15 years 9 months ago [\#7631](#7631) by [Eppo](/forum/user/973-eppo "View Eppo's Profile") Replied by *[Eppo](/forum/user/973-eppo "View Eppo's Profile")* on topic *[Re: Faulty invoice and tax calculation! - Solved](/forum/4-how-to/5847-faulty-invoice-and-tax-calculation-solved?start=20#7631 "Hello, now, near the lunch of my shop and some ordering testing, I ran into a big problem. The tax calculation and shipping-tax calculation makes some mistakes. I did a testorder and took some screenshots (all from the same order) to explain it. and the tax for germany is 19%. Here you see a screenshot of the cart in the frontend. Here is the first mistake: - the "Zwischensumme" (sum) incl. the tax is 44,-€ -> thats ok. - the "Versand" (shipping) incl. the tax is 5,95 -> thats ok. - the "Steuern" (tax) is wrong. If 49,95€ is the endprice with tax, than 41,97€ is the endprice without tax and the tax is 7,98€ (not 7,95€). Next screenshot. This time from the email the user will get: Here the user gets an email with the price without tax. Ok, I think this could be changed in the emailsettings, but also here the price calculation is wrong. Because the price without tax from 44,-€ is not 37,-€, it should be 36,974789915966386554621848739496€ or better 36,97€. Next screenshot from the invoice in the backend: Here are some more mistakes: - the 37,-€ without tax is wrong, as I allready said in the second picture. - The MwSt. is wrong. Why only 7,-€? In the cart is was 7,95€ (that was allready wrong) and now its only 7,-€ (more wrong) but we allready told the user in the mail that it was 7,95€? I am confused about this. - the rest is ok. Ok, last screenshot. Now from my own invoice-program I use for a long time and do the calculation right: Here you see the price per pcs. of 0,44€ with tax. So for 100 pcs. 44,-€. Then the shipping with 5,95€ incl. tax and the endprice incl. tax is 49,95. And now the big difference at the tax, with 7,98€ its right in this calculation. So what do do? I think I know where is the big problem. At the product page I type in the price incl. tax. and I type there the price of 0,44€ incl. tax at min. 100pcs. When I leave the "price incl. tax" field it automatic write at the field "without tax" the value 0.37000€. And thats the mistake I think. Regards, Benny.")* Hi Nicolas, Here I am again... another tax calculation issue, this time in the back-end when I look at the details of an order. In the product list, the tax calculation is wrongly displayed. In Unit Price, Hikashop displays 16,76 € +3,00 € BTW, where it should be 16,76 € + 3,19 € BTW (19% Tax). Consequently, the total price is also wrong (19,76 instead of 19,95). The funny thing is that in extra information, the subtotal and total price are correct, and if I do not change something on one order, the total price in the order overview is also correct... Thanks for your help, Regards, Eppo Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU4NDctZmF1bHR5LWludm9pY2UtYW5kLXRheC1jYWxjdWxhdGlvbi1zb2x2ZWQ/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 15 years 9 months ago [\#7636](#7636) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Faulty invoice and tax calculation! - Solved](/forum/4-how-to/5847-faulty-invoice-and-tax-calculation-solved?start=20#7636 "Hello, now, near the lunch of my shop and some ordering testing, I ran into a big problem. The tax calculation and shipping-tax calculation makes some mistakes. I did a testorder and took some screenshots (all from the same order) to explain it. and the tax for germany is 19%. Here you see a screenshot of the cart in the frontend. Here is the first mistake: - the "Zwischensumme" (sum) incl. the tax is 44,-€ -> thats ok. - the "Versand" (shipping) incl. the tax is 5,95 -> thats ok. - the "Steuern" (tax) is wrong. If 49,95€ is the endprice with tax, than 41,97€ is the endprice without tax and the tax is 7,98€ (not 7,95€). Next screenshot. This time from the email the user will get: Here the user gets an email with the price without tax. Ok, I think this could be changed in the emailsettings, but also here the price calculation is wrong. Because the price without tax from 44,-€ is not 37,-€, it should be 36,974789915966386554621848739496€ or better 36,97€. Next screenshot from the invoice in the backend: Here are some more mistakes: - the 37,-€ without tax is wrong, as I allready said in the second picture. - The MwSt. is wrong. Why only 7,-€? In the cart is was 7,95€ (that was allready wrong) and now its only 7,-€ (more wrong) but we allready told the user in the mail that it was 7,95€? I am confused about this. - the rest is ok. Ok, last screenshot. Now from my own invoice-program I use for a long time and do the calculation right: Here you see the price per pcs. of 0,44€ with tax. So for 100 pcs. 44,-€. Then the shipping with 5,95€ incl. tax and the endprice incl. tax is 49,95. And now the big difference at the tax, with 7,98€ its right in this calculation. So what do do? I think I know where is the big problem. At the product page I type in the price incl. tax. and I type there the price of 0,44€ incl. tax at min. 100pcs. When I leave the "price incl. tax" field it automatic write at the field "without tax" the value 0.37000€. And thats the mistake I think. Regards, Benny.")* Do you use the latest version of HikaShop ? Was that order made recently ? There was such a problem in previous versions of HikaShop, but if you use the latest version, it shouldn't be the case. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU4NDctZmF1bHR5LWludm9pY2UtYW5kLXRheC1jYWxjdWxhdGlvbi1zb2x2ZWQ/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")** - [![freemanbob's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6950-freemanbob "View freemanbob's Profile") - [ Offline](/forum/user/6950-freemanbob) Less More - Posts: 32 - Thank you received: 2 - - 13 years 8 months ago - 13 years 8 months ago [\#93299](#93299) by [freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile") Replied by *[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")* on topic *[Re: Faulty invoice and tax calculation! - Solved](/forum/4-how-to/5847-faulty-invoice-and-tax-calculation-solved?start=20#93299 "Hello, now, near the lunch of my shop and some ordering testing, I ran into a big problem. The tax calculation and shipping-tax calculation makes some mistakes. I did a testorder and took some screenshots (all from the same order) to explain it. and the tax for germany is 19%. Here you see a screenshot of the cart in the frontend. Here is the first mistake: - the "Zwischensumme" (sum) incl. the tax is 44,-€ -> thats ok. - the "Versand" (shipping) incl. the tax is 5,95 -> thats ok. - the "Steuern" (tax) is wrong. If 49,95€ is the endprice with tax, than 41,97€ is the endprice without tax and the tax is 7,98€ (not 7,95€). Next screenshot. This time from the email the user will get: Here the user gets an email with the price without tax. Ok, I think this could be changed in the emailsettings, but also here the price calculation is wrong. Because the price without tax from 44,-€ is not 37,-€, it should be 36,974789915966386554621848739496€ or better 36,97€. Next screenshot from the invoice in the backend: Here are some more mistakes: - the 37,-€ without tax is wrong, as I allready said in the second picture. - The MwSt. is wrong. Why only 7,-€? In the cart is was 7,95€ (that was allready wrong) and now its only 7,-€ (more wrong) but we allready told the user in the mail that it was 7,95€? I am confused about this. - the rest is ok. Ok, last screenshot. Now from my own invoice-program I use for a long time and do the calculation right: Here you see the price per pcs. of 0,44€ with tax. So for 100 pcs. 44,-€. Then the shipping with 5,95€ incl. tax and the endprice incl. tax is 49,95. And now the big difference at the tax, with 7,98€ its right in this calculation. So what do do? I think I know where is the big problem. At the product page I type in the price incl. tax. and I type there the price of 0,44€ incl. tax at min. 100pcs. When I leave the "price incl. tax" field it automatic write at the field "without tax" the value 0.37000€. And thats the mistake I think. Regards, Benny.")* I am having this same problem in the latest version of HikaShop 2.1.0 this is really bad for my business. It seems that this release is not stable as I am coming across other anomallies which I shall list for you once this has been addressed. many thanks Bob I should add that my VAT is incorrectly calculated, even though it is set to 20% and with the incorrect VAT value the total is still not what it should be please see attached. I have removed the attached file due to customers personal details being present it was not my intention to display the personal details of a customer. Last edit: 13 years 8 months ago by [freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU4NDctZmF1bHR5LWludm9pY2UtYW5kLXRheC1jYWxjdWxhdGlvbi1zb2x2ZWQ/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 13 years 8 months ago [\#93304](#93304) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Faulty invoice and tax calculation! - Solved](/forum/4-how-to/5847-faulty-invoice-and-tax-calculation-solved?start=20#93304 "Hello, now, near the lunch of my shop and some ordering testing, I ran into a big problem. The tax calculation and shipping-tax calculation makes some mistakes. I did a testorder and took some screenshots (all from the same order) to explain it. and the tax for germany is 19%. Here you see a screenshot of the cart in the frontend. Here is the first mistake: - the "Zwischensumme" (sum) incl. the tax is 44,-€ -> thats ok. - the "Versand" (shipping) incl. the tax is 5,95 -> thats ok. - the "Steuern" (tax) is wrong. If 49,95€ is the endprice with tax, than 41,97€ is the endprice without tax and the tax is 7,98€ (not 7,95€). Next screenshot. This time from the email the user will get: Here the user gets an email with the price without tax. Ok, I think this could be changed in the emailsettings, but also here the price calculation is wrong. Because the price without tax from 44,-€ is not 37,-€, it should be 36,974789915966386554621848739496€ or better 36,97€. Next screenshot from the invoice in the backend: Here are some more mistakes: - the 37,-€ without tax is wrong, as I allready said in the second picture. - The MwSt. is wrong. Why only 7,-€? In the cart is was 7,95€ (that was allready wrong) and now its only 7,-€ (more wrong) but we allready told the user in the mail that it was 7,95€? I am confused about this. - the rest is ok. Ok, last screenshot. Now from my own invoice-program I use for a long time and do the calculation right: Here you see the price per pcs. of 0,44€ with tax. So for 100 pcs. 44,-€. Then the shipping with 5,95€ incl. tax and the endprice incl. tax is 49,95. And now the big difference at the tax, with 7,98€ its right in this calculation. So what do do? I think I know where is the big problem. At the product page I type in the price incl. tax. and I type there the price of 0,44€ incl. tax at min. 100pcs. When I leave the "price incl. tax" field it automatic write at the field "without tax" the value 0.37000€. And thats the mistake I think. Regards, Benny.")* As we cannot reproduce the problem on our end, we cannot help you unless you give more information on how to reproduce it. Can you do screenshots of the different elements which would allow to reproduce that ? A screenshot of the order details page, of the product edition page, of the tax rules and one of the tax options in the configuration would be a good start. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU4NDctZmF1bHR5LWludm9pY2UtYW5kLXRheC1jYWxjdWxhdGlvbi1zb2x2ZWQ/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")** - [![freemanbob's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6950-freemanbob "View freemanbob's Profile") - [ Offline](/forum/user/6950-freemanbob) Less More - Posts: 32 - Thank you received: 2 - - 13 years 8 months ago - 13 years 8 months ago [\#93311](#93311) by [freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile") Replied by *[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")* on topic *[Re: Faulty invoice and tax calculation! - Solved](/forum/4-how-to/5847-faulty-invoice-and-tax-calculation-solved?start=20#93311 "Hello, now, near the lunch of my shop and some ordering testing, I ran into a big problem. The tax calculation and shipping-tax calculation makes some mistakes. I did a testorder and took some screenshots (all from the same order) to explain it. and the tax for germany is 19%. Here you see a screenshot of the cart in the frontend. Here is the first mistake: - the "Zwischensumme" (sum) incl. the tax is 44,-€ -> thats ok. - the "Versand" (shipping) incl. the tax is 5,95 -> thats ok. - the "Steuern" (tax) is wrong. If 49,95€ is the endprice with tax, than 41,97€ is the endprice without tax and the tax is 7,98€ (not 7,95€). Next screenshot. This time from the email the user will get: Here the user gets an email with the price without tax. Ok, I think this could be changed in the emailsettings, but also here the price calculation is wrong. Because the price without tax from 44,-€ is not 37,-€, it should be 36,974789915966386554621848739496€ or better 36,97€. Next screenshot from the invoice in the backend: Here are some more mistakes: - the 37,-€ without tax is wrong, as I allready said in the second picture. - The MwSt. is wrong. Why only 7,-€? In the cart is was 7,95€ (that was allready wrong) and now its only 7,-€ (more wrong) but we allready told the user in the mail that it was 7,95€? I am confused about this. - the rest is ok. Ok, last screenshot. Now from my own invoice-program I use for a long time and do the calculation right: Here you see the price per pcs. of 0,44€ with tax. So for 100 pcs. 44,-€. Then the shipping with 5,95€ incl. tax and the endprice incl. tax is 49,95. And now the big difference at the tax, with 7,98€ its right in this calculation. So what do do? I think I know where is the big problem. At the product page I type in the price incl. tax. and I type there the price of 0,44€ incl. tax at min. 100pcs. When I leave the "price incl. tax" field it automatic write at the field "without tax" the value 0.37000€. And thats the mistake I think. Regards, Benny.")* I'll get right on it. Here are some screenshots. I noticed that in the product screenshot (tipicalProduct) that the tax is calculated correctly but not in the final order. The final order has two problems 1/ the tax is not being added and 2/ the tax is incorrectly calculated. Last edit: 13 years 8 months ago by [freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU4NDctZmF1bHR5LWludm9pY2UtYW5kLXRheC1jYWxjdWxhdGlvbi1zb2x2ZWQ/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")** - [![freemanbob's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6950-freemanbob "View freemanbob's Profile") - [ Offline](/forum/user/6950-freemanbob) Less More - Posts: 32 - Thank you received: 2 - - 13 years 8 months ago [\#93382](#93382) by [freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile") Replied by *[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")* on topic *[Re: Faulty invoice and tax calculation! - Solved](/forum/4-how-to/5847-faulty-invoice-and-tax-calculation-solved?start=20#93382 "Hello, now, near the lunch of my shop and some ordering testing, I ran into a big problem. The tax calculation and shipping-tax calculation makes some mistakes. I did a testorder and took some screenshots (all from the same order) to explain it. and the tax for germany is 19%. Here you see a screenshot of the cart in the frontend. Here is the first mistake: - the "Zwischensumme" (sum) incl. the tax is 44,-€ -> thats ok. - the "Versand" (shipping) incl. the tax is 5,95 -> thats ok. - the "Steuern" (tax) is wrong. If 49,95€ is the endprice with tax, than 41,97€ is the endprice without tax and the tax is 7,98€ (not 7,95€). Next screenshot. This time from the email the user will get: Here the user gets an email with the price without tax. Ok, I think this could be changed in the emailsettings, but also here the price calculation is wrong. Because the price without tax from 44,-€ is not 37,-€, it should be 36,974789915966386554621848739496€ or better 36,97€. Next screenshot from the invoice in the backend: Here are some more mistakes: - the 37,-€ without tax is wrong, as I allready said in the second picture. - The MwSt. is wrong. Why only 7,-€? In the cart is was 7,95€ (that was allready wrong) and now its only 7,-€ (more wrong) but we allready told the user in the mail that it was 7,95€? I am confused about this. - the rest is ok. Ok, last screenshot. Now from my own invoice-program I use for a long time and do the calculation right: Here you see the price per pcs. of 0,44€ with tax. So for 100 pcs. 44,-€. Then the shipping with 5,95€ incl. tax and the endprice incl. tax is 49,95. And now the big difference at the tax, with 7,98€ its right in this calculation. So what do do? I think I know where is the big problem. At the product page I type in the price incl. tax. and I type there the price of 0,44€ incl. tax at min. 100pcs. When I leave the "price incl. tax" field it automatic write at the field "without tax" the value 0.37000€. And thats the mistake I think. Regards, Benny.")* Hi I have found that the VAT is already calculated in the subtotal which would explain the VAT not being haddded to the total so hold fire on any further investigations until I explore further. I shall come back today when I have done my homework. I may need to apologise for this one, which I shall if I have overlooked something. bob Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU4NDctZmF1bHR5LWludm9pY2UtYW5kLXRheC1jYWxjdWxhdGlvbi1zb2x2ZWQ/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")** - [![freemanbob's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6950-freemanbob "View freemanbob's Profile") - [ Offline](/forum/user/6950-freemanbob) Less More - Posts: 32 - Thank you received: 2 - - 13 years 8 months ago [\#93395](#93395) by [freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile") Replied by *[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")* on topic *[Re: Faulty invoice and tax calculation! - Solved](/forum/4-how-to/5847-faulty-invoice-and-tax-calculation-solved?start=20#93395 "Hello, now, near the lunch of my shop and some ordering testing, I ran into a big problem. The tax calculation and shipping-tax calculation makes some mistakes. I did a testorder and took some screenshots (all from the same order) to explain it. and the tax for germany is 19%. Here you see a screenshot of the cart in the frontend. Here is the first mistake: - the "Zwischensumme" (sum) incl. the tax is 44,-€ -> thats ok. - the "Versand" (shipping) incl. the tax is 5,95 -> thats ok. - the "Steuern" (tax) is wrong. If 49,95€ is the endprice with tax, than 41,97€ is the endprice without tax and the tax is 7,98€ (not 7,95€). Next screenshot. This time from the email the user will get: Here the user gets an email with the price without tax. Ok, I think this could be changed in the emailsettings, but also here the price calculation is wrong. Because the price without tax from 44,-€ is not 37,-€, it should be 36,974789915966386554621848739496€ or better 36,97€. Next screenshot from the invoice in the backend: Here are some more mistakes: - the 37,-€ without tax is wrong, as I allready said in the second picture. - The MwSt. is wrong. Why only 7,-€? In the cart is was 7,95€ (that was allready wrong) and now its only 7,-€ (more wrong) but we allready told the user in the mail that it was 7,95€? I am confused about this. - the rest is ok. Ok, last screenshot. Now from my own invoice-program I use for a long time and do the calculation right: Here you see the price per pcs. of 0,44€ with tax. So for 100 pcs. 44,-€. Then the shipping with 5,95€ incl. tax and the endprice incl. tax is 49,95. And now the big difference at the tax, with 7,98€ its right in this calculation. So what do do? I think I know where is the big problem. At the product page I type in the price incl. tax. and I type there the price of 0,44€ incl. tax at min. 100pcs. When I leave the "price incl. tax" field it automatic write at the field "without tax" the value 0.37000€. And thats the mistake I think. Regards, Benny.")* Hi Guys, I have gone into every product on the above included invoice and I discovered that one product does not calculate the VAT? see attached pdf dolphineNoVAT which shows that the product is not calculating the VAT yet every other product does. *This attachment is hidden for guests. Please log in or register to see it.* I thought it might be that this product has 'characteristics' and that this might be the source of the problem but other products with 'characteristics' calculate the VAT without any problems?? I'm at a loss as to why this product refuses to calculate the VAT. I await your response. regards bob Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU4NDctZmF1bHR5LWludm9pY2UtYW5kLXRheC1jYWxjdWxhdGlvbi1zb2x2ZWQ/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 13 years 8 months ago [\#93435](#93435) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Re: Faulty invoice and tax calculation! - Solved](/forum/4-how-to/5847-faulty-invoice-and-tax-calculation-solved?start=20#93435 "Hello, now, near the lunch of my shop and some ordering testing, I ran into a big problem. The tax calculation and shipping-tax calculation makes some mistakes. I did a testorder and took some screenshots (all from the same order) to explain it. and the tax for germany is 19%. Here you see a screenshot of the cart in the frontend. Here is the first mistake: - the "Zwischensumme" (sum) incl. the tax is 44,-€ -> thats ok. - the "Versand" (shipping) incl. the tax is 5,95 -> thats ok. - the "Steuern" (tax) is wrong. If 49,95€ is the endprice with tax, than 41,97€ is the endprice without tax and the tax is 7,98€ (not 7,95€). Next screenshot. This time from the email the user will get: Here the user gets an email with the price without tax. Ok, I think this could be changed in the emailsettings, but also here the price calculation is wrong. Because the price without tax from 44,-€ is not 37,-€, it should be 36,974789915966386554621848739496€ or better 36,97€. Next screenshot from the invoice in the backend: Here are some more mistakes: - the 37,-€ without tax is wrong, as I allready said in the second picture. - The MwSt. is wrong. Why only 7,-€? In the cart is was 7,95€ (that was allready wrong) and now its only 7,-€ (more wrong) but we allready told the user in the mail that it was 7,95€? I am confused about this. - the rest is ok. Ok, last screenshot. Now from my own invoice-program I use for a long time and do the calculation right: Here you see the price per pcs. of 0,44€ with tax. So for 100 pcs. 44,-€. Then the shipping with 5,95€ incl. tax and the endprice incl. tax is 49,95. And now the big difference at the tax, with 7,98€ its right in this calculation. So what do do? I think I know where is the big problem. At the product page I type in the price incl. tax. and I type there the price of 0,44€ incl. tax at min. 100pcs. When I leave the "price incl. tax" field it automatic write at the field "without tax" the value 0.37000€. And thats the mistake I think. Regards, Benny.")* Hi, Could you give us a screeshot of a product without VAT problems ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU4NDctZmF1bHR5LWludm9pY2UtYW5kLXRheC1jYWxjdWxhdGlvbi1zb2x2ZWQ/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")** - [![freemanbob's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6950-freemanbob "View freemanbob's Profile") - [ Offline](/forum/user/6950-freemanbob) Less More - Posts: 32 - Thank you received: 2 - - 13 years 8 months ago [\#93465](#93465) by [freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile") Replied by *[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")* on topic *[Re: Faulty invoice and tax calculation! - Solved](/forum/4-how-to/5847-faulty-invoice-and-tax-calculation-solved?start=20#93465 "Hello, now, near the lunch of my shop and some ordering testing, I ran into a big problem. The tax calculation and shipping-tax calculation makes some mistakes. I did a testorder and took some screenshots (all from the same order) to explain it. and the tax for germany is 19%. Here you see a screenshot of the cart in the frontend. Here is the first mistake: - the "Zwischensumme" (sum) incl. the tax is 44,-€ -> thats ok. - the "Versand" (shipping) incl. the tax is 5,95 -> thats ok. - the "Steuern" (tax) is wrong. If 49,95€ is the endprice with tax, than 41,97€ is the endprice without tax and the tax is 7,98€ (not 7,95€). Next screenshot. This time from the email the user will get: Here the user gets an email with the price without tax. Ok, I think this could be changed in the emailsettings, but also here the price calculation is wrong. Because the price without tax from 44,-€ is not 37,-€, it should be 36,974789915966386554621848739496€ or better 36,97€. Next screenshot from the invoice in the backend: Here are some more mistakes: - the 37,-€ without tax is wrong, as I allready said in the second picture. - The MwSt. is wrong. Why only 7,-€? In the cart is was 7,95€ (that was allready wrong) and now its only 7,-€ (more wrong) but we allready told the user in the mail that it was 7,95€? I am confused about this. - the rest is ok. Ok, last screenshot. Now from my own invoice-program I use for a long time and do the calculation right: Here you see the price per pcs. of 0,44€ with tax. So for 100 pcs. 44,-€. Then the shipping with 5,95€ incl. tax and the endprice incl. tax is 49,95. And now the big difference at the tax, with 7,98€ its right in this calculation. So what do do? I think I know where is the big problem. At the product page I type in the price incl. tax. and I type there the price of 0,44€ incl. tax at min. 100pcs. When I leave the "price incl. tax" field it automatic write at the field "without tax" the value 0.37000€. And thats the mistake I think. Regards, Benny.")* Hi I have attached two files showing one product with 'characteristics' and and one without 'characteristics' both have the VAT calculated just fine. It is unfortunate that this problem does not follow some form of grouping but rather seems to be quite random? Bob Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU4NDctZmF1bHR5LWludm9pY2UtYW5kLXRheC1jYWxjdWxhdGlvbi1zb2x2ZWQ/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")** - [![freemanbob's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6950-freemanbob "View freemanbob's Profile") - [ Offline](/forum/user/6950-freemanbob) Less More - Posts: 32 - Thank you received: 2 - - 13 years 8 months ago - 13 years 8 months ago [\#93705](#93705) by [freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile") Replied by *[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")* on topic *[Re: Faulty invoice and tax calculation! - Solved](/forum/4-how-to/5847-faulty-invoice-and-tax-calculation-solved?start=20#93705 "Hello, now, near the lunch of my shop and some ordering testing, I ran into a big problem. The tax calculation and shipping-tax calculation makes some mistakes. I did a testorder and took some screenshots (all from the same order) to explain it. and the tax for germany is 19%. Here you see a screenshot of the cart in the frontend. Here is the first mistake: - the "Zwischensumme" (sum) incl. the tax is 44,-€ -> thats ok. - the "Versand" (shipping) incl. the tax is 5,95 -> thats ok. - the "Steuern" (tax) is wrong. If 49,95€ is the endprice with tax, than 41,97€ is the endprice without tax and the tax is 7,98€ (not 7,95€). Next screenshot. This time from the email the user will get: Here the user gets an email with the price without tax. Ok, I think this could be changed in the emailsettings, but also here the price calculation is wrong. Because the price without tax from 44,-€ is not 37,-€, it should be 36,974789915966386554621848739496€ or better 36,97€. Next screenshot from the invoice in the backend: Here are some more mistakes: - the 37,-€ without tax is wrong, as I allready said in the second picture. - The MwSt. is wrong. Why only 7,-€? In the cart is was 7,95€ (that was allready wrong) and now its only 7,-€ (more wrong) but we allready told the user in the mail that it was 7,95€? I am confused about this. - the rest is ok. Ok, last screenshot. Now from my own invoice-program I use for a long time and do the calculation right: Here you see the price per pcs. of 0,44€ with tax. So for 100 pcs. 44,-€. Then the shipping with 5,95€ incl. tax and the endprice incl. tax is 49,95. And now the big difference at the tax, with 7,98€ its right in this calculation. So what do do? I think I know where is the big problem. At the product page I type in the price incl. tax. and I type there the price of 0,44€ incl. tax at min. 100pcs. When I leave the "price incl. tax" field it automatic write at the field "without tax" the value 0.37000€. And thats the mistake I think. Regards, Benny.")* Any News on this problem guys? ![:unsure:](/media/kunena/emoticons/18.png ":unsure:") Last edit: 13 years 8 months ago by [freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU4NDctZmF1bHR5LWludm9pY2UtYW5kLXRheC1jYWxjdWxhdGlvbi1zb2x2ZWQ/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")** - [![freemanbob's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6950-freemanbob "View freemanbob's Profile") - [ Offline](/forum/user/6950-freemanbob) Less More - Posts: 32 - Thank you received: 2 - - 13 years 8 months ago [\#93712](#93712) by [freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile") Replied by *[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")* on topic *[Re: Faulty invoice and tax calculation! - Solved](/forum/4-how-to/5847-faulty-invoice-and-tax-calculation-solved?start=20#93712 "Hello, now, near the lunch of my shop and some ordering testing, I ran into a big problem. The tax calculation and shipping-tax calculation makes some mistakes. I did a testorder and took some screenshots (all from the same order) to explain it. and the tax for germany is 19%. Here you see a screenshot of the cart in the frontend. Here is the first mistake: - the "Zwischensumme" (sum) incl. the tax is 44,-€ -> thats ok. - the "Versand" (shipping) incl. the tax is 5,95 -> thats ok. - the "Steuern" (tax) is wrong. If 49,95€ is the endprice with tax, than 41,97€ is the endprice without tax and the tax is 7,98€ (not 7,95€). Next screenshot. This time from the email the user will get: Here the user gets an email with the price without tax. Ok, I think this could be changed in the emailsettings, but also here the price calculation is wrong. Because the price without tax from 44,-€ is not 37,-€, it should be 36,974789915966386554621848739496€ or better 36,97€. Next screenshot from the invoice in the backend: Here are some more mistakes: - the 37,-€ without tax is wrong, as I allready said in the second picture. - The MwSt. is wrong. Why only 7,-€? In the cart is was 7,95€ (that was allready wrong) and now its only 7,-€ (more wrong) but we allready told the user in the mail that it was 7,95€? I am confused about this. - the rest is ok. Ok, last screenshot. Now from my own invoice-program I use for a long time and do the calculation right: Here you see the price per pcs. of 0,44€ with tax. So for 100 pcs. 44,-€. Then the shipping with 5,95€ incl. tax and the endprice incl. tax is 49,95. And now the big difference at the tax, with 7,98€ its right in this calculation. So what do do? I think I know where is the big problem. At the product page I type in the price incl. tax. and I type there the price of 0,44€ incl. tax at min. 100pcs. When I leave the "price incl. tax" field it automatic write at the field "without tax" the value 0.37000€. And thats the mistake I think. Regards, Benny.")* Hi All, In light of no solution being offered I have deleted the product and re-created it. This is still a concern to me and NOT SOLVED. sincerely Bob Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU4NDctZmF1bHR5LWludm9pY2UtYW5kLXRheC1jYWxjdWxhdGlvbi1zb2x2ZWQ/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 13 years 8 months ago [\#93877](#93877) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Faulty invoice and tax calculation! - Solved](/forum/4-how-to/5847-faulty-invoice-and-tax-calculation-solved?start=20#93877 "Hello, now, near the lunch of my shop and some ordering testing, I ran into a big problem. The tax calculation and shipping-tax calculation makes some mistakes. I did a testorder and took some screenshots (all from the same order) to explain it. and the tax for germany is 19%. Here you see a screenshot of the cart in the frontend. Here is the first mistake: - the "Zwischensumme" (sum) incl. the tax is 44,-€ -> thats ok. - the "Versand" (shipping) incl. the tax is 5,95 -> thats ok. - the "Steuern" (tax) is wrong. If 49,95€ is the endprice with tax, than 41,97€ is the endprice without tax and the tax is 7,98€ (not 7,95€). Next screenshot. This time from the email the user will get: Here the user gets an email with the price without tax. Ok, I think this could be changed in the emailsettings, but also here the price calculation is wrong. Because the price without tax from 44,-€ is not 37,-€, it should be 36,974789915966386554621848739496€ or better 36,97€. Next screenshot from the invoice in the backend: Here are some more mistakes: - the 37,-€ without tax is wrong, as I allready said in the second picture. - The MwSt. is wrong. Why only 7,-€? In the cart is was 7,95€ (that was allready wrong) and now its only 7,-€ (more wrong) but we allready told the user in the mail that it was 7,95€? I am confused about this. - the rest is ok. Ok, last screenshot. Now from my own invoice-program I use for a long time and do the calculation right: Here you see the price per pcs. of 0,44€ with tax. So for 100 pcs. 44,-€. Then the shipping with 5,95€ incl. tax and the endprice incl. tax is 49,95. And now the big difference at the tax, with 7,98€ its right in this calculation. So what do do? I think I know where is the big problem. At the product page I type in the price incl. tax. and I type there the price of 0,44€ incl. tax at min. 100pcs. When I leave the "price incl. tax" field it automatic write at the field "without tax" the value 0.37000€. And thats the mistake I think. Regards, Benny.")* Hi, The issue is simple for the product [ www.hikashop.com/media/kunena/attachment...50/dolphineNoVAT.pdf](http://www.hikashop.com/media/kunena/attachments/6950/dolphineNoVAT.pdf) You didn't select any "product tax category" in that product. And your tax rule is set to the "default tax category" tax category. So unless you set that product's tax category to the "default tax category", not tax will be calculated for it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU4NDctZmF1bHR5LWludm9pY2UtYW5kLXRheC1jYWxjdWxhdGlvbi1zb2x2ZWQ/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")** - [![freemanbob's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6950-freemanbob "View freemanbob's Profile") - [ Offline](/forum/user/6950-freemanbob) Less More - Posts: 32 - Thank you received: 2 - - 13 years 8 months ago [\#93986](#93986) by [freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile") Replied by *[freemanbob](/forum/user/6950-freemanbob "View freemanbob's Profile")* on topic *[Re: Faulty invoice and tax calculation! - Solved](/forum/4-how-to/5847-faulty-invoice-and-tax-calculation-solved?start=20#93986 "Hello, now, near the lunch of my shop and some ordering testing, I ran into a big problem. The tax calculation and shipping-tax calculation makes some mistakes. I did a testorder and took some screenshots (all from the same order) to explain it. and the tax for germany is 19%. Here you see a screenshot of the cart in the frontend. Here is the first mistake: - the "Zwischensumme" (sum) incl. the tax is 44,-€ -> thats ok. - the "Versand" (shipping) incl. the tax is 5,95 -> thats ok. - the "Steuern" (tax) is wrong. If 49,95€ is the endprice with tax, than 41,97€ is the endprice without tax and the tax is 7,98€ (not 7,95€). Next screenshot. This time from the email the user will get: Here the user gets an email with the price without tax. Ok, I think this could be changed in the emailsettings, but also here the price calculation is wrong. Because the price without tax from 44,-€ is not 37,-€, it should be 36,974789915966386554621848739496€ or better 36,97€. Next screenshot from the invoice in the backend: Here are some more mistakes: - the 37,-€ without tax is wrong, as I allready said in the second picture. - The MwSt. is wrong. Why only 7,-€? In the cart is was 7,95€ (that was allready wrong) and now its only 7,-€ (more wrong) but we allready told the user in the mail that it was 7,95€? I am confused about this. - the rest is ok. Ok, last screenshot. Now from my own invoice-program I use for a long time and do the calculation right: Here you see the price per pcs. of 0,44€ with tax. So for 100 pcs. 44,-€. Then the shipping with 5,95€ incl. tax and the endprice incl. tax is 49,95. And now the big difference at the tax, with 7,98€ its right in this calculation. So what do do? I think I know where is the big problem. At the product page I type in the price incl. tax. and I type there the price of 0,44€ incl. tax at min. 100pcs. When I leave the "price incl. tax" field it automatic write at the field "without tax" the value 0.37000€. And thats the mistake I think. Regards, Benny.")* I was almost certain I had checked the settings for tax. So the leason I have leart here is to check everything three times. I can only apologise for any time I may have waisted. sincerely Bob Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU4NDctZmF1bHR5LWludm9pY2UtYW5kLXRheC1jYWxjdWxhdGlvbi1zb2x2ZWQ/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) 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.106 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)