941 Tax Deposit Report vs QTR Federal Tax Return

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
FirstMOBC
Posts: 133
Joined: Sat Nov 28, 2009 9:22 pm

941 Tax Deposit Report vs QTR Federal Tax Return

Post by FirstMOBC »

I notice that my 941 Tax Deposit report is 10.78 less than 941 Employer's QTR Federal Tax Return. Should the rates be enter as 6.20 and 1.450 in the payroll tax table? I notice that 1 employee the withholding for the medicare is 3.91 less than what it should have been and another employee was 1.50 more but that does not make up the 10.78.
The total medicare is short 10.88 and the SS tax was .10 over. Had problem in 2012 where the SS tax where over the amount that should have been withheld. Do not want to run into this problem again. The problem seem to be in the medicare calculation.
Margaret Allen

NeilZ
Posts: 10575
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: 941 Tax Deposit Report vs QTR Federal Tax Return

Post by NeilZ »

FirstMOBC wrote:I notice that my 941 Tax Deposit report is 10.78 less than 941 Employer's QTR Federal Tax Return. Should the rates be enter as 6.20 and 1.450 in the payroll tax table? I notice that 1 employee the withholding for the medicare is 3.91 less than what it should have been and another employee was 1.50 more but that does not make up the 10.78.
The total medicare is short 10.88 and the SS tax was .10 over. Had problem in 2012 where the SS tax where over the amount that should have been withheld. Do not want to run into this problem again. The problem seem to be in the medicare calculation.
Check the IRS Pub 15 for correct percentages for 2013, but the setup for all Federal Taxes can be found here:

https://www.powerchurch.com/support/kb. ... 140&type=1

it gives an example for 2009, but the directions are the same for 2013, just check Pub 15 for the proper numbers.
Neil Zampella

Using PC+ since 1999.

FirstMOBC
Posts: 133
Joined: Sat Nov 28, 2009 9:22 pm

Re: 941 Tax Deposit Report vs QTR Federal Tax Return

Post by FirstMOBC »

Hello
I have a problem with my 941's again. For instant I have an employee that make $75.00 a week which the SS and Medicare is $4.65 and $1.00 each week. So by QTR end the SS is 60.45 and Medicare is 13.00. But if you take the salary by the QTR which is $975.00 and SS is 60.45 and Medicare is 13.00. But the Medicare should be 1.09 each week and 14.14 per QTR. My question is why do normal PC calculate the lower amount doing payroll then on the QTR report the calculation is different and correct? That means the employee and employer amounts are wrong doing the payroll cycle and I need to know how to resolve this issue. I am lost but need some input.
Thank you
Margaret Allen

Matt
Authorized Teaching Consultant
Authorized Teaching Consultant
Posts: 733
Joined: Fri Dec 05, 2003 4:04 pm
Location: Jacksonville, AL

Re: 941 Tax Deposit Report vs QTR Federal Tax Return

Post by Matt »

It sounds like the tax table for Medicare in the Payroll Module has the "Round tax to nearest whole dollar" checkbox checked. If so, uncheck this box.

FirstMOBC
Posts: 133
Joined: Sat Nov 28, 2009 9:22 pm

Re: 941 Tax Deposit Report vs QTR Federal Tax Return

Post by FirstMOBC »

Thank you I did. So for employee that did not get enough deduction or too much deduction do I adjust their checks or just pay and adjust at year end.
Margaret Allen

Matt
Authorized Teaching Consultant
Authorized Teaching Consultant
Posts: 733
Joined: Fri Dec 05, 2003 4:04 pm
Location: Jacksonville, AL

Re: 941 Tax Deposit Report vs QTR Federal Tax Return

Post by Matt »

Since we are still in the middle of the calendar year, recommend that you adjust the next check the employees receive. Don't forget to adjust the employer's share as well.

FirstMOBC
Posts: 133
Joined: Sat Nov 28, 2009 9:22 pm

Re: 941 Tax Deposit Report vs QTR Federal Tax Return

Post by FirstMOBC »

Thank you I do appreciate your speedy reply.
Margaret Allen

Post Reply