Multiple Pay Rates Project Tracking
TSheets does not give me an option (that I am aware of) to put an Employee's 2nd Pay Rate in for my employees who are working out of state for some Projects.
*TSHEETS: When employee's are to be paid their "Original" Pay Rate, they will select the "Labor" service item. When the employee's are to be paid their Second Pay Rate, they well select the "Out of State" service item.
*QUICKBOOKS ONLINE: When time is exported from TSheets to QBO, all Regular Time is listed under the employee's Original Regular Pay Rate and all Overtime is listed under the employee's Original OT Rate. I have to manually adjust the hours in each pay rate box in order for the employee to be paid correctly.
>>FOR EXAMPLE:
*Total Hours: 50 (40 Regular, 10 Overtime)
| Original (REG) Pay ($10/hr) | Original (OT) Pay ($10/hr) | Out of State (REG) Pay ($20/hr) | Out of State (OT) Pay ($30/hr) |
| 10 Hours | 5 Hours | 30 Hours | 5 Hours |
**TSHEETS REPORT: Based on the example above, Tsheets will show ALL "REG" Hours (40) under the "Original (REG) Pay Rate ($10/hr) and ALL "OT" Hours (10) under the "Original (OT) Pay Rate." The only clarification it will show is the service item beings that all "Original Pay Rate Hours" are listed under the "Labor" Service Item and all "Out of State Pay Rate Hours" are listed under the "Out of State" Service Item.
**QBO EXPORT (PAYROLL): ALL hours will be exported into the "Original (REG)/(OT) Pay Rate" just as explained in the TSheets Report above. This is where I have to manually adjust the hours in each pay rate box for the employee to be paid correctly. ****WHICH I BELIEVE THIS IS CAUSING A PROBLEM WHEN I REVIEW MY PROJECTS IN QUICKBOOKS ONLINE. I DONT BELIEVE THE CORRECT PAYROLL COSTS ARE LISTED WITHIN EACH PROJECT IN QUICKBOOKS.
Is anyone else having this issue?
Is there some sort of solution to have each pay rate allocated and exported correctly to QBO as it should?
Is there a way to make sure the Payroll costs within each job are correct and showing what was actually paid to the employee for the hours and rate on each project?