• You've already voted on this page
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
Banking Creating & Customizing Forms Importing & Exporting Data Inventory Journal Entries & Accounting Tasks Multicurrency Vendors & Vendor Center Printing in Quickbooks QuickBooks Installation, Update, & Conversion
Customers & Customer Center Reports & Report Center QuickBooks UPS, FedEx Shipping Manager QuickBooks Online Services & Features QuickBooks File, Edit & View Menu Tasks QuickBooks Performance Issues & Program Errors QuickBooks Networking & User Setup
QuickBooks Attached Documents QuickBooks Connect QuickBooks Enterprise Solutions QuickBooks for Mac QuickBooks Online (US) QuickBooks Online Suggestions for Improvement QuickBooks Point of Sale QuickBooks Simple Start Edition QuickBooks Time and Billing Manager Cash Register Plus Customer Manager
Customer Manager & Client Manager Desktop Intuit Commissions Manager Intuit Data Protect Intuit Websites Review Websites and Get Feedback GoPayment Intuit Sync Manager New Intuit Business Tools & Resources Quickbase Quicken Turbotax
Better Because of You Considering Buying QuickBooks? Quickbooks Educational Resources QuickBooks Service/Support Policies & Procedures Classifieds
QuickBooks Payroll (Desktop) Intuit Online Payroll ViewMyPaycheck
Builders & Contractors Non-profit Real Estate Retailers Service Industries Other Industries
QuickBooks Canada QuickBooks UK Desktop QuickBooks UK Online QuickBooks Singapore Online QuickBooks en Español QuickBooks Australia
  • QuickBooks Tasks
  • Intuit Products
  • Intuit Resources
  • Intuit Payroll
  • Industries
  • International
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help with Intuit Products   International   QuickBooks UK   VAT (UK)  
hide
05/24/2012 at 04:51PM PDT
Important Announcement! A planned system-wide upgrade will take place over the Memorial Day Weekend in the US (From Thurs, May 24, 2012 at 6 pm PDT thru Tues, May 29, 2012 at 5 am PDT). This includes QuickBooks, QuickBooks Payroll, Point of Sale, & Salesforce.com. This is only for US based products. This does not affect QuickBooks Online customers! During this time, you can shop, but can’t place orders online, activate products or update account info. We apologize for the inconvenience & thank you for patience while we improve our infrastructure to better serve you. International versions are unaffected. For more info, see our community discussion.
70
13003
cxAznr3sur35qUacfA8pyY
Subscribe RSS
Graceman
Graceman
Questions asked: 64
Questions answered: 12377
Points earned: 24350
AllStar UK
AllStar UK
Advisory council of community power users within the UK.
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
Graceman
Graceman
Questions asked: 64
Questions answered: 12377
Points earned: 24350
Allstar
10/21/10 8:13am PDT
Viewed by asker 04/21/12 8:40am PDT

Vat Jan 2011 @20%. in QB 2010 & QB 2008

20% Vat from January 4th 2011.  for QB 2008 scroll down to that post.

For those of you wanting to know how to change their Vat system in QB 2010 to be ready for the change to 20% Vat in January I offer this simple guide.

1. Open Item list, scroll to Vat item's,  choose your Standard Vat Item used @17.5%; I use Standard Sales in this example.

2. Right click on Standard Sales; and choose duplicate item, an edit window will open with the item ready for editing.

3. Edit name "I choose 20% Standard Sales".  (You can call it what you like).

4. Edit description to include the 20%

5. Edit the rate to be 20.0%. do not change anything else; Save.

6. Repeat this for your standard purchase Vat Item

7. Go to Vat menu and Vat codes List.

8. Right mouse click in the Vat code list window and select New.

9. For Vat code I used S20 again you can use what you want but you are limited to three characters.

10 . Enter Description I choose S20, again its your choice of Description.

11. Tick the Taxable box and then select the two Vat items you just created above one for Sales & One for Purchases. Save

You have now converted the Vat system to Handle 20% Vat select this code for anything you have to enter data for dates after 4th January 2011. and on January 4th "011 if you are back at work by then.

From edit preferences>Vat ; select the default standard vat rate as S20.(or what ever you decided to call it).

From here you will need to Assign Vat from the Manage Vat Menu and then using Bulk Change button you can change all your Items & Supplier/Customer codes if used.
 

If you are using EC codes then you will need to do this for each of the EC codes where currently 17.5% is used. Creating a new Group if required from the new Items.

If this post was helpful or answers your question, please either mark the answer as Helpful or Solved. This will then close your topic). Otherwise, let us know if you have more questions.
Submit a reply to this question
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
28 Replies
tictoc42
tictoc42
Questions asked: 3
Questions answered: 20
Points earned: 35
tictoc42
tictoc42
Questions asked: 3
Questions answered: 20
Points earned: 35
Contributor
11/02/10 7:48am PDT

