Zen Cart Logo
Forums / Currencies & Sales Taxes, VAT, GST, etc. / Payment calculation total does not ad up?

Payment calculation total does not ad up?

Views: 2,320

Results 1 to 18 of 18
11 Apr 2011, 1:08 PM
#1
i_wish_i_could avatar

i_wish_i_could

Zen Follower

Join Date:
Dec 2010
Posts:
112
Plugin Contributions:
0

Payment calculation total does not ad up?

When I reach Payment information in Checkout process the total is not correctly calculated. See example below

Sub-Total $24.00 which is correct
Tax $2.40 which is correct
Total $24.00 incorrect

The total is always incorrect. It should be $26.40

Does anyone know the answer to this puzzle? As usual it is probably simple but I can’t seem to find the way to fix it. I never was good with mathematics at school. lol

Can anyone help?

I wish I could :dontgetit

o What version of Zen Cart? v1.3.9h
o Is it a new install or an upgrade? New installed on my server Just Host. I am editing it there.
o What the addons/contributions you have installed? Non
o What customizations have you made? Created custom Template. Moved text and boxes form home page. Setting up categories etc
o What type of server are you using? Unix-based servers on JustHost.com
o Are you installing locally? It’s already installed on my host. I am editing it there.
 What operating system? Windows 7
 What version of PHP is installed on the server? PHP 5.2.16

o
o What version of MYSQL is installed on the server? MySQL server version 5.0.91
o What you were doing when your problem occurred? Editing my home page
o What are the steps to reproduce the problem?
o Have you attempted to fix the problem? Reading FAQ and trying instructions found there.

11 Apr 2011, 2:39 PM
#2
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,621
Plugin Contributions:
0

Re: Payment calculation total does not ad up?

Where are you located? Are your prices 'tax included'?

12 Apr 2011, 11:31 PM
#3
i_wish_i_could avatar

i_wish_i_could

Zen Follower

Join Date:
Dec 2010
Posts:
112
Plugin Contributions:
0

Re: Payment calculation total does not ad up?

Kim:

Where are you located? Are your prices 'tax included'?

My store is set up as located in New South Wales, Australia which is correct.

My prices do not include tax. Each product is set up as Tax class - Taxable goods. Products price (net) & (gross) are correct on product page.

Have I missed a setting somewhere?

I wish I could

25 Apr 2011, 9:58 AM
#4
congerman avatar

congerman

Zen Follower

Join Date:
Oct 2008
Posts:
392
Plugin Contributions:
0

Re: Payment calculation total does not ad up?

I have the same problem, Has anyone got the solution?

Attachment #9160

29 Apr 2011, 8:32 PM
#5
jtessler avatar

jtessler

New Zenner

Join Date:
Apr 2011
Posts:
7
Plugin Contributions:
0

Re: Payment calculation total does not ad up?

Hi, I am having the same problem. I think that the tax class I created for my products adds up all the different tax rates I created (I set up different tax rates for each of the 50 US states I ship to). My store is:

https://www.makingmemorytreasure.com

How can I fix this? My customers don't like being charged 400% extra. Thanks!

29 Apr 2011, 8:41 PM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Payment calculation total does not ad up?

When you set up the Zone Definitions ... what did you set for the DETAILS of each of the Zones so that it would limit that Zone Definition and its Tax Rate to only the 1 State? :unsure:

29 Apr 2011, 8:59 PM
#7
jtessler avatar

jtessler

New Zenner

Join Date:
Apr 2011
Posts:
7
Plugin Contributions:
0

Re: Payment calculation total does not ad up?

I'm not really sure, since I'm not very knowledgeable about zen cart.

I first set up 50 zones under Admin->Location/Taxes->Zone Definitons. Then, I made 50 tax rates. When you create a new tax rate, its asks for the zone and all the zones I created were in the drop down list.

29 Apr 2011, 9:04 PM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Payment calculation total does not ad up?

