If your business sells goods or services in the state of California, you must collect California sales tax on each transaction. According to the California Sate Board of Equalization, the standard statewide tax rate is 8.25%. However, the final tax rate may increase or decrease according to the specific district the transactions occur. To import the California sales tax data into QuickBooks, you must create an Intuit Interchange Format (IIF) file that contains the sales tax data, then import the IIF file into QuickBooks. You can create an IIF file using Microsoft Excel.
Create a California Sales Tax IIF File
Launch Microsoft Excel. Open a new spreadsheet and populate it with your California sales tax data. Use the sample template from Intuit as a guide to input the data in the correct format (see “References”).
Click "File" and select "Save As" from the drop-down list. The "Save As" window opens.
Select "Text (Tab delimited)" from the "Save as Type" drop-down box.
Type a name for the file in the "Name" text box and add the extension ".iif" at the end of it. Select the location on your hard drive you want to save the file and click "Save."
Import the California Sales Tax File
Click "File" from the main menu bar and select "Utilities" from the drop-down list.
Click "Import" and select "IIF Files."
Navigate to the California sales tax IIF file you created and click the "Import" button.
An avid technology enthusiast, Steve Gregory has been writing professionally since 2002. With more than 10 years of experience as a network administrator, Gregory holds an Information Management certificate from the University of Maryland and is pursuing MCSE certification. His work has appeared in numerous online publications, including Chron and GlobalPost.