Sounds good. Will it report Ok to the VAT100?

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
CSmi
CSmi
Questions asked: 3
Questions answered: 1
Points earned: 1
New Member
02/16/11 2:59am PST

My client has changed all the existing accounts to 20% and now the VAT 100 is empty. Any suggestions?

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
Graceman
Graceman
Questions asked: 64
Questions answered: 12377
Points earned: 24350
Allstar
11/02/10 8:05am PDT

If you follow the instructions correctly then it will report correctly to the correct boxes.

Note that is why I used duplicate and changed the rate % so it retained the original reporting line.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
1
Reply to this Answer
 Report Abuse
 
 
 
jacjoinery
jacjoinery
Questions asked: 0
Questions answered: 1
Points earned: 1
jacjoinery
jacjoinery
Questions asked: 0
Questions answered: 1
Points earned: 1
New Member
11/04/10 7:45am PDT

 Does this also apply to QB pro 2008?

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
Graceman
Graceman
Questions asked: 64
Questions answered: 12377
Points earned: 24350
Allstar
11/04/10 8:52am PDT

Vat from January 2011 @20%. For QB 2008

20% Vat from January 4th 2011. 

For those of you wanting to know how to change their Vat system in QB 2008 to be ready for the change to 20% Vat in January I offer this simple guide.

 1. Open Item list, Right mouse click anywhere in Grid,  Select New, Select "Vat Item".

 2. Edit window for new "Vat Item" will open.

 3. Edit name "I choose 20% Standard Sales". (You can call it what you like).
 

 5. Edit the rate to be 20.0%.

 6. Select your Vat tax Agency for this item to report to. (Will be same as other Vat Items). 

 7. In Bottom Box for Vat Return Box Select; Domestic Sales : Save

 8. Repeat this to create a new Vat Purchase Item at 20%, Selecting; Domestic Purchases < Box 4, Box 7> : Save.

 9. Now go to Vat menu and Vat codes List.

10. Right mouse click in the Vat code list window and select New.

11. For Vat code I used S20 again you can use what you want but you are limited to three characters.

12 . Enter Description I choose S20, again its your choice of Description.

13. Tick the Taxable box and then select the two Vat items you just created above one for Sales & One for Purchases. Save

You have now converted the Vat system to Handle 20% Vat select this code for anything you have to enter data for dates after 4th January 2011. and on January 4th 2011 if you are back at work by then.

From edit preferences>Vat ; select the default standard vat rate as S20.(or what ever you decided to call it).

If you are using EC codes then you will need to do this for each of the EC codes where currently 17.5% is used. Creating a new Group if required from the new Items.

 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
1
Reply to this Answer
 Report Abuse
 
 
 
Jo99
Jo99
Questions asked: 2
Questions answered: 5
Points earned: 5
Jo99
Jo99
Questions asked: 2
Questions answered: 5
Points earned: 5
New Member
11/19/10 2:10am PST

This answered the question I posted yesterday

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
Badgerperson
Badgerperson
Questions asked: 3
Questions answered: 4
Points earned: 5
Badgerperson
Badgerperson
Questions asked: 3
Questions answered: 4
Points earned: 5
New Member
01/05/11 5:28am PST

Thank you Graceman, that was exactly what I was after.

I used your own procedure which was very easy to follow.

You are a star.

I hope that Intuit rewards you well for all your efforts.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
1
Reply to this Answer
 Report Abuse
 
 
 
delitissue
delitissue
Questions asked: 0
Questions answered: 1
Points earned: 1
delitissue
delitissue
Questions asked: 0
Questions answered: 1
Points earned: 1
New Member
01/05/11 8:55am PST

Hello,

I did all the steps mentioned above and when trying to create invoice, added items i still have 17.5% VAT. Items have been updated as well  with new VAT code. Do  i need to change anything else?

Im using QB Premier 2008.

Thanks
Best Regards
Chris

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
AnnemariefromIntuit
AnnemariefromIn...
Questions asked: 39
Questions answered: 133
Points earned: 233
AllStar UK
AllStar UK
Advisory council of community power users within the UK.
Allstar
Allstar
Advisory council of community power users.
ProAdvisor UK
ProAdvisor UK
Members of the QuickBooks ProAdvisor Program
AnnemariefromIntuit
AnnemariefromIn...
Questions asked: 39
Questions answered: 133
Points earned: 233
Host, Allstar
01/05/11 9:08am PST

Thank you for taking the time to post this up Graceman! Very clear and easy to follow instructions. Hope you had a great holiday.

Annemarie

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
Squiffy
Squiffy
Questions asked: 1
Questions answered: 1
Points earned: 1
Squiffy
Squiffy
Questions asked: 1
Questions answered: 1
Points earned: 1
New Member
01/06/11 3:37am PST

