The standard rate of VAT in the UK increases from 17.5% to 20% for all invoices raised on or after the 4th of January 2011. Unlike previous VAT changes this does not happen on the first of the month. Note: For companies outside the UK, this VAT change program does not need to be run.
Please read the following information carefully and familiarise yourself with the options available to you.
Please refer to FAQ below for critical timing.
Note: Installing and running the VAT Change Program will not make any changes to the database until you select one of the update options. (Before running the program for real, you can download, install and run the program to review the options- choose CLOSE to not run any updates).
IMPORTANT NOTE: AS THIS DOWNLOAD MAKES SIGNIFICANT CHANGES TO YOUR DATABASE IT IS CRUCIAL THAT YOU BACK-UP EACH OF YOUR LIVE DATABASES BEFORE YOU START.
TO DOWNLOAD VERSION 8. . . Click the green Download Update link below. Follow the instructions given below.
INSTRUCTIONS
Clicking the Download Update button takes you to our “box” download site.
You then need to click the “Download (136.5 KB)” button on that page.
Choose RUN rather than SAVE FILE.
If you get a security warning: the publisher could not be verified, choose RUN rather than DON’T RUN.
Once downloaded, the file will run and you will see this screen…
Leave the destination folder and choose Install to ensure that you are running the most up-to-date program. If running more than once, always download again from this link for the same reason. The program looks like this…
Select Company: Choose the company you want to update. Any options already run for this VAT change are highlighted in green. The options chosen for previous VAT changes will be shown for information.
Options 1 and 2: Run these options.
Options 3 and 4: If your system is geared to TRADE, skip options 3 and 4. They will have no effect on your database. If your system is geared to RETAIL, you may wish to run either option 3 or option 4 or you can skip both options. Running either of these options will create Sales VAT invoices resulting in you having to pay VAT sooner than if you were to skip these options, so think carefully if you want to run either of these.
Option 5: Run option 5 to change the VAT Rate of any live sales orders. If your system is geared to RETAIL then the selling price to the customer is kept the same (the goods value is reduced appropriately because the VAT element is increasing). If your system is geared to TRADE, the goods price is unchanged but the VAT amount will increase and so the price the customer will ultimately pay for the orders will increase.
Option 6: If you do not have the Quotes module then this does not need to be run. If you have the Quotes then this needs to be run. This option changes the VAT Rate of any quotes you have on your system.
Option 7: If your system is geared to TRADE, you should skip this option. If your system is geared to RETAIL, you may wish to run this. Running this option will increase the selling price to your customer of any live sales orders, so think carefully if you would want to run this.
Option 8: If you still have many Purchase Invoices to post for the old VAT rate then you should close the program at this point and download this program again later when you have very few or none still to post. When you download later, you can pick up where you left off – the program shows you which options you have run already.
Option 9: If you still have many Nominal Ledger journals to post for the old VAT rate then you should close the program at this point and download this program again later when you have very few or none still to post. When you download later, you can pick up where you left off – the program shows you which options you have run already.
Close: Click this to close the program. Now download again and run for any other company databases.
________________________________________________________________
FAQs regarding the VAT change have been provided at the end of this blog. Any queries, call the helpdesk on 0131-448-0483 or email support@oltd.co.uk. As our lines may be busy, please also keep checking back to this web page where we will post any other significant information regarding the VAT rate change.
Over the festive period we are operating the following service:-
Friday 24th December – Closed.
Saturday 25th December – Closed.
Monday 27th December – Closed.
Tuesday 28th December – Closed.
Wednesday 29th December – Emergency Service (call 0131-448-0483 or email support@oltd.co.uk).
Thursday 30th December – Emergency Service (call 0131-448-0483 or email support@oltd.co.uk).
Friday 31st December – Emergency Service (call 0131-448-0483 or email support@oltd.co.uk).
Saturday 1st January – Closed.
Sunday 2nd January – Closed.
Monday 3rd January – Emergency Service for VAT queries only (normal support number is not available- email support@oltd.co.uk for a call-back).
Tuesday 4th January – Open.
________________________________________________________________
FAQs
Q. When should the VAT update be run (before or after month end and which month end)?
A. The sequence is as follows:-
1. Run the “Purchase / Nominal” period end for the end of November (if not yet run).
2. Finish posting all sales orders for December.
3. Complete normal end of day programs, such as SOP – End of Day – Invoice Summary / Update to invoice any December invoices.
4. Run the “Sales / Product” period end for the end of December.
5. Finish entering all sales orders for the period 1st January 2011 up to and including the 3rd January 2011.
6. Complete normal end of day programs, such as SOP – End of Day – Invoice Summary / Update to invoice any January 1st to 3rd invoices.
7. Download the VAT Change module and run the options appropriate to your business. It is likely that you will only run options down to option 7 at this point.
8. Once the bulk of supplier / nominal postings for the old VAT rate have been posted (which could be later in January), download the VAT Change module again and run options 8 and 9.
Q. Do I need to download and run the program on our server?
A. No. use your normal client PC.
Q. What if my network settings do not allow files to be downloaded?
A. You need to contact your network administrator to change your settings to allow you to download files.
Q. How do I run the VAT Change module?
A. Start by clicking on the green Download Update button above then follow the instructions below the button in this blog.
Q. If I don’t have time to run all the options I need to at one time, can I run some on one day and some the next day?
A. Yes. Each time you want to run the VAT Change module, download it again. You can pick up where you left off – the program shows you which options you have run already.
Q. If I want to do a dry run of the VAT Change module can I test it on my test area?
A. Yes. Provided your test area is up to date to the same program version as your live system, you can run the VAT Change module on your test area. When you run the VAT Change module, make sure you choose the Test area when selecting the company at the top of the program. This will have no effect on your live system.
Q. Can I download the VAT Change module and run it just to see what it looks like?
A. Yes. You can download and run it. Simply click the CLOSE button at the bottom of the screen once you have had a look. When you come to run the program proper, download again from the website in the same way.
Q. Can I download the program and save it somewhere so that I don’t have to download it later when I come to run it?
A. Yes you can. However, whenever you run the program, it will tidy up files that it uses and will give an error if run a second time without downloading. Downloading each time you need it will also ensure you have the very latest release.
Q. Does this VAT Change module work for Southern Ireland?
A. This VAT Change module does not need to be run if you are in Southern Ireland as the rate of VAT is not changing. If you do run it, there will be no changes made to your system.
Q. Does the VAT Change module change the customer’s selling prices on sales orders that are outstanding at the end of December?
A. The update will change the VAT Rate on sales orders outstanding to the new rate. If you have the OptimiseTrade system then the goods value will not be changed – it is just the VAT amount that will be changed when the invoice is raised. If you have the Optimise Retail system then the goods value is reduced slightly such that the total price to the customer is unchanged. There is an option to increase prices (Option 7) but you have the choice of whether you run that option or not.
Q. If I have more than one database, do I need to run the VAT Change module on each one?
A. Yes. Best thing is to download it from the website and run it on the first database. Once finished, download again and run it on the second database, etc. You don’t need to run it on your test area but you may find it useful. If you have more than one database remember to back up each database before you start.
Q. Can I run the VAT Change Module on a terminal server or data server, e.g. using remote desktop?
A. Yes. It is designed to run from a client but should also run on a server.
Q. Can I test the VAT Change program on our test database whilst users are logged into the live database?
A. Yes. When the VAT Change program runs you select the database to change. Only that database is changed and users only need to be logged out of that database.
Q. I ran the last VAT Change Module in January 2010. Do I need to run this one?
A. Yes if you are based in the UK. The previous VAT Change Module only catered for the previous VAT rate change. If you are based in Southern Ireland then you do not need to run this one as the VAT rate is not changing.
Q. I have a RETAIL system. When I run option 5, will there be any effect on my business written information?
A. Yes. Because the selling price stays the same to the customer, your margins will be reduced and therefore you will see business written changes for the day that you run the VAT Change module reflect the loss of margin. There will be one change per sales order line. If you also run option 7 then there will be business written changes reflecting the increase in your margins to previous levels.
Q. Does the VAT Change module change prices in my Product database?
A. If your system is geared to RETAIL then the VAT Change module does not change your “including VAT” selling prices (if you want to increase prices then you need to use the Export / Import Products program). If your system is geared to TRADE then the VAT Change module does not change the “excluding VAT” selling prices, however, if you need to quote “including VAT” prices, remember that these will be higher after running the VAT Change module.
Note for retailers: This program does not change any of your “including VAT” product static selling prices. You will need to do these yourself in the usual way (e.g. Product Export/Import in the Administration – Toolbox program) if you, in fact, want to change selling prices.
Written by Gordon Kinnear
Topics: Optimise News