• 100% Satisfaction Guarantee
R. Klein, EA, Accountant
Category: Finance
Satisfied Customers: 3373
Experience:  TurboTax Expert. QuickBooks Certified Pro Advisor
63817126
R. Klein, EA is online now

Forecasting for FICA, FUTA and SUTA on a 12 month spread. I

Customer Question

Forecasting for FICA, FUTA and SUTA on a 12 month spread. I

Resolved Question:

Forecasting for FICA, FUTA and SUTA on a 12 month spread. I have a spreadsheet that has Salaries & Wages in \$ dollars going accross the top sheet for 12 months. I want to compute the FICA tax at rate of 7.65% but I have some earners that might reach their caps as the months go by each month. What is the best way to calculate the true tax exposure for each month. In other words I have maybe 4 employees reaching the \$106,800 cap in April then 4 more in May and so forth. Taking 7.65% for each month's S&W would overstate these particular employees tax expense. What I am trying to figure out is there some kid of tax factor that I should use? How would that work in setting up my spreadsheet/
Submitted: 2 years ago.
Category: Finance
Expert:  R. Klein, EA replied 2 years ago.

R. Klein, EA :

Thank you for your question today.

R. Klein, EA :

In 2014, the cap will be at 117K

R. Klein, EA :

there is no percentage amount of salary that computes the cap. It is 7.65% for SS & Medicare combined up to the earnings limit.

R. Klein, EA :

BUT THEN....there is an additional Medicare tax that must be withheld equal to 0.9% after you hit 200K earnings for the calendar year.

R. Klein, EA :

Plus, the Medicare amount of 1.45% does NOT have a cap at all.

R. Klein, EA :

R. Klein, EA :

Then you can compute the tax amount in another column for SS tax (6.2%). You can use an If/Then type statement in the calculation such that "If YTD wages in the Taxable SS column is less than 117001, then SS tax = 62% of that column, otherwise the amount is 0"

R. Klein, EA :

You would have another column for "additional Medicare tax", similarly, although the column would calculate as "If the YTD SS wages are >200.000 then the Additional Medicare tax is 0.9% of the amount over \$200K"

Customer :

Do you have an example worksheet?

R. Klein, EA :

No, but you'll need to have several intermediary columns, as noted above.

R. Klein, EA :

For each pay period, you have a current earnings and a YTD amount. The tricky calculations are when you hot the YTD trigger amounts.

R. Klein, EA :

The calculation in Excel looks something like this, although I don't have enough time right now to do the full TRUE calculation.

R. Klein, EA :

Assume cell A1 has the current period check and B1 is the YTD after that check.

R. Klein, EA :

Formula would look like =if(A2>117000,0,(A1*0.062))

R. Klein, EA :

This says "If the YTD amount is Greater than 117K, then the SS amount = 0. If this is false, then the SS amount for this check is 6.2% times A1"

R. Klein, EA :

To do this fully accurately, where the TRUE statement is 0, you would need an IF statement in case the current period check carries the YTD amount OVER the 117K threshold, but PART of the current period check is taxed.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

• I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response... T.G.W Matteson, IL
< Previous | Next >
• I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response... T.G.W Matteson, IL
• I WON!!! I just wanted you to know that your original answer gave me the courage and confidence to go into yesterday's audit ready to fight. Bonnie Chesnee, SC
• Great service. Answered my complex tax question in detail and provided a lot of additional useful information for my specific situation. John Minneapolis, MN
• Excellent information, very quick reply. The experts really take the time to address your questions, it is well worth the fee, for the peace of mind they can provide you with. Orville Hesperia, California
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA

Meet The Experts:

Satisfied Customers:

2489
Graduated in law with Emphasis on Finance and have have been working in financial sector for over 12 Years
< Last | Next >

Satisfied Customers:

2489
Graduated in law with Emphasis on Finance and have have been working in financial sector for over 12 Years

Megan C

Satisfied Customers:

2210
Licensed CPA, CFE, CMA, CGMA who teaches accounting courses at Master's Level

Manal Elkhoshkhany

Satisfied Customers:

1905
More than 5000 online tutoring sessions.

JKCPA

Satisfied Customers:

843
Bachelors degree and CPA with Accounting experience.

Eric

Satisfied Customers:

559
Loan servicing, counseling and real estate expert. Foreclosure Expert and Financial Planner.

R. Klein, EA

Satisfied Customers:

480
TurboTax Expert. QuickBooks Certified Pro Advisor

332