I've always taken for granted that the bi-weekly payroll calculation works until I was faced with a question from an employee I could not answer. Best explained with an example, so assume the following basic example for the year 2019 to illustrate:
You have an employee that earns a salary of $26,000 per year. That employee was hired on 1/1/19 and terminated on 12/31/19. So, in theory they should receive exactly $26,000 as payment.
The pay schedule for the company is bi-weekly, where they are paid each Friday for the previous 2 weeks. And, the first pay date for the year is 1/4/19.
For some reason, I cannot get the sum of all the bi-weekly payments to match $26,000. In other words, they don't end up getting paid $26,000. By my calculations they get paid $26,100. An extra $100.
Here's the calculation: First, note that with a bi-weekly payroll, they should expect to get paid $1,000 per week
1. Pay period 01/04/19 is for work during 12/16/18 to 12/29/18. So they don't get anything that week.
2. Pay period 01/18/19 is for work during 12/30/18 to 01/12/19. Here they only worked 9 of the 10 days, so the payroll was prorated to $900
3. The next 25 pay periods from 02/01/19 to 01/03/20 cover everything from 01/13/19 to 12/28/19. And, they get the full amount of $1,000 per week
4. Pay period 01/17/20 is for work during 12/29/19 to 01/11/20. Here they only worked 2 of the 10 days, so the payroll was prorated to $200
5. Given the above the sum of the bi-weekly amounts equal $900 + ($1,000 X 25) + $200 = $26,100
Why doesn't their annual salary doesn't match the sum total of the relevant bi-weekly payments for that year?
You have an employee that earns a salary of $26,000 per year. That employee was hired on 1/1/19 and terminated on 12/31/19. So, in theory they should receive exactly $26,000 as payment.
The pay schedule for the company is bi-weekly, where they are paid each Friday for the previous 2 weeks. And, the first pay date for the year is 1/4/19.
For some reason, I cannot get the sum of all the bi-weekly payments to match $26,000. In other words, they don't end up getting paid $26,000. By my calculations they get paid $26,100. An extra $100.
Here's the calculation: First, note that with a bi-weekly payroll, they should expect to get paid $1,000 per week
1. Pay period 01/04/19 is for work during 12/16/18 to 12/29/18. So they don't get anything that week.
2. Pay period 01/18/19 is for work during 12/30/18 to 01/12/19. Here they only worked 9 of the 10 days, so the payroll was prorated to $900
3. The next 25 pay periods from 02/01/19 to 01/03/20 cover everything from 01/13/19 to 12/28/19. And, they get the full amount of $1,000 per week
4. Pay period 01/17/20 is for work during 12/29/19 to 01/11/20. Here they only worked 2 of the 10 days, so the payroll was prorated to $200
5. Given the above the sum of the bi-weekly amounts equal $900 + ($1,000 X 25) + $200 = $26,100
Why doesn't their annual salary doesn't match the sum total of the relevant bi-weekly payments for that year?