--- title: Updating VAT Rates and Stock Prices description: As per the latest Government Update regarding the change in VAT to the Hospitality Sector, we have created the new guide on amending your VAT rates. image: https://kcpos.co.uk/hubfs/Imported_Blog_Media/KCPOS-2020-Update--min-1.jpg --- 04 September 2020 | [resources](https://kcpos.co.uk/news/tag/resources) | [ VisiSoft ](https://kcpos.co.uk/news/author/visisoft) # Updating VAT Rates and Stock Prices with KC Back Office Accounts ![Updating VAT Rates and Stock Prices](https://kcpos.co.uk/hs-fs/hubfs/Imported_Blog_Media/KCPOS-2020-Update--min-1.jpg?width=1310&height=736&name=KCPOS-2020-Update--min-1.jpg) ## Explore Topics - [resources](https://kcpos.co.uk/news/tag/resources) - [Videos](https://kcpos.co.uk/news/tag/videos) ### Amending the VAT Rate on Stock Records Navigate to Commercials -> Stock Records   ![Commercials Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/11.png) Use the Prev / Next buttons or the Find option to locate the item you wish to change the VAT Rate on. ### Amending the Sell Price on Stock Records Navigate to Commercials -> Stock Records   ![Commercials Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/11.png) Use the Prev / Next buttons or the Find option to locate the item you wish to change the Sell Price on. ### Amending an Existing VAT Rate Navigate to Utilities -> VAT Control -> VAT Rates ![Utilities Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/12.png) Use the Prev / Next buttons, or use the Find option to locate the VAT rate you wish to amend. ![VAT Codes Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/13.png) Click Edit and amend the necessary information. ![VAT Codes Screenshot 2](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/14.png) Click Save to update the record. ![VAT Codes Screenshot 2](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/15.png) ### Bulk Updating Prices Sell Prices on Stock records can be amended in several ways, but a time saving option is to use the Stock Import / Export functionality. Firstly you need to export the stock to an Excel spreadsheet. You can do this by going to Commercials -> Stock Control -> Utilities -> Export to Excel. ![Utilities Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/16.png) You can choose to only export a range of stock records based on code and category: ![Stock Records Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/17.png) Click Ok and when prompted save the spreadsheet to a suitable location. Open the spreadsheet and you’ll see stock codes in column A which is labelled cstockcode. The corresponding Sell Price is in column S which is labelled nsellprice. Amend the Sell Price for any items you wish to change ensuring that the structure of the spreadsheet isn’t altered in any way. If you wish to use Excel to perform some calculations (such as increasing all prices by 10%) then copy the nsellprice column to another spreadsheet, perform the necessary calculations, and paste the results back using the Paste Values option. Once you’ve finished amending prices, save the spreadsheet in the same format, which is Microsoft Excel 5.0/95 Workbook (.xls) and switch back to Back Office Accounts. Go to Commercials -> Stock Control -> Utilities -> Import from Excel ![Import Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/18.png) Click on the Browse button and locate your amended spreadsheet ![Stock Import Screenshot 2](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/19.png) Click Import When prompted you can view a report of which records will be updated. For ease you can just select Screen Preview here ![Screen Preview Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/20.png) You’ll then be presented with the report ![Report Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/21.png) If you’re happy with the proposed changes then say Yes on the following prompt ![Confirmation Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/22.png) Once the import is finished, you’ll receive the following confirmation ![Import Complete Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/23.png) ### Creating A New VAT Rate You can’t actually create new VAT Rates in Back Office Accounts, but there are 12 (S, E, Z and 1-9) created as standard, so you just need to amend one which isn’t already in use. Navigate to Utilities -> VAT Control -> VAT Rates ![Utilities Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/31.png) Use the Prev / Next buttons to locate a Rate which isn’t already being used ![VAT Codes Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/32.png) Click Edit and set the Description and VAT Rate accordingly. ![VAT Codes Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/33.png) Click Save ![VAT Codes Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/34.png) ### VAT Inclusive Items In Back Office Accounts you have the ability to flag an item as VAT Inclusive which is very convenient in a retail environment as it allows you to enter the Gross Price in the Sell Price field, which is what the customer will ultimately pay. However, when using this option, it’s important to note that if the rate of VAT associated with the item changes, the price of the item itself will remain the same. If you want to pass on some of the costs or savings to your customer, then the price will need to be adjusted manually. To change the VAT Inclusive Price status of an item, navigate to Commercials -> Stock Records ![Commercials Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/11.png) Use the Prev / Next buttons or the Find option to locate the item you wish to change the option on. ![Locate Items Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/35.png) Click Edit and tick VAT Inclusive Price. You’ll see that the read-only VAT Inc Price field is now renamed to VAT Ex Price so you can see the price of the item without any VAT included. ![Stock Records Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/36.png) Click Save ![Stock Records Screenshot](https://cdn.thehbpgroup.co.uk/kcpos.co.uk/wp-content/uploads/2021/09/37.png) ### Related Articles [ 8 min read • 11 October 2021 ![How To Choose An EPOS System](https://kcpos.co.uk/hs-fs/hubfs/Imported_Blog_Media/How-to-choose-an-epos-system-news.jpg?width=360&name=How-to-choose-an-epos-system-news.jpg) #### How To Choose An EPOS System ](https://kcpos.co.uk/news/how-to-choose-an-epos-system) [ 8 min read • 11 October 2021 ![How To Maximise Sales In Retail](https://kcpos.co.uk/hs-fs/hubfs/Imported_Blog_Media/maximise-sales-in-retail.jpg?width=360&name=maximise-sales-in-retail.jpg) #### How To Maximise Sales In Retail ](https://kcpos.co.uk/news/how-to-maximise-sales-in-retail) ###### **CONTACT US** [![Email Icon](https://kcpos.co.uk/hubfs/Visi-assets/Images/Email%20Icon.svg)info@kcpos.co.uk](mailto:info@kcpos.co.uk) [![Phone Icon](https://kcpos.co.uk/hubfs/Visi-assets/Images/Phone%20Icon.svg)01482 423907](tel:01482423907) [KCPOS, The HBP Group, 12 The Metro Centre, Welbeck Way, Peterborough, Cambridgeshire, PE2 7UH](https://maps.app.goo.gl/x3JrsHDDifv9kQfEA) ###### **PRODUCT FEATURES** - [EPOS System](https://kcpos.co.uk/product-features/epos-system) - [Stock Control](https://kcpos.co.uk/product-features/stock-control) - [Accounts Integration](https://kcpos.co.uk/product-features/accounts-integration) - [Dynamics Integration](https://kcpos.co.uk/dynamics-365-business-central-integration) - [Online Sales](https://kcpos.co.uk/product-features/online-sales) - [Reporting](https://kcpos.co.uk/product-features/reporting) - [Card Payments](https://kcpos.co.uk/card-payment-processing) - [Courier Integration](https://kcpos.co.uk/product-features/courier-integration) - [Commercials](https://kcpos.co.uk/product-features/commercials) - [KC 365](https://kcpos.co.uk/kcpos-365) ###### **INDUSTRIES** - [Trade Counter](https://kcpos.co.uk/by-industry/trade-counter) - [Retail](https://kcpos.co.uk/by-industry/retail) - [Wholesale & Distribution](https://kcpos.co.uk/by-industry/wholesale-distribution) - [Hospitality](https://kcpos.co.uk/by-industry/hospitality) - [Caravan & Holiday Parks](https://kcpos.co.uk/by-industry/caravan-and-holiday-parks) - [Tourist Attractions](https://kcpos.co.uk/by-industry/tourist-attraction) ###### ABOUT - [About Us](https://kcpos.co.uk/about-us) - [Contact Us](https://kcpos.co.uk/contact) - [Become A Partner](https://kcpos.co.uk/become-a-business-partner) - [Customer Support](https://kcpos.co.uk/customer-support) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "VisiSoft", "url" : "https://kcpos.co.uk/news/author/visisoft" }, "dateModified" : "2025-05-21T12:16:40.731Z", "datePublished" : "2020-09-03T23:00:00.000Z", "headline" : "Updating VAT Rates and Stock Prices", "image" : [ "https://kcpos.co.uk/hubfs/Imported_Blog_Media/KCPOS-2020-Update--min-1.jpg" ], "mainEntityOfPage" : { "@id" : "https://kcpos.co.uk/news/updating-vat-rates-and-stock-prices-with-kc-back-office-accounts", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://kcpos.co.uk/hubfs/KCPOS%20(No%20Tagline)%20-%20Full%20Colour.jpg" }, "name" : "The HBP Group" } } ```