===== Overview =====



One way to change several tax rates at once would be to use the Control XML Import feature. It should be noted that depending on the number of Tax Rates that need to be changed, it may be faster and easier to change them in the Chart of Accounts screen inside Control. However, to demonstrate the Control XML import feature, we'll explain how to change them all at once.



===== Warning =====



Using this method to update information in Control could result in permanent loss of data. Extreme caution should be used and a backup of the database should be performed while using this method.



Any loss of data or damage to the database due to improper use is not covered under the normal Support Agreement.



The steps below only walk through how to import Tax Rate changes. You should familiarize yourself with the typical method for changing Tax Rates as well as be aware of the additional steps necessary after changing Tax Rates. These steps are discussed further in the following wiki:



[[how-to_change_your_sales_tax_rates]] 



===== Export Existing Account Information =====

**Important!** - Make a backup of the database first by clicking Backup Database in the File menu. Verify the backup is complete before moving on.



1. Navigate to Setup > Accounting Setup > Chart of Accounts > Liabilities > Sales Tax Liabilities



2. Right click on the Sales Tax Liabilities folder and choose **Export as XML**.



{{::taxrateimport1.png?nolink&|}}



3. Name the file SalesTaxes.xml and save it to your desktop.



4. Right-Click on the SalesTax.XML file and choose **Open with** > **Notepad**.



{{::taxrateimport1a.png?nolink&|}}



4. Scroll down until you see the first Sales Tax account surrounded by the  tags. The information for each Sales Tax Account will start like this.



5. Find the  tag immedietly following the first Tax Account Name. This is where you change the rate for that Tax Account.



6. Change the TAXRATE value to the new Tax Rate.



{{::taxrateimport2.png?nolink&|}}



7. Repeat Steps 4-6 for each Tax Rate you would like to change.



8. Once all Tax Rates have been changed, Save the text document and close it.



9. **Important!** - If you haven't done a backup, now is the last opportunity to do so. Please make sure you have a valid database backup before continuing.



10. In Control, click the Tools menu. Expand Import Data and choose **Import from Control XML Files**.



{{::taxrateimport3.png?nolink&|}}



11.The Importer screen will appear.



12. Click the elipsis [...] button and navigate to the SalesTax.XML file on your desktop.



13. Click the Open button.



{{::taxrateimport4.png?nolink&|}}



14. Once the file is loaded, click the Save button on the right side of the screen.



15. The Importer screen will display status updates and indentify the changes it's making. If there are any errors on this screen, please take a screenshot now as it will help with troubleshooting later on.



16. If you don't receive any error messages, the import is complete and the rates you updated in the SalesTax.XML file have been updated in Control.



{{::taxrateimport5.png?nolink&|}}