UK VAT setup

[uksitebuilder]

The only time postage is VAT Free (for the UK at least) is when you sell postage stamps.

[SXGuy]

The only time postage is VAT Free (for the UK at least) is when you sell postage stamps.

haha thats cost stamps are zero rated, so nothing to charge vat on.

[uksitebuilder]

exactamundo

[mberlant]

The only time postage is VAT Free (for the UK at least) is when you sell postage stamps.

haha thats cost stamps are zero rated, so nothing to charge vat on.

Let me try to wrap my head around this. If you charge your customer for shipping, then you must apply VAT. But, if you sell the correct value of postage stamps to the customer and then stick them on his outgoing package as a courtesy, does that mean that the very same postage is not subject to VAT?

[uksitebuilder]

No, hehe

Basically Shipping should be charged with VAT Added to it period.

Only the post office and other similar outlets that sell stamps are allowed to charge zero rated VAT on them

If you sell stamps online they are zero rated but you must charge VAT on the postage to send them out

[sculptex]

Please announce the results of your investigation. I fear that, while this is a very slick way of getting prices to display the way you want, you will end up with calculation problems in the shopping cart and at checkout. OpenCart will have difficulties trying to reconcile the devalued GBP used for display with the full rate GBP needed to collect money for your store.

What you may end up needing to do is to create a dummy currency, devalued as you have for the purposes of display, whilst forcing everyone to check out in the real GBP currency.

I actually tried that first, I created a currency called INV (INclsive of Vat) and set that to 0.8333333333. But then it came up as another currency on the list in the cart and I don't think I could get the default admin currency to be different to the shop currency. However, I agree that would be the better way to go and would be 100% maintainable.

An alternative (if it has not already been mentioned) would be a bit of javascript to allow entry of EX or INC vat prices and have the other field auto update I guess.

So, I have not really progressed much with this as I have a few other aspects to investigate before I commit creating a whole store.

[uksitebuilder]

here goes a quick hack, assuming all your prices are vatable @ 20%

although, you can just manually enter whatever you wish in the ex vat box if the item is non vatable, the inc vat box will just look odd. The inc vat box servers no other purpose than for the calculation. It is the ex vat box value that gets stored in the DB

open: admin/view/template/catalog/product.tpl

find

Code: Select all

            <tr>
              <td><?php echo $entry_price; ?></td>
              <td><input type="text" name="price" value="<?php echo $price; ?>" /></td>
            </tr>


change to

Code: Select all

            <tr>
              <td><?php echo $entry_price; ?></td>
              <td>exc. VAT -&gt; <input type="text" class="exvat" name="price" value="<?php echo $price; ?>" /> inc. VAT -&gt; <input type="text" name="incvat" class="incvat" value="<?php echo number_format(($price*1.2),2,'.',''); ?>" /></td>
            </tr>


then at the bottom

before

Code: Select all

<?php echo $footer; ?>


add

Code: Select all

<script type="text/javascript"><!--
$('.incvat').bind('change keydown keyup',function (){
   $('input.exvat').val(($(this).val()/1.2).toFixed(4));
});
$('.exvat').bind('change keydown keyup',function (){
   $('input.incvat').val(($(this).val()*1.2).toFixed(2));
});
//--></script>


vQmod file if you want it:

uksb_inc_exc_vat_prices.xml

(1.04 KiB) Downloaded 341 times

[sculptex]

The only time postage is VAT Free (for the UK at least) is when you sell postage stamps.

Forgot to mention about this.

VAT on delivery should be charged at the same rate as the goods.
So if all goods are zero rated, the delivery VAT should be zero rated.
If the goods are 20% vat, the delivery should be 20% vat
If there is a mixture, vat must be charged. I just charge the higher rate in this instance but apparently you can apportion the vat rate to the amount on the goods.

I have been doing this for years, I was advised by a book supplier friend who has this situation a lot but I suggest you check with HMRC yourself!

WOW- that was a quick hack, great stuff!

[uksitebuilder]

just re-upped the vqmod as I had put a non-existent filename

View a demo over at

http://www.designs.org.uk/admin
Username: demo
Password: demo

