QuickBooks quarterly tax rate table import instructions

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:

  • Professional
  • Premier
  • Enterprise

To import the latest quarterly tax rate table:

  1. Download the tax rate table file to a directory on your computer.
  2. Launch QuickBooks and open your company file
  3. For 2006 – 2008 versions: Select File > Utilities > Import > IIF Files (See Figure 1)
    For 2005 version: Select File > Import > IIF Files (See Figure 2)

Figure 1. Path to importing IIF files for QuickBooks 2006 and newer.

 

Figure 1

 

Figure 2. Path to importing IIF files for QuickBooks 2005.

 

 

Figure 2

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:

 

imported alert

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.

Tax rates change quarterly! Be sure to check each quarter to get the most current tax rates.

 

Figure 3