Thread: VAT Rounding

Results 1 to 6 of 6
  1. #1
    Join Date
    May 2006
    Posts
    15
    Plugin Contributions
    0

    Default VAT Rounding

    Hello, is there any reason why my zencart might be incorrectly rounding my tax calculation?


    Sub-Total:
    £86.65

    Delivery (Delivery):
    £10.00

    UK VAT:
    £16.92

    Total:
    £113.57

    VAT on this should be £16.91 ( 96.65x 0.1755= 16.91375)

    Many Thanks

    Guy

  2. #2
    Join Date
    Mar 2008
    Location
    Cape Town & London (depends on the season)
    Posts
    2,975
    Plugin Contributions
    0

    Default Re: VAT Rounding

    UK vat is not 17.55% but 17.50%

    (So the factor in your UK VAT table should be 17.5000).

    (Check this and put in the 3 trailing zeros, and try the calculation again.)

    Additionally, check your currency settings for things like Decimal Places, etc.

    The math will be correct if your settings are correct.

  3. #3
    Join Date
    May 2006
    Posts
    15
    Plugin Contributions
    0

    Default Re: VAT Rounding

    Hello, My tax rate is set to: 17.5000%

    the 17.55 was a typo!

    Thanks

    Guy

  4. #4
    Join Date
    Mar 2008
    Location
    Cape Town & London (depends on the season)
    Posts
    2,975
    Plugin Contributions
    0

    Default Re: VAT Rounding

    ... and it's still rounding UP instead of DOWN ?

  5. #5
    Join Date
    May 2006
    Posts
    15
    Plugin Contributions
    0

    Default Re: VAT Rounding

    Yes it is!

  6. #6
    Join Date
    May 2006
    Posts
    15
    Plugin Contributions
    0

    Default Re: VAT Rounding

    Yes it is!

    Additionally:


    £101.50
    Sub-Total:

    £10.00
    Delivery (Delivery):

    £19.52
    UK VAT:

    £131.02
    Total:

    This is also rounded up instead of down, the VAT should be £19.51 (from 19.5125)!!!

 

 

Similar Threads

  1. v154 UK VAT rounding discrepancy
    By igi2011 in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 0
    Last Post: 12 May 2015, 04:08 PM
  2. Rounding errors in VAT and using Sales Report
    By tsrplatelayer in forum General Questions
    Replies: 1
    Last Post: 21 Jun 2011, 10:11 AM
  3. 20% VAT rate rounding up
    By peanut77 in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 12
    Last Post: 15 Jan 2011, 07:34 PM
  4. product quanitites cause VAT Rounding Errors
    By guyp in forum Built-in Shipping and Payment Modules
    Replies: 0
    Last Post: 6 Jun 2008, 11:10 AM
  5. Price rounding problems with VAT
    By nicedreams in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 30 Jan 2008, 09:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg