How do I upload my employees payroll details to intuit quickbook?

Questions
1

I have the details of my employee payroll in an excel sheet. The columns in it are pretty simple. They look something like this:

Company Code Employee ID Employee Name Rate per hour Total Hours worked Total Amount

Now, I would like to upload this information to intuit quickbook. I have already created employees on there. I would just like to upload the information based on either the name of the employee, or preferably using the Employee ID.

I don’t want to use quickbooks employee ID to do this. What are my possible options? How can I do this?

2

Hey @Hamza4 , can you share screenshots…

3

If you do not want to use Quickbook EmployeeID, you must use one of the following methods:

  • Create an intermediate database that will map Employee IDs from your table to Employee IDs in QuickBook or use switch() function (more complex to maintain)
  • Search for the employee in QuickBooks to get the ID first and then use it to make updates.

There is no other magic way, as any system must know exactly what it needs to update. And you either provide it or search for it.