I dont know if this belongs in the VAT forum or the Sales Report mod support forum - so I put it in 'General'
I have noticed a rounding issue associated with VAT calculations.
Please see attached screen grab. In one location it shows Total as £26.25 and in onother location as £26.26.
I have a VAT zone set at 20%.
The product is entered with its Gross price as £25.00 inc VAT.
The product page calculates the ex-VAT price as £20.8333.
The product has an attribute set up with a 5% 'On-Line Ticket handing Fee' i.e. £1.25 inc VAT.
Giving an Invoice total of £26.25 inc VAT
Calculating VAT backwards gives £4.375 - which rounds to £4.38
Calculating Net backwards using the VAT % gives of £21.875 - which rounds to a Total Net of £21.88,
Subtracting the calculated VAT would give Total Net of £21.87
Thus producing inconsistencies in invoices
This then produces inconsistencies downstream when generating reports either using mods for 'Sales report' or 'Download' for use in a spreadsheet.
Anyone any suggestions?


Reply With Quote
