Search the Community
Showing results for tags 'Rounding'.
Found 2 results
-
Hello, With the last annual financial statement we found some rounding errors in our outgoing invoices (15-20%). Example (negative invoice): Correct calculation: -0,1103 * 1,19 = -0,1313 = -0,13 Example (positive invoice): Correct calculation: 16,18 * 1,19 = 19,2542 = 19,25 How are these values calculated?
-
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
