This page (revision-16) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
16 26-Nov-2021 10:22 8 KB rforbes to previous
15 26-Nov-2021 10:22 8 KB JMyers to previous | to last
14 26-Nov-2021 10:22 8 KB JMyers to previous | to last
13 26-Nov-2021 10:22 8 KB JMyers to previous | to last
12 26-Nov-2021 10:22 8 KB JMyers to previous | to last
11 26-Nov-2021 10:22 8 KB JMyers to previous | to last
10 26-Nov-2021 10:22 8 KB JMyers to previous | to last
9 26-Nov-2021 10:22 8 KB JMyers to previous | to last
8 26-Nov-2021 10:22 8 KB JMyers to previous | to last
7 26-Nov-2021 10:22 8 KB JMyers to previous | to last
6 26-Nov-2021 10:22 8 KB JMyers to previous | to last
5 26-Nov-2021 10:22 8 KB JMyers to previous | to last
4 26-Nov-2021 10:22 8 KB JMyers to previous | to last
3 26-Nov-2021 10:22 8 KB JMyers to previous | to last
2 26-Nov-2021 10:22 7 KB JMyers to previous | to last
1 26-Nov-2021 10:22 8 KB JMyers to last

Page References

Incoming links Outgoing links
UPCALC INSUFFICIENT EARNINGS
UPCALC INSUFFICIENT EARNINGS

Version management

Difference between version and

