New Zenner
- Join Date:
- Oct 2008
- Posts:
- 2
- Plugin Contributions:
- 0
Rounding tax rates, result wrong tax.
Hi.
Zencart seems to count everything using only 2 decimals.
This would not be any big issue if it did it cleverly but unfortunately it does it in a way that causes rounding errors to become huge.
F.ex.
I have a product that costs 0.42 SEK
Tax rate in Sweden is 25% (VAT)
The price including tax is thus 0.525 sek
Zencart rounds this up to 0.53 sek - fairly ok. BUT
the customer buys 35 pcs.
correct price ist 0.52535 = 18,375 SEK
but i end up with 0.5335 = 18,55 Sek
Since I do my invoice in Excel the math does not add up.
The correct way to actually calculate the VAT would be to add up
all the prices and THEN multiply with 1.25..... not do this strange
vat calcuation with rounding errors and then add wrong numbers together.
kind regards
Jonas D.
