How to Import Employee List into QuickBooks Online using Dancing Numbers Online?

Importing employees in QuickBooks Online is a task when you want to import it in bulk. It took a lot of time if you do it manually. The easy way to do it is automatically and also in multiple numbers. The automatic way is to import the employee list into QuickBooks Online using Dancing Numbers Online software. Dancing Numbers Online software helps you to do it automatically after providing the required data. The time it takes is less than the time of the manual process. In Dancing Numbers Online software the total time depends on the size or number of data you are importing.

What are the Requirements Before Processing the Import Process?

Connect QuickBooks Online to Dancing Numbers Online via QuickBooks AppStore. Just click on “Get App Now” to start using the Dancing Numbers Online application program. You can also start the 7 Days Free Trial if you are not subscribed for Dancing Numbers Online yet.

Steps to Import Employee List into QuickBooks Online using Dancing Numbers Online

For importing employee lists properly and automatically follow the below-mentioned process. After this process, it automatically imports the data into your QuickBooks Online account.

• Upload: After signing in to Dancing Numbers Online using your QuickBooks Online credentials, you have to click on the Import button to start the import process. Select option Employee after that choose the file of the employee list to upload the excel file.
• Mapping: It is required to map the rows and columns of data according to QuickBooks Online data format so that all the data is imported in the right place.
• Import: When done with the above process, click on the Import button and it automatically imports the employee list into QuickBooks Online.

Dancing Numbers Online Fields of Importing Employee List

Field Name	Format	Description
Title	Characters	Mention the employee’s title.
First Name	25 Characters	Provide the employee’s first name.
Middle Name	25 Characters	Write down the employee’s middle name.
Last Name	25 Characters	Mention the employee’s last name or family name in this field.
Suffix	10 Characters	Mention the suffix if any used for the employee name.
Display Name As	100 Characters	The Display name of the employee or organization must be unique from all other employees, employees, customers, and any other names.
Print On Check As	100 Characters	Mention the employee or organization name that is printed on the check. If you won’t mention it then it is populated from the Display Name.
Address Line 1	500 Characters	This is the 1st line to mention your Billing address where you are living.
Address Line 2	500 Characters	This is the 2nd line to mention your Billing address where you are living.
Address Line 3	500 Characters	This is the 3rd line to mention your Billing address where you are living.
Address City	255 Characters	Write down the city name where you are living.
Address Postal Code	31 Characters	Write the Postal code that is the zip code for Canada or USA.
Address Country	255 Characters	Provide the Country name in which you are living.
Address State	255 Characters	Mention the state in which you are living. For example Province name for Canada or State name for the USA.
Phone	21 Characters	Provide the telephone number if any in free form.
Mobile	21 Characters	Mention the mobile number of employees in free form.
Fax	21 Characters	Write the fax machine number in free form.
Other	21 Characters	Any other information like phone number, email, address, etc.
Email	100 Characters	Enter the email address of the employee.
Employee Number	99 Characters	Employee’s ID of organization.
SSN	Characters	Mention the Employee’s SSN (Social Security number). In case the SSN is already set then masked it in the response with XXX-XX-XXXX. If it is sent in the update or creates a request then you can be ignored and its old value is preserved. This is the attribute that is not passed into the request when the QuickBooks Payroll is enabled.
Billable Time	Boolean	This Employee is currently enabled for use by QuickBooks.
Billable Rate	Decimal	The amount that is not paid or the open balance of the employee is written here.
Gender	Characters	Mention the gender correctly of the employee.
Notes	2000 Characters	Employee’s description is the free form text.
Hired Date	Date	Employee’s hire date on which you hire the employee into your organization.
Released Date	Date	Mention the Release date of the employee correctly.
Birth Date	Date	Write the Date of birth of the employee.

Let’s import the Employee list altogether automatically. For any queries connect with the expert team via email at support@dancingnumbers.com or LIVE CHAT to fix them quickly.

---

Frequently Asked Questions (Faqs)