Thank you so much I'd never have sorted this myself -  been trying for ages.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
TVRC
TVRC
Questions asked: 2
Questions answered: 3
Points earned: 3
TVRC
TVRC
Questions asked: 2
Questions answered: 3
Points earned: 3
New Member
01/06/11 6:47am PST

Thank you Graceman.

Very clear and easy to follow.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
Lornab
Lornab
Questions asked: 4
Questions answered: 6
Points earned: 6
Lornab
Lornab
Questions asked: 4
Questions answered: 6
Points earned: 6
New Member
01/12/11 3:47am PST

In QB in the item I have standard purchases @17.5% which I can duplicate no problem and amend to 20%. But the standard sales item shows 0%. However,  below this entry I have;-Vat (1) on purchase, Vat (1) on Sales 0% Vat, Vat (2) as above but showing 5.0%, Vat (3) as the two previously with a rate of 17.5% and VAT (4) at a rate of 15%

Do I ignore the standard sales line which shows 0% and just amend Vat (3) sales? Or should I duplicate standard sales currently showing 0%  and set it up as 20%?

I'm a bit confused why standard purchases has a stand alone line as well as an entry against VAT (3) but sales doesn't? 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
Graceman
Graceman
Questions asked: 64
Questions answered: 12377
Points earned: 24350
Allstar
01/12/11 2:35pm PST

You have all these because its a result of the upgrade you did, and it points to problems that you might have about the set up of the Vat system on your PC.

The answer is that you can do either if you wish but I would for clarity use the standard sales 0% and duplicate and amend to 20% as it follows a more logical route.

However the fact that you have the Vat 1,2,3 is that the possibility that the re are more than one Vat agency set up in your accounts and you need to look at the Vat items in the item list and make sure they are all reporting to the same account.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
andyg1
andyg1
Questions asked: 2
Questions answered: 2
Points earned: 2
andyg1
andyg1
Questions asked: 2
Questions answered: 2
Points earned: 2
New Member
03/18/11 2:08am PDT

I didn't use these instructions exactly - I got some from elsewhere at the New Year change over. But I have just noticed that on my invoices in the Data Field "VAT%, VAT Amount" the new code isn't included.

For example on the old invoices it would say something like:

"VAT S@17.7% £117.50"

But now it is just nothing in those rows, and then says "Total VAT 0.00".

It is only this field which is affected. The other fields such as per row in the products and the subtotal of VAT on the entire invoice are correct.

Can anyone help to tell me why this field is not being populated? All other VAT behaviour is correct.

Thank you in advance.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
OneManBand
OneManBand
Questions asked: 6
Questions answered: 217
Points earned: 398
OneManBand
OneManBand
Questions asked: 6
Questions answered: 217
Points earned: 398
Contributor
11/04/11 2:45am PDT

Hi Graceman,

i had already installed the S20 code, noticed the bulk change you mentioned. been changing them on the fly..

so i followed your instructions edit/prefferances/VAT but can't see the 'Bulk Change' command anywhere.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
Graceman
Graceman
Questions asked: 64
Questions answered: 12377
Points earned: 24350
Allstar
11/04/11 6:58am PDT

Its under Manage Vat menu and the button on right hand side Assign Vat and here you can bulk change.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
Natassaa
Natassaa
Questions asked: 2
Questions answered: 9
Points earned: 10
Natassaa
Natassaa
Questions asked: 2
Questions answered: 9
Points earned: 10
New Member
03/01/12 11:06pm PST

Dear Graceman,

how do the reverse charge (RC) will be calculated? Will it be at new rate?

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
Graceman
Graceman
Questions asked: 64
Questions answered: 12377
Points earned: 24350
Allstar
03/02/12 7:28am PST

It will be at the rate as set by the items assigned to the group. If you change that today it will be at that rate for transctions as entered from today.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
Natassaa
Natassaa
Questions asked: 2
Questions answered: 9
Points earned: 10
New Member
03/06/12 12:02am PST

Thank you.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
Natassaa
Natassaa
Questions asked: 2
Questions answered: 9
Points earned: 10
New Member
03/12/12 3:27am PDT

Dear Graceman,

I have changed the VAT from 15% to 17% as you explain and I have checked it now and the RC (reverse charge) is calculated at the rate 15%. Where am I wrong?

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
    Next ›     Last »
 
Submit a reply to this question
 
Subscribe RSS
Tags for this topic
  • 20% vat 2011
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
CountryMusicMom
2 hrs ago
CountryMusicMom
replied to
Changing account type
dec1801
2 hrs ago
dec1801
posted
Changing account type
Diana_Intuit
7 hrs ago
Diana_Intuit
replied to
Is Quickbooks 2012 RTI comp...
Bebebleurenault
7 hrs ago
Bebebleurenault
posted
Error in my email address
CountryMusicMom
9 hrs ago
CountryMusicMom
replied to
Bill Entry - Generate refer...
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2012 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business