UPCALC INSUFFICIENT EARNINGS#
Overview#
High Line provides capabilities for users to handle Insufficient Earnings situation when the employees do not have enough Earnings to cover all their deductions. This document is to help the user to set up the Pay Point Table (IPPP) in order to perform or re-calculate certain Pay Point Tasks during the Net Pay Calculation process to adjust the net pay amount in UPCALC.Normal Earnings Pay Point#
IPPP – Pay Point Set Up
For normal Regular processing in UPCALC, the following Pay Point set up are usually used to define Net Pay after Legislative Calculation.
When the employee’s Gross earnings are not enough to cover all deductions, this timesheet will trigger the Insufficient Earnings processing logic.
For each deduction pay component, the IPPC Acct/Arrears tab must indicate the Actions to be taken for this deduction.
If the deduction is an exemption amount to reduce the Taxable Earnings, and the full deduction amount is not taken, then the Taxable Earnings will be in an incorrect situation, please see next page for example.
UPCALC – Insufficient Earnings Example
From this pay, before Net Pay calculation, the following pay component values are: PC 3001 125 Plan 124.47 PC 3002 401K Plan 62.56 (original amount)
For US Taxation, 125 Plan and 401K Plan deductions are to be exempted from Taxable Earnings as follows: Gross – 125 Plan – 401K PC 8005 FIT Earn 192.31 – 124.47 – 62.56 = 5.28 PC 8037 FICA EE Earn 192.31 – 124.47 = 67.84 PC 8045 Work SIT Earn 192.31 – 124.47 – 62.56 = 5.28
From PC 8045 Work SIT Earn of $5.28, it calculates: PC 6040 Work SIT = 0.04
From Net Pay calculation, there is Insufficient Earnings to cover all deductions. PC 3001 from IPPC set up is to Take as much as possible and generate Arrears. Therefore PC 3001 generated an Arrears of 0.96 and PC 3001 is adjusted to 61.60.
For US Taxation, 125 Plan and 401K Plan deductions should be exempted from Taxable Earnings as follows: Gross – 125 Plan – 401K PC 8005 FIT Earn 192.31 – 124.47 – 61.60 = 5.28 s/b 6.24 PC 8037 FICA EE Earn 192.31 – 124.47 = 67.84
PC 8045 Work SIT Earn 192.31 – 124.47 – 61.60 = 5.28 s/b 6.24
Therefore the above Pay Register results are incorrect.
Insufficient Earnings Pay Point#
IPPP – Insufficient Earnings Pay Point Set Up
When there is Insufficient Earnings for an employee, if there are deductions that reduce the Taxable Earnings, the user need to re-calculate taxes again with the adjusted deductions, otherwise the Taxable Earnings are inflated with the deduction amounts that are not deducted.
On IPPP screen, the Pay Point Type ‘82-Insufficient Earnings’ is used to specify the Pay Point Tasks that are to be performed only when the timesheet is in Insufficient Earnings.
The following is an example for IPPP Insufficient Earnings set up:
- In ‘82-Insufficient Earnings’ Pay Point, the user can only set up the following Pay Point Tasks: Legislative Calc, User Calculation, Net Pay
- For US payroll, the Legislative Calc will call the Vertex module again with the revised 125 plan, 401K plan deduction amounts with all earnings for re-calculation
- For Canada, ….. will update later, only need to call Taxation, not EI, CPP etc new Pay Point Task?
- After Legislative Calculation, the user may adjust certain tax results base on client’s own situation, in this case, the user need to perform User Calculation to adjust tax amount manually e.g. for US Ohio School District tax, the user may only withhold School District Tax and do not withhold City Residence Tax, however, City Residence Tax are returned by Vertex in order to calculate the School district tax, then the user need to zero out the City Residence Tax after Taxation
- After Legislative Calculation, the user MUST set up an entry with Pay Point Task ‘Net Pay’ to re-calculate Net pay again
UPCALC – After Insufficient Earnings Pay Point processing
From first UPCAC, the following pay component values are: PC 3001 125 Plan 124.47 PC 3002 401K Plan 62.56 61.60 with Arrears of 0.96
For US Taxation, 125 Plan and 401K Plan deductions are to be exempted from Taxable Earnings as follows: Gross – 125 Plan – 401K PC 8005 FIT Earn 192.31 – 124.47 – 61.60 = 6.24 PC 8037 FICA EE Earn 192.31 – 124.47 = 67.84 PC 8045 Work SIT Earn 192.31 – 124.47 – 61.60 = 6.24
From PC 8045 Work SIT Earn of 5.28 $6.24, it calculates: PC 6040 Work SIT = 0.04 0.05
When Net Pay is calculated again after Taxation, since PC 6040 Work SIT increases from 0.04 to 0.05, there is new Insufficient Earnings for 0.01 (one cent). Therefore PC 3001 generated an additional Arrears 0.01 to 0.97 and PC 3001 is reduced to 61.59, thus the Taxable Earnings need to be adjusted again.
For US Taxation, 125 Plan and 401K Plan deductions should be exempted from Taxable Earnings as follows: Gross – 125 Plan – 401K PC 8005 FIT Earn 192.31 – 124.47 – 61.59 = 5.28 6.24 to 6.25 PC 8037 FICA EE Earn 192.31 – 124.47 = 67.84
PC 8045 Work SIT Earn 192.31 – 124.47 – 61.59 = 5.28 6.24 to 6.25
US Taxation is called again and all Taxable Earnings are correct, Arrears are generated.
Insufficient Earnings Pay Point Processing#
UPCALC – Insufficient Earnings Pay Point Processing
- UPCALC processes all Pay Points and Pay Point Tasks according to IPPP set up for the Pay Category of each timesheet
- in IPPP ‘80-Net Pay’ Pay Point, if there is Insufficient Earnings for a timesheet to cover all deductions, UPCALC triggers the Insufficient Earnings logic to generate Arrears
- if any Arrears are generated for a timesheet, UPCALC will perform Insufficient Earnings Net Pay Processing according to IPPP ’82-Insufficient Earnings’ pay point set up
- from IPPP ’82-Insufficient Earnings’ pay point, UPCALC performs the Pay Point Task entries for this Pay Point and then re-check if additional Arrears are generated
- if no more Arrears are generated after ’82-Insufficient Earnings’, then UPCALC returns to IPPP Pay Point that is immediately after the ‘80-Net Pay’ Pay Point entry
- if additional Arrears are generated after ’82-Insufficient Earnings’, then UPCALC will perform the same ’82-Insufficient Earnings’ pay point tasks the second time, this is the example as shown above that fix the Taxable Earnings
- UPCALC will perform ’82-Insufficient Earnings’ pay point entries 2 times or when there is no Arrears generated after the first time is performed
- The taxation amounts and earnings should be accurate after 2 time recursive calls to ’82-Insufficient Earnings’
- in IPPP ’82-Insufficient Earnings’ pay point, the user may perform the following Pay Point Tasks:
- Legislative Calc - if any deduction pay components are to be exempted from Taxable Earnings, user must set up ‘Legislative Calc’ entry to re-calc, otherwise not needed
- User Calc - user may adjust Tax results after Legislative Calc - user may adjust Employer portion for Employee Amount - otherwise not needed
- Net Pay - if the Tax is re-calculated, then Net Pay Entry must exist - if user only adjust certain Pay Components that do not affect Net Pay, then there is no need to set up Net Pay entry
- when UPCALC performs ’82-Insufficient Earnings’ pay point, if there are Advances given in the same timesheet, UPCALC clears all Advances prior to perform ’82-Insufficient Earnings’ pay point because when Net Pay is called again, the Advances will be given again
- when UPAUDT is run to prepare all Pay Point entries for a timesheet, the IPPP ’82-Insufficient Earnings’ entries will not be pulled in by the Prep process in UPAUDT
- user can set up IPPP ’82-Insufficient Earnings’ pay point by Pay Category, this allows user to dynamically adjust the Net Pay based on the types of pay
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation