Having Trouble With VAT

[d4funky1]

Hi,

 

I've applied my tax zone, class and rates (all UK @ 17.5%) and in my store configuration I have set it Display Prices with Tax to 'true'

 

What I am seeing now is my product info page showing one price and the shopping cart showing another???

 

I have a product which costs £8.49 when you browse the products page the price is shown as £9.98 when you get to the shopping cart confirmation screen the price is shown as £8.49???

 

Now, I know that £8.49 plus 17.5% is £9.98 but why show the more expensive price then revert back to the real price at checkout_confirmation? confusing?

 

Also, is there a way in which we can obtain the VAT figures for previous orders before the tax rates were applied?

 

Hope you can help

 

D4

[GemRock]

it all depends on how much and in what way the shop in question has been modified. but for q1 it 'd be fairly easy to identify the problem. for q2, it'd be more complicated:

1. if it only sells to the UK & EU (excl. channel islands etc) and there is no zero rate vat products, ie, all are standard rate @17.5%, then an update query on order products table would be all that is needed;

2. if it sells worldwide and there are hundreds of 'backdated' products, then custom coding is needed and it may not worth it. as far as i know, vatman does not ask for vat to be backdated - you only charge vat on and from the date you register for it.

 

Ken

[d4funky1]

Hi,

 

Thanks for that just spoke to the VAT man and yes you only become liable for VAT from the day you register for it.

 

My site sells products at 17.5% and 0% so how would i run an update query for this?

[d4funky1]

sorry,

 

just to add that my products are sold within the UK only

[GemRock]

...Thanks for that just spoke to the VAT man and yes you only become liable for VAT from the day you register for it...

 

so why bother with your old order records? be aware that if your order data shows there is vat charged before you register, then you may have lots of explanation to make, for the taxman may think you charge vat illegally and keep the vat in your pocket, which means a hevey fine that could ruin your business/life.

 

Ken

[d4funky1]

Hi,

 

Yes well the reason being that the tax threshold was reached in February so I will need to have figures from that date (plus a 5% or £50 fine for the late registration)

 

If you could offer any further suggestions it would be highly appreciated.

 

Thanks again

D4

[satish]

Your code was modified not considering the fact that the price display might need to take care of price with Tax.

 

Satish

[d4funky1]

Thanks for that,

 

Do you have any ideas how I would run an update query between two dates to show older orders with the VAT now?

 

Thanks

D4

[satish]

Do elaborate its not very clear.

 

Satish

[d4funky1]

all previous orders up until this date have just shown the gross figure.

 

no the vat is showing on the apprpriate products i need to back track to february and show the vat on all those older invoices too?

 

Is there a way in which i can achieve this?

 

thanks

[satish]

Place How Your older invoice looks now and How You want it to look.

 

Satish

[GemRock]

...Do you have any ideas how I would run an update query between two dates to show older orders with the VAT now...

first, congratulations for reaching the 65,000 threshold - business going well!

 

1. its doable;

 

2. do not think you can just run an update query to get it done - too risky;

 

3. you need someone who knows the vat inside out (given that you also have other vat related issue on site and actully look at your data to do it.

 

Good Luck!

Ken

[d4funky1]

Hi,

 

Here's how my order looks

 

 

The red line needs to show £11.91

 

The Blue Line needs to show £11.91

 

And the shipping needs to so £2.54 with a vat line of £0.44

 

I only want to achieve this on all invoices from a certain date 01/02/08

 

Thanks

D4

[d4funky1]

Ok,

 

I've managed to sort out the original problem with the prices showing differently but now I would like some advice on the display within the checkout_confirmation.php page:

 

At present it shows:

 

Sub-Total: £8.49

Royal Mail Recorded Delivery (Total postage for this order): £2.99

Total: £11.48

Tax: £1.71

 

The taxable amount is correct but I would like to show the product tax and the shipping tax as two seperate figures on this page and also the invoice?

 

Would you know how I could achieve this?

 

So it would show:

 

Sub-Total: £8.49

Tax: £1.26

Royal Mail Recorded Delivery (Total postage for this order): £2.99

Tax: £0.44

Total: £11.48

 

Order would it show correctly in my sales reports?

 

Thanks again

D4

[GemRock]

the answers to your questions are closely related to your raw data.

i doubt it you can back track vat by modifying the invoice and the checkout confirmation bits without getting your raw data right first.

given that you have two different rates of vat, you would need to run some php code to get it done, which is depending on the raw data.

it is certainly possible to manipulate the relevant code eg invoice to have the order totals displayed the way you like it.

btw, if you got ( as it seemed to be) the vat for postage of £2.99 as £0.44 then your setup got a problem - it'd be £0.45 - well, just one penny but in the eyes of the taxman, its a problem.

 

Ken

[satish]

A proper order table configuration will put the needed details in that sequence for future order.

 

For previous order You need to look into orders_total table.

 

For any orderid it has some number of rows ands those the individual details needed to construct an invoice.

 

Satish

[d4funky1]

Hi,

 

I have checked the orders_total table and I am providing two examples of what I found:

 

1, An Order Before VAT Was Applied:

 

INSERT INTO `orders_total` VALUES (12722, 4243, 'Sub-Total:', '£21.49', 21.4900, 'ot_subtotal', 160);
INSERT INTO `orders_total` VALUES (12723, 4243, 'Royal Mail Recorded Delivery (Total postage for this order):', '£2.99', 2.9900, 'ot_shipping', 200);
INSERT INTO `orders_total` VALUES (12724, 4243, 'Total:', '<b>£24.48</b>', 24.4800, 'ot_total', 760);

 

2, An Order After VAT Was Applied:

 

INSERT INTO `orders_total` VALUES (24816, 8271, 'Sub-Total:', '£6.99', 6.9900, 'ot_subtotal', 160);
INSERT INTO `orders_total` VALUES (24817, 8271, 'Royal Mail Recorded Delivery (Total postage for this order):', '£2.99', 2.9946, 'ot_shipping', 200);
INSERT INTO `orders_total` VALUES (24818, 8271, 'Total:', '<b>£9.98</b>', 9.9846, 'ot_total', 760);
INSERT INTO `orders_total` VALUES (24819, 8271, 'Of Which Is VAT Inclusive:', '£1.49', 1.4910, 'ot_tax', 780);

 

I need to know how I am going to seperate the VAT from the older orders and show them as tax?

 

Thanks Again

D4

[satish]

You need to split each order total into 5 parts.

1)sub total.

2)shipping

3)shipping tax

4)product tax

5)total.

 

Now You need to insert the rows for each orders that are missing and then modify values of all five.

 

Using some customized code You will be able to create an interface and modify one order at a time.

 

Satish

[d4funky1]

WOW,

 

Sounds like exactly what a need an interface to achieve this.

 

Wouldn't know where to start though so satish as you have been so helpful up to now could you explain how i would achieve this? or if your feeling really nice achieve it for me? :blush:

 

Thanks

D4

[burt]

You should expect to pay a good amount for that.

[d4funky1]

Can't seeing costing that much?

 

all quotes gratefully received.

 

Thanks

[GemRock]

...an interface to achieve this...

an interface? i suppose every osc owner got an 'interface' already in admin - customers - orders - invoice, plus hardware 'interface' which should be your keyboard?

 

some php skills, a good knowledge of how osc handles orders, invoices plus one hr of time minus time spent on talking are all what you needed.

 

or make a contribution for this? no, dont think its practical.

 

Ken

[d4funky1]

trouble is i don't have the php skills and wouldn't really know where to start.

 

don't get me wrong i can follow instructions but wouldn't know how to start coding something.

 

thanks

D4