Question: As a Payroll admin you are tasked to prepare a bi-weekly payroll calendar for your organization. Use the template below to complete the payroll calendar
As a Payroll admin you are tasked to prepare a bi-weekly payroll calendar for your organization.
Use the template below to complete the payroll calendar for 2023. Use Alberta standard stat holidays under the week it falls. Assume that Pay date is every second Friday. Complete the table below. HINT: Your final Pay Period Week should be 27 and you should have 2 rows for it: 27-1 and 27-2. The final Pay Period End Date should be 12/31/2023As a Payroll admin you are tasked to prepare a bi-weekly payroll calendar for your organization. Use the template below to complete the payroll calendar for 2023. Use Alberta standard stat holidays under the week it falls. Assume that Pay date is every second Friday. Complete the table below.
HINT:
- Your final Pay Period Week should be 27 and you should have 2 rows for it: 27-1 and 27-2.
- The final Pay Period End Date should be 12/31/2023
| Pay Period Week | Pay Period Serial # | Description | Pay Period Start Date | Pay Period End Date | Pay Date | Holiday Start | Holiday End |
| 1 | 1 | First Week of the Pay Period | 12/19/2022 | 12/25/2022 | 12/23/2022 | 12/23/2022 | |
| 1 | 2 | Second Week of the Pay Period | 12/26/2022 | 01/01/2023 | 01/06/2023 | 12/26/2022 | 12/30/2022 |
| 2 | 1 | ||||||
| 2 | 2 | ||||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
