Various UK tax problems.

[kelvyn]

We only ship to the UK.
We have two tax rates. VAT and NON VAT.

I've set a country, United Kingdom, GB, GBR.

I've set a Zone, United Kingdom Zones: GB Code: GB

I've set a Zone Definition: Country: United Kingdom, Zone: All Zones

I've set tax classes:
id1: taxable goods
id2: NON VAT

I've set tax rates: Taxable Goods and NON VAT

I've set up order totals in the following way:

Shipping ot_shipping 200
Sub-Total ot_subtotal 100
Tax ot_tax 300
Total ot_total 999

I've uploaded products excluding tax, and in my store I've set "display prices with tax: true".

But when I use either Paypal Express or Google Checkout, even though it calculates the tax correctly, when the order is actually placed, in admin it shows the order as 0% tax.

Even more weird is that with Paypal, when you've logged into Paypal and it's automatically created a store account, it then starts displaying the catalogue prices without tax until you log out again! What the ?!?

I've removed the modules, I've put them back again, I've deleted and re-created all the tax rates and zones (checking the tax ID's of the products in the db are correct with the tax id table).

That's it. I'm done. 13 hours on it today, all out of ideas. Help greatly appreciated.

[kelvyn]

Four days on...

delete the zones! That's the solution to most of it!
No zones. Now tax shows correctly for shoppers and it calculates correctly for Google Checkout, but still tax is not showing as calculate properly on the orders (the total is correct, but the line does not show tax), but also, when using Paypal Express, tax is not being added. Note that Paypal is NOT set with any taxes, as per instructions.

Here's a sample order:

ProductsModel						Tax	Price (ex)	Price (inc)	Total (ex)	Total (inc)
1 x	Authentic Style Western Gambler Hat	36337	0.00%	£3.58		£3.58		£3.58		£3.58
1 x	Western Gambler Costume 		30375M	0.00%	£24.99		£24.99		£24.99		£24.99

Sub-Total: £28.57
Store Pickup (Walk In): £0.00
VAT 20%: £5.71
Total: £28.57

Yes, 20% VAT of 28.57 is £5.71, but it's not added!

Here's what the products look like in admin:

Gambler Hat
Tax class: Taxable goods
Net: 3.5750
Gross: 4.29

Western costume:
Tax class: Taxable goods
Net: 24.9917
Gross: 29.99


Yes, 20% VAT of 28.57 is £5.71, but it's not added!

The total of two vat-able items should be £34.28 inc VAT.
£34.28 - £28.57 = £5.71.

But throughout the whole order page, it's the wrong way round.

It should be £28.57 PLUS £5.71, and each taxable item should be listed properly.

In other words instead of

1 x	Authentic Style Western Gambler Hat	36337	0.00%	£3.58	£3.58	£3.58	£3.58

it should be

1 x	Authentic Style Western Gambler Hat	36337	20%	£3.58	£4.29	£3.58	£4.29

Some products are taxable, some aren't. They are listed in the DB as ex-tax.
In "my store" the products are set to show as inc tax.
Tax is calculating correctly in admin as you can see.

Bases of both product and shipping taxes are "store".

This all seems to work OK with Google Checkout since I removed the zone.

And I've also tried it in Apsona, and again it shows tax as 0%.

To confirm my location/tax settings I have:

One country:
United Kingdom GB GBR

No Zones.

One zone definition:
UK VAT - Applies to all zones

Two tax classes:
id 1: non vat
id 2: Taxable goods

Two tax rates:

Priority 1: Tax Class: Taxable Goods Zone: UK VAT Tax rate: 20.00% Description: VAT 20%
Priority 1: Tax Class: NON VAT Zone: UK VAT Tax rate: 0.00% Description: NON VAT


Here's part of the transaction log- this looks wrong:

Request Parameters: {DoExpressCheckoutPayment} 

    [AMT] => 28.57
    [SHIPTOCOUNTRYCODE] => GB

Response: 

[TRANSACTIONTYPE] => expresscheckout
    [PAYMENTTYPE] => instant
    [AMT] => 28.57
    [FEEAMT] => 1.17
    [TAXAMT] => 0.00

Can anyone shed any light on this please?

[kelvyn]

Tax shows correctly for shoppers and it calculates correctly for Google Checkout, but still tax is not showing as calculating properly on the orders, but also, when using Paypal Express, tax is not being added. Note that Paypal is NOT set with any taxes, as per instructions.

Here's a sample order:

ProductsModel						Tax	Price (ex)	Price (inc)	Total (ex)	Total (inc)
1 x	Authentic Style Western Gambler Hat	36337	0.00%	£3.58		£3.58		£3.58		£3.58
1 x	Western Gambler Costume 		30375M	0.00%	£24.99		£24.99		£24.99		£24.99

Sub-Total: £28.57
Store Pickup (Walk In): £0.00
VAT 20%: £5.71
Total: £28.57

Yes, 20% VAT of 28.57 is £5.71, but it's not added!

