How to Import Sales Tax Items into QuickBooks Desktop?

Importing data into QuickBooks Desktop has always been a challenge, but Dancing Numbers has streamlined the process, making it simple, fast, and efficient. This guide will take you through each step to help you seamlessly import Sales Tax Items into QuickBooks Desktop using Dancing Numbers.

Steps to Importing Sales Tax Items to QuickBooks Desktop

Free Trial Available:

You can try Dancing Numbers for free by downloading the trial version from the Dancing Numbers website. Follow the steps outlined below for a step-by-step installation and setup guide.

The import process is streamlined through a user-friendly wizard that guides you through the bulk import process with ease. Follow these steps:

1. Start the Import Process:  On the home screen, click the “Import” button to begin.
2. File Selection: Click “Select Your File” or “Browse File” to locate the file on your computer. Alternatively, click “View Sample File” to download a sample file template from Dancing Numbers for easy formatting.
3. Mapping Fields: In this step, you’ll map the columns in your file to QuickBooks fields. Dancing Numbers’ template file automates this process. To use it, download the Dancing Numbers template file. You can also manually adjust the mapping if needed.
4. Review and Import: After mapping, click “Next” to review your file data on the preview screen. This allows you to verify data accuracy before finalizing the import.

The purpose of using the plugin is to provide additional features that’ll simplify the import process. So you as the user can not only import the sales tax transactions but also undo the action altogether. This enables you to go to the previous state of data if you accidentally import data that you want to remove.

How to Import Sales Tax Items into QuickBooks Desktop Without Additional Software

If you prefer to import Sales Tax Items into QuickBooks Desktop without using third-party software, you can manually enter data through QuickBooks’ built-in features. While this process is less automated, it can be a reliable method if you’re working with a limited number of items or prefer not to use external tools.

Here’s a step-by-step guide:

Step 1: Prepare Your Data in Excel

1. Open Excel: Start by organizing your data into an Excel spreadsheet.
2. Set Up Columns: Create columns for each field that QuickBooks requires. Include fields such as:
   • Sales Tax Name: The name or code for the sales tax item.
   • Description: Brief details about the tax.
   • Rate: The percentage rate for the sales tax.
   • Tax Vendor: The vendor or agency name that collects the tax.
   • Is Active: Specify whether the item is active.
3. Save the File: Save your Excel file in a format QuickBooks supports, like CSV (.csv) or Excel (.xlsx).

Step 2: Use QuickBooks Import Feature (for Lists)

QuickBooks Desktop has a built-in import tool for lists, which includes Sales Tax Items. Here’s how to use it:

1. Open QuickBooks Desktop: Launch QuickBooks and navigate to the company file where you want to import the data.
2. Go to File Menu: Click on File > Utilities > Import > Excel Files.
3. Select Your Data: Choose the option to import data for Lists (including Sales Tax Items).
4. Choose Your File: Locate and select your Excel or CSV file from your computer.

Step 3: Map Fields

QuickBooks will prompt you to map the columns in your Excel file to the corresponding fields in QuickBooks.

1. Match Fields: Ensure that each column in your file is matched with the appropriate QuickBooks field (e.g., “Sales Tax Name” to the “Name” field).
2. Review Mapping: Double-check that each field is matched correctly to avoid import errors.

Step 4: Review and Import

1. Preview Data: QuickBooks will show you a preview of your data. Review it to make sure everything is correct.
2. Complete the Import: If everything looks good, proceed with the import. QuickBooks will add your Sales Tax Items to the company file.

Step 5: Verify Imported Data

After the import, go to Lists > Item List in QuickBooks Desktop to check that your Sales Tax Items have been imported correctly.

Using this manual method may require a bit more attention to detail, but it’s an effective way to import Sales Tax Items into QuickBooks Desktop without relying on additional software.

Supported Versions of QuickBooks Desktop

With Dancing Numbers, you can import Sales Tax Items automatically. The filter attributes enable you to precisely import the data you need, saving time and minimizing errors. This powerful tool is designed exclusively for QuickBooks Desktop, ensuring compatibility and ease of use.

The Supported Versions include:

• QuickBooks Desktop Pro
• QuickBooks Desktop Premier
• QuickBooks Desktop Enterprise
• QuickBooks Desktop for Accountants

Our app comes with a free trial for all users who require it. It generally means that you get to test it out before you purchase a subscription. The app works with QuickBooks desktop and can be installed and used locally.

Note: we also have a version for QuickBooks Online that you can install directly from the Intuit app store. This integrates directly with QuickBooks Online and then works with the company file through the Api provided.

Mapping QuickBooks Fields

Field Name	Format	Description
Name	Text	Name of the Tax Code
Description	Text	Details about the Tax Code
Rate	Numerical	Sales Tax Percentage
Tax Vendor Ref	Text	Name of the Tax Vendor/Agency
Is Active	True/False	Indicates that Sales Tax item is active or not

---

---

Frequently Asked Questions

Many users would have some questions while moving data to your QuickBooks Desktop. Some of the questions are mentioned below:

What if I make mistakes during the Import Process, and my QuickBooks Reports are affected?

With Dancing Numbers, you can undo or revert the import (either partially or completely) using the Delete feature. The undo feature enables removing all the sales tax data that you imported.

Do you provide Sample Templates?

Yes, sample templates are available for easier file setup. You can download these templates and replace the sample data with your actual data. This helps you quickly format your data and import into QuickBooks.

What File Types are Supported?

The tool supports XLS, XLSX, and other standard file formats. These formats are widely supported across different platforms. You can export and import these file formats from and to QuickBooks Desktop respectively.

Where can I Get help if I’m Stuck?

Our support team is here to help. You can reach out via email at support@dancingnumbers.com or visit our Support Centre for quick assistance. Our agents are available round the clock to help you through any issues that occur.