How to Import Item Inventory Assemblies into QuickBooks Desktop using Dancing Numbers

Efficiently managing your inventory is crucial for any business, and QuickBooks Desktop offers powerful tools to streamline this process. One such feature is the ability to import item inventory assemblies, which can save you significant time and reduce data entry errors. This guide will walk you through the process of importing item inventory assemblies into QuickBooks Desktop using Dancing Numbers, a specialized tool designed to simplify bulk data imports.

Understanding Item Inventory Assemblies

Before diving into the import process, it’s essential to understand what item inventory assemblies are. An inventory assembly is a parent item composed of multiple individual inventory parts or items. For example, if you sell computers, a computer assembly might include the CPU, monitor, keyboard, and mouse as separate inventory items.

Dancing Numbers: Your Import Solution

Dancing Numbers is a third-party application built exclusively for QuickBooks Desktop that simplifies the process of importing item inventory assemblies. This tool supports QuickBooks Desktop Pro, Premier, Accountant, and Enterprise Editions.

Key Features of Dancing Numbers

1. Automated Import Process
2. Customizable Filters for Accurate Data Import
3. Direct Import from Excel to QuickBooks Desktop
4. User-Friendly Interface

To get started with Dancing Numbers, download a Free Trial from the Dancing Numbers Website.

Step-by-Step Guide to Import Item Inventory Assemblies

Follow these steps to import your item inventory assemblies into QuickBooks Desktop using Dancing Numbers:

Step 1: File Selection

1. Launch Dancing Numbers and click the “Import” or “Start” button on the home screen.
2. Click “Select Your File” or “Browse File” to choose the Excel file containing your inventory assembly data.
3. Alternatively, you can click “View Sample File” to download a template file for reference.

Step 2: Mapping

1. Set up the mapping between your file columns and QuickBooks fields.
2. If you’re using the Dancing Numbers template file, this step will be done automatically.
3. Ensure all required fields are correctly mapped to avoid import errors.

Step 3: Review and Import

1. Click “Next” to preview your file data before importing it into QuickBooks.
2. Review the data carefully to catch any potential errors or inconsistencies.
3. If everything looks correct, proceed with the import process.

QuickBooks Fields for Item Inventory Assemblies

When preparing your import file, make sure to include the following fields for each item inventory assembly:

Field Name	Format	Description
Name	Text	Inventory Item name
Parent	Text	Primary/Head Inventory Item/Product
Manufacturer Part Number	Alphanumeric	Part number used by the manufacturer
Unit Of Measure Set	Text	Combination of Multiple Unit of Measures
Sales Tax Code	Text	Area Sales Tax Code
Sales Description	Text	Description used for sales transactions
Sales Price	Numeric	Price for the item
COGS Account	Text	Cost of goods sold Account
Description	Text	Item/Product Description
Price	Numeric	The price charged for the item
Purchase Tax Code	Tax/Non	Tax Code Used while Purchasing Item/Product
Pref Vendor	Text	Preferred Vendor
Income Account	Numeric	Income account related to assembly
Asset Account	Numeric	The account which is used by QuickBooks to look at the current inventory value of the company
Minimum Build Point	Numeric	Minimum Quantity for Building the Assembly
Maximum Build Point	Numeric	Maximum Quantity for Building the Assembly
Quantity On Hand	Numeric	Item Quantity in the Stock
Inventory Date	MM/DD/YYYY	The date on which inventory is updated
Average Cost	Numeric	The average cost of the product
Item Name	Text	Name of the item
Quantity	Numeric	Number of the product
Is Active	True/False	Whether import item is active or not

Import Settings and Customization

Dancing Numbers offers additional tools to customize your import process. These settings are accessible from the top right-hand corner of the import screen. Use these options to fine-tune your import according to your specific needs.

Troubleshooting and FAQs

Here are some common questions and solutions related to importing item inventory assemblies:

Q: I made Mistakes During the Import Process, and my QuickBooks Reports are now Incorrect. Can I undo or Revert the Import?

A: Yes, you can partially or completely undo the import using the Delete feature available in Dancing Numbers. This allows you to correct errors without manually adjusting each affected entry.

Q: My File uses a Specific Date Format. Do I Need to Change it, or does Dancing Numbers Support all Date Formats?

A: Dancing Numbers requires dates to be in the MM/DD/YYYY format. You’ll need to adjust your file to match this format before importing to ensure accurate data transfer.

Q: Are there Sample Templates Available for Reference?

A: Yes, Dancing Numbers provides sample templates. You can access these by clicking the “View Sample File” link during the import process.

Q: What File Types are Supported by Dancing Numbers?

A: Dancing Numbers supports common spreadsheet formats, including XLS and XLSX files.

Q: Can I Import Multiple Assembly Items in a Single File?

A: Yes, Dancing Numbers supports multi-line imports for including multiple assembly items. To group lines for the same item, use the same Item number in multiple lines.

Best Practices for Importing Item Inventory Assemblies

1. Backup your QuickBooks company file before performing any bulk imports.
2. Double-check your data for accuracy before importing.
3. Use consistent naming conventions for your items and assemblies.
4. Regularly update your inventory counts to maintain accurate records.
5. Perform a test import with a small dataset before importing large amounts of data.

Getting Help

If you encounter any issues or have questions during the import process, don’t hesitate to seek assistance. You can:

1. Email support@www.dancingnumbers.com for direct support.
2. Visit the Dancing Numbers Support Center at https://www.dancingnumbers.com/support/ for quick answers and resources.

---

Video Tutorial

---