Skip to main content
May 29, 2021
Question

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

  • May 29, 2021
  • 3 replies
  • 0 views
Original commenter did not share additional details

3 replies

Rose-A
May 29, 2021

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!

Rose-A
May 30, 2021

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!

August 3, 2022

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

August 3, 2022

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.

April 19, 2023

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. 

April 19, 2023

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:

 

 

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!