cancel
Showing results for 
Search instead for 
Did you mean: 
Iowa Mama of 7
Level 3

Why did payroll liabilities did not take out enough payroll taxes, it is different than my form 941 that was populated.

Why does my 941 form I created for 4th quarter 2019 have a different amount of tax than what my payroll center liabilities told me to pay...by $58.01.  I have pulled a payroll summary report, the amount of taxable income on the 941 is equal to gross pay less other insurance pre-tax plus employer contribution fringe benefit.  The fringe benefit under payroll item list is set up as a fringe benefit in the tax line item.  The pre-tax insurance is set up as a 125 (cafeteria plan tax item).  When I play around with these numbers to see if that's how the 941 form is different than what the payroll center liabilities told me to pay.....that is NOT the difference....Do I just override the form showing a balance due, pay the $58.01 and show I paid it all.....and fix the payroll center liability transaction....and pray it works for 1st quarter 2020?

 

Backstory--I went to payroll center and paid the payroll liabilities for 941 (federal, med, ss taxes) and paid that amount on my old computer windows 7 that was using Quickbooks Desktop Premier for Contractors 2018.  I couldn't get the 941 form to populate because I kept getting an error that my payroll wasn't activated, so I'd verify, and it was, but then when I clicked on to create the 941 form, it would repeat.  I figured it was because I needed to get on a windows 10 computer.  So I created a backup of my file....went to my new computer, installed Quicbooks 2020, opened my back up, and started using Quickbooks just fine.  I opened the payroll center, created the 941 form, and it saw the payments I made and on the form it calculated that I needed to pay $58.01 more and showed a balance due. 

 

Did QB do an update/correction in the payroll center and the form caught it, but the payroll liabilities hadn't?  How can I see how the payroll liabilities calculated it wrong?  What went wrong?

4 Comments 4
Iowa Mama of 7
Level 3

Why did payroll liabilities did not take out enough payroll taxes, it is different than my form 941 that was populated.

***update***

 

I want to update, I figured out the difference of $58 is due to Quickbooks taxing my fringe benefits in the month of December.  Payroll liabilities calculated October and November correctly but not December?  I'm so confused why it did that, but at least I found the spot where it went wrong

MadelynC
Moderator

Why did payroll liabilities did not take out enough payroll taxes, it is different than my form 941 that was populated.

Thanks for the update, @Iowa Mama of 7.

 

You can try to run a Paryoll tax liability report by quarter, to see the difference. QuickBooks will automatically calculate and adjust payroll liabilities.

 

If you have negative and positive payments, QuickBooks will apply the amount to your next payment.

 

You’ll want to ensure that you have the latest payroll tax table to have accurate rates and calculations.

 

For your future reference, let me share this article on how to correct payroll liabilities using a liability adjustment: Adjust payroll liabilities in QuickBooks Desktop.

 

I’m always here to help.

Iowa Mama of 7
Level 3

Why did payroll liabilities did not take out enough payroll taxes, it is different than my form 941 that was populated.

Thank you for responding and for the ideas.  This is what I can tell:

 

When I look at payroll liabilities, it never took out the missing $58.01 and it did not leave it as a balance for the next month either.

 

Payroll liabilities did not take out the correct tax amount (it did not include fringe benefits as a taxable income even though set up correctly)  When I compare the payroll summary and my W3 and W2's for the year it is still doing the same thing, probably because payroll liabilities didn't automatically calculate it.  But the 941 did calculate it, which is what showed it off.

 

How do I update quickbooks to take out the extra $13.49 for social security employee, $13.49 for social security company, $3.16 for medicare employee, $3.16 for medicare company.....and $10.01, $10.01, $2.35, $2.35.....so that it reflects correctly on my W3 and W2's for 2019.  When I take the total wages listed on the payroll summary and the W3 total of $23,883.53 and multiply by .0124 for taxable social security wages and x .029 for taxable medicare wages as shown on form 941.....what should have been taken out is off by $58.01.....it's off in the payroll summary and on the W3 and W2's.  Quickbooks calculated wrong and it's still not calculating correctly, probably because the quarter and calculations are done....should I try unlocking and reopening the paychecks for that quarter....will it then redo and calculate correctly I wander? 

 

Thank you,

Rachel

JenoP
Moderator

Why did payroll liabilities did not take out enough payroll taxes, it is different than my form 941 that was populated.

There are two options on how to correct the taxes, Iowa Mama of 7.

 

First, is to delete the affected paychecks. Then, recreate them and make sure that the calculations are already correct before saving them. Here's how:

 

  1. Open the affected paycheck.
  2. Click the X or Delete button in the upper part of the transaction.
  3. Select Delete check and click OK.
  4. Recreate the paycheck and make sure it has the correct paycheck date.

Second option is to create a payroll liability adjustment to correct the form and payroll reports. Here's how:

 

  1. Click the Adjust Payroll Liability link under the Pay Liabilities tab.
  2. Use the last day of the 4th quarter in both Date and Effective Dates field.
  3. Select Employee in the Adjustment is for section, then select the name of the employee.
  4. Select the taxes that you've mentioned in the Item Name column.
  5. Enter the amounts that you will be adjusting.
  6. Click Next Adjustment to proceed to the next employee. 

Once done, run a payroll summary report or open your 941 to check if the amounts are already correct. You'll also want to save these articles in case you need them in the future:

 

Add another reply below if you still need help with the rest of your tax forms.

Need to get in touch?

Contact us