Skip to main content
D
DBG JWCDS
August 16, 2021
Question

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

  • August 16, 2021
  • 2 replies
  • 0 views

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 replies

BigRedConsulting
BigRedConsulting
August 16, 2021

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
Fiat Lux - ASIA
August 16, 2021

@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

 

Terms & ConditionsAccessibility statement