This page (revision-7) 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
7 26-Nov-2021 10:22 7 KB jmyers to previous
6 26-Nov-2021 10:22 7 KB jmyers to previous | to last
5 26-Nov-2021 10:22 12 KB jmyers to previous | to last
4 26-Nov-2021 10:22 12 KB jmyers to previous | to last
3 26-Nov-2021 10:22 2 KB JMyers to previous | to last
2 26-Nov-2021 10:22 2 KB JMyers to previous | to last
1 26-Nov-2021 10:22 2 KB JMyers to last

Page References

Incoming links Outgoing links
UPFLSABONUS
UPFLSABONUS

Version management

Difference between version and

At line 7 changed one line
When ever bonuses are paid to employees for prior period earnings, [FLSA] calculations are affected when any overtime hours were worked within the prior period. In normal situations, these earnings would be dated appropriately in the prior period and FLSA would be automatically invoked during the calculation of the employee pay. If that is the case, then this process is not required and the normal pay cycle will handle the reassessment of FLSA.\\ \\
When ever bonuses are paid to employees for prior period earnings, Fair Labor Standards Act [FLSA] calculations are affected when any overtime hours were worked within the prior period. In normal situations, these earnings would be dated appropriately in the prior period and FLSA would be automatically invoked during the calculation of the employee pay. If that is the case, then this process is not required and the normal pay cycle will handle the reassessment of FLSA.\\ \\
At line 15 changed one line
Any of these calendars can easily be extended when needed by the ‘Extend Calendar’ button in IDCL.\\ \\
Any of these calendars can easily be extended when needed by the [Extend Calendar|EXTEND_CALENDAR] button in IDCL.\\ \\
At line 17 changed 3 lines
3 Element Definition
!!Element Definition
The formula/calculation used by UPFLSABONUS requires that certain elements be set up in [IPPE] to calculate the total value for hours and earnings in a bonus period.
At line 21 changed 10 lines
The User The formulae/Calculation used by UPFLSABONUS requires that ‘Elements’ be set up to calculate the total value for hours and earnings in a bonus period.
These are all required and UPFLSABONUS will terminate prematurely if any are missing.
An Element is required for ‘Regular Hours’. These are any ‘Worked Hours’ that are paid at a regular rate of Pay.
An Element is required for ‘Overtime Hours’. These are any ‘Worked Hours’ that are paid at 1.5 times the regular rate of Pay.
An Element is required for ‘Double time Hours’. These are any ‘Worked Hours’ that are paid at 2 times the regular rate of Pay.
4 FLSA Pay Component Definition
One Earnings Pay Component must be set up. This Pay Component is used to record any calculated FLSA on the prior period earnings.
Although there can be multiple ‘Bonus Periods’, only one ‘FLSA Earnings’ Pay Component should be setup. When recording any FLSA Earnings into this component, any values previously given are taken into consideration so that the FLSA is not overpaid.
This Pay Component should be defined as shown below. Be sure to toggle the Pay Component as ‘Store Results’.
%%warning These are all required and UPFLSABONUS will terminate prematurely if any are missing.%%
At line 22 added 3 lines
*An element is required for ‘Regular Hours’. These are any ‘Worked Hours’ that are paid at a regular rate of pay.
*An element is required for ‘Overtime Hours’. These are any ‘Worked Hours’ that are paid at 1.5 times the regular rate of pay.
*An element is required for ‘Double time Hours’. These are any ‘Worked Hours’ that are paid at 2 times the regular rate of pay.
At line 26 added 4 lines
!!FLSA Pay Component Definition
One Earnings pay component must be set up in order to record any calculated FLSA on the prior period earnings.
Although there can be multiple ‘Bonus Periods’, only one ‘FLSA Earnings’ pay component should be setup. When recording any FLSA Earnings into this component, any values previously given earngings are taken into consideration so that the FLSA is not overpaid.\\ \\
This pay component should be defined as shown below. Be sure to toggle the pay component as ‘Store Results’.
At line 31 added one line
[UPFLSABONUS_1.JPG]
At line 33 added 3 lines
!!Bonus Pay Components
For each different bonus period, a separate pay component must be set up for the actual bonus earnings. This pay component is used to record the actual bonus earnings for each employee when the bonus pay is entered before running UPFLSABONUS.\\ \\
Separate pay components for each type are necessary to keep the bonus earnings separated for each type of bonus period.
At line 36 changed 3 lines
5 Bonus Pay Components
For each different Bonus Period, a separate Pay Component must be set up for the actual Bonus Earnings. This Pay Component is used to record the actual Bonus Earnings for each employee when the Bonus Pay is entered before running UPFLSABONUS.
Separate Pay Components for each type are necessary to keep the bonus earnings separated for each type of bonus period.
!!The Calculations
For the bonus batch selected, the pay is evaluated for the bonus period to determine if any additional FLSA earnings need to be recorded.\\ \\
Each of the pays with a ‘Pay Issue Date’ within the bonus period is evaluated separately.\\ \\
The formula used on each pay is exactly as shown below. Dates and values have been plugged in to better illustrate the calculations.\\ \\
Bonus earnings in the batch must be dated on the last day of the bonus period.
At line 40 changed one line
An example of one is shown below.
|(A)|Hourly Rate of Pay on 11-May-2007 ==> $41.03/HR
|(B)|Quarterly Incentive from 01-Jan-2007 to 31-Mar-2007 ==> $1,000.00
|(C)|Regular Hours from 01-Jan-2007 to 31-Mar-2007 ==> 144.00
|(D)|Overtime Hours from 01-Jan-2007 to 31-Mar-2007 ==> 7.00
|(E)|Double time Hours from 01-Jan-2007 to 31-Mar-2007 ==> 7.00
|(F)|Quarterly Regular Earnings: $5,907.69 = (A) $41.03 X (C) $144.00
|(G)|Quarterly Regular Plus Incentive: $6,907.69 = (B) $1,000.00 + (F) $5,907.69
|(H)|Quarterly Adjusted Rate: $47.97 = (G) $6,907.69 / (C) $144.00
|(I)|Quarterly Hourly Rate Increment: $6.94 = (H) $47.97 - (A) $41.03
|(J)|Quarterly Overtime FLSA: $72.92 = (I) $6.94 * (D) $7.00 * 1.5
|(K)|Quarterly Overtime FLSA: $97.22 = (I) $6.94 * (D) $7.00 * 2.0
|(L)|Quarterly FLSA Total: $170.14 = (J) $72.92 + (K) $97.22 * 2.0
|(M)|Quarterly FLSA Previously Paid: $0.00
|(N)|Quarterly FLSA Retroactive Added: $170.14
At line 42 changed one line
The FLSA earnings (N) are logged into the same batch as the bonus earnings. This batch is provided as a report parameter.\\ \\
When any FLSA is recorded, the bonus pay (as well as the batch) is marked as ‘To Be Audited’. [UPAUDT] must be executed before the Bonus Batch of Incentive Earnings and FLSA Earnings (added here) can be paid to the employee.
At line 44 removed 181 lines
6 The Calculations
For the Bonus Batch selected, Pay is evaluated for the bonus period to determine if any additional FLSA earnings need to be recorded.
Each of the Pays with a ‘Pay Issue Date’ within the bonus period is evaluated separately.
The formulae used on each pay is exactly as shown below. Dates and values have been plugged in to better illustrate the calculations.
Bonus earnings in the batch must be dated on the last day of the Bonus Period.
(A) Hourly Rate of Pay on 11-May-2007 ==> $41.03/HR
(B) Quarterly Incentive from 01-Jan-2007 to 31-Mar-2007 ==> $1,000.00
(C) Regular Hours from 01-Jan-2007 to 31-Mar-2007 ==> 144.00
(D) Overtime Hours from 01-Jan-2007 to 31-Mar-2007 ==> 7.00
(E) Double time Hours from 01-Jan-2007 to 31-Mar-2007 ==> 7.00
(F) Quarterly Regular Earnings: $5,907.69 = (A) $41.03 X (C) $144.00
(G) Quarterly Regular Plus Incentive: $6,907.69 = (B) $1,000.00 + (F) $5,907.69
(H) Quarterly Adjusted Rate: $47.97 = (G) $6,907.69 / (C) $144.00
(I) Quarterly Hourly Rate Increment: $6.94 = (H) $47.97 - (A) $41.03
(J) Quarterly Overtime FLSA: $72.92 = (I) $6.94 * (D) $7.00 * 1.5
(K) Quarterly Overtime FLSA: $97.22 = (I) $6.94 * (D) $7.00 * 2.0
(L) Quarterly FLSA Total: $170.14 = (J) $72.92 + (K) $97.22 * 2.0
(M) Quarterly FLSA Previously Paid: $0.00
(N) Quarterly FLSA Retroactive Added: $170.14
The FLSA earnings (N) are logged into the same batch as the Bonus Earnings. This batch is provided as a Report Parameter.
When any FLSA is recorded the Bonus Pay (As well as the Batch) is marked as ‘To Be Audited’. UPAUDT must be executed before the Bonus Batch of Incentive Earnings and FLSA Earnings (Added here) can be paid to the Employee.
7 Report Parameters
Each type of Bonus Period is processed separately. For example, the ‘Monthly’ Bonus is executed separately from the ‘Term Bonus’. Be careful to select the correct ‘Bonus Pay Component’ for the type of Bonus.
The single Batch Number selected contains the Bonus Earnings for each Employee paid a bonus. There can be more than one Bonus Batch, however they are processed separately.
8 Report Output
The output consists of Execution Run Logs only. Any errors and warnings are logged here. All FLSA is recorded into the batch selected on the parameter form, and the results can be seen by printing UPAUDT for the batch.
Generate FLSA on Prior Bonus Earnings
Execution # 307024
Function: UPFLSABONUS
Run By: RDEPAPP
Run Start Date: Mar 9, 2010 11:54:52 AM
Entity: USA CITY
Payroll: BW HOURLY
Bonus Batch Number: 8987
Bonus Calendar: MONTHLY
Bonus Period: 200701
Trial: Yes
Exception Level: 1-User Trace
User Comment: Rudy Comment
Bonus Pay Component: 1121
FLSA Pay Component: 1225
Regular Hours: REG HOURS
Overtime Hours: OT HOURS 1.5
Double Time Hours: OT HOURS 2.0
Lv Module Context Message
1 RETROFLSA FLSA Bonus Calculator Version 20100309
1 RETROFLSA BONUS Calendar (MONTHLY) Monthly Payroll
1 RETROFLSA BONUS Period (200701) From 01-JAN-2007 to 31-JAN-2007
0 RETROFLSA Trial: Y
0 RETROFLSA Process Bonus Batch number 8987
1 RETROFLSA Bonus Pay Component: (1121) Monthly Incentive Bonus $
1 RETROFLSA FLSA Pay Component: (1225) FLSA on Incentive Bonus
1 RETROFLSA Regular Hours Element: (REG HOURS) Regular Hours
1 RETROFLSA Overtime Hours Element: (OT HOURS 1.5) Overtime Hours
1 RETROFLSA Double Time Hours Element: (OT HOURS 2.0) OT Hours at 2.0
1 RETROFLSA Period Begin Date: 01-JAN-2007
1 RETROFLSA Period End Date: 31-JAN-2007
1 RETROFLSA FLSA Bonus Calculator Version 20100309
1 RETROFLSA ***************************
| (BONUS 1) Mckenzie, Bob |
***************************
1 RETROFLSA Bonus Before Bonus End Date: $0.00
1 RETROFLSA Bonus on Bonus End Date: $750.00
1 RETROFLSA Bonus After Bonus End Date: $0.00
1 RETROFLSA ***************************
| (BONUS 1) Mckenzie, Bob |
***************************
1 RETROFLSA Rate of Pay on 11-MAY-2007 ==> $80,000.00/YR
1 RETROFLSA (A) Hourly Rate of Pay on 11-MAY-2007 ==> $41.03/HR
1 RETROFLSA (B) Incentive from 01-JAN-2007 to 31-JAN-2007 ==> $750.00
1 RETROFLSA (C) Regular Hours from 01-JAN-2007 to 31-JAN-2007 ==> 144.00
1 RETROFLSA (D) Overtime Hours from 01-JAN-2007 to 31-JAN-2007 ==> 7.00
1 RETROFLSA (E) Doubletime Hours from 01-JAN-2007 to 31-JAN-2007 ==> 0.00
1 RETROFLSA (F) Regular Earnings: $5,907.69 = (A) $41.03 X (C) $144.00
1 RETROFLSA (G) Regular Plus Incentive: $6,657.69 = (B) $750.00 + (F) $5,907.69
1 RETROFLSA (H) Adjusted Rate: $46.23 = (G) $6,657.69 / (C) $144.00
1 RETROFLSA Rate increased by $5.21
1 RETROFLSA (I) Hourly Rate Increment: $5.21 = (H) $46.23 - (A) $41.03
1 RETROFLSA (J) Overtime FLSA: $54.69 = (I) $5.21 * (D) $7.00 * 1.5
1 RETROFLSA (K) Overtime FLSA: $0.00 = (I) $5.21 * (E) $0.00 * 2.0
1 RETROFLSA (L) FLSA Total: $54.69 = (J) $54.69 + (K) $0.00 * 2.0
1 RETROFLSA (M) FLSA Previously Paid: $0.00
1 RETROFLSA (N) FLSA Retroactive Added: $54.69
1 RETROFLSA FLSA Bonus Calculator Version 20100309
1 RETROFLSA *****************************
| (BONUS 2) Mackenzie, Doug |
*****************************
1 RETROFLSA Bonus Before Bonus End Date: $0.00
1 RETROFLSA Bonus on Bonus End Date: $700.00
1 RETROFLSA Bonus After Bonus End Date: $0.00
1 RETROFLSA *****************************
| (BONUS 2) Mackenzie, Doug |
*****************************
1 RETROFLSA (A) Hourly Rate of Pay on 11-MAY-2007 ==> $28.00/HR
1 RETROFLSA (B) Incentive from 01-JAN-2007 to 31-JAN-2007 ==> $700.00
1 RETROFLSA (C) Regular Hours from 01-JAN-2007 to 31-JAN-2007 ==> 144.00
1 RETROFLSA (D) Overtime Hours from 01-JAN-2007 to 31-JAN-2007 ==> 10.00
1 RETROFLSA (E) Doubletime Hours from 01-JAN-2007 to 31-JAN-2007 ==> 0.00
1 RETROFLSA (F) Regular Earnings: $4,032.00 = (A) $28.00 X (C) $144.00
1 RETROFLSA (G) Regular Plus Incentive: $4,732.00 = (B) $700.00 + (F) $4,032.00
1 RETROFLSA (H) Adjusted Rate: $32.86 = (G) $4,732.00 / (C) $144.00
1 RETROFLSA Rate increased by $4.86
1 RETROFLSA (I) Hourly Rate Increment: $4.86 = (H) $32.86 - (A) $28.00
1 RETROFLSA (J) Overtime FLSA: $72.92 = (I) $4.86 * (D) $10.00 * 1.5
1 RETROFLSA (K) Overtime FLSA: $0.00 = (I) $4.86 * (E) $0.00 * 2.0
1 RETROFLSA (L) FLSA Total: $72.92 = (J) $72.92 + (K) $0.00 * 2.0
1 RETROFLSA (M) FLSA Previously Paid: $0.00
1 RETROFLSA (N) FLSA Retroactive Added: $72.92
1 RETROFLSA Number of Incentive Bonus Pays 2
1 RETROFLSA Number of FLSA Lines Added ==> 2
1 RETROFLSA Amount of FLSA Added ==> 127.61
1 RETROFLSA All Data has been Rolled Back
1 P2K_PMRPT CREATE_MEX Starting create_mex p_mfn_id = 4272 v_mex.id: 307024
1 P2K_PMRPT CREATE_MEX Starting create_mex UPDATE p2k_am_executions SET id = 307024,DESTYPE = 'CACHE',PRINT_ORIENTATION = 'PORTRAIT',RETURN_CODE = '00',DESFORMAT = 'PDF',DESTINATION = 'REPMERCURY' WHERE id = 307024
1 INIT Init k_trace_level: 1, k_sort_stage=10, k_sort_thread=0
!!Processing Information
The (UPFLSABONUS) report will generate the Fair Labor Standards Act ([FLSA]) on prior earnings.
----
At line 62 added one line
Each type of bonus period is processed separately. For example, the ‘Monthly’ bonus is executed separately from the ‘Term Bonus’. Be careful to select the correct ‘Bonus Pay Component’ for the type of bonus.
At line 64 added 2 lines
The single batch number selected contains the bonus earnings for each employee paid a bonus. There can be more than one bonus batch, however, they are processed separately.
At line 83 added 3 lines
!!Report Output
The output consists of Execution Run Logs only; any errors and warnings are logged here. All FLSA is recorded into the batch selected on the parameter form, and the results can be seen by printing [UPAUDT] for the batch.
This page (revision-7) was last changed on 26-Nov-2021 10:22 by jmyersTop