Zen Cart Logo
Forums / Bug Reports / Tax Miscalculation with Discounts

Tax Miscalculation with Discounts

Locked

Views: 2,156

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
27 Feb 2008, 4:22 AM
#1
danebrood avatar

danebrood

New Zenner

Join Date:
Sep 2007
Posts:
7
Plugin Contributions:
0

Tax Miscalculation with Discounts

It looks like when there are discounts, sales tax is being calculated a little wonky.

For example a transaction that would normally play out like:

$30 Subtotal

  • $7.50 ( 25% discount coupon)
  • $5.10 Shipping

(30 - 7.50 + 5.10) = 27.60

Tax = (27.60 X 0.084) = $2.32
Total = (2.32 + 27.60) = $29.92

Is getting calculated in a strange order by zen:

$30 + $5.10 = $35.10 (subtotal + shipping)
0.084 X (1 - .25) = 0.063 (tax rate less coupon discount of 25%)
$35.10 X 1.063 = $37.31 (total X (1 + tax))
$37.31 - 7.50 = $29.81 ( total with tax minus coupon)

close, but wrong. This happens with all types of discounts.

All my discount modules are set to not include tax, and Standard tax recalculation. Store set to include shipping in the tax calculation. Tax works great when there isn't a discount occurring.

Any ideas?

29 Feb 2008, 7:48 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Tax Miscalculation with Discounts

What version of Zen Cart are you using?
What addons do you have installed?
Which discount modules do you have enabled?
What is your URL?
What states are you collecting tax for?
What tax rates are configured in your store?

29 Feb 2008, 8:53 PM
#3
danebrood avatar

danebrood

New Zenner

Join Date:
Sep 2007
Posts:
7
Plugin Contributions:
0

Re: Tax Miscalculation with Discounts

Hey there, thanks for the response.

To keep this simple, the issue can be duplicated with a default installation of v.1.3.8a using the sample products included with the installation and sample coupon.

Checkout with the coupon 'zzzz', and set your address to Florida to include tax. Here's the order total calculation I just got, shipping to Florida:

$299 Sub-Total (1 x Matrox G200 MMS)

$2.50 Per Item (Best Way)

-$45.00 Discount Coupon: zzzz

$17.85 FL TAX 7.0%

$275.34 Total

The pre-tax total is $256.50, which should result in 7% tax of $17.96.

If you need a default 1.3.8a installation, I've got one here:

http://www.indexsmithy.com/demos/zen-default/

It's nearly a pristine installation, but think I've just disabled some payment and shipping options.

18 Apr 2008, 6:52 AM
#4
tzeyangng avatar

tzeyangng

New Zenner

Join Date:
Dec 2007
Posts:
35
Plugin Contributions:
0

Re: Tax Miscalculation with Discounts

i had the similar situation. anyone found the solution to this yet?

21 Apr 2008, 3:13 PM
#5
tzeyangng avatar

tzeyangng

New Zenner

Join Date:
Dec 2007
Posts:
35
Plugin Contributions:
0

Re: Tax Miscalculation with Discounts

anyone please help? This issue has been bugging me for few days. and my store is up and running now. please help. Any help is appreciate.