Skip to Content
author's profile photo Former Member
Former Member

Education Reimbursement PCR

I need to write a PCR to switch a non-taxable payment wage type to a taxable payment wage type once the non-taxable wage type reaches a certain amount.

EX. Payments over 5,250.00 in current year is taxable

YTD balance on non-taxable WT = 5,200.00

Non-taxable WT Current payment = 1000.00

50.00 should stay on the non-taxable WT

950.00 should be switched to a taxable WT

Should I be cumulating the non-taxable WT to a variable and then comparing it to a constant?

Any ideas are greatly appreciated!

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Mar 16, 2011 at 06:00 PM

    In table view V_T511K, create a constant for the annual maximum non taxable (eg. ZMAXN)

    For demonstration purpose, 9NER will be the Non-taxable Education Reimbursement WT, and 9TER the Taxable Education Reimbursement WT.

    In the PCR that processes the "current deduction" of 9NER WT, query the annual cumulated amount of 9NER in the previous CRT (AMT=CY9NER), transfer that into a temporary variable (ADDWT& YNER), return WT 9NER to it's input values (ZERO= RNA FILLF RNA), add the cumulated annual amount to the current deduction amount (AMT+& YNER), transfer that sum into a second temporary variable (ADDWT& ZNER), and then compare that sum to the value of the constant (AMT?KZMAXN).

    If the return value is >, you now have all the information to transfer part of or all the current deduction into WT 9TER, but if the return value is *, you return WT 9NER to it's input values.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Rémi Corriveau

      Hi Remi,

      as i am new to US payroll, request you to help on this

      Issue:

      Per IRS regulations, the maximum amount an employee can be reimbursed tax-free for tuition assistance is $5,250. Currently WT 1000 (tuition reimbursement) is limited to $5,000 and WT 1001 (books) is $250. We also have prior year codes 1002 (prior year tuition) and 1003 (prior year books) that combines the amount with the previous year to make sure we don’t go over the maximum amount allowed per the tuition policy.


      There has been a revision to the Tuition Assistance Policy that requires a change to the WT codes due to tax implications. The new policy allows for $10,000 in tuition reimbursement plus $750 in books. Therefore, we need to increase the maximums AND determine how to capture the taxable portion over $5,250.00.

      Solution: in 511k table i have changed the constants amounts to maximum increased amounts effective from 01.01.2013, still it is not deducting tax on 4750 { 10750(new amounts)-5250(old amounts)}

      please suggest me on this, in writing a PCR and where to place it in schema.

      many thanks,


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.