How to Import California Sales Tax to Quickbooks

Save

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

References

Promoted By Zergnet

Comments

Resources

You May Also Like

  • How to Adjust Sales Tax in QuickBooks

    Sales tax percentages vary from state to state. Manage your sales tax payments in QuickBooks by updating tax percentages to accommodate the...

  • California Import Laws

    California Import Laws. The State of California regulates the importation of products, animals and vehicles into the state. Importation can either be...

  • How to Calculate Sales Tax in Excel

    Sales taxes are taxes added to the purchase of goods and services. In the United States, each individual state can determine the...

  • How to Make a Sales Analysis on a Spreadsheet

    You have to attend a meeting in the afternoon. Your manager has emailed you the sales figures from last month and wants...

  • California Auto Sales Tax Law

    Four types of transactions are exempt from the automobile use tax. First, if a parent, child, grandparent, grandchild, domestic partner or sibling,...

Related Searches

Read Article

23 Deliciously Easy Lunches to Bring to Work

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!