Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2009
    Posts
    61
    Plugin Contributions
    0

    Default Tax calculating wrongly

    Hi,

    I have 15% VAT set up globally, yet when I get to checkout, zen is only applying 13%. The Tax settings in admin are correct. Is there anything else (apart from built-in creative accounting!) which could be causing this?

    Thanks,

    Sean

  2. #2
    Join Date
    May 2005
    Location
    Bath, Somerset
    Posts
    1,053
    Plugin Contributions
    3

    Default Re: Tax calculating wrongly

    Are you charging VAT on shipping? Has this module been set to taxable under Modules >> Shipping >> Your shipping method?

    Are you using Coupons on this order?

    Can you post the order total calculations so we can see the workings?

    Do you have a link to the store?

    Absolute

  3. #3
    Join Date
    Jan 2009
    Posts
    61
    Plugin Contributions
    0

    Default Re: Tax calculating wrongly

    Currently, testing with walk-in

    No Coupons

    I set up a dummy product priced £100
    I added it to the cart and checked out.
    The cart shows:

    Sub-Total: £100

    Collect in Person (Walk In):£0.00

    Group Discount:-£5.00 (this is application of a group discount of 5%)

    VAT 15%:£12.39

    Total:£95.00


    The VAT figure doesn't work, whichever way you add it up...

    Link to test product, so you can try it yourself...

    http://off-m a n d r e l.com/zen/index.php?main_page=product_info&cPath=65_74_75&products_id=425

    If anyone can shed light, I'd be most grateful.

    Regards,

    Sean

  4. #4
    Join Date
    May 2005
    Location
    Bath, Somerset
    Posts
    1,053
    Plugin Contributions
    3

    Default Re: Tax calculating wrongly

    The £100 includes the VAT. Check that your prices are including VAT when displaying on teh store-side.

    Then, 5% off gives £95.00 inc VAT. 95 divide by 1.15 = 82.61. 15% VAT on 82.61 = 12.39, as shown.

    Absolute
    Back, after a 4 year absence! Did you miss me?
    Absolute Web Solutions Ltd
    Interested in our work? Take a look at one of our sites - The Tech Store

  5. #5
    Join Date
    Jan 2009
    Posts
    61
    Plugin Contributions
    0

    Default Re: Tax calculating wrongly

    You are absolutely right, and I showed the wrong example.

    Here's the right one:

    No Coupons

    I set up a dummy product priced £100
    I added it to the cart and checked out.
    The cart shows:

    Sub-Total: £100 (inc. VAT)

    Shipping:£10.00 (inc. VAT)

    Group Discount:-£5.00 (this is application of a group discount of 5%)

    VAT 15%:£13.63

    Total:£105.00


    ot_group_pricing is set Include Shipping & Include Tax both False.

    The VAT figure should be 105 * 15% = 13.70
    What's actually happening is that the VAT is being calced thus:

    104.50 * 15% = 13.63

    The 104.50 is coming from:

    100 less 5% = 95.00
    10 less 5% = 9.50

    The 5% is the group discount.

    How do I stop the Group Discount being applied to shipping for VAT purposes? I guess it's in the tax module, but that code is a bit scary to a noob. Any help very much appreciated.

    Thanks,

    Sean

  6. #6
    Join Date
    Jan 2009
    Posts
    61
    Plugin Contributions
    0

    Default Tax & Discount maths problem

    Hi,
    Apologies for the cross-post, but I don't know if this is a tax issue or a group discount issue. It does seem to be a fairly fundamental problem though, so I'm sure it has been dealt with before. Any help will be much appreciated.

    I have a problem with group pricing and shipping (I think).
    No Coupons
    ZC1.3.8a
    I set up a dummy product priced £100
    I added it to the cart and checked out.
    The cart shows:

    Sub-Total: £100 (inc. VAT)

    Shipping:£10.00 (inc. VAT)

    Group Discount:-£5.00 (this is application of a group discount of 5%)

    VAT 15%:£13.63

    Total:£105.00


    ot_group_pricing is set Include Shipping & Include Tax both False.

    The VAT figure should be 105 * 15% = 13.70
    What's actually happening is that the VAT is being calced thus:

    104.50 * 15% = 13.63

    The 104.50 is coming from:

    100 less 5% = 95.00
    10 less 5% = 9.50

    The 5% is the group discount.

    How do I stop the Group Discount being applied to shipping for VAT purposes? I guess it's in the tax module, but that code is a bit scary to a noob. Any help very much appreciated.

    Thanks,

    Sean

  7. #7
    Join Date
    Jan 2009
    Posts
    61
    Plugin Contributions
    0

    Default Re: Tax & Discount maths problem

    Anybody? Or is this better put on the Bugs list?

    Sean

 

 

Similar Threads

  1. Tax not calculating
    By colorowdy in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 13
    Last Post: 23 Aug 2011, 03:56 AM
  2. Tax calculating on shipping
    By littletoycompany in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 16 Aug 2008, 03:44 AM
  3. Tax calculating and not calculating
    By pottsy in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 1
    Last Post: 5 Mar 2008, 10:11 AM
  4. Tax Calculating Incorrectly
    By KlingstedtBrothers in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 4
    Last Post: 17 Jan 2008, 04:22 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