cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
DBG JWCDS
Level 1

How do I import employee information from excel into quickbooks desktop?

I have over 500 employees in my previous software that need to exist in my new quickbooks file. I can get all of my employee info into excel just as I did with everything else but i cannot figure out how to import that info from excel into Quick Books desktop

2 Comments 2
BigRedConsulting
Community Champion

How do I import employee information from excel into quickbooks desktop?

QuickBooks allows for the import of basic employee information - like name and address - using an IIF file.

Convert your excel worksheet into an IIF file using our BRC List Importer .

Fiat Lux - ASIA
Level 15

How do I import employee information from excel into quickbooks desktop?

@DBG JWCDS 

Prepare your Employee List data with the following template

First NameLast NameMiddle NameIs ActiveSalutationPrint on CheckSS NoGenderDate of BirthDate HiredDate ReleasedAddress Line1Address Line2Address CityAddress StateAddress PostalCodePhoneCellularAlt. PhoneFaxEmailPagerPIN (Pager)Account NumberNotes
KarenSmithL.YMsKaren L. Smith F01/12/1970  18 Main StreetApt 11AnytownCA123451234567890999888777777788899999876543210[email address removed](123) 456-789012345888 
JohnDoeN.YMrJohn N. Doe M01/01/1990  100 South Street NewtonAZ111111234567890999888777777788899999876543210[email address removed](123) 456-789054321999 
JaneSmithA.YMrsJane A. Smith F05/02/1985  18 West Street CaliCA99999(999) 888-7777   [email address removed]    
KimBurnsL.Y Kim L. Burns F13/12/1966  1 North StreetApt 213PhoenixAZ88888(111) 222-3333   [email address removed]    

 

then utilize an importer tool

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us