Tax Rounding In Reports

Spektrix is able to automatically calculate Tax, Net and Gross rates for all items you sell.  We can then output these calculations on reports and invoices so that you can send them straight onto your customers or agents.  

In the UK this is Value Added Tax (VAT) but the same logic applies in other areas. 

How Spektrix Rounds Tax

Spektrix calculates Tax at item level - like so:

Tax is then rounded at item level and stored in the system like this

In your reports we can group the items together in different ways and sum the amount of Tax for those groups.  We sum the figures after they have been rounded:

or

Customers may question the fact that the Total VAT is not always 20% of the Total Gross (because a penny of VAT has been lost or gained on each item in the calculation). This isn't a problem as the guidance from HMRC states that rounding on a line by line basis is acceptable. The most important issue is that rounding is always consistent.

This is why we round at item level - the VAT will always be rounded in the same way no matter how the items in your reports are grouped. In all of the examples above - the total VAT will always add up to £8.68.

If we were to leave things un-rounded in the system and only round the totals in your reports then you would risk getting different amounts depending on the way you grouped the items: