[BCB:5:Third-party support:ECB] All reports and formulas listed below use the following Pay IDs: - REG=Regular Pay id
- OT=Overtime Pay id (factor 1.5)
- DT=Doubletime Pay id (factor 2.0)
The Premium portion of Double time equals the (Double time rate*0.50)*0.50. This is due to the FLSA not recognizing Double time pay. If you don’t use these Pay IDs, or factors, modify the reports and formulas so that they display the correct calculations. Calculation Examples OT Amount will be multiplied by .66667, and then subtracted from the OT amount: $50.00*1.5=75, Formulas subtract the REG rate from the OT calculation resulting in the Premium portion of this pay of $25.00. DT Amount will be multiplied by 0.50, then multiplied by 0.50 again. $50.00*2=100, It divides the amount and divides in half again. This results in the Premium portion of this pay of $25.00. The premium portion of Double time pay won’t exceed the premium portion of Overtime pay. Reports Add these reports to your menu in Payroll. Pay Detail by Employee with OT-DT-1 Page per EE Print this report and give it to your employee with their W-2. - Transaction file report
- Uses the check date
- Prints one page per employee
Pay Detail by Employee with OT-DT Calculations Provide this report to assist the employer with validating totals. - Transaction file report
- Uses the check date
- Provides report totals
Prior Year OT-DT Employee Pay Totals Provide this report to assist the employer with validating totals. - Master file report
- Retrieves prior year amounts
Formulas Alternatively, you can add the following formulas to report Overtime and Double time premiums on Box 14 of the W-2 form for 2025. Create the following formulas Prior Year OT LOOKUP(Prior Year Pay[PR Employee Pay],Employee[PR Employee],2,"OT") PrYr OT*.66667 Prior Year OT[Public Formula]*0.66667 PrYr OT Exemption Prior Year OT[Public Formula]-PrYr OT*.6667[Public Formula] Prior Year DT LOOKUP(Prior Year Pay[PR Employee Pay],Employee[PR Employee],2,"DT") PrYR DT Exemption (Prior Year DT[Public Formula]*0.50)*0.50 PrYr OT Premium PrYr DT Exemption[Public Formula]+PrYr OT Exemption[Public Formula] Add Formula to the W-2 Form - Go to Payroll, Tools, Modify, W-2 Forms.
- Select the W-2 format.
- Click the Amounts tab.
- Tab to Box 14.
- Box 14 can have several lines of detail.
- Use the Text button to add a description to the first available blank line. For example, PrYrOT.
- Use the Formula button to add your formula. For example, PrYr OT Premium.
- Click Save.
|