WHY ARE MY TAX AND WAGE REPORTS NOT MATCHING WITH PAYROLL SUMMARY?

A warm welcome to the Community, rancan500.

It will be my pleasure to help you figure out why your tax and wage don't match with your payroll summary report in QuickBooks Online.

Payroll Summary displays employee's total wages, deductions, contributions, and taxes. While the Tax and Wage Summary report shows the total subject wages, excess wages, and taxable wages by tax type. 

The amounts on your reports may be different or overstated due to  different date ranges. You may want to ensure they have the same dates.

I recommend customizing the report to get the specific details you need. You can visit this write-up for the outlined steps: Customize reports in QuickBooks Online.

Additionally, can I ask which specific column you're trying to match? I want to make sure I've got you covered.

Feel free to get back to the Community team if you have additional questions. We'll be right here to help. Have a good day!

Hi, rancan500.

Hope you're doing great. I wanted to see how everything is going about the payroll reports you had yesterday. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I'd be happy to help you at anytime.

Looking forward to your reply. Have a pleasant day ahead!

when i print my NCUI-101 (Tax & wage) from the file form tab under payroll the amount that says is owed is different than the Pay liabilities tab to write the check for a certain amount. how can they be that big of a different almost a hundred dollar difference. Any suggestion?   It was correct for my 2 quarter for both sections 

Hello there, @krissy.

There are times that the stored cache and cookies in your browser get corrupted, causing unusual behaviors, like runtime errors and unresponsive pages. 

Start by accessing QuickBooks in an incognito or private browser. You may use these keyboard shortcuts to launch the window:

• Ctrl + Shift + N for Google Chrome

• Ctrl + Shift + P for Mozilla Firefox and Microsoft Edge

• Command + Shift + N for Safari

Once you're in, try to print your NCUI-101 again with the steps above. If it's now working, you'll have to go back to your regular browser and then clear the cache to get rid of the junk files. You can also use other supported browsers as an alternative.

I've also added this link about customizing the report to get the specific details you need: Customize reports in QuickBooks Online.

Please let me know how it goes or if I can be of additional assistance. I'm only a post away to assist you always.

Sorry I should have mentioned, I use Desktop pro plus 2021. 

Thanks for coming back and providing us information on the QuickBooks version you're using, krissy.

QuickBooks Desktop payroll works best when all payroll activity is performed from within the payroll menus and it includes paying accrued payroll taxes to the respective taxing authorities. If you write checks or use the Enter/Pay Bills to pay for the liabilities and the QuickBooks-created Payroll Liabilities account was assigned, a warning message will pop up. This will not prevent you from using the wrong type of payment (i.e., Write Checks or Enter/Pay Bills) when paying payroll liability. To resolve this, follow the steps below:

1. Back up the Company file.
2. Go to Write Checks or Bill Payment and use the Previous and Next keys to locate the payment. Note the amount paid and the expense account used.
3. In the Payroll Center, go to the Pay Liabilities tab and select the overdue liability that was paid through Write Checks.
4. Select the View/Pay button, which brings up the liability check. Then, choose the Expense tab.
5. In the Account column, tap the drop-down arrow and choose the account used in Write checks. In the Amount field, enter a negative amount equal to the amount of the liability check. If the liability shown as being owed was only partially paid through Write Checks, enter the actual amount paid through Write Checks as a negative instead of the whole amount shown as being owed.)
6. Tick the Recalculate button to zero the check amount.
7. Uncheck the To be printed box.
8. If the check number field populates, remove the check number.
9. Date the transaction to be the same date as the payment that was already entered into the QuickBooks Desktop bank register.
10. Press Save, then Close.

You can check out the Scheduled liabilities payroll show as overdue or in red article for other scenarios and how to troubleshoot them. After the process, you can review your balance sheet report and the payroll liability window if the dues are now correctly posted. 

Feel free to visit our Payroll page for more insights about managing your payroll transactions on the software. 

I want to make sure everything is taken care of for you, please let me know how it goes or if you have any other issues or concerns. Just leave a comment below and I'll get back to you. Take care always.

Can someone explain to me why my total gross wages are not matching my 941s and Twc report I was told by my accountant they should be the same number at the end of each quarter

Hi there, kathyewhite.

I just wanted to let you know that my colleague responded to your other post. In order to keep the conversation streamlined and provide you with the best resolution, I'll ask that you post any follow-ups there.

Just in case you haven't been notified of the new response, here's the link: https://quickbooks.intuit.com/learn-support/en-us/taxes/re-texas-unemployment-tax/01/1123537#M18891

Lastly, I'm also adding this article to see several payroll reports you can use to view useful information about your business, employees, and payroll taxes: Run payroll reports in QuickBooks Online Payroll. 

Please let me know if you have other questions or concerns related to QuickBooks. I'll be here every step of the way. As always, you can post again to the QuickBooks Community anytime you need a helping hand. Take care, kathyewhite.

I am having this same problem and more. I have Quickbooks Desktop Pro 2023. On the 941 tax form the total wages on line 2 are way off, by over $1,000.00. The federal income tax withheld matches the summary, and the tax liability paid all matches on schedule B. Also, one person's wages show less on unemployment total wages paid by $102.96 than on first quarter payroll summary. While paying the unemployment tax due I fixed it on that before submitting but today am finding this issue with the 941. 

Welcome to the Community. I'm delighted to assist you with your first post on our forum. It gives me great pleasure to be of service to you.

They do not need to coincide because part of your employee's salary could not be disclosed on the TWC Gross Wages and 941 forms because of pre-tax and insurance payments. Therefore, the Texas Workforce Commission Gross Wages are not equivalent to your quarterly federal return.

You might want to run a payroll report to keep track of your taxes. In addition, I advise getting in touch with your live support team. They are equipped to evaluate your account and determine whether your taxes need to be adjusted. Here's how:

1. Sign in to your QuickBooks Online account.
2. Select the Help (?) icon.
3. Type in your concern, then select the Let's talk option.
4. Choose Contact Us to connect with a live support agent.
5. Select Start a chat with a support expert or Get a callback from the next available expert.

The following article will help you manage your payroll activities moving forward:

• Pay and file payroll taxes and forms in Online Payroll
• Set up, change, or delete employee-paid payroll deductions

We're always here to assist you if you need further assistance with any QuickBooks-related concerns. Just click the Reply button below or post in the Community again. Take care!