Jump to content

Problem With Invoices And Sales Tax


Recommended Posts

I'm having some trouble with the calculations of VAT/Sales Tax and invoice totals.


For example, I have 2 line items...


Line Item 1 -- Quantity 3 -- Unit Price 32.50 -- Cost 97.50

Line Item 2 -- Quantity 3 -- Unit Price 32.50 -- Cost 97.50


Subtotal: 195.00

VAT @ 23.0000%: 44.86

Total: 239.86


The subtotal is 195.00, which is correct. The sales tax on this invoice is 44.86, which is incorrect. 23% of 195.00 is 44.85, so the invoice total should be 239.85, not 239.86.


The problem seems to be that the VAT/tax is being calculated on a per line basis, rounded, and then summed up. However, it should be calculated on the subtotal and then rounded. Or calculated on a per line basis, summed up, and then rounded.


23% of 97.50 is 22.425

Rounded, that becomes 22.43. 22.43 x 2 = 44.86. The rounding occurs before the addition. It should occur after the addition.


Installed Version 3.6.1

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...