Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

GP Not Calculating FICA Social Security Wages Correctly?

Posted on by 235

We are using GP 2018.   

As we are nearing the end of the year and encountering employees meeting their FICA wage limit, I'm having issues reconciling their FICA Social Security Wages to the PAYROLL SUMMARY.  GP does not appear to consistently apply the tax-exempt deductions for FICA Social Security Wages when an employee meets their max in a given pay period.   

If an employee has FICA Social Security Wages in a pay period, shouldn't all tax-exempt deductions to those wages apply in full, if they are less than the wage amount (as they are in all of my examples)?   This doesn't seem to be the case.   In my examples, the tax-exempt deductions in question are health insurance premiums (INS125) and short-term disability premiums paid by the employee (STD). 

In October, GP correctly applied the FICA Social Security wage exemption for the health insurance premium for an employee who met their max in a pay period (but, still had FICA Social Security Wages).   But, it didn't include the tax-exempt deduction for that same employee's STD premium for that pay period.

In November, I had 2 more employees meet their FICA Social Security max. They both had FICA Social Security wages for the first pay period of the month.  But, GP is not applying the insurance premium exemption OR the short-term disability exemption to their FICA Social Security Wages.

Please help me understand this! 

I have attached the reconciliation file with notes.  These numbers are used for our 941 reporting (941 line numbers are referenced in the file), so it's important that they're correct!

OCT22_5F00_NOV22-940_5F00_941-Wage-Reconciliation.xlsx

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP Not Calculating FICA Social Security Wages Correctly?

    Yeah, GP not working for me.

    From last update

  • Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at
    RE: GP Not Calculating FICA Social Security Wages Correctly?

    Yes I did have a TSA deduction involved with this test.

    Here is a link to create a case

    https://support.serviceshub.microsoft.com/supportforbusiness

    Thanks

    Terry Heley

    Microsoft

  • PattiK323 Profile Picture
    PattiK323 235 on at
    RE: GP Not Calculating FICA Social Security Wages Correctly?

    In your test, did you have tax-exempt deductions, such as health insurance and employee-paid short-term disability?  Was the max met in one payroll and there was a subsequent payroll in the month with no FICA wages?

    How do I go about opening a case?

    Thank you.

  • Suggested answer
    Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at
    RE: GP Not Calculating FICA Social Security Wages Correctly?

    Screenshot-2022_2D00_12_2D00_08-173151.jpgHi Patti,

    I did a quick test where I met the SS limit in January all my reports and information tie as I expect see below.

    I then ran a payroll for the same year in September and it all ties.

    Screenshot-2022_2D00_12_2D00_08-173357.jpg

    We may need you to create a case so we can look into these records further with you, as we typically do not see issues with maximums and deductions.

    Thanks

    Terry Heley

    Microsoft

  • PattiK323 Profile Picture
    PattiK323 235 on at
    RE: GP Not Calculating FICA Social Security Wages Correctly?

    The tax is calculating correctly. It's the FICA Social Security Wages (the tax base) that I believe are not. Exemptions are not being properly or consistently applied in the pay period that the FICA wage max is met.

  • DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: GP Not Calculating FICA Social Security Wages Correctly?

    hi

    look this

    community.dynamics.com/.../fica-social-security-tax-table

    DAniele

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans