Changing Prices To Include VAT

[Moxey]

Following a previous thread that I set up, we are now on the brink of being VAT registered.

What I need to look at is changing all of our prices so that they include VAT. What is the best way to do this? We have literally thousands of products, and I hope we will not have to adjust every single price for every single item!

Our pricing will remain the same, and so (ideally) I need to know if there is a "qucik fix" to adjust all prices so that the Net Price is shown (Ex VAT) and then the final price is shown (Inc. VAT.)

Would be most grateful for any assistance.

Many thanks.

David
www.diecastdevon.co.uk

The Site for Obsolete, Discontinued and New Release Diecast Models
Promotional Model Trucks with Your Logo

[leehack]

=round(sum(A1/1.175),0) - A1 contains the gross price in pence.

is your excel formula to do it. The Access version will be similar.

Export your catalog, run the change, import the catalog.

Back up before you try anything.

[Moxey]

Thanks Lee.

Will give that a blast!

David
www.diecastdevon.co.uk

The Site for Obsolete, Discontinued and New Release Diecast Models
Promotional Model Trucks with Your Logo

[NormanRouxel]

Not at a V7 system so this may not be definitive.

The price Actinic uses internally is the ex-vat price. If you've set up your catalog to not use VAT, then all you may need to do is turn VAT on and you'll now be selling the product with VAT added.

[Moxey]

The price Actinic uses internally is the ex-vat price. If you've set up your catalog to not use VAT, then all you may need to do is turn VAT on and you'll now be selling the product with VAT added.

Thanks for that, Norman. Just tried that method, but it's added 17.5% to all prices. We really need a "quick fix" so that current prices are Inclusive of VAT.

Therefore, previous sale price: £53.95 before VAT.

New sale price: £45.91 (Ex. Vat.) £53.95 (Inc. Vat)

If there is no other option, then it will have to be Lee's way today.

Thanks.

David
www.diecastdevon.co.uk

The Site for Obsolete, Discontinued and New Release Diecast Models
Promotional Model Trucks with Your Logo