In between the two steps ... after you make a Zone Definition, you will see a button for DETAILS ... if you click that button, what DETAILS do you see set for the
Country:
Zone:

or have you perhaps not yet not added them to you Zone Definitions? :unsure:

29 Apr 2011, 9:04 PM
#9
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Payment calculation total does not ad up?

The User Manual...
http://www.zen-cart.com/index.php?main_page=page&id=16

has excellent explanations of how to configure taxes and zones...

29 Apr 2011, 9:09 PM
#10
jtessler avatar

jtessler

New Zenner

Join Date:
Apr 2011
Posts:
7
Plugin Contributions:
0

Re: Payment calculation total does not ad up?

After I created the tax rates, I went back to the Zone Definitions, but they were still not configured (indicated by the red dot). So I went into California, and created a Sub Zone. I selected US for the country and California for the Zone. Went I went back, the red dot was replaced with a green dot.

29 Apr 2011, 9:19 PM
#11
jtessler avatar

jtessler

New Zenner

Join Date:
Apr 2011
Posts:
7
Plugin Contributions:
0

Re: Payment calculation total does not ad up?

I also notice that when I edit one of my products and change the net price to say $5.00, the gross price becomes $15.00

Again, not sure why zen cart is adding up all the tax rates and applying it to every item.

29 Apr 2011, 9:31 PM
#12
jtessler avatar

jtessler

New Zenner

Join Date:
Apr 2011
Posts:
7
Plugin Contributions:
0

Re: Payment calculation total does not ad up?

Looking through it again, I'm thinking that maybe because I didn't finish adding subzones to each zone, the unfinished zones are being added in with the finished ones. But I'll have to wait until later to try it.

29 Apr 2011, 9:34 PM
#13
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Payment calculation total does not ad up?

Get all your Zone Definitions setup with their proper DETAILS and it should correct all of these issues ...

29 Apr 2011, 11:36 PM
#14
jtessler avatar

jtessler

New Zenner

Join Date:
Apr 2011
Posts:
7
Plugin Contributions:
0

Re: Payment calculation total does not ad up?

Thank you very much for your help! It's working. I'm not done with all the zones, but I can see the gross price of my items falling each time I activate a Zone. What a relief.

30 Apr 2011, 12:30 AM
#15
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Payment calculation total does not ad up?

Thanks for the update that you are starting to see a light at the end of the tunnel ... :smile:

Just curious, but are you sure you need to charge tax for all states? :unsure:

Might check with your accountant on that one ...

1 May 2011, 11:01 AM
#16
congerman avatar

congerman

Zen Follower

Join Date:
Oct 2008
Posts:
392
Plugin Contributions:
0

Re: Payment calculation total does not ad up?

Great to see all that comunication, but my problem was that the full price showed first in the check out, then the delivery and the vat were shown seperatly. The first price should be the price without vat then the delivery and vat amounts then the bottom line should be the total of all. Please look back at my attachement and advise. Many thanks.

2 May 2011, 8:05 AM
#17
ryk avatar

ryk

Totally Zenned

Join Date:
Oct 2004
Location:
Southport, UK
Posts:
3,644
Plugin Contributions:
6

Re: Payment calculation total does not ad up?

Congerman:

Great to see all that comunication, but my problem was that the full price showed first in the check out, then the delivery and the vat were shown seperatly. The first price should be the price without vat then the delivery and vat amounts then the bottom line should be the total of all. Please look back at my attachement and advise. Many thanks.

Your "problem" is that if you are displaying prices with tax, the tax figure shown is the amount of tax that is included, not the amount of tax to be added (which is what one would normally expect to see in the UK). The simple workaround is to go to admin > localisation/taxes > tax rates, edit your vat and alter the description to "includes VAT @ 20%"

2 May 2011, 9:34 AM
#18
congerman avatar

congerman

Zen Follower

Join Date:
Oct 2008
Posts:
392
Plugin Contributions:
0

Re: Payment calculation total does not ad up?

Many thanks