[uksitebuilder]

edited one final time to work both ways now - see the demo above

[rmi]

Does this work on 1.4.9.x?

[zapalniczek]

Open cart 1.5.1 perfect script!!!
Works for Polish problem in this topic!
THX

[thegeekz]

Hi uksitebuilder,

I'm looking at using the VQMOD for this mod, however have a question, as my client is based in Singapore.... We'll need to change the VAT wording to GST.

Is that possible in your VQMOD ?

And our tax rate here is 7%

Kindly clarify...

P.S: When I use Excel to open the XML, there's only :

UKSB Inc and Exc VAT Price Boxes 1.0 1.2.3 http://www.opencart-extensions.co.uk/

IS that supposed to be right?

Regards

Faustine

EDIT: Nevermind found the correct way to do it!

[dvh]

What an infuriating and enlightening thread.

UKsitebuilder thank you for coming up with a solution. At least one developer understands the reality of what business users actually face. Some of you guys should really be working for MS with your "we're right, you're wrong" attitude towards users.

[i2Paq]

Works on 1.5.4.x!

I use also: Deafult Tax Class.

[Ljubo]

hhhmmm...
I would need to set different display of prices to retail and to wholesale customer groups.
for one, lets say retail, emphasis would be on prices including VAT (and perhaps showing only that price), while for the wholesale the emphasis would be on prices excluding VAT, but also showing price with VAT in smaller letters.
any ideas how I could do it?
multistore is not an option because I am already using them for other purposes, and that is 9 of them.

perhaps it could be done with discount tab.
i.e. retail price is 100$, wholesale price is 90$ which is set at discount tab for wholesale customer group.
now, I suppose there has to be some if else function in tpl file in order to display prices in different manners, depending if there is discount price active or not.
for retail customer for example, price including VAT should be standing either alone or much bigger than the price without VAT. On the other hand, for wholesale customer, should probably see the price without VAT in bigger font than the price including VAT.

can anybody help me with this?

[thegeekz]

Hi .


How can I make this VQMOD work for Discount tab and Special tab?

Thanks!

[Ljubo]

I have tried to upgrade it to have the same functionality for Discount tab...
let say it is working, but not at first.

it means that during first entering of the discount price, it would not let you do it correctly.
but, you can enter any number in the price box, along with dates in other boxes and save it.
after that, just edit it and it would work perfectly!

you can find it here:
http://forum.opencart.com/viewtopic.php?f=10&t=81408&start=20#p347307

if someone could correct it to work better, or even upgrade it further to work for Special tab as well, it would be great.

EDIT:
I have made it to work for Special tab as well as it is working for Discount tab.
Not properly but is working on editing at least.
Feel free to correct it to work perfectly.
here is the link:
http://forum.opencart.com/viewtopic.php?f=10&t=81408&p=347741#p347741

[thegeekz]

Thanks for sharing.

Will try it out 1st.

I had an issue earlier, trying to implement this on my own....

For the discount portion, its chaotic, as there are multiple lines - -for different quantities.. then the numbers for the inc. GST was somehow fixed, depending on what my next entry is for each line of excl GST.

IE: If i enter $80 in excl GST, it will appear $85.60 -- incl gst and same $85.60 for each line ( different quantities).

That's why it baffles me in that way!

[thegeekz]

Tried the "upgraded" version, but there were 2 problems.

I wonder if the experts or perhaps uksitebuilder could give a hint on how to solve the 2 issues.

In the Discount Tab, there are more than 1 line right... so each line, when I enter a different price for the Inc. VAT/GST, the Exc. TAX/GST became the same figure! Any way to solve this?

1st Line

Image A.jpg (30.49 KiB) Viewed 1381 times

2nd Line

Image B.jpg (28.57 KiB) Viewed 1381 times

And lastly, there is a problem if I add in additional line no matter to the Discount tab or the Special tab in this manner - The last field would disappear -- become 1 column short.

Image D.jpg (54.54 KiB) Viewed 1381 times

I confirm the original codings without the XML file here, is alright. no missing fields.

Help anyone?

Thank you.