u/WhiteMustang17

I had a request come through to allow submissions from comp for people in tuition reimbursement to allow their requests up to a certain limit pay out up to an annual limit and the pay out the excess year over year until the balance was paid off.

It’s working after using every ounce of my brain but excited to see it in action. Combination of memo codes, two earnings, multiple pay balances and some accumulators.

Cheers!

Post Edit:

Request - HR/ Payroll team wanted the ability to allow employees to submit Tuition Reimbursement requests through Comp but in payroll stop them at their annual limit. Anything in excess would be paid out automatically at the beginning of each year up to the annual limit and a lifetime limit.

Solution:

1. Utilized an existing code for TR
2. 2 Built a Memo Code for the historical conversion since those balances weren’t converted as a part of their implementation a few years ago.
3. Create Pay Accumulator for the limits
4. Created multiple pay balances for the excess, available balance of the life amount allowed, and the lifetime amounts to be paid.
5. Created a second earning for the excess and scheduled it to trigger on the first of the year if the balance to be paid had a balance with the annual limits on the code
6. Had another pay accumulator to track and create the actual balance to be paid. Example: someone submits 20k and lifetime limit is 20k but 5k is paid in 2025 and 5k is paid in 2026 - then balance remaining is 10k so another 5k can be paid in 2027

So much math.

I’m looking at Christian Louboutin’s and some other brands on 1st dibs but wanted to hear some other’s experiences!