The Department has created a tax rate and jurisdiction table file in a text file (.IIF) that can be imported into QuickBooks quarterly. The quarterly tax rate table can be imported into your QuickBooks company file if you are using one of the following versions of QuickBooks:
To import the latest quarterly tax rate table:
Figure 1. Path to importing IIF files for QuickBooks 2006 and newer.
Figure 2. Path to importing IIF files for QuickBooks 2005.
4. Open the directory where you downloaded the quarterly tax rate table in Step 1.
5. Double-click the quarterly tax rate table file.
6. QuickBooks will import the quarterly tax rate table in you “Item” list. You should see the following message when complete:
7. Click OK.
Important note: Starting July 1, 2008, updates will be included in the quarterly tax rate and jurisdiction table. The tax rate updates will include an “effective date” next to the “Item Name.” (See Figure 3)
Updates added after July 1, 2008, will remain on the tax rate and jurisdiction table. Over time, the file will include tax rate updates with different effective dates. Therefore, a single location may have two or more effective dates. After importing the quarterly tax rate and jurisdiction table, you may want to review your “Item List” and delete any previous tax rates if they are no longer needed.