If you track Washington sales tax rates in QuickBooks, you should take a moment to update everything for Q3 2009. It’s simple and takes just a minute or two.
Step 1: Download WAQBQ309.IIF from the Department of Revenue website. Save it somewhere easy to find, like your Desktop.
Step 2: Open QuickBooks and log into your company file as you usually do.
Step 3: Open the File menu and then the following chain of sub-menus: Utilities > Import > IIF Files…
Step 4: QuickBooks will prompt you to open the file you downloaded in Step 1. Select it and click Open.
A progress bar will display as the rates are imported. QuickBooks will do the following:
- If the import file has a rate that isn’t in your QB file, it will be added.
- If the import file has a rate with the same name as one in your QB file, it will be updated.
- Any items in your file with no matches in the import file will remain unchanged.
Some people don’t like adding the hundred-plus sales tax items. There’s no easy way around that, but you can always choose the Make Inactive option on any rates that you don’t plan to use.
Categories: Tax News and Tips
1 Comment »
One Response to “Third quarter sales tax rates available”
After the downloaded information was imported into QuickBooks, the state changed the download files. Each changed rate now has an indication of when it went effective, such as “eff 4/09.” This makes it a new rate in QuickBooks and does not replace the old rate. We recommend that you either delete or make inactive each of the previous tax rates as the State of Washington had changed the names.
This is tedious, but it makes sure you don’t accidentally use an old sales tax rate, such as an old rate that as assigned as the default for particular customers.
Care to comment?
You must be logged in to post a comment.