Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello @Lisa galvin,
Thank you for reaching out to us here in the Community about importing payroll data. Allow me to chime in and help you upload the list in QuickBooks Desktop.
Currently, you can only import customers, vendors, items, and Chart of Accounts from an Excel spreadsheet. For the employee information, you'll need to use an IIF file.
As a workaround, you can open the file using Microsoft Excel and convert it to IIF. You can reach out to the Microsoft Support Team for further assistance with changing the file format.
Another option would be to use a third-party application that offers assistance with uploading employee data. I've found an app that allows users to import information using an Excel file.
Though, we can't suggest which app is best to use, you can visit the links below for more information. These websites contain the details you need to determine if it works best for you:
For more information about IIF files, as well as some sample files you use as a reference when importing data in the future, I recommend the following article: IIF Overview: import kit, sample files, and headers.
Please drop me a comment if you need anything else related to importing payroll information or the availability of the features. The Community and I will be here to help you.
I transferred the employee files over everything is great with the and address ss# however none of the direct deposit information was transferred nor any of the individual deductions. Is it possible to transfer those?
I appreciate your time getting back to us, judy28479.
Payroll transactions including direct deposit information is not included in transferring employee information. You'll want to re-enter this information in the employee setup.
Here's how:
You can have this article handy to guide you through the whole process of setting up direct deposit information for your employees: Set up direct deposit for employees.
To learn more about the items you can import and how to map the data, see this article: Import and export data in QuickBooks Desktop.
Also, you can check out these articles for tips that will make navigating around QuickBooks even easier: QuickBooks Desktop Help Articles.
Please know that you're always welcome to come back to this thread if you have other questions or concerns about the program. I'll be happy to answer them for you. Take care and have a good one.
Sorry to bother a Desktop topic but I have a question about QB Online .... My Desktop Enterprise "target" size is too large to be transferred into Online directly, I will have to "manually" transfer Lists (Vendors, Customers, Accounts), but can I transfer the employee's list and its transactions too ? Thanks
I appreciate you joining this thread, EHHC.
The option to transfer employees' lists and their transactions are unavailable in QuickBooks Online.
You'll need to enter them manually or you can look for a third-party application that allows you to employees' list as well as their transactions in QuickBooks. Here's how:
QuickBooks displays the list of applications available that match the description you entered. Once you find the right app, click on it to open it.
You can also visit this link for a better view: https://apps.intuit.com/. From there, you can find different apps that are compatible and designed to work with QuickBooks Online.
Additionally, you can check this write-up to know what data can be moved into QuickBooks Online: What to expect when you switch from QuickBooks Desktop to QuickBooks Online.
Stay in touch if you have any follow-up questions. Just add a comment by clicking the Reply button below and I'll be sure to get back to you. Have a great day!
But I need it in CSV or excel format??
Thanks for checking in with us, @TViega.
If you are trying to import and export info in QuickBooks, we can do it through CSV files or with MS Excel files. Since we can't undo info you import, let's make a backup just in case. To import a list in the CSV format, we'll need to install the QuickBooks Import Excel and CSV toolkit. The toolkit contains:
Then, follow the next step in this article: Import/export CSV files. To import and export QuickBooks data with MS Excel files, just check out this article: Import or export MS Excel files. Other ways to import and export info in QuickBooks are the following:
Keep in touch if you need any more assistance with this, or if there's something else I can do for you. I've got your back. You have a good one.
Hi I am trying to import an employee iif list into QBDT but I am getting an error ENDQBPEMP is not a valid record, any idea what the right syntax would be?
Does the employee have a valid social security number?
Yes, the list is coming from another QBDT company. There seems to be something with the syntax, the same way Bill Payments checks need to be modified as regular check when importing.
Thank you for following up on this thread, AccountantUser1.
I understand how frustrating it can be to encounter errors when trying to import data. Let's work together so you can successfully move the information to QuickBooks.
When importing your employees' list, make sure the format is correct to ensure you can bring them to your other QuickBooks company successfully. Let's download the.IIF import kit to save time and improve your results. You can also download the sample.IIF files to practice or use as templates for importing transactions into the desktop program.
Here's how:
I've got some handy resources that cover basic information about the IIF tool:
In addition, these resources include instructions on how to bring your employee data to another QuickBooks company as well as a checklist to prepare for the upcoming year-end filings:
If you still need further assistance importing your employee list or have other QuickBooks concerns, including your payroll, leave a comment below and tag my name. I'll help you the best that I can. Have a good one, @AccountantUser1
I am trying to transfer employee data (address, phone numbers etc) from one company file to a second one and I am trying to use IIF to do that. The problem I am encountering is with the Date Of Birth field. Apparently recently it became a required field in quickbooks HOWEVER the export is not pulling out date of birth and its not importing it either. With birthdate being a required field I am getting warnings on all the employees that I imported. Is there a fix for this so I dont have to touch each employee manually?
Thanks in advance.
You can use the exporter tool and will get your Employee List data with the following template
First Name | Last Name | Middle Name | Is Active | Salutation | Print on Check | SS No | Gender | Date of Birth | Date Hired | Date Released | Address Line1 | Address Line2 | Address City | Address State | Address PostalCode | Phone | Cellular | Alt. Phone | Fax | Pager | PIN (Pager) | Account Number | Notes | |
Karen | Smith | L. | Y | Ms | Karen L. Smith | F | 01/12/1970 | 18 Main Street | Apt 11 | Anytown | CA | 12345 | 1234567890 | 9998887777 | 7778889999 | 9876543210 | [email address removed] | (123) 456-7890 | 12345 | 888 | ||||
John | Doe | N. | Y | Mr | John N. Doe | M | 01/01/1990 | 100 South Street | Newton | AZ | 11111 | 1234567890 | 9998887777 | 7778889999 | 9876543210 | [email address removed] | (123) 456-7890 | 54321 | 999 | |||||
Jane | Smith | A. | Y | Mrs | Jane A. Smith | F | 05/02/1985 | 18 West Street | Cali | CA | 99999 | (999) 888-7777 | [email address removed] | |||||||||||
Kim | Burns | L. | Y | Kim L. Burns | F | 13/12/1966 | 1 North Street | Apt 213 | Phoenix | AZ | 88888 | (111) 222-3333 | [email address removed] |
then use the importer tool on your new company file to proceed. It's a one time license
https://get.transactionpro.com/qbd
Thank you for joining this thread, HR54boss.
Aside from following 4Gal suggestion, I have other options to make your employee birth date export successfully to your other company by using the Import it for me. I'll fix it later. Here's how:
This will allow you to import the.IIF without QuickBooks doing the usual check for the file. Our IIF Overview is a great resource as well.
Should you need additional assistance in importing your employee information in QuickBooks Desktop, feel free to include them in the comments below. Stay safe!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here