Maximise efficiency by bulk importing Employee Advanced Standard Hours

A woman sits at a desk and is typing on a computer keyboard with one, and holding up a piece of paper to read. There is a pen between her fingers, as well as a clipboard and a computer mouse on the desk that she is sitting at.

As payroll administrators, we are constantly looking for ways to increase efficiency and streamline processes, which means bulk importing! If we can bulk import or update data, we will! Am I right?

KeyPay allows users to bulk import various data files, including employees, opening balances, pay rate templates and much more. Importing employee data is one way that users are able to add new and update existing employee profiles in bulk. One exception to this is that the data included in the import/export files did not capture the employees ‘advanced standard hours'...until now.

If you've not used Advanced Standard Hours before, they are located in the employee's pay run defaults page and allow users to allocate specific hours, breaks and locations on different days across 2 separate weeks. Currently the advanced hours are not included in either the export or import options when managing employee records. This means that any changes need to be made manually for each employee.

What's new?

The new Advanced Standard Hours export/import feature will allow users to significantly decrease the time it takes to update their employees' work week. Imagine: your hours of operation have changed and you're updating the advanced standard hours for 50 employees. Some of the employees are changing and some are staying the same, however you need to review the current hours first. You're not able to export the existing hours, but need to manually access each employee's profile to review their current setup. Then when you're ready to edit, you also have to manually make the changes. What a headache!

Now, you can export the existing data, edit the document and reimport all within a few steps. The beauty of this new feature is just how much time it will save! But wait, there's more...

The best part: easy data matching!

In the past, KeyPay users were required to enter employee data in a specific format and save the file as Excel or CSV before being able to upload the document to KeyPay. This often meant copying and pasting information into the exported template, resulting in formatting or data entry errors.

Flexible employee payroll data imports

The Advanced Standard Hours import feature will be using a new flexible file import method that can be customised based on the user's file format. E.g. In the past, if you were using Micropay you would have to export your employee data, copy and paste the information into KeyPay's exported template and then upload it. Now, as long as you're using the advanced importer you can export your spreadsheet directly from Micropay into KeyPay. Once the spreadsheet has been uploaded, you will be able to review and edit data, map the columns and best of all, you can memorise the settings for future imports!

This new feature really is a two-for-one special, allowing KeyPay users to increase efficiency and reduce errors.

Find out more about this exciting feature via our support articles: AU | UK | NZ | SG | MY

Bec Allen

Support at KeyPay

You might also like...

3 air stewardesses walking in an airport towards the tarmac and a plane. They are wearing blue dresses, and are each pulling along a suitcase behind them.
November 3, 2021

Group 3 modern award pay rates have now been increased

In line with Fair Work's 2.5% increase to the national minimum wage and awards, KeyPay has now updated our Group 3 modern award pay rates.
A person's hand is seen holding a pen and writing on a piece of paper, whilst they are sitting at a table. There is a Mac laptop on the left side of the photo, and there is a glass containing a liquid beverage in the background of the photo. There is a KeyPay logo in the top left corner of the photo.
September 27, 2021

Save time through splitting earnings by location!

From next week, payroll administrators will now be able to automate the distribution of earnings across different locations.
KeyPay's Document Acknowledgement Report. Office worker sitting at the desk and looking at her laptop and holding her mobile phone on her left hand.
September 2, 2021

The Document Acknowledgement Report is here!

The new Document Acknowledgement Report will allow KeyPay users to review the acknowledgment status and send reminders at the same time!
Automation illustration

Not using KeyPay yet?

Try it free for 30 days

Learn more