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 one line
[{TableOfContents}]
[{TableOfContents }]
At line 12 removed one line
[UPCALC Insufficient Earnings_01.JPG]
At line 14 changed one line
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 16 removed one line
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 18 changed one line
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.
When the employee’s gross earnings are not enough to cover all deductions, this timesheet will trigger the Insufficient Earnings processing logic.
At line 19 added 7 lines
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.
At line 21 changed 2 lines
[UPCALC Insufficient Earnings_02.JPG]
\\
At line 24 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 28 changed 7 lines
||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
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
At line 41 added 2 lines
From PC 8045 Work SIT Earn of $5.28, it calculates:
PC 6040 Work SIT = 0.04
At line 37 removed 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 45 added 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 48 added 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 41 changed 4 lines
||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__
PC 8045 Work SIT Earn 192.31 – 124.47 – 61.60 = 5.28 s/b 6.24
At line 52 changed one line
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.
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.
At line 54 changed one line
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.
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.
At line 58 removed one line
[UPCALC Insufficient Earnings_03.JPG]
At line 60 removed 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 removed 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 67 changed one line
*For Canada, (will update later, only need to call Taxation, not EI, CPP etc. new Pay Point Task?)
- 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 69 changed 2 lines
*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
- 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
At line 82 added one line
At line 74 changed one line
[UPCALC Insufficient Earnings_04.JPG]
At line 76 removed 3 lines
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 88 added 4 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 81 changed 4 lines
||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__
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
At line 86 changed 2 lines
From PC 8045 Work SIT Earn of %%strike 5.28/% $6.24, it calculates:
|PC 6040 Work SIT|=%%strike 0.04/% 0.05
From PC 8045 Work SIT Earn of 5.28 $6.24, it calculates:
PC 6040 Work SIT = 0.04 0.05
At line 89 removed 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 91 changed one line
For US Taxation, 125 Plan and 401K Plan deductions should be exempted from taxable earnings as
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 93 removed 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 98 changed one line
US Taxation is called again and all taxable earnings are correct, arrears are generated.
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
At line 110 added 4 lines
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.
At line 104 changed one line
*UPCALC processes all Pay Points and Pay Point Tasks according to the IPPP set up for the Pay Category of each time sheet.
*UPCALC processes all Pay Points and Pay Point Tasks according to IPPP set up for the Pay Category of each timesheet
At line 106 changed one line
*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.
*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
At line 108 changed one line
*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.
*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
At line 110 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.
*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 112 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.
*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 114 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.
*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 116 changed one line
*UPCALC will perform ’82-Insufficient Earnings’ pay point entries two times or when there is no arrears generated after the first time is performed.
*UPCALC will perform ’82-Insufficient Earnings’ pay point entries 2 times or when there is no Arrears generated after the first time is performed
At line 118 changed one line
*The taxation amounts and earnings should be accurate after two recursive calls to ’82-Insufficient Earnings’.
*The taxation amounts and earnings should be accurate after 2 time recursive calls to ’82-Insufficient Earnings’
At line 120 changed 13 lines
*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.
*in IPPP ’82-Insufficient Earnings’ pay point, the user may perform the following Pay Point Tasks:
At line 136 added 17 lines
**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 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
[{If var='loginstatus' contains 'authenticated'
At line 135 changed 2 lines
![Notes|Edit:Internal.UPCALC INSUFFICIENT EARNINGS]
[{InsertPage page='Internal.UPCALC INSUFFICIENT EARNINGS' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.UPCALC INSUFFICIENT EARNINGS]
[{InsertPage page='Internal.UPCALC INSUFFICIENT EARNINGS' default='Click to create a new discussion page'}]
}]
This page (revision-16) was last changed on 26-Nov-2021 10:22 by rforbesTop