At line 1 changed 3 lines
1 Overview
Intent
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.
[{TableOfContents}]
!!!UPCALC INSUFFICIENT EARNINGS
At line 5 changed 2 lines
Audience
All users who are responsible for the Pay Cycle processing in UPCALC.
!!Overview
The system allows you to handle an insufficient earnings situation where employees do not have enough earnings to cover all their deductions. This section explains how 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].
At line 8 changed 2 lines
Prerequisites
Users must have a thorough understanding of the Payroll Pay cycle processing and the Insufficient Earnings Arrears set up from the Payroll Manual.
!!Normal Earnings Pay Point
!IPPP – Pay Point Set Up
At line 10 added one line
For normal regular processing in UPCALC, the following Pay Point set up is usually used to define Net Pay after Legislative Calculation.
At line 12 added one line
[UPCALC Insufficient Earnings_01.JPG]
At line 13 changed one line
2 Normal Earnings Pay Point
When the employee’s gross earnings are not enough to cover all deductions, this time sheet will trigger the Insufficient Earnings processing logic.
At line 15 changed one line
IPPP – Pay Point Set Up
For each deduction pay component, the [IPPC Acct/Arrears tab|IPPC#Acct Arrears tab] must indicate the actions to be taken for this deduction.
At line 17 changed one line
For normal Regular processing in UPCALC, the following Pay Point set up are usually used to define Net Pay after Legislative Calculation.
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 section for an example.
At line 19 changed 19 lines
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
!UPCALC – Insufficient Earnings Example
[UPCALC Insufficient Earnings_02.JPG]
\\
At line 39 changed 2 lines
PC 3001 125 Plan 124.47
PC 3002 401K Plan 62.56 (original amount)
|PC 3001 125 Plan|124.47
|PC 3002 401K Plan|62.56 (original amount)
At line 43 changed 4 lines
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
||PC ||Gross – 125 Plan – 401K||Total
|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
At line 48 removed 2 lines
From PC 8045 Work SIT Earn of $5.28, it calculates:
PC 6040 Work SIT = 0.04
At line 37 added one line
From the Net Pay calculation, there is insufficient earnings to cover all deductions. PC 3001 from the 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__.
At line 52 removed 2 lines
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.
At line 55 removed 3 lines
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
At line 59 changed one line
PC 8045 Work SIT Earn 192.31 – 124.47 – 61.60 = 5.28 s/b 6.24
||PC ||Gross – 125 Plan – 401K||Total
|PC 8005 FIT Earn|192.31–124.47 – __61.60__|= %%(text-decoration:line-through)5.28%% s/b __6.24__
|PC 8037 FICA EE Earn|192.3 – 124.47|= 67.84
|PC 8045 Work SIT Earn| 192.31 – 124.47 – __61.60__|= %%(text-decoration:line-through)5.28%% s/b __6.24__
At line 63 changed one line
3 Insufficient Earnings Pay Point
!!Insufficient Earnings Pay Point
At line 65 changed one line
IPPP – Insufficient Earnings Pay Point Set Up
!IPPP – Insufficient Earnings Pay Point Set Up
At line 67 changed one line
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.
When there is are insufficient earnings for an employee, if there are deductions that reduce the taxable earnings, you need to re-calculate taxes again with the adjusted deductions, otherwise the taxable earnings are inflated with the deduction amounts that are not deducted.
At line 69 changed one line
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.
On the 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 time sheet is in Insufficient Earnings.
At line 58 added one line
[UPCALC Insufficient Earnings_03.JPG]
At line 60 added 4 lines
*In ‘82-Insufficient Earnings’ Pay Point, the user can only set up the following Pay Point Tasks:
**Legislative Calc
**User Calculation
**Net Pay
At line 65 added one line
*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
At line 76 changed 2 lines
- In ‘82-Insufficient Earnings’ Pay Point, the user can only set up the following Pay Point Tasks:
Legislative Calc, User Calculation, Net Pay
*For Canada, (will update later, only need to call Taxation, not EI, CPP etc. new Pay Point Task?)
At line 79 changed 9 lines
- 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
*After Legislative Calculation, you may adjust certain tax results base on the client’s own situation, in this case, you need to perform User Calculation to adjust tax amount manually.\\ \\e.g. for US Ohio School District tax, you 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 you need to zero out the City Residence tax after taxation.\\ \\
*After Legislative Calculation, you MUST set up an entry with Pay Point task ‘Net Pay’ to re-calculate Net pay again
At line 72 added one line
!UPCALC – After Insufficient Earnings Pay Point processing
At line 90 changed one line
UPCALC – After Insufficient Earnings Pay Point processing
[UPCALC Insufficient Earnings_04.JPG]
At line 92 changed one line
From first UPCALC, the following pay component values are:
|PC 3001 125 Plan|124.47
|PC 3002 401K Plan|%%strike 62.56/% __61.60__ with arrears of 0.96
At line 94 removed 5 lines
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
At line 100 changed 4 lines
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
||PC ||Gross – 125 Plan – 401K||Total
|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__
At line 105 changed 2 lines
From PC 8045 Work SIT Earn of 5.28 $6.24, it calculates:
PC 6040 Work SIT = 0.04 0.05
From PC 8045 Work SIT Earn of %%strike 5.28/% $6.24, it calculates:
|PC 6040 Work SIT|=%%strike 0.04/% 0.05
At line 89 added one line
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.
At line 109 changed one line
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
At line 93 added 4 lines
||Pay Component||Gross – 125 Plan – 401K||Total
|PC 8005 FIT Earn |192.31 – 124.47 – __61.59__|= %%strike 5.28/% %%strike 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__|= %%strike 5.28/% %%strike 6.24/% to __6.25__
At line 112 changed 4 lines
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
US Taxation is called again and all taxable earnings are correct, arrears are generated.
At line 117 changed one line
PC 8045 Work SIT Earn 192.31 – 124.47 – 61.59 = 5.28 6.24 to 6.25
!!Insufficient Earnings Pay Point Processing
At line 119 changed one line
US Taxation is called again and all Taxable Earnings are correct, Arrears are generated.
!UPCALC – Insufficient Earnings Pay Point Processing
At line 121 changed one line
4 Insufficient Earnings Pay Point Processing
*UPCALC processes all Pay Points and Pay Point Tasks according to the IPPP set up for the Pay Category of each time sheet.
At line 123 changed one line
UPCALC – Insufficient Earnings Pay Point Processing
*In IPPP ‘80-Net Pay’ Pay Point, if there is insufficient earnings for a time sheet to cover all deductions, UPCALC triggers the Insufficient Earnings logic to generate arrears.
At line 125 changed one line
- UPCALC processes all Pay Points and Pay Point Tasks according to IPPP set up for the Pay Category of each timesheet
*If any arrears are generated for a time sheet, UPCALC will perform Insufficient Earnings Net Pay Processing according to IPPP ’82-Insufficient Earnings’ pay point set up.
At line 127 changed one line
- 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
*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.
At line 129 changed one line
- 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
*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.
At line 131 changed one line
- 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 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.
At line 133 changed one line
- 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
*UPCALC will perform ’82-Insufficient Earnings’ pay point entries two times or when there is no arrears generated after the first time is performed.
At line 135 changed one line
- 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
*The taxation amounts and earnings should be accurate after two recursive calls to ’82-Insufficient Earnings’.
At line 137 changed one line
- UPCALC will perform ’82-Insufficient Earnings’ pay point entries 2 times or when there is no Arrears generated after the first time is performed
*In IPPP ’82-Insufficient Earnings’ pay point, you 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
**UserCalc
***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 time sheet, 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 time sheet, 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 you to dynamically adjust the Net Pay based on the types of pay.
At line 139 changed 19 lines
- 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
----
![Notes|Edit:Internal.UPCALC INSUFFICIENT EARNINGS]
[{InsertPage page='Internal.UPCALC INSUFFICIENT EARNINGS' default='Click to create a new notes page'}]
This page (revision-16) was last changed on 26-Nov-2021 10:22 by rforbesTop