VirtueMart Forum

VirtueMart 1.1.x [ Old version - no longer supported ] => Products, Prices, Tax and Categories VM 1.1 => Topic started by: upmm019 on January 03, 2011, 22:13:11 pm

Title: Tax is all wrong.
Post by: upmm019 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?
Title: Re: Tax is all wrong.
Post by: robert101083 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?
Title: Re: Tax is all wrong.
Post by: upmm019 on January 04, 2011, 20:00:02 pm
Here is the image.

(http://www.knackjack.com/Product.png)
Title: Re: Tax is all wrong.
Post by: upmm019 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.
Title: Re: Tax is all wrong.
Post by: upmm019 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.
Title: Re: Tax is all wrong.
Post by: upmm019 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?
Title: Re: Tax is all wrong.
Post by: Jörgen 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
Title: Re: Tax is all wrong.
Post by: upmm019 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.
Title: Re: Tax is all wrong.
Post by: upmm019 on January 04, 2011, 23:42:28 pm
Look at these screen prints

This is of products for a Non Georgia User

(http://www.knackjack.com/NonGAUser.png)
Title: Re: Tax is all wrong.
Post by: upmm019 on January 04, 2011, 23:43:53 pm
this print is of a Georgia User

(http://www.knackjack.com/GAUser.png)

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.
Title: Re: Tax is all wrong.
Post by: upmm019 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.

(http://www.knackjack.com/NonGAUserCart.png)
Title: Re: Tax is all wrong.
Post by: upmm019 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.

(http://www.knackjack.com/GAUserCart.png)

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
Title: Re: Tax is all wrong.
Post by: upmm019 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  ;)
Title: Re: Tax is all wrong.
Post by: robert101083 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...
Title: Re: Tax is all wrong.
Post by: upmm019 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
Title: Re: Tax is all wrong.
Post by: robert101083 on January 05, 2011, 03:00:10 am
Yes, just set the VAT id to 6%, re-enter the Gross price to the original price(including tax/vat). The Net price will be recalculated automatically. Then set the Discounted Price, which is including tax/vat.
Title: Re: Tax is all wrong.
Post by: upmm019 on January 05, 2011, 03:07:04 am
What should I do with the tax rate table for Georgia?  Will that add 6% more
Title: Re: Tax is all wrong.
Post by: upmm019 on January 05, 2011, 03:15:47 am
I did that... and it almost did what I wanted it too.

see here:

(http://www.knackjack.com/GAModifedProductCart.png)

The problem I have is this...

1. the calculated tax is wrong... 499.95 * 6% = 29.997 ($30.00)

2. the Gross price I was treated as the MSRP and if I add the VAT then that gets inflated.  So now my discounted price is correct but my (Gross) or what I am calling MSRP is inflated.
Title: Re: Tax is all wrong.
Post by: upmm019 on January 05, 2011, 03:18:19 am
Even this calculation is off.

It says 541.95 but if you add it all up it should be : $570.25

What I am expecting.. is

SubTotal = $499.95
Shipping and Handling Fee = $40.00
Tax Total = $30.00
Fee = $2.00
Total = $571.95
Title: Re: Tax is all wrong.
Post by: upmm019 on January 05, 2011, 03:20:51 am
I've also noticed that this route also screws up the pricing for the Non-GA customers.

Instead of the product being 499.95 it now shows $460.05
Title: Re: Tax is all wrong.
Post by: upmm019 on January 05, 2011, 20:35:28 pm
Any further suggestions??
Title: Re: Tax is all wrong.
Post by: robert101083 on January 06, 2011, 00:53:27 am
What I was experiencing at my own site yesterday was that if you change any TAX settings, make sure you logout at the front end and clear you browser cache. Otherwise the site might show the wrong numbers.

FYI: I belief the topic would be easier to read if you use print screens with only the useful data, you might have to modify it a bit if there is some info in one corner and more info in the other. And if you have new info, place it in you last post if nobody posted after you last post. Thnx! :D
Title: Re: Tax is all wrong.
Post by: upmm019 on January 06, 2011, 00:59:53 am
I've been playing with this all day with the same results and have cleared my cache.
Title: Re: Tax is all wrong.
Post by: upmm019 on January 06, 2011, 01:00:28 am
What is your example of " print screens with only the useful data "
Title: Re: Tax is all wrong.
Post by: robert101083 on January 06, 2011, 02:58:09 am
Like this:
(http://img9.imageshack.us/img9/8628/nongauser.png)

And this:
(http://img521.imageshack.us/img521/7469/nongausercart.png)
Title: Re: Tax is all wrong.
Post by: upmm019 on January 06, 2011, 03:32:10 am
i did provide such.
Title: Re: Tax is all wrong.
Post by: Bruce Morgan on January 06, 2011, 17:49:24 pm
Not sure if this will be helpful, but I can say that few things in VM are as screwed up as the tax calculation.  If you have a single tax rate in your state applicable to all prducts then it usually seems to work.  I have multpie tax rates in WA state to deal with as well as destination based local tax rates.  I hired someone to solve the first problem and just plain ignored the second.  The downside it that I never did learn the basis for how the tax is calculated "right out of the box" but the hacke we designed did the job.

Since you tax rates calculation should be simple I suggest doing the following:

1. Go into VM admin and uncheck the box "show prices including tax where applicable".  In the USA we are acoostmend to seeing prices before tax.
2. Makes sure you have the correct tax mode set.  I think for most states selecting taxes based on shipping address works best.
3. Go into the tax rates table and see what you have.  If you have a single tax rate for your state use that number and delete everything else.
4.  Go into your VM products list and make sure the correct tax rate (VAT ID) is selected.  This migh be easiet to do from PhPMyAmin.
5.  Clear the cache and give it a test.

Not sure if this will make a difference but give it a try.

Bruce
www.pepper-passion.com

Title: Re: Tax is all wrong.
Post by: upmm019 on January 07, 2011, 22:23:09 pm
The problem with adding the VAT at the product level is that it adds the tax to my base price.

I do not want tax added at the product level.

I am really surprised that VM cannot do this simple task.

Only apply tax at the shopping cart and have the tax based upon the sub-total.
Title: Re: Tax is all wrong.
Post by: aravot on January 07, 2011, 22:32:06 pm
The problem with adding the VAT at the product level is that it adds the tax to my base price.

I do not want tax added at the product level.

I am really surprised that VM cannot do this simple task.

Only apply tax at the shopping cart and have the tax based upon the sub-total.

Of course VM can do what you want, the problem users don't read the manual or search
http://virtuemart.net/documentation/User_Manual/User_Management.html#N2120A
Title: Re: Tax is all wrong.
Post by: upmm019 on January 07, 2011, 22:34:34 pm
If I have to read the manual.. then VM is not that intuitive.

I will take your advice and look at it and search and see where I net.
Title: Re: Tax is all wrong.
Post by: upmm019 on January 07, 2011, 22:40:14 pm
Ok, I searched... didnt find the answers to my problem.
Title: Re: Tax is all wrong.
Post by: aravot on January 07, 2011, 23:04:16 pm
If I have to read the manual.. then VM is not that intuitive.
You have the choice to choose whatever shopping cart best suits your needs.

Ok, I searched... didnt find the answers to my problem.
I gave you the link in my previous post.
Title: Re: Tax is all wrong.
Post by: upmm019 on January 07, 2011, 23:09:19 pm
I looked at it.. it implies shopper groups...

Not sure how shopper groups will solve my problem.

I need the cart to not add tax to my products base price.

When the tax is added for a given shipping local it should add 6% to the sub-total in the cart and then calculate as such:

SubTotal + S&H + Tax + Fee = Total.

Title: Re: Tax is all wrong.
Post by: CreativeDesigns on September 08, 2011, 09:49:19 am
Anyone found a solution to this issue? I'm having the EXACT same problem :(
Title: SOLUTION: Tax is all wrong.
Post by: claytondaley on September 27, 2011, 21:12:25 pm
As far as I can tell, this is resolved by selecting the option:

Configuration - Global - Subtract payment discount before tax/shipping