cancel
Showing results for 
Search instead for 
Did you mean: 
Sara-CO
Level 1

Import Employee Data?

It looks like I need to enter each employee into QB Enterprise separately, I can't upload/import, correct? If I already have them in T-Sheets, can I do it that way?  

 

Speaking of T-Sheets, I need to set up my QB first, and then it pushes the fields the employees can select from in T-Sheets, right?  I need to ensure our crew can choose a job, a piece of equipment, and a job task (What I believe QB calls an item?). 

Thanks!

4 Comments 4
Fiat Lux - ASIA
Level 15

Import Employee Data?

You may utilize an importer tool to import Employee List

https:// transactionpro.grsm.io/qbd

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

 

Prepare the 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]    
MonicaM3
Moderator

Import Employee Data?

Hey there @Sara-CO,

 

Hope your day has been going great! You’re absolutely correct in the fact that you should set up all items in your QuickBooks first, and then sync them over to TSheets. If you have any employees or items created in TSheets, you must create the same item in QuickBooks, and the names must match EXACTLY, no extra spaces, punctuation, letters must all be in the same format (upper/lower case) in order for them to sync or export properly.

Once you have all of the items and employees set up and sync them, your employees will be able to select them in TSheets.

There ya go! Let me know if you have any other questions or run into a snag, I’ll be here to help.

Sara-CO
Level 1

Import Employee Data?

Thanks, Monica!  We've been using T-Sheets for about 2 years, but entered the employees time into a different billing system.  Now that we're setting up QB, it seems like it might be best to start from scratch with T-Sheets.  I see too much opportunity for error trying to copy info over from T-Sheets to QB.

 

We've been using the custom fields in T-Sheets to have the guys select what job task and piece of equipment they're using.  Example, using an excavator to demo a house.  Moving forward in QB, would our equipment be set up in the Class?  That would give the guys the opportunity to select what equipment they're using, and it would show up in QB when we want to invoice or pull a job costing report?

 

For the job task, (demolition, sewer line install, etc.) that would that be the service item, right? 

Kristine Mae
Moderator

Import Employee Data?

Let's go over to your questions, Sara-CO.

 

Concerning the custom fields, you can set them up as classes in QuickBooks Online. It lets you create segments in the company that can provide you clear insights on your sales, expenses, or profitability. You can check this article for more information: Create and manage classes in QuickBooks Online.

 

Then, for the job task, you can create it as a service item. You can add it to any sales form. For more details, refer to this article: Add product and service items to QuickBooks Online.

 

If you have additional questions, please don't hesitate to let us know. Keep safe!

Need to get in touch?

Contact us