Odd Report Issue

So got stocktake today and quite puzzled.
Just noticed on Item Sales Report the total sales for several products was an odd number. Since all prices are rounded to at least 5p to have totals with .16 and .14 was odd.
Looking at first product bottled Becks.
Price £3.50
8 Sold
1 Refunded


So first thing I though since was only small number sold was to quickly double check database, perhaps for whatever reason a price had been overidden.

No… all orders are the correct price in database.

So, is it the report…

[Item Sales:8, 2, 2, 2]
{REPORT ORDER DETAILS:O.ItemGroup,O.ExactTotal.Percent,O.Quantity.Sum,O.ExactTotal.Sum}
Total Sales||{REPORT ORDER DETAILS:O.ExactTotal.Sum}

I cant see how it is, the default item sales report seems to have the exact same total/issue…


So… 7*3.50-24.16 = 0.34… so what is 0.34 difference from…
Isnt VAT (20%) that would be 0.58333333

Could it be calculations/discounts?
Would be odd for that to be the case since there shouldnt be a direct link between orders and calculations…

OK, so it does seem to be the discounts from our loyalty/staff discount offering.
Cant beleive I haven’t noticed this before.
Surely we should be or at least be able to report gross/total sales and not have discount calculations deducted from these?
If we only have total tocket calculation fair enough but since we can update manually and set more advanced rules this cannot be right…

Look at this ticket;


7.95 (50% food discount) and 0.80 10% drinks discount.
However the £3.50 becs now reports as £2.22


OK, so guessing I should be using O.TotalPrice.Sum rather than ExactTotal.
Cant see what use Exact Total really is, but either way…