Tom Let me put it another way. Take the following sales: 50 items @ 1.37 VAT @20% = 68.50 VAT = 13.70 If the same items are sold separately, the VAT would be different. 1 item @ 1.37 VAT @ 20% = 0.274 for the VAT This would be rounded to 27p and 50 x 0.27 = 13.50 Rounding has caused a difference of 20p When paying tax, you are required to pay what you have collected. If you calculate as you suggest you may hand over more tax than you have collected. What I think he is looking for is a simple way of calculating the VAT due on his total with each individual item rounded down and that cannot be done. Each item has to be calculated, rounded down and then a total obtained for the rounded figures. HMRC take the view that VAT is payable on the total value of cash sales plus the VAT calculated on Invoiced sales. In my examples the VAT due would be 27.20 assuming that the 100 items sold would consist of 50 invoiced and 50 cash sales. Tink. -- View this message in context: http://nabble.documentfoundation.org/Visible-currency-rounding-tp4065342p4065571.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted