Page 1 of 2 12 LastLast
Results 1 to 10 of 13
  1. #1
    Join Date
    Feb 2005
    Posts
    283
    Plugin Contributions
    0

    Default 20% VAT rate rounding up

    Hello

    I have a problem where the 20% vat is causing prices to round up causing some prices to be a penny out.

    UK store, all prices shown with vat.

    Vat was 17.5% before so all I have done is amend the store vat rate to 20% - however when I have amended a few prices I am having the following issue

    The gross price is for example £7.95
    zencart works the net price to be £6.6250
    price displayed on the store is £7.96

    Totally stuck - but need to resolved this asap as prices advertised are not correct.

    Sorry meant to say this only happens on some prices but not others - for example £3.95 shows ok but £4.95 shows as £4.96, £12.95 shows ok, but £34.95 shows as £34.96 etc....

    Any help appreciated - and beer/coffee bought.
    Last edited by peanut77; 9 Jan 2011 at 06:54 PM. Reason: further info provided

  2. #2
    Join Date
    Feb 2005
    Posts
    283
    Plugin Contributions
    0

    Default Re: 20% VAT rate rounding up

    Any ideas? even if I could change the amount of digits after the decimal point - as whatever I put in zen overwrites me and adds more zeoros - i.e I add 20 it adds 20.0000

    Help!

  3. #3
    Join Date
    May 2010
    Location
    London
    Posts
    237
    Plugin Contributions
    0

    Default Re: 20% VAT rate rounding up

    1.3.8a?

  4. #4
    Join Date
    Feb 2005
    Posts
    283
    Plugin Contributions
    0

    Default Re: 20% VAT rate rounding up

    Apologies for not mentioning versions no and yup! 1.38a

  5. #5
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: 20% VAT rate rounding up

    Search the forums for rounding tax*. There were some rounding errors in version 1.3.8 that have been fixed in the latest version (1.3.9h).

  6. #6
    Join Date
    Feb 2005
    Posts
    283
    Plugin Contributions
    0

    Default Re: 20% VAT rate rounding up

    Cheers - had literally tried every search term under the sun - vat - vate rate error, vat rate round up, uk vat, europe vat rate etc, etc - all about the right search termology!!

    Will see what I can dig out from that.

  7. #7
    Join Date
    Feb 2005
    Posts
    283
    Plugin Contributions
    0

    Default Re: 20% VAT rate rounding up

    The solution seems to be to upgrade to the latest version as the looks like the wee tax 1p glitch is now been resolved - sods law - if the vat rate hadn't changed everything would be fine!

    Thanks for the pointers and hints on the correct search term much apprecaited.

  8. #8
    Join Date
    Nov 2010
    Posts
    3
    Plugin Contributions
    0

    Default Re: 20% VAT rate rounding up

    I also have the same problem, but i'm on the latest version.
    I did a post before but no-one replied.


  9. #9
    Join Date
    Feb 2005
    Posts
    283
    Plugin Contributions
    0

    Default Re: 20% VAT rate rounding up

    Hello

    I have a new site installed (1.39h) and i have checked the new vat rate of 20% on the figures I was having problems with and it is working ok by letting me show prices as 7.95 - which shows as 7.96 on 1.38

    If I find anything else out I'll give you a shout - I know what its like to be stuck!

  10. #10
    Join Date
    Aug 2006
    Posts
    42
    Plugin Contributions
    0

    Default Re: 20% VAT rate rounding up

    simple fix change vat rate to 19.999 % it still works out 20% but dosent round up

 

 
Page 1 of 2 12 LastLast

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. 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
  4. VAT Rounding
    By guyp in forum Built-in Shipping and Payment Modules
    Replies: 5
    Last Post: 23 Apr 2008, 12:40 PM
  5. Price rounding problems with VAT
    By nicedreams in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 30 Jan 2008, 09:58 AM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR