Example of Banked Overtime Paycode in Canadian Payroll

This article introduces an example of Banked Overtime Paycode in Canadian Payroll in Microsoft Dynamics GP.

Applies to:   Microsoft Dynamics GP
Original KB number:   2003424

  1. Here's the BOT 'banked pay code' setup using a Paycode Applied by Units method. You can also see the REG hourly income pay code.

    Screenshot of a BOT banked pay code setup and the REG pay code.

  2. Here's the employee test2 that's created to test with:

    Screenshot of the Payroll Employee test2 setup.

  3. When you select the Control button on the Employee Maintenance window and you can see the following setup:

    Screenshot of the setting details of payroll employee control.

  4. Select the Paycodes tab and you will see below paycodes (REG, OT, and BOT) mapped to the employee:

    Screenshot of the Payroll Employee Paycodes detail.

  5. Here are screenprints of each of these paycodes:

    Hourly: REG

    Screenshot of the income paycode REG detail.

    Overtime code: OT

    Screenshot of the income paycode OT detail.

    Banked Overtime: BOT

    Screenshot of the banked paycode BOT detail.

  6. Now you created a batch called 13: Make sure the batch type and pay periods per year match the employee.

    Screenshot of the Payroll batch 13 setup details.

  7. Go to the Payroll Quick Entry - Canada window and key a 9 hour transaction for one day at a rate of 25.00 using the REG hourly income pay code.

    Screenshot of Payroll Quick Entry details.

  8. Then go to Payroll Generate Overtime - Canada window and Generate Overtime for the batch:

    Screenshot of the Payroll Generate Overtime - Canada window.

  9. Next go to the Payroll Calculate Batch - Canada window and Calculate the Payroll Batch:

    Screenshot of the Payroll Calculate Batch - Canada window.

  10. Then go to Reports > Payroll-Canada > Transactions > Calculation Reports and select the Detail Advice Slips button and print to screen.

    Note

    The BOT banked overtime code has a 1.00 unit record at 37.50, so all of the overtime is banked.

    Screenshot of the detail advice slips screen output.

  11. Next go to Payroll Generate Cheques - Canada and select Generate Cheques:

    Screenshot of the Payroll Generate Cheques - Canada window.

  12. Then go to Payroll Create Poster - Canada and select Create Poster File:

    Screenshot of the Payroll Create Poster - Canada window.

  13. Then go to Payroll Update Masters - Canada and Send Poster To G/L and Update Masters with Current Payroll Data.

    Screenshot of the Payroll Update Masters - Canada window.

  14. Next, go to Cards > Payroll-Canada > Employee, pull up the TEST2 Employee ID, and then select the Banked button. In the Payroll Banked Display window, select Overtime as the Banked Pay method. You should see the 1.00 unit entry against the BOT banked paycode:

    Screenshot of Payroll Banked Display details.