Oregon Quarterly Form 132 shows inaccurate work hours

I can see that you're having data issues with your tax forms for the state of Oregon, SheelaAC. I'm here to assist you and ensure that you can file them accurately with the correct information.

The Payroll Summary report and Form 132 should have matching hours as they share the same source. When you process payroll, it populates the hours worked from the employee's paycheck details in both areas.

So if you notice a discrepancy between the hours on these two reports, it likely means there's inconsistent data on the actual paychecks. Double-check that the hours on the paychecks for the quarter match what you expect to see on the reports.

You can also use the QuickBooks Tool Hub to help us identify and fix small data errors that can be causing the discrepancies. The Tool Hub comes with utilities that can scan for and repair corrupted or incorrect data that could lead to discrepancies like payroll hour differences. By running these tools, you can sync up small data inconsistencies and improve the accuracy of your QuickBooks data.

Let me show you how:

1. Download the most recent version (1.5.0.0) of the QuickBooks Tool Hub.
2. Open the file you downloaded (QuickBooksToolHub.exe). You can look it up in your Downloads folder or in the location you selected when you downloaded it.
3. Follow the on-screen steps to install and agree to the terms and conditions.
4. Double-click the icon on your Windows desktop to open the tool hub.
5. Once opened, look for Program Problems, then select Quick Fix my Program.
6. Start QuickBooks Desktop and open your data file.

For additional details on using the QuickBooks Desktop Tool Hub to fix various errors and data issues, feel free to check out this article: Fix Common Problems and Errors With the QuickBooks Desktop Tool Hub.

After that, go back to the Form 132 to check if the number of hours is already similar to your Payroll Summary report. 

Let me also share this comprehensive year-end checklist for QuickBooks Payroll that covers all the steps for payroll year-end processes: Year-end Checklist For QuickBooks Desktop Payroll.

This guide walks through key tasks like preparing annual filings, issuing W-2s, closing the payroll year, and more. Having a detailed checklist can help ensure you complete everything required.

Please feel free to reference this if you need a thorough walkthrough of payroll year-end to-dos, SheelaAC. The QuickBooks Community is always here if you have any other payroll questions come up. Let me know how else I can assist as you wrap up 2023 taxes and payroll.

@SheelaAC 

RE: The hours showing on the Quarterly Report for some of the employees do not match what is on the payroll summary. The payroll summary IS accurate the quarterly report is inaccurate. There are about 15 employees that worked varying hours but all worked 100 hours or more. On the "Whole Hours Worked" column of the Form 132 for 4th quarter Oregon Quarterly Report it shows some of the employees as working only 6 hours. I can't figure out why this is happening. 

The instructions for the form say to report hours worked in the quarter, not hours paid in the quarter, and point out that these are two different things:

----------------------

Box 1c. Hours worked during this quarter. Enter the number of hours each employee worked in the quarter. If you don’t track hours for a full time employee, use 520 hours for the report. For fractions or portions of an hour worked by an employee, round up any portion of an hour to the nearest whole hour. Report the actual number of hours worked, both straight time and overtime. Don’t report hours paid for sick leave, vacation leave, or any other hours paid where no work was performed. Even though these hours aren’t reported in box 1c, wages paid
are still included in the subject wages in box 1g. Although you report wages in the quarter they are paid, report hours in the quarter they are worked.

----------------------

I have not verified this for the Oregon form because I'm not set up to do so, but I suspect that, like other some other forms, because of these instructions the form code is pulling hours from paychecks based on the pay period, not the check date.

You can check by reviewing the paychecks for the employees that look wrong, especially those paychecks on the cusp of the quarter (just after the quarter starts) and then add up the hours for all the paychecks where the pay period includes the quarter start date.

For the employee you mentioned was paid for 100 hours or more but only has 6 hours on the report, I suspect that the first paycheck in the quarter had a pay period that didn't include the quarter. Or maybe more than one paycheck.