How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask R. Klein, EA Your Own Question

R. Klein, EA
R. Klein, EA, Accountant
Category: Finance
Satisfied Customers: 2879
Experience:  Intuit Ask a Tax Expert. QuickBooks Certified Pro Advisor (all editions)
Type Your Finance Question Here...
R. Klein, EA is online now
A new question is answered every 9 seconds

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: 8 months ago.
Category: Finance
Expert:  R. Klein, EA replied 8 months 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 :

In your Excel spreadsheet, you'll need a column for taxable SS wages in addition Taxable Wages

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.

JustAnswer in the News:

 
 
 
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.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...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
< Last | 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:

 
 
 
  • Rakhi Vasavada

    Financial and Legal Consultant

    Satisfied Customers:

    2073
    Graduated in law with Emphasis on Finance and have have been working in financial sector for over 12 Years
< Last | Next >
  • http://ww2.justanswer.com/uploads/RA/rakhi.v/2012-7-3_14374_RakhiVasavadaL.64x64.jpeg Rakhi Vasavada's Avatar

    Rakhi Vasavada

    Financial and Legal Consultant

    Satisfied Customers:

    2073
    Graduated in law with Emphasis on Finance and have have been working in financial sector for over 12 Years
  • http://ww2.justanswer.com/uploads/BU/BusinessTutor/2012-2-2_115741_Kouki2.64x64.jpg Manal Elkhoshkhany's Avatar

    Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    1890
    More than 5000 online tutoring sessions.
  • http://ww2.justanswer.com/uploads/MY/MyVirtualCPA/2012-7-5_44024_cookmegan1.64x64.jpg Megan C's Avatar

    Megan C

    Certified Public Accountant (CPA)

    Satisfied Customers:

    1755
    Licensed CPA, CFE, CMA who teaches accounting courses at Master's Level
  • http://ww2.justanswer.com/uploads/JK/jkcpa/2011-1-16_182614_jkcpa.64x64.jpg JKCPA's Avatar

    JKCPA

    CPA

    Satisfied Customers:

    838
    Bachelors degree and CPA with Accounting experience.
  • http://ww2.justanswer.com/uploads/starside8/2010-2-16_55433_DSCN1175.JPG Eric's Avatar

    Eric

    Financial Manager

    Satisfied Customers:

    558
    Loan servicing, counseling and real estate expert. Foreclosure Expert and Financial Planner.
  • http://ww2.justanswer.com/uploads/FA/fastfile/2011-12-15_23139_Klein2011small.64x64.jpg R. Klein, EA's Avatar

    R. Klein, EA

    Accountant

    Satisfied Customers:

    397
    Intuit Ask a Tax Expert. QuickBooks Certified Pro Advisor (all editions)
  • http://ww2.justanswer.com/uploads/dkaplun/2009-05-17_173121_headshot_1_2.jpg Dimitry K., Esq.'s Avatar

    Dimitry K., Esq.

    Attorney

    Satisfied Customers:

    324
    NASD Licensed Rep, 1997-2001, Business Attorney