cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 11-13-2018

Accepted Solutions
QuickBooks Team

Re: 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

7 Comments
QuickBooks Team

Re: 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

Re: 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

Re: 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

Re: 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

Re: 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

Re: 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

Re: 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.

Need to get in touch?

Contact us