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

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
18 26-Nov-2021 10:22 7 KB jmyers to previous
17 26-Nov-2021 10:22 9 KB jmyers to previous | to last
16 26-Nov-2021 10:22 9 KB jmyers to previous | to last
15 26-Nov-2021 10:22 8 KB jmyers to previous | to last
14 26-Nov-2021 10:22 4 KB jmyers to previous | to last
13 26-Nov-2021 10:22 4 KB jmyers to previous | to last
12 26-Nov-2021 10:22 4 KB jmyers to previous | to last
11 26-Nov-2021 10:22 4 KB jmyers to previous | to last
10 26-Nov-2021 10:22 4 KB jmyers to previous | to last
9 26-Nov-2021 10:22 4 KB jmyers to previous | to last
8 26-Nov-2021 10:22 4 KB jmyers to previous | to last
7 26-Nov-2021 10:22 4 KB jmyers to previous | to last
6 26-Nov-2021 10:22 4 KB jmyers to previous | to last
5 26-Nov-2021 10:22 4 KB jmyers to previous | to last
4 26-Nov-2021 10:22 4 KB jmyers to previous | to last
3 26-Nov-2021 10:22 4 KB jmyers to previous | to last
2 26-Nov-2021 10:22 4 KB jmyers to previous | to last
1 26-Nov-2021 10:22 4 KB jmyers to last

Page References

Incoming links Outgoing links
GROSS UP AWARD PROCESS
GROSS UP AWARD PROCESS

Version management

Difference between version and

At line 7 changed one line
[{$applicationname}] uses third party software for legislative calculations. As a result there are no tax rates held in [{$applicationname}]. In order to calculate the gross up amount the federal, state, FICA and Medicare deduction percentages are referenced from user variables. These are then applied to the target amount to be paid to arrive at a gross pay which will, after all deductions are taken be the target amount.
Personality uses third party software for legislative calculations. As a result there are no tax rates held in Personality. In order to calculate the gross up amount the federal, state, FICA and Medicare deduction percentages are referenced from user variables. These are then applied to the target amount to be paid to arrive at a gross pay which will, after all deductions are taken be the target amount.
At line 10 changed one line
The tax rates are stored in the Vertex software and as such, [{$applicationname}] has no facility to access them for use in a process such as a gross-up. Tax percentages have been set up in the following user variables:
The tax rates are stored in the Vertex software and as such, Personality has no facility to access them for use in a process such as a gross-up. Tax percentages have been set up in the following user variables:
At line 77 changed one line
UserCalc
!PR-GROSSUP_1
At line 79 changed 29 lines
Run By: P2K RMUC-20031113 User: P2K Product: PR Name: PR-GROSSUP_1 Usage: Variable Name Variable Type Tax-Fed Number Tax-St Number Line Com. Operand 1 User: P2K Product: PR Name: PR-GROSSUP_2 Usage: 10 LET Variable 20 LET Variable 30 LET Global Variable 40 LET Pay Component - Current (N) 50 LET Pay Component - Current (N) 99999 EXIT Tax-Fed Tax-St Gross_up_value 2110 2110 Variable Name Variable Type Fed_difference Number State_difference Number difference Number net_pay Number User Calcs 28-May-2004 16:44:47 Personality 2000 Page: 1 of 2 Type: Calculation Return Value: Status: In Production Description: Calc taxes using fixed percent Variable Length Initial Value 0 0 Oper. Operand 2 Operand 3 Go to Else Description Type: Calculation Return Value: Status: In Production Description: PRC Element - Current (N) User Consant 20 Calulate Federal and PRC Element - Current (N) User Consant 30 Load State taxes into a EQ Pay Component - Current (N) 40 Load the entered grossADD Pay Component - Current (N) Variable 99999 add state taxes to grossGROSS TAX_%_FED state taxes on a grossGROSS TAX_%_STATE varaible 2110 up amount, before2110 Tax-Fed up amount 2110 Tax-St up amount. This willup amount based on UserVariables holding thetax rate percentages.This user calc is in IPPP before taxes are calculated ++++++++++++++++++++++++ ++++++++++++++++++++++++ ++++++++++++++++++++++++ Load Federal tax calc into a variable estimated taxes are added, to be picked upby user calc PRGROSSUP_2. ADD Pay Component - Current (N) Variable 50 Add Fed taxes to grossrepresent the gross up +federal and state taxes based on UV percentages Variable Length Initial Value 0 0 0 0
RMUC-20031113 Personality 2000 Page: 2 of 2
Run By: P2K User Calcs 28-May-2004 16:44:47
Line Com. Operand 1 Oper. Operand 2 Operand 3 Go to Else Description
10 LET net_pay Variable SUB GROSS Element - Current (N) DEDUCTIONS Element - Current (N) 20 This user calc finds the difference between the estimated gross up taxesand the calcuated taxes.
The difference is
prorated and added backto the Fed and State tax
deduction so that the
Net Pay is the amount ofthe gross up pay beforetax estimates are added.
This User Calc must be
in the 70-After Govt
Calc pay point type inIPPP
++++++++++++++++++++++++
++++++++++++++++++++++++
++++++++++++++++++++
20 IF Gross_up_value Global Variable EQ net_pay Variable 99999 30 Determine the net payIf the gross up value isthe same as net pay,exit
30 LET Variable SUB Variable Global Variable 40 Determine the difference
40 LET difference Variable DIV net_pay User Consant Gross_up_value User Consant 50 betwen the net pay andthe gross up valueDetermine the ratio of
Fed_difference TAX_%_STATE TAX_%_FED Fed to State taxes and load into variable. This
will be the factor to
mulitply the differenceby to determine whatprotion is for Fedtaxes.
50 LET Variable MLT Variable Variable 60 This is the emount that
Fed_difference difference Fed_difference is the Federal Tax difference
60 LET Variable SUB Variable Variable 70 This is the amount that
State_difference difference Fed_difference is the State Tax difference
70 LET 6000 Pay Component - Current (N) ADD 6000 Pay Component - Current (N) Fed_difference Variable 80 Add the Federal Tax differenc to exisitingFederal Tax deduction
80 LET 6020 Pay Component - Current (N) ADD 6020 Pay Component - Current (N) State_difference Variable 99999 Add the State Tax difference to the existing State Taxdifference
99999 EXIT
Personality 2000
||Variable Name||Variable Type||Variable Length||Initial Value
|Tax-Fed Number| Number| |0
|Tax-St |Number| |0
At line 109 removed one line
User Calcs
At line 111 changed one line
End of Report
||Line||Com.||Operand 1||Oper.||Operand 2||Operand 3||Go To||Else||Description
|10|LET|Variable\\Tax-Fed|PRC|Element-Current (N)\\GROSS|User Consant\\TAX_%_FED|20| |Calculate Federal and state taxes on a gross up amount based on User Variables holding the tax rate percentages. This UserCalc is in IPPP before taxes are calculated.\\++++++++++++++++++++++++\\++++++++++++++++++++++++\\++++++++++++++++++++++++\\Load Federal tax calc into a variable
|20|LET|Variable\\Tax-St|PRC|Element-Current (N)\\GROSS|User Consant\\TAX_%_STATE|30| |Load State taxes into a variable
|30|LET|Global Variable\\Gross_up_value|EQ|Pay Component - Current (N) 2011| |40| |Load the entered gross up amount, before estimated taxes are added, to be picked up by UserCalc PR-GROSSUP_2.
|40|LET|Pay Component - Current (N) 2110|ADD|Pay Component - Current (N) 2011|Variable Tax-Fed |50| |Add Fed taxes to gross up amount
|50|LET|Pay Component - Current (N) 2110|ADD|Pay Component - Current (N) 2011|Variable Tax-St|99999| |Add state taxes to gross up amount. This will represent the gross up + federal and state taxes based on UV percentages.
|99999|EXIT| | | | | | |
At line 93 added 23 lines
!PR-GROSSUP_2
||Variable Name||Variable Type||Variable Length||Initial Value
|Fed_difference| Number| |0
|State_difference |Number| |0
|difference |Number| |0
|net_pay |Number| |0
||Line||Com.||Operand 1||Oper.||Operand 2 ||Operand 3||Go to||Else||Description
|10 |LET |Variable\\net_pay |SUB|Element - Current (N)\\GROSS|Element - Current (N)\\DEDUCTIONS|20| |This UserCalc finds the difference between the estimated gross up taxes and the calculated taxes. The difference is prorated and added back to the Fed and State tax deduction so that the Net Pay is the amount of the gross up pay before tax estimates are added. This UserCalc must be in the 70-After Govt Calc pay point type in IPPP\\++++++++++++++++++++++++\\++++++++++++++++++++++++\\++++++++++++++++++++
|20|IF|Global Variable\\Gross_up_value|EQ |Variable\\net_pay | |99999 |30 |Determine the net pay If the gross up value is the same as net pay,exit
|30|LET|Variable\\difference|SUB|Variable\\net_pay|Global Variable\\Gross_up_value|40| |Determine the difference between the net pay and the gross up value
|40|LET|Variable\\Fed_difference|DIV|User Constant\\TAX_%_STATE|User Constant\\TAX_%_FED|50| |Determine the ratio of Fed to State taxes and load into variable. This will be the factor to multiply the difference by to determine what portion is for Fed taxes.
|50|LET |Variable\\Fed_difference|MLT|Variable\\difference|Variable\\Fed_difference|60| |This is the amount that is the Federal Tax difference
|60|LET |Variable\\State_difference|SUB|Variable\\difference|Variable\\Fed_difference|70| |This is the amount that is the State Tax difference
|70|LET|Pay Component - Current (N)\\6000|ADD|Pay Component - Current (N)\\6000|Variable\\Fed_difference|80| |Add the Federal Tax difference to existing Federal Tax deduction
|80|LET |Pay Component - Current (N)\\6020|ADD|Pay Component - Current (N)\\6020|Variable\\State_difference| 99999| |Add the State Tax difference to the existing State Tax difference
|99999|EXIT| | | | | | |
This page (revision-18) was last changed on 26-Nov-2021 10:22 by jmyersTop