Here's what the products look like in admin:

Gambler Hat
Tax class: Taxable goods
Net: 3.5750
Gross: 4.29

Western costume:
Tax class: Taxable goods
Net: 24.9917
Gross: 29.99


Yes, 20% VAT of 28.57 is £5.71, but it's not added!

The total of two vat-able items should be £34.28 inc VAT.
£34.28 - £28.57 = £5.71.

But throughout the whole order page, it's the wrong way round.

It should be £28.57 PLUS £5.71, and each taxable item should be listed properly.

In other words instead of

1 x	Authentic Style Western Gambler Hat	36337	0.00%	£3.58	£3.58	£3.58	£3.58

it should be

1 x	Authentic Style Western Gambler Hat	36337	20%	£3.58	£4.29	£3.58	£4.29

Some products are taxable, some aren't. They are listed in the DB as ex-tax.
In "my store" the products are set to show as inc tax.
Tax is calculating correctly in admin as you can see.

Bases of both product and shipping taxes are "store".

This all seems to work OK with Google Checkout since I removed the zone.

And I've also tried it in Apsona, and again it shows tax as 0%.

To confirm my location/tax settings I have:

One country:
United Kingdom GB GBR

No Zones.

One zone definition:
UK VAT - Applies to all zones

Two tax classes:
id 1: non vat
id 2: Taxable goods

Two tax rates:

Priority 1: Tax Class: Taxable Goods Zone: UK VAT Tax rate: 20.00% Description: VAT 20%
Priority 1: Tax Class: NON VAT Zone: UK VAT Tax rate: 0.00% Description: NON VAT


Here's part of the transaction log- this looks wrong:

Request Parameters: {DoExpressCheckoutPayment} 

    [AMT] => 28.57
    [SHIPTOCOUNTRYCODE] => GB

Response: 

[TRANSACTIONTYPE] => expresscheckout
    [PAYMENTTYPE] => instant
    [AMT] => 28.57
    [FEEAMT] => 1.17
    [TAXAMT] => 0.00

Can anyone shed any light on this please?

[kelvyn]

Solved part of the problem by reverting to stock orders.php and removing the editing orders function (this mod)

Taxable rubber chicken at £6.89 inc tax and
Taxfree children's costume £10.69 - no taxes

Here's the result of four test orders:

5398 Google checkout, taxed chicken only: single item and total correct!
5401 Google checkout, mixed products: per line items shown wrong but total correct

5399 Paypal: taxed chicken only: single item and total correct!
5400 Mixed products: per line items AND total correct!

So now we only have one outstanding problem - when MIXED products bought in Google Checkout are purchased together, then the taxable item line doesn't show tax BUT the total is correct.

To get this far, I had to temporarily remove the function to edit orders.

PS - why was my post (about TAXES) moved from the TAXES forum into the PAYPAL forum, when it's not specifically a Paypal issue, thus creating a duplicate in the thread?

[kelvyn]

Anyone? Any ideas at all?

[DrByte]

So, you're saying that the Edit Orders mod and the Google Checkout mod are breaking things, but that regular core code is working fine.
Sounds like a classic problem of conflicting or bad or out-of-date addons.

[kelvyn]

Right, here we go again. Stock install, Paypal Express:

(US people: VAT is tax).

PayPal. Almost working since removing zones definitions:

1. All tax due for products is calculated and shown correctly regardless of mixed tax/non-tax product orders and regardless of delivery option chosen.
2. All the delivery charges are shown ex vat and are correct, but the vat due on the delivery charge is not added to the vat due for products, which means we are losing 83p on 2nd class deliveries and 1.67 on next day delivery orders through PayPal.

But the postage MUST include and display VAT element in invoice as appropriate, as we post mainly taxable items. Only where an entire order consists of non-vat items should postage exclude vat

Google Checkout

1. When only non vat items are ordered, regardless of whether they are delivered or collected from store, all the charges relating to tax etc. are correct on the invoice and the customer is being charged the right amount.
2. When an order consists of non vat and vat-able products the customer is charged the correct amount and the right tax is shown on the break down including any tax due on the cost of delivery.
The big problem is that where a product is a vat-able product, regardless of whether it is on it's own or with a non vat product the tax, price, total (inc) does not show the vat element.

We're using the "flat rate" module for next day, with a price of £8.23, taxable, and table rate with price-based table of 99:4.16,100:0, taxable, tax based on store

[kelvyn]

This just gets more and more crazy!

Paypal:

Admin

20 xNerd Glasses @ £0.99
Add tax at 20.00% £1.19
Products total ex vat £19.83
Products Total inc vat £23.77 < this bit is confusing and wrong, but WHY?!
Sub-Total: £23.80
Table Rate (Royal Mail 2nd class recorded): £4.99
VAT 20%: £3.97
Total: £28.79 < and yet this overall total is correct.


What the???!? We're getting some pretty confused customers out there. Surely I can't be the only person with this?