Payroll timesheet imports

  • 1
  • Question
  • Updated 7 months ago
  • Answered
I have imported payroll timesheets into QB, the problem I am having is that it is making blank lines (setting up new blank employees) is there a way around this?  And how do I delete the blank employees?  Any help is greatly appreciated.
Photo of Sarah Johnston

Sarah Johnston

  • 304 Points 250 badge 2x thumb

Posted 7 months ago

  • 1
Photo of Sarah Johnston

Sarah Johnston

  • 304 Points 250 badge 2x thumb
LOL I have found my answer, if anyone is interested you need to delete the activity and then you can delete the blank employee.
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,632 Points 5k badge 2x thumb
We had this issue when importing payroll data from Wageloch.... the problem turned out to be in the employee names...  the name has to be exactly as per Reckon - and in this instance - we had to remove the initials in Reckon as Wageloch wasnt able to provide a middle initial... also, if the setting in Reckon is Last name first - then the import file needs to show as LASTNAME, Firstname - otherwise it will create new employees...  in order to delete the blank employees - what I did first was edit one and give it a name of say A... then I edited the others and also called them A and said yes to merge them... once I only had one - then I needed to find and delete all timesheets for the employee A - then I could delete Employee A... hopefully this makes sense and helps you?
Photo of Sarah Johnston

Sarah Johnston

  • 304 Points 250 badge 2x thumb
Thanks Linda, there is a report you can do to show all the Timer Activity.   Reports > Jobs Time and Mileage > Time by Name.  Then sort by blanks and delete the Timer Activity and then you can delete the blank employees.