How to Import Other Names into QuickBooks Desktop?

QuickBooks Desktop is a powerful accounting software that allows businesses to manage their financial data efficiently. One of its key features is the ability to import various types of data, including “Other Names” – a category for contacts that don’t fit into the standard customer, vendor, or employee classifications. This guide will walk you through the process of importing Other Names into QuickBooks Desktop using Dancing Numbers, a third-party tool designed to simplify data import.

Introduction to Dancing Numbers

Dancing Numbers is a specialized tool built exclusively for QuickBooks Desktop that streamlines the process of importing data. It offers a user-friendly interface and powerful features to make bulk imports quick and accurate.

Key Features

• Automatic import of Other Names
• Advanced filtering options for precise data selection
• Direct import from Excel to QuickBooks Desktop
• Supports QuickBooks Desktop Premier, Pro, Accountant, and Enterprise editions

To get started with Dancing Numbers:

1. Visit the Dancing Numbers Website
2. Download the Free Trial
3. Follow the installation instructions provided on the website

Step-by-Step Guide to Import Other Names

Follow these steps to import Other Names into QuickBooks Desktop using Dancing Numbers:

Step 1: Initiate the Import Process

1. Launch Dancing Numbers after installation
2. Click the “Import (Start)” button on the home screen

Step 2: File Selection

1. Click “Select Your File” or “Browse File” to choose your data file from your computer
2. Alternatively, click “View Sample File” to use a pre-formatted template

Step 3: Mapping

1. Set up the mapping between your file columns and QuickBooks fields
2. For automatic mapping, use the Dancing Numbers template file

Step 4: Review and Import

1. Click “Next” to preview your data before importing
2. Review the information carefully to ensure accuracy
3. If satisfied, proceed with the import

For a more detailed walkthrough of these steps, refer to the comprehensive guide available on the Dancing Numbers website.

QuickBooks Fields for Other Names

When importing Other Names, it’s crucial to understand the available fields and their formats. Here’s a detailed breakdown:

Field Name	Format	Description
Salutation	Text	Mr/Ms/Mrs
Name	Text	Full name of the contact
First Name	Text	Contact’s first name
Company Name	Text	Name of the associated company
Middle Name	Text	Contact’s middle name
Last Name	Text	Contact’s last name
Phone	Numbers	Primary phone number
Alt Phone	Numbers	Alternative phone number
Fax	Numbers	Fax number
Email	Alphanumeric	Email address
Contact	Text	Primary contact name
Alt Contact	Numeric	Alternative contact phone number
Account Number	Numbers	Associated bank account number
Notes	Alphanumeric	Additional information about the contact
Address Line 1	Alphanumeric	First line of the mailing address
Address Line 2	Alphanumeric	Second line of the mailing address
Address Line 3	Alphanumeric	Third line of the mailing address
Address Line 4	Alphanumeric	Fourth line of the mailing address
Address Line 5	Alphanumeric	Fifth line of the mailing address
City	Text	City of residence
State	Text	State or province
Postal Code	Numbers	ZIP or postal code
Is Active	Yes/No	Indicates if the contact is currently active

Advanced Import Settings

Dancing Numbers offers advanced import settings to customize your data import process. These tools are accessible from the top right-hand corner of the import screen. They allow you to:

• Filter Data Based on Specific Criteria
• Set Default Values for Certain Fields
• Handle Duplicate Entries
• Manage Error Handling and Logging

Familiarize yourself with these settings to optimize your import process and ensure data integrity.

Frequently Asked Questions

Q: Can I undo or revert an import if I made mistakes?

A: Yes, Dancing Numbers provides a Delete feature that allows you to undo imports partially or completely. Exercise caution when using this feature to avoid unintended data loss.

Q: Are there sample templates available for importing Other Names?

A: Yes, Dancing Numbers offers sample templates. Access them by clicking the “View Sample File” link during the import process.

Q: What file types does Dancing Numbers support?

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

Q: How can I get help if I encounter issues during the import process?

A: For assistance, email support@dancingnumbers.com or visit the Dancing Numbers Support Center for quick answers and guidance.

Q: Does Dancing Numbers support multiline transactions?

A: Yes, Dancing Numbers supports multiline transactions. However, to ensure proper grouping, use the same Sales tax group name for related entries.

Best Practices for Importing Other Names

To ensure a smooth import process and maintain data integrity, consider these best practices:

1. Prepare Your Data: Clean and organize your Excel file before importing. Remove duplicates, standardize formats, and ensure all required fields are filled.
2. Use Templates: Whenever possible, use the Dancing Numbers templates to minimize mapping errors.
3. Backup Your QuickBooks File: Always create a backup of your QuickBooks company file before performing any bulk imports.
4. Test with a Small Dataset: Before importing a large number of records, test the process with a small subset of data to identify and resolve any issues.
5. Review and Verify: After importing, thoroughly review the imported data in QuickBooks to ensure accuracy and completeness.
6. Maintain Consistent Naming Conventions: Establish and follow consistent naming conventions for your Other Names to facilitate easier searching and reporting.

---

Video Tutorials

---