How to Change Sales Tax Rates for Multiple Customers in QuickBooks |

How to Change Sales Tax Rates for Multiple Customers in QuickBooks

Published 08/14/2009 |

I need to change my sales tax from 7% to 8%. It changed in May 2009 and I made the mistake of going in and just changing the current rate. Well, it is still wrong. I am having to manually change each invoice and sales receipt. I just set up a new sales tax group for the SC Sales Tax of 6%, the transportation tax of 1% and the local option tax of 1%. Apparently this is the better way to do it so that I can just add any new sales tax options and make inactive the old ones. My question is how can I get this changed over without having to change each customer and item that we use?

The quickest and easiest way to do a massive change like this is to export your customer list to an IIF file, open it in Excel, make the change, and then import the IIF file back into QuickBooks. Here are the steps:

1.   Go to File > Utilities > Export > Lists to IIF Files and select Customers
2.   Save the file somewhere easy to find like your desktop
3.   Open it with Excel and find the TAXITEM column
4.   Change the old tax item to the new tax item
5.   Save the file
6.   Go to File > Utilities > Import and browse to the IIF file
7.   Then go through the same process for your Item List

If you haven’t already, you should also change the Most common sales tax item at Edit > Preferences > Sales Tax > Company Preferences so new customers default to your new sales tax item.

If we helped solve your problem, please consider posting a review for us!

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth has provided QuickBooks help to thousands of businesses around the world since 1996. She is an Intuit Solutions Provider, an Advanced Certified QuickBooks ProAdvisor, and a member of the Intuit Trainer/Writer Network. She is also certified in QuickBooks Point of Sale and QuickBooks Enterprise Solutions.

QuickBooks price list | Buy QuickBookse | Free trial of QuickBooks POS | Free trial of QuickBooks Enterprise