cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Projects module: How to reconcile the employee's per-hour cost with his/her actual total payroll cost (wage/salary, payroll taxes, etc) on the general ledger? By hand?

 
Solved
Best answer 06-05-2019

Accepted Solutions
QuickBooks Team

Re: Projects module: How to reconcile the employee's per-hour cost with his/her actual total payr...

Welcome to the Community, @istracion.


At this time, reconciling the employee’s per hour cost versus the actual total payroll expenses is unavailable. You can run two reports in QuickBooks Online and print them instead to compare the amount.


Pull up the Profit and Loss Report to view Payroll Expenses. Here’s how:

  1. Go to the Reports menu.
  2. Enter Profit and Loss on the Search box or look for it under Business overview section.
  3. Update the Report period.
  4. Look for Payroll Expenses and click the amount for Wages.

payroll expenses 2.PNG payroll expenses 1.PNG

 

Once done, you should see the total wages per employee. Right after, run the Time by Employee Report to manually reconcile the data. 


Follow the steps below:

  1. Open the project.
  2. Go to the Project Reports tab.
  3. Click View beside Time Cost Employee or Vendor.

time activity 1.PNG time activity 2.PNG

 

For reference, check out these articles: 

That should do it. Let me know how this goes or if you need further assistance. I’m always here to help. Have a pleasant day ahead!
 

View solution in original post

2 Comments
QuickBooks Team

Re: Projects module: How to reconcile the employee's per-hour cost with his/her actual total payr...

Welcome to the Community, @istracion.


At this time, reconciling the employee’s per hour cost versus the actual total payroll expenses is unavailable. You can run two reports in QuickBooks Online and print them instead to compare the amount.


Pull up the Profit and Loss Report to view Payroll Expenses. Here’s how:

  1. Go to the Reports menu.
  2. Enter Profit and Loss on the Search box or look for it under Business overview section.
  3. Update the Report period.
  4. Look for Payroll Expenses and click the amount for Wages.

payroll expenses 2.PNG payroll expenses 1.PNG

 

Once done, you should see the total wages per employee. Right after, run the Time by Employee Report to manually reconcile the data. 


Follow the steps below:

  1. Open the project.
  2. Go to the Project Reports tab.
  3. Click View beside Time Cost Employee or Vendor.

time activity 1.PNG time activity 2.PNG

 

For reference, check out these articles: 

That should do it. Let me know how this goes or if you need further assistance. I’m always here to help. Have a pleasant day ahead!
 

View solution in original post

Not applicable

Re: Projects module: How to reconcile the employee's per-hour cost with his/her actual total payr...

Thanks for the quick answer.  I also found this other post, which is related to the same thing: Project Expenses Associated with Payroll

 

For businesses in the service industry having salaried employees, this kind of functionality is essential.  Here's a suggestion, as a small step in this direction: when changing the hourly cost of an employee (in Projects), offer the option to automatically recalculate all existing hours in the timesheets (say, from a given date onwards, or even for a provided time window).  As fas as I've been able to tell, QBO doesn't recalculate this automatically, and you have to re-enter the timesheet.

 

Need to get in touch?

Contact us