Upcoming UK VAT Rate Change

[UH-Matt]

You will almost certainly need to use some scripting/sql to correct issued invoices. If you are not good at doing this yourself then you should contact whmcs support or some others on these forums for help with it. Should have all been done already by now!

[easyhosting]

Im not too familiar with scripts and wish to avoid doingit that way if i can to change the vat rate by doing more simply

Woudl there be any problems with just doing it by changing the rules?

I assume that all i do is delete the old tax rule and create a new one with 20% ?? Am i right ?

But would this change the VAT charged on invoices already sent last month ?

Thanks in advance for advice

use this

UPDATE tbltax SET taxrate=20 WHERE taxrate=17.5;

in a databse query to change the tax rule automatically to 20%

use

UPDATE tblinvoices SET taxrate=20,tax=subtotal*0.2,total=subtotal+tax-credit WHERE status='Unpaid' AND taxrate=17.5 AND duedate>='2011-01-04';

to change any allready issued invoices that have the old rate applied.

[stugster]

What a mess.

Can I suggest that for situations like this, an accountant is brought in to just quickly confirm that what's happening with the software is the correct thing?

We just did the "quick and easy" query posted in post #1 and yes, all our invoices previously raised are now wrong.

This is pathetic for software whose main intention is a billing system.

[easyhosting]

What a mess.

Can I suggest that for situations like this, an accountant is brought in to just quickly confirm that what's happening with the software is the correct thing?

We just did the "quick and easy" fix posted in post #1 and yes, all our invoices previously raised are now wrong.

This is pathetic for software whose main intention is a billing system.

we have used thes queries that Matt provided and all work fine and all invoices are correct

[UH-Matt]

What a mess.

Can I suggest that for situations like this, an accountant is brought in to just quickly confirm that what's happening with the software is the correct thing?

We just did the "quick and easy" fix posted in post #1 and yes, all our invoices previously raised are now wrong.

This is pathetic for software whose main intention is a billing system.

I doubt many billing systems have built in support for adjusting existing invoices to a new rate of tax.

It is a fairly easy fix, but you do need to check the queries before using them for your own situation.

We had to modify them as we put our pricing including VAT and also wanted to absorb the rise, so the second query which modifies the TOTAL was no good to us, we instead needed the SUBTOTAL modifying, TAX modifiying and the TOTAL leaving the same. I posted what we used, but thats just an example of checking specifically what you want to do and making sure you adjust the query as appropriate.

[stugster]

I doubt many billing systems have built in support for adjusting existing invoices to a new rate of tax.

No, I completely agree, they probably don't. It was my mistake for not reading Matt's post in its entirety, as he says "at the latest" for implementing the code.