Double-Pay Report

Double-Pay Report is under Payroll ⇒ Payroll Reports.

Double-PayReport20220729105552333.xlsx

Only Monthly-Rated Employees are shown on the report.

You can import the double-pay of the employee using the Payroll Amendment import function.

Report Columns

    • Employee No

    • Employee Name

    • Dept Code

    • Division

    • Employer

    • Work Location

    • Double Pay (Average Basic Wages)

      1. Use the employee Appointment History for reporting.

      2. Does not consider actual Payroll in Payroll Batch.

      3. Does not consider Basic Salary in Salary Info Tab in Employee Master.

      4. Leap year (i.e. 366) is also considered if the given year is a leap year.

      5. For existing employees and there is no appointment history in the given year, use the latest Salary Column in the Appointment History Tab as Double Pay Amount.

      6. Otherwise, based on each Appointment records in the Salary Column in Appointment History Tab. e.g. (01/01/2010 - 14/04/2010) / 365 * $10000 + (15/04/2010 - 11/11/2010)/365 * $10500 + (12/11/2010 - 31/12/2010)/365 * $12000.

      7. For new join and terminated employees, consider the join date and termination date also (i.e. the 365 is replaced by the elapsed days).

  • Double Pay (Last Basic Wages)

      1. Use the employee Appointment History for reporting.

      2. Does not consider actual Payroll in Payroll Batch.

      3. Does not consider Basic Salary in Salary Info Tab in Employee Master.

      4. Leap year (i.e. 366) is also considered if the given year is a leap year.

      5. For existing employees and there is no appointment history in the given year, usethe latest Salary Column in the Appointment History Tab as Double Pay Amount.

      6. Based on the Appointment records in the Salary Column in the Appointment History Tab at Dec 31.

      7. For new join and terminated employees, consider the Probation End Date and termination date also (i.e. the 365 is replaced by the elapsed days).

    • Double Pay (Average Regarded Wages)

      1. Average Monthly Wage will be used to calculate the Double Pay Amount.