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...

Woman using computer in office.
April 19, 2022

There are New Employee enhancements coming your way!

KeyPay is releasing enhancements to improve the user experience when adding a New Employee.
Product
KeyPay and Zoho Books product shots integrating.
March 28, 2022

Streamline payroll reporting with Zoho Books

KeyPay has released an integration with Zoho Books so that shared users can benefit from an automated payroll and accounting experience.
Product
This is an image of a spreadsheet on a laptop screen. There is a KeyPay logo in the top left corner.
March 16, 2022

Save time on importing employee data

Introducing our newest feature - flatfile importing! You can now import employee data from other systems into KeyPay with minimal manual intervention required.
Product
Automation illustration

Not using KeyPay yet?

Try it free for 30 days

Learn more