cancel
Showing results for 
Search instead for 
Did you mean: 
WEP1932
Level 1

Payroll Summary Report doubled hours

Printed out the Payroll Summary report to do payroll taxes and for some reason it doubled the employee hours, deductions, etc. in the report.

When I check the actual employee record, the timesheet the hours, paycheck, everything seems to be correct.

I don't know where the problem is originating, so, can't figure out how to correct it.

 

Thank you in advance for any help .

5 Comments 5
JaneD
Moderator

Payroll Summary Report doubled hours

Hi WEP1932.

 

The Payroll Summary report contains the total hours and summary of payroll by paycheck date. You might want to check each paycheck to see if there are items with hours without a rate. Hours entered on the paycheck will also be included in your payroll reports.

 

  1. On the Payroll Summary report, double click on the amount associated with the hours.1.PNG
  2. Click on the Customize Report button in the Transactions by Payroll Item window.
  3. Type in Pay Period under Columns. Then, mark to select Pay Period Begin Date and Pay Period End Date.3.PNG
  4. Click on OK.
  5. To check if there are duplicate paychecks created, review the Pay Period Begin Date and Pay Period End Date columns.5.PNG
  6. Then, double-click on the amount to see the detailed information of each paycheck. 
  7. Click on the Paycheck Detail button and review each item with hours.

I'm adding an article that you can learn more about customizing payroll and employee reports in QuickBooks.

 

Once done, it's a great idea to memorize the report. This helps save the same settings of the customized report for reuse.

 

We'll fill you in if you have any additional questions. Have a great day.

WEP1932
Level 1

Payroll Summary Report doubled hours

Thank you so much for responding...but, as far as I can see it looks like the checks are correct.

I'll have someone else double check just to make sure I'm not missing anything.

 

Ashley H
QuickBooks Team

Payroll Summary Report doubled hours

Thanks for the follow-up, @WEP1932.

 

I'll keep a lookout for your response after they've double-checked your Payroll Checks. If you see any errors or need further assistance, please let me know. I'm just a Reply away! Talk to you soon.

dsquaredelectric
Level 1

Payroll Summary Report doubled hours

Hi Ashley,

 

We are also experiencing the same issue with our payroll summary report.  All filters look fine however the hours shown on the summary report are not quite doubled but are close like maybe there is also an issue with rounding hours within the totals plus the doubling up on hours and dollar amount totals.

ChristieAnn
QuickBooks Team

Payroll Summary Report doubled hours

Hi there, dsquaredelectric.

 

The rounding numbers show in the reports accept a maximum of two decimal places. That said, the system will automatically round off/round-up from the original amount. If the discrepancies with the rounded hours and totals are different, this is due to round off/round-up.

 

However, if the rounding amount is bigger than the original amount, you'll have to check each paycheck to see if there are items with hours without a rate. Hours and amounts entered on the paycheck will also be included in your payroll reports. As mentioned above, the Payroll Summary report contains the total hours and summary of payroll by paycheck date.

 

If the issue persists, I recommend running the Verify/Rebuild tool. This helps identify the most commonly known data issues within the file and resolves it.

 

Before we begin with the troubleshooting, you'll have to secure a backup of your company file. Once done, we can proceed to verifying and rebuilding your data in QuickBooks Desktop. I'll guide you how:

 

Here’s how to verify:

 

  1. Go to the File menu.
  2. Select Utilities.
  3. Click Verify Data then select OK to close all windows.

 

To rebuild:

 

  1. Go to the File menu.
  2. Select Utilities.
  3. QuickBooks will ask to make a backup before rebuilding your company file, select OK.
  4. Once the rebuild is done, click OK.

 

For more details in verifying and rebuilding your QBDT, you can check out this article for reference: Verify and rebuild data in QuickBooks Desktop.

 

To learn more about how to personalize your reports with formats and details you want, please feel free to check out this article: Customize reports in QuickBooks Desktop.

 

Once done, click Memorize to save its current customization settings. Doing so will help you quickly access the report in the future.

 

 Please let me know if there's anything you need help with with QuickBooks. I'll be happy to work with you anytime. Have a good one!

Need to get in touch?

Contact us