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 .
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.
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.
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.
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.
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:
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!