Pro rata hours now auto calculated in pay run

Pro rata hours auto calculated in pay run

Previously, when a new employee started or, alas, an employee left, the hours to be paid for the employee had to be manually calculated and adjusted in the pay run. Sorry about that... On a positive note though, we're happy to say this is no longer the case. If an employee starts or leaves within the pay period, we will automatically calculate the pro rata hours for you! No manual adjustments required!

I hear what you're saying but an example would be great!

Who doesn't love a before and after shot! Rather than seeing the amount of weight lost (or gained) this example will highlight the amount of time you will now save in the pay run.

So, there is a new employee, Edward Norrington, who started employment on 12/7/18. He is part of the monthly pay run that runs from the start of the month to the end of the month. He is employed to work on a part time basis - 20 hours per week.

Pay Run Hours (Before)

The hours displayed in the pay run would be for the whole month, regardless of the fact Edward didn't work the whole month. This is where a manual calculation and adjustment of hours was required:

Pro rata hours

Pay Run Hours (After)

The hours calculated in the pay run now apply from the employee's start date up to the end of the pay period. No manual calculation and adjustment of hours are now required:

Pro rata hours

The logic we've used to automatically calculate the pro rata hours (using the above example) is as follows:

  1. Number of days worked in the pay period / Total number of days in the pay period = 0.64516
  2. Total number of hours the employee will be working in the pay period = 86.66667 hrs
  3. 0.64516 * 86.66667 = 55.91387, or 55.91 hrs.

What employee settings are required for this magic to work?

Magic always has it's hidden secrets. In this instance, we won't keep them hidden from you. In order for the pro rata hours to be calculated automatically in the pay run, the following needs to be setup within the employee's pay run defaults screen:

  • There are basic standard hours entered (ie the employee's standard weekly hours). If '0' hours are entered please don't expect anything to happen in the pay run!; and
  • The setting "Pay these earnings by default in a pay run" is ticked.

(N.B. This enhancement already existed for employees with advanced standard hours set up).

How will I know the pro rata hours have occurred in the pay run?

We have added a warning in the pay run to highlight when an employee has pro rata hours in the pay run, as follows:

Pro rata hours

As a result, this will:

  1. Highlight new and terminated employees without having to keep reminder notes;
  2. Allow you to check the correct start/termination dates have been setup for the employee;
  3. Ensure you double check the hours are correct for any exceptional situations, for eg if the employee did start on the 12th but only worked 2 days in that first month, you can easily change the hours in the pay run.

How does this benefit me as a payroll officer?

Have you had scenarios where:

  • You simply forgot there was a new starter in the pay run and so overpaid them because the hours weren't adjusted to account for the employee not working the full pay period?
  • You accidentally forgot to adjust the hours of a terminated employee whose end date was earlier than the pay period end date and consequently overpaid the employee?
  • Trying to calculate the pro rata hours required a calendar, calculator and extreme patience?

No one really wants to spend hours processing a pay run or making errors that can be avoided. This enhancement is another tool that will assist users in eliminating manual calculations and processes and getting closer to finalising that pay run!

Dimitra Karas

Follow me on:


You might also like...

This is a photo of a person's hands at a computer desk. They are typing into a calculator and processing payroll. There is the KeyPay logo in the top left corner of the photo.
April 21, 2022

5 things to keep in mind when running payroll for public holidays in New Zealand

From Mondayisation to processing payroll on ANZAC Day, here's some things that all outsourced payroll providers should consider on public holidays in NZ.
Industry Insights
This is an image of a female business owner who is approving timesheets and looking at paperwork. The white KeyPay logo is in the top left corner of the image.
March 1, 2022

No more manual timesheet approvals!

No more manually approving timesheets against hours worked; if a timesheet matches the roster exactly, the system will auto-approve this for you!
This is an image of a nurse and an elderly woman, smiling at each other.
January 17, 2022

Managing your caregiver team: 4 ways to improve efficiency

Managing caregiver teams and support workers can be complex, time-consuming and stressful. Consider a few minor changes to save time and cut down costs.
Industry Insights
Automation illustration

Not using KeyPay yet?

Try it free for 30 days

Learn more