Updating sales tax rates in quickbooks
This keeps the amount of work to a minimum and makes it less likely that I’ll have an error due to overlooking a customer.In some cases you may not be using sales tax group items.
Let’s take a look at a way to get updated sales tax rates for free and import them into Quick Books. Here’s an example of what the file for California looks like, in Excel.Today I’ll talk about some ways to handle this situation.I am going to assume you understand how to set up sales tax in Quick Books (see my article on how to set up sales tax in Quick Books). In my local customer records I specify that they are taxed using the combined rate. If I have an invoice with the old rate, and then change the rate of the sales tax item in the item list, the existing invoice still shows the original rate.It used to be that we just had to worry about our local tax rate, when selling items to customer who walked in the door.Now, most businesses are finding that they have to ship to multiple locations, and each location has a different tax rate.Look for Charlie’s articles in the Accountex Report blog, as well as his California Wildflower Hikes blog.
Dealing with sales tax rates in Quick Books Desktop can be a pain, particularly if you are working with customers in many different locations.
This saves you from having to go back through all of the customers to change the rate.
Note that you won’t get the “name information changed” warning if you have turned off this preference (under Charlie Russell is the founder of CCRSoftware.
Then I will edit the sales tax group item to use the new rate instead of the old rate.
As you can see, now the report properly separates the sales by the different rates for different times of the year. Another big benefit – because each of my customers were assigned a sales tax group item (rather than a sales tax item) I can make the change to the rate, but I don’t have to go into each customer record and change them to use a different rate.
Perhaps you have a locale where you don’t have multiple combined sales tax rates.