Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Two VAT-rates on invoice


Recommended Posts

Dear forum members,


I tried to find out a solution for my problem on the Dutch forum, but onfortunately I got no replies, I hope someone here can help me.


My financial adviser wants the gross income of our shop to be split between the 2 used VAT-rates. My shop uses 2 rates: 6% and 19%. If I print the invoices for the administration, they are split out in a correct way, like this:


Sub-Totaal: €1.883,00

Verzend- en administratiekosten (NL en B): €0,00

BTW 6%: €111,24

BTW 19%: €5,51

Totaal: €1.999,75


Problem is, that the amounts over which these VAT rates are being calculated are not shown on the invoice. Therefore, my accountant prints the orders, but has to manually calculate the 6% and 19% gross income.


I think there has to be a way to mention these amounts. For instance, if yoe see that the VAT of 6% will be € 111,24, you can calculate the desired amount: € 111,24 / 1,06. And, for the 19% Vat: € 5,51 / 1,19.


Can someone help me how to integrate these small calculations on my invoice.php?


Thank you very much!

Link to comment
Share on other sites

Usually, the tax is calculated from the Sub-Total but I cannot see what number your taxes are based on. But, I'm not in Europe so do not understand how things are done there..


Your taxes do not seem to be calculated off the sub-total. What are they based on?

Community Bootstrap Edition, Edge


Avoid the most asked question. See How to Secure My Site and How do I...?

Link to comment
Share on other sites

I assume you are using a separate tax for each product. and then creating those lines by grouping products by tax rate.


You could do one thing.. if you check the orders_total table, you might be able to view the order line class. Then change the invoice.php file to check for the ot_class and do the calculation as you have mentioned.




Our truest life is when we are in dreams awake.

-- Henry David Thoreau --

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...