New Zenner
- Join Date:
- Sep 2008
- Posts:
- 4
- Plugin Contributions:
- 0
Major problem with Zone configurations, VAT and tax exempt
Hi everyone,
This is my first post since I started with Zen-Cart 3 months ago. So far reading the faq and forums have been a big help with just about anyting but I've run into a brick wall now.
I've read virtually every post on these subjects at least twice.
The problem is products get taxed twice on checkout, or not at all. There seems to be some sort of conflict and I can't for the life of me figure out what it is.
My store is in the Netherlands, and I sell makeup.
ZenCart 1.3.8 is installed with:
- BKN Versie 0.7, adds Chamber of Commerce # and VAT # per customer.
- VAT module Versie 1.2.7 for tax exempt customers.
I've set up VAT according to this tutorial:https://www.zen-cart.com/tutorials/index.php?article=77 and after that things went haywire.
I want to charge 19% VAT to customers in the Netherlands and either 0% or 19% to customers in the rest of Europe, depending on whether or not they have a European VAT #.
This is the configuration right now:
Display Prices with Tax true
Display Prices with Tax in Admin true
Basis of Product Tax Shipping
Basis of Shipping Tax Shipping
Sales Tax Display Status 1
I want to use Table rate shipping within the Netherlands set to:
**Table Rate **
Table Method
weight
Handling Fee
0
Tax Class
BTW 19%
Tax Basis
Shipping
Shipping Zone
Nederland
Sort Order
0
Enable Table Method
True
Shipping Table
2:2.65,10:6.20
and** I use zone rates **for the rest of Europe:
Enable Zones Method
True
Calculation Method
Weight
Tax Class
BTW 19%
Tax Basis
Shipping
Sort Order
0
Skip Countries, use a comma separated list of the two character ISO country codes
NL
Zone 1 Countries
BE,LU
Zone 1 Shipping Table
2:11.75,5:16.95,10:21.45,20:28.75,30:34.21
Zone 1 Handling Fee
0
Zone 2 Countries
DK,DE,FR,IT,AT,ES,GB,SE
Zone 2 Shipping Table
2:12.75,5:18.95,10.24.75,20:33.25,30:39.57
Zone 2 Handling Fee
0
Zone 3 Countries
BG,EE,FI,HU,IE,LV,LT,PL,PT,RO,SI,SK,CZ
Zone 3 Shipping Table
2:17.95,5:23.25,10:29.25,20:37.95,30:45.16
Zone 3 Handling Fee
0
**ZONE definitions **are configured using bof zones sql
EEC VAT Zone EEC Countries Zone for VAT (contains all european countries inclusing The Nethlands.
"all zones" applied to every county.
Dutch VAT zone for The Netherlands.
**TAX CLASSES **are:
1 VAT high (19%)
2 VAT low (19%)
4 taxable goods (inserted according to the abovementioned tutorial) can't get rid because I get an error saying products are using it.
**TAX RATES **are:
1 tax rate voor de EEC VAT Zone set to 19%
1 tax rate for the Netherlands set to 19%
I've been testing this set up with a mock product of € 1,00 in a dutch account without VAT # and this is what I get upon checkout:
If VAT on the product is set to 'low':€1,00 Sub-Total:
€2,65 Table Rate (1 x 0.01kg) (Best Way):
€0,00 Sales Tax:
€3,65 Total:
VAT set to 'high' gives:
€1,00 Sub-Total:
€2,65 Table Rate (1 x 0.01kg) (Best Way):
€0,57 VAT 19% + VAT 19% + :
€0,00 Sales Tax:
€4,22 Total
VAT set to "-none-" of "taxable goods" gives in both cases:
€1,00 Sub-Total:
€2,65 Table Rate (1 x 0.01kg) (Best Way):
€0,00 Sales Tax:
€3,65 Total:
**When I set tax class to "high" in the shipping mode **I get:
€1,00 Sub-Total:
€4,16Table Rate (1 x 0.01kg) (Best Way):
€0,00 Sales Tax:
€1,51 BTW 19% + BTW 19% + :
€5,16 Total:
Im really at my wits end here after 5 days of trying this, and on the Dutch forum no one seems to know the answer. Ive never been so frustrated in my life so I hope someone will be able to help!!
It can't be that hard, but I just don't see it.
thank you so much!
Best regards,
Monique
