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 42 changed 3 lines
|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
|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 52 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 54 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 61 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 64 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 74 removed one line
At line 77 changed one line
[UPCALC Insufficient Earnings_04.JPG]
At line 76 added 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 80 removed 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 85 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 90 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 94 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 97 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 102 removed 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 110 changed one line
*UPCALC processes all Pay Points and Pay Point Tasks according to IPPP set up for the Pay Category of each timesheet
*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 112 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
*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 114 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 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 116 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 118 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 120 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 122 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
*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 124 changed one line
*The taxation amounts and earnings should be accurate after 2 time recursive calls to ’82-Insufficient Earnings’
*The taxation amounts and earnings should be accurate after two recursive calls to ’82-Insufficient Earnings’.
At line 126 changed one line
*in IPPP ’82-Insufficient Earnings’ pay point, the user may perform the following Pay Point Tasks:
*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 128 removed 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 146 changed 4 lines
![Discussion|Edit:Internal.UPCALC INSUFFICIENT EARNINGS]
[{InsertPage page='Internal.UPCALC INSUFFICIENT EARNINGS' default='Click to create a new discussion page'}]
}]
![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