How to Import Employees into QuickBooks Desktop?

Import employees data into QuickBooks Desktop can be a time-consuming task, especially when dealing with large numbers of employees. However, with the right tools and processes, this task becomes significantly easier and more efficient. This guide will walk you through the process of importing employees into QuickBooks Desktop using Dancing Numbers, a powerful third-party tool designed to streamline data import processes.

Understanding the Importance of Efficient Employee Data Import

Before diving into the specifics of the import process, it’s crucial to understand why an efficient employee import system is vital for businesses:

1. Time-saving: Manually entering employee data can be extremely time-consuming, especially for businesses with many employees.
2. Error reduction: Automated import processes significantly reduce the risk of data entry errors.
3. Data consistency: Importing data ensures consistency across all employee records.
4. Scalability: As your business grows, an efficient import process becomes increasingly important.

Introduction to Dancing Numbers

Dancing Numbers is a specialized tool built exclusively for QuickBooks Desktop. It simplifies the process of importing various types of data, including employee information, directly from Excel spreadsheets into QuickBooks Desktop.

Key Features of Dancing Numbers

• Automatic import of employee data
• Advanced filtering options for more accurate data import
• Support for multiple QuickBooks Desktop versions (Premier, Pro, Accountant, and Enterprise editions)
• User-friendly interface with a step-by-step import wizard

Getting Started with Dancing Numbers

To begin using Dancing Numbers for importing employees into QuickBooks Desktop, follow these steps:

1. Visit the Dancing Numbers Website to download a Free Trial of the software.
2. Install the software on your computer, following the provided installation instructions.
3. Launch Dancing Numbers and connect it to your QuickBooks Desktop application.

Step-by-Step Guide to Import Employees

Once you have Dancing Numbers installed and connected to QuickBooks Desktop, follow these steps to import your employee data:

Step 1: Initiate the Import Process

• Open Dancing Numbers and click the “Import” (or “Start“) button on the home screen.
• This action will launch the import wizard, guiding you through the process.

Step 2: File Selection

• Click “Select Your File” or “Browse File” to choose the Excel file containing your employee data from your local computer.
• If you need a reference, click “View Sample File” to see a Dancing Numbers sample file format.

Step 3: Mapping Fields

• In this crucial step, map the columns in your Excel file to the corresponding QuickBooks fields.
• If you’re using a Dancing Numbers template file, this step will be performed automatically.
• Carefully review the mappings to ensure accuracy.

Step 4: Review and Import

• Click “Next” to proceed to the preview screen.
• Carefully review your file data before the final import into QuickBooks.
• If everything looks correct, initiate the import process.

Understanding QuickBooks Employee Fields

To ensure a successful import, it’s essential to understand the various fields available for employee data in QuickBooks Desktop. Here’s a comprehensive list of fields and their descriptions:

Field Name	Format	Description
Salutation	Text	Title or honorific (e.g., Mr., Ms., Dr.)
First Name	Text	Employee’s first name
Middle Name	Text	Employee’s middle name (if applicable)
Last Name	Text	Employee’s last name
Job Title	Text	Employee’s position or job title
Supervisor Ref	Text	Name of the employee’s supervisor
Department	Text	Department the employee works in
Description	Text	Additional notes or description about the employee
Target Bonus	Text	Employee’s target bonus amount or percentage
Print As	Text	How the employee’s name should appear on checks
Phone	Number	Employee’s primary phone number
Mobile	Number	Employee’s mobile/cell phone number
Pager	Number	Employee’s pager number (if applicable)
Pager Pin	Number	PIN for the employee’s pager
Alt Phone	Number	Alternative phone number for the employee
Fax	Number	Employee’s fax number
Social Security No.	Number	Employee’s Social Security Number
Gender	M/F	Employee’s gender
Birth Date	MM-DD-YYYY	Employee’s date of birth
US Citizen	Yes/No	Indicates if the employee is a US citizen
Ethnicity	Text	Employee’s ethnicity
Email	Alphanumeric	Employee’s email address
Employee Type	Text	Classification of employee (e.g., Full-time, Part-time, Contractor)
Part Or Full Time	Text	Specifies if the employee is part-time or full-time
Exempt	Text	Indicates if the employee is exempt from overtime pay
Key Employee	Yes/No	Designates if the employee is considered a key employee
Hired Date	MM-DD-YYYY	Date the employee was hired
Original Hire Date	MM-DD-YYYY	Original hiring date (if rehired)
Adjusted Service Date	MM-DD-YYYY	Date used for calculating benefits based on tenure
Released Date	MM-DD-YYYY	Date the employee was released or terminated
Disabled	Yes/No	Indicates if the employee has a disability
Disability Description	Text	Description of the employee’s disability (if applicable)
US Veteran	Yes/No	Indicates if the employee is a US veteran
Military Status	Text	Employee’s military status (e.g., Active, Reserve)
Account Number	Numeric	Employee ID or account number
Primary Contact	Text	Name of employee’s primary emergency contact
Secondary Contact	Text	Name of employee’s secondary emergency contact
Primary Contact Relation	Text	Relationship of primary emergency contact to employee
Secondary Contact Relation	Text	Relationship of secondary emergency contact to employee
Home Address Line 1-4	Alphanumeric	Lines 1-4 of employee’s home address
Home City	Text	City of employee’s home address
Home State	Text	State of employee’s home address
Home Postal Code	Numeric	Postal code of employee’s home address
Home Country	Text	Country of employee’s home address
Is Active	Yes/No	Indicates if the employee is currently active

Customizing Your Import with Import Settings

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 process and ensure the data is imported exactly as needed.

Troubleshooting and FAQs

Here are some common questions and issues users might encounter when importing employee data:

Q: I made mistakes during the import process, and my QuickBooks reports are now incorrect. Can I undo or revert the import?

A: Yes, Dancing Numbers provides a Delete feature that allows you to partially or completely undo an import. This feature helps maintain the integrity of your QuickBooks data.

Q: Does Dancing Numbers support tax-related fields?

A: Yes, the application supports tax-related fields for employee data.

Q: My Excel file uses a different date format. Do I need to change it before importing?

A: Dancing Numbers requires dates to be in the MM/DD/YYYY format. You may need to adjust your Excel file to match this format before importing.

Q: Are there sample templates available for employee data import?

A: Yes, Dancing Numbers provides sample templates to help you format your data correctly. You can access these 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.

Best Practices for Importing Employee Data

To ensure a smooth and accurate import process, consider these best practices:

1. Prepare Your Data: Ensure your Excel file is clean, formatted correctly, and contains all necessary information.
2. Use Sample Templates: Utilize the provided sample templates to understand the correct format for your data.
3. Backup Your QuickBooks File: Always create a backup of your QuickBooks company file before performing a large data import.
4. Test with a Small Dataset: If you’re new to the process, start by importing a small subset of your employee data to familiarize yourself with the process.
5. Review Carefully: Take time to review the data mapping and preview screens to catch any potential errors before they are imported into QuickBooks.

Getting Help

If you encounter any issues or have questions during the import process, Dancing Numbers offers dedicated support:

• Email Support: Contact support@dancingnumbers.com for assistance.
• Support Center: Visit the Dancing Numbers Support Center for comprehensive guides and FAQs.

---

---