Author Topic: Tax is all wrong.  (Read 7888 times)

upmm019

  • Jr. Member
  • **
  • Posts: 59
Tax is all wrong.
« on: January 03, 2011, 22:13:11 pm »
I have Joomla 1.5.22 with VM 1.1.6

I have my tax rate set to 0.06000 (6%).

I have an item of $499.95 USD but with the tax on it is calculating to $539.85 which is a difference of $39.90.  The tax should be $30(499.95*6%=$29.997 - rounded to $30.00).

Any ideas why it is not calculating correctly?

How do I go about getting a correct calculation?

robert101083

  • Jr. Member
  • **
  • Posts: 141
    • Rsvdv-Online.nl
Re: Tax is all wrong.
« Reply #1 on: January 04, 2011, 14:28:12 pm »
To me it looks like you filled out the price including tax in the wrong field at the product details. Can you please attach a print screen of the product details from the back-end?
/*************************************************************************************/
  * http://www.rsvdv.nl  -> Personal Site
  * http://ideal.rsvdv.nl  -> iDeal Payment Methods for Virtuemart, Marketplace, iDeal Donation Modules.
/*************************************************************************************/

upmm019

  • Jr. Member
  • **
  • Posts: 59
Re: Tax is all wrong.
« Reply #2 on: January 04, 2011, 20:00:02 pm »
Here is the image.


upmm019

  • Jr. Member
  • **
  • Posts: 59
Re: Tax is all wrong.
« Reply #3 on: January 04, 2011, 20:02:16 pm »
I need to have a tax of 6% for Georgia (GA) customers.

I have this already entered into the Tax Rate table.

The issue I see is when I login as a GA customer, all of my product prices in the cart are inflated by a tax but the calculation is much more than 6%... See my first post for example.

upmm019

  • Jr. Member
  • **
  • Posts: 59
Re: Tax is all wrong.
« Reply #4 on: January 04, 2011, 20:03:15 pm »
Ideally, I'd like to keep all product prices the same regardless of who is logged in but for GA customers when they get to the shopping cart I'd like the tax line to show the 6% tax amount on the sub-total.

however, that is not happening.

upmm019

  • Jr. Member
  • **
  • Posts: 59
Re: Tax is all wrong.
« Reply #5 on: January 04, 2011, 20:06:12 pm »
I guess if I do the math.. again, looking at all of the elements it appears the tax is based upon the Product Gross/Net...

eg.  665.00 * 6% = 39.90

then the 39.90 is being added to the discounted price of $499.95

bringing the total to $539.85.

the tax should be based upon discounted price and not the Gross/Net.

How does that get resolved?

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 2386
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Tax is all wrong.
« Reply #6 on: January 04, 2011, 22:50:58 pm »
Hello

Can You show us where the tax is beeing ADDED ?
The TOTAL price for this product should be 499.95, this price is including tax. ;-)

Your screen dump shows that the tax that is beeing used for this item is tax rate 3 = 0% tax ???

Where are You adding this 6 % tax You are talking about ?

Please show us a screen dump of the incorrect calculation.

regards

Jörgen @ Kreativ Fotografi
Joomla 3.9.8
Virtuemart 3.4.x
Olympiantheme Hera (customized)

upmm019

  • Jr. Member
  • **
  • Posts: 59
Re: Tax is all wrong.
« Reply #7 on: January 04, 2011, 22:54:09 pm »
Technically, the calculation is correct.  If you see my last post... I think I figured out the math issue.

however, when I look at my products, the tax is being added to the overall discounted price but the tax that has been added is based upon the NET/Gross price and really should be based upon the discounted price.

upmm019

  • Jr. Member
  • **
  • Posts: 59
Re: Tax is all wrong.
« Reply #8 on: January 04, 2011, 23:42:28 pm »
Look at these screen prints

This is of products for a Non Georgia User


upmm019

  • Jr. Member
  • **
  • Posts: 59
Re: Tax is all wrong.
« Reply #9 on: January 04, 2011, 23:43:53 pm »
this print is of a Georgia User



See the price differences between the two.

This is because the 6% tax is being applied.

I don't want the tax applied to the prices here but rather in the cart.

Look at the Locomotive product as that is what I'll show in the next prints.

upmm019

  • Jr. Member
  • **
  • Posts: 59
Re: Tax is all wrong.
« Reply #10 on: January 04, 2011, 23:45:28 pm »
Here is the cart of a Non Georiga User with the locomotive product.

This cart is correct, the price is the discounted price and the tax is zero.


upmm019

  • Jr. Member
  • **
  • Posts: 59
Re: Tax is all wrong.
« Reply #11 on: January 04, 2011, 23:48:54 pm »
This cart is of a Georgia User with the locomotive.

You'll see the sub-total is really the discounted price + Tax (tax of 6% calculated on the product Gross/Net price).

And you will see the tax line item is zero.



What I expected to see was the cart having the following:

SubTotal = $499.95
Shipping and Handling Fee = $40.00
Tax Total = $30.00
Fee = $2.00
Total = $571.95

upmm019

  • Jr. Member
  • **
  • Posts: 59
Re: Tax is all wrong.
« Reply #12 on: January 04, 2011, 23:49:47 pm »
I am not sure what I am doing wrong but if someone can help steer my sinking ship to shore I'd appreciate it  ;)

robert101083

  • Jr. Member
  • **
  • Posts: 141
    • Rsvdv-Online.nl
Re: Tax is all wrong.
« Reply #13 on: January 05, 2011, 01:26:51 am »
How about setting the VAT id to the one with 6% and remove all the discount prices an save. If that non discounted price shows correct at the front, start adding the discount info. Doing this step by step will give you a better idea where it goes wrong, if it still goes wrong after setting the VAT id...
/*************************************************************************************/
  * http://www.rsvdv.nl  -> Personal Site
  * http://ideal.rsvdv.nl  -> iDeal Payment Methods for Virtuemart, Marketplace, iDeal Donation Modules.
/*************************************************************************************/

upmm019

  • Jr. Member
  • **
  • Posts: 59
Re: Tax is all wrong.
« Reply #14 on: January 05, 2011, 02:33:53 am »
so your saying that I should set the VAT to 6% at the product level?

I am not sure how I do that for the discounted prices