Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Payroll Garnishments and Admin fees paid by creditor

Posted on by 82

Need a little help with this one.  I am setting up a payroll garnishment for a student loan and also setting up the Payroll to Payables integration.  The deduction is based on 15% of earnings and the employee is an hourly employee.  The client is taking a $3 administrative fee for each pay run.  the total amount is around $10,000

So for example, if the system calculates a Garnishment of 100, $100 is withheld from the check and a $97 check needs to be cut to the creditor - with $3 retained as income.  The trick is the garnishment amount changes each period because the employee is hourly and we need to track the total amount of the debt less what has been paid.

Anyone ever run into this or know of a good way to handle this scenario using garnishments. 

Thanks!

Joe

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payroll Garnishments and Admin fees paid by creditor

    Set up 2 deductions - one for the garnishment amount and one for the fee.  That way, you'll know exactly what amount is applied to the $10,000 balance

  • Sherlene Sorenson Profile Picture
    Sherlene Sorenson 965 on at
    RE: Payroll Garnishments and Admin fees paid by creditor

    Hi Joe,

    You would need a separate deduction codes for the fee.  It works best if you set up GARN1 and FEE1, GARN2 and FEE2.  Greenshades garnishment product handles this well, if you need the codes to be tied together so that fees aren't deducted if the garnishment isn't deducted.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans