Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
January 18, 2019
Question

Payroll Summary Report - Rate Column

  • January 18, 2019
  • 2 replies
  • 19 views

Does anyone know how QB calculated the rate in the rate column on the payroll summary report? It isn't an average. I've attached a small example to refer to. If you look at the salary rate here it is 22.83, but on the very next payroll with no other changes it is 34.95. The total pay was exactly the same.

2 replies

January 18, 2019

It uses the last rate it finds on the most recent paycheck for each employee for each item.

January 18, 2019

I understand that is what happens for the report when you display each employee, but this is the report with the only column being the total.

January 18, 2019

RE: but this is the report with the only column being the total.

??

Sorry, I don't understand what you mean.

January 28, 2020

Did anyone solve this issue as to why the rate is continually incorrect?

When calling into QB, they do not seem to be able to assist. Please advise. Thank you.

QuickBooks Team
January 28, 2020

Let's investigate what's causing the incorrect employee's rate showing in the Payroll Summary report, RR20.

 

I've check here on our end and there's no reported case about this one. Whatever the rate you set up in the employee's profile will be the default rate for the paychecks. Then, this rate will be reflected on the report based in the applied rate on paychecks.

 

It's possible the rate was changed in the employee's paycheck. To better isolate this issue, let's run the Audit Trail report to check who and when the rate was modified into a different one.

 

Here's how:

 

  1. Click Reports on the top menu.
  2. Choose Accountant & Taxes.
  3. Hit Audit Trail.
  4. Manually changed the date period.
  5. Look in the Last modified by and Date column to trace of who and the changes was made.
  6. Double-click the transaction to see the full details.

You can also run Employees Pay Adjustments History report to track the employees' pay rate changes over a period of time. Just check out this article for the steps and details: Employee Pay Adjustments History Report.

 

Please touch-based with me if you need a hand with running other payroll reports or any QuickBooks related. I'll be here to help.

January 28, 2020

It's the average rate that is not calculating correctly.  It is never the actual average when you divide the # hours into the Gross $ payroll.