Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Social Security and Medicare Deductions

The taxes (Social Security and Medicare) for an employee whose pay is based on timesheet entires are incorrect and we have to manually calculate and enter them for each payroll period so the 941 calculations are correct at the end of the quarter. Calculation of these taxes for salaried employees are correct. This first started being a problem the middile of August. Payroll updates are current.

Solved
Best answer November 13, 2018

Best Answers
Moderator

Social Security and Medicare Deductions

Thank you for telling me when this issue started, dlb53. I'll give you options to fix the calculation of these taxes.

It's possible that an employee's paycheck on August has an overpayment or underpayment for Social Security and Medicare. When that happens, QuickBooks will try to automatically correct the calculation on the next pay period. However, since you've started manually changing the taxes each payroll, the program wasn't able to auto correct.

I have two options for you to straighten out the tax calculations:

  • Do a liability adjustment for Social Security and Medicare, or
  • Stop manually changing them on the employee's paycheck and let QuickBooks do the correction on the succeeding paychecks.

Let's run the Payroll Detail Review report and go back to the paychecks for August.

Here's how:

  1. Click Reports at the top.
  2. Select Employees & Payroll, and then click Payroll Detail Review.
  3. Filter Date from August 1 until the end of the year (December 31).
  4. Click the Customize Report button in the upper left-hand corner, and then click the Filters tab.
  5. In the Search Filters box, type Payroll Item.
  6. Click the All payroll items drop-down, and then select Multiple payroll items.
  7. Scroll down and check Social Security and Medicare for employee and company.
  8. Click OK twice.

Once done, kindly review the employee's paychecks for August to find out the discrepancy. When you see it, you can follow the options I provided above to get it resolved.

Please leave a reply if you have additional questions. I'll get back to you as soon as I can.

View solution in original post

9 Comments
Moderator

Social Security and Medicare Deductions

Thank you for telling me when this issue started, dlb53. I'll give you options to fix the calculation of these taxes.

It's possible that an employee's paycheck on August has an overpayment or underpayment for Social Security and Medicare. When that happens, QuickBooks will try to automatically correct the calculation on the next pay period. However, since you've started manually changing the taxes each payroll, the program wasn't able to auto correct.

I have two options for you to straighten out the tax calculations:

  • Do a liability adjustment for Social Security and Medicare, or
  • Stop manually changing them on the employee's paycheck and let QuickBooks do the correction on the succeeding paychecks.

Let's run the Payroll Detail Review report and go back to the paychecks for August.

Here's how:

  1. Click Reports at the top.
  2. Select Employees & Payroll, and then click Payroll Detail Review.
  3. Filter Date from August 1 until the end of the year (December 31).
  4. Click the Customize Report button in the upper left-hand corner, and then click the Filters tab.
  5. In the Search Filters box, type Payroll Item.
  6. Click the All payroll items drop-down, and then select Multiple payroll items.
  7. Scroll down and check Social Security and Medicare for employee and company.
  8. Click OK twice.

Once done, kindly review the employee's paychecks for August to find out the discrepancy. When you see it, you can follow the options I provided above to get it resolved.

Please leave a reply if you have additional questions. I'll get back to you as soon as I can.

View solution in original post

Level 15

Social Security and Medicare Deductions

This might be the issue: "whose pay is based on timesheet entires are incorrect"

 

Because a lot of payroll clerks do not understand how Dates are applied here.

 

The timesheet has Days Worked and the Paycheck is for that Pay Period = dates that fall in the pay period. but the Paycheck is the Financial activity. Taxes are only owed because the Money happened. That means the Pay Date is what applies for purposes of the 941.

 

Example: The first paycheck in Oct is for the second half of Sept (1st-15th) and that makes it the 4th Quarter 941 and that makes the Liabilities October liabilities, and if you are a monthly payer, that is due by Nov 15th.

 

Evaluate everything by date; you might have been working off of Pay Period, as if that applies to the 941. It doesn't use that. It uses Pay Date. Run your Payroll Summary report for October, to see Oct 941 data; there is no Timesheet Date relationship to this. It is Money that matters, not Dates Worked.

Level 1

Social Security and Medicare Deductions

Thank you for the prompt reply. Using your instructions to print a Payroll Detail Review we were able to identify when the problem first occurred and correct it.

QuickBooks Team

Social Security and Medicare Deductions

Hello, @dlb53.

 

Pleased to hear that your concern was fixed and QuickBooks was able to help you with your business.

 

Feel free to post again if you have any other future concerns about QuickBooks. Wishing you continued success!

 

Level 2

Social Security and Medicare Deductions

In March, I upgraded to Pro Desktop 2019 from 2017 version. I didn't remove 2017 version before I created next paycheck. Since I had cancelled Enhanced PR subscription for 2017, the paycheck didn't have any taxes deducted. I did put that payroll check into 2019 with enhanced payroll and had to override the deductions for that paycheck. The employee's next paycheck (which was the last for the quarter) deducted more than was due for that wage. 

Now, I see you suggest to let quickbooks catch up with those deductions, which I've agreed to. But since those errors were in 1st quarter, will QB eventually finish catching up? Should I be doing more? 

Level 2

Social Security and Medicare Deductions

In addition to my questions above, why does the payroll checkup report show the overpayments if QB is supposedly adjusting accordingly? Will that report eventually zero out? 

Thanks for your help

QuickBooks Team

Social Security and Medicare Deductions

Hello there, @Bigdog54.

 

QuickBooks will finish catching up those deductions and you don't have to do any changes of the taxes each payroll. But as mentioned by my colleague, you'll need to make sure that you didn't manually change the taxes.

 

Regarding the Payroll Detail Review report, it'll show overpayments if the date range is set to that specific quarter. To zero out the report, please make sure that the date range should be customized into the current year.

 

Here's how to customize the report:

 

  1. Go to the Reports menu.
  2. Choose Employees and Payroll.
  3. Select Payroll Detail Review report.
  4. In the Dates section, select Custom in the drop-down.
  5. Then, change the date range from 01/01/2019 to 12/31/2019.

Once done, the report will eventually zero out.

 

That's it! Don't hesitate to let me know if you have other concerns about payroll deductions. I'd be glad to help.

Level 1

Social Security and Medicare Deductions

I have been doing payroll liabilities right along, but this week when I go into Quickbooks it says I have outstanding Medicare and Social Security Payments due for the last two checks.   Why would that happen? 

 

QuickBooks Team

Social Security and Medicare Deductions

Hi @ictvinc,

 

I'll take care of this query about payroll liabilities for you. 

 

An outdated QuickBooks Desktop (QBDT) version and payroll tax table can lead to the situation you stated above. So the first thing I can suggest is to update both.

 

 See these articles for the steps:

 

 

You can then follow the suggestions provided by my colleague @SophiaAnnL above, which is to adjust payroll liabilities or allow QBDT to make the corrections on the succeeding paychecks. 

 

In case you'd like to enter a refund check from an overpayment of your payroll liabilities, check out this article: Record a payroll liability refund check. There are different sets of steps provided, which depend on the situation of the refund check. 

 

I'll be around in case you need further assistance. Feel free to leave a comment below, and I'll be sure to get back to you. 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us