Import hours worked from People Planner

Access People Planner is a home care management product for scheduling and rostering.

You can export the time worked by employees as a CSV file and import it here to set the amount to pay your employees.

Preparation

First, ensure that the Employee Reference used in the People Planner matches the Payroll Code for the employee in the payroll software.

Secondly, you may wish to create additional Pay Codes as we’ll shortly be mapping each Payment Reference value in People Planner to a Pay Code.

Before importing payments, you must have started a payrun. This process will overwrite any existing payment values on the payrun.

Import CSV

On the payrun page, select Import Payments.

From the options provided, choose to import from People Planner.

You’ll receive a prompt to browse for a CSV file. Locate the file you exported from People Planner.

We’ll parse the file and extract the list of Payment Reference values used.

An example People Planner CSV file show in Excel

Map Payment References

You’ll now need to map the list of Payment References to Pay Codes.

For the standard regular hours, choose Regular Pay.

Unless you’ve changed the setting for an employee, this will result in a payment to the BASIC code.

You can map any additional Payment References to other codes you may have created, such as Holiday Pay or Overtime.

You’ll only need to do this once as we save your choices so that the next time you do this, you only need to click the button to confirm the pre-selected choice.

Preview Import

Once you’ve mapped the codes you can now preview the import.

If you’re happy with the values shown, select Import Data to update your payment amounts for the payrun.


Need more help? Email hello@staffology.co.uk