If you have implemented a payroll system such as Xero, Quickbooks, Netsuite, Gusto, MYOB, ADP or WageEasy, you can import your payroll file into Deputy to add people.

Adding employees via Excel Spreadsheet

If you have your employees in a simple Microsoft Excel file, you can also add employees via Excel spreadsheet. For a downloadable template, click here. Please remember to remove the sample employee, and to save/download the file as a CSV file.

To get the most accurate information, fill in the spreadsheet with the fields above as shown in the screenshot (First name, last name, time card no., email address, mobile no., date of birth, employment date, hourly rates for weekdays, Saturdays, Sundays and public holidays). Ensure that the file is saved as a CSV file

Now head over to the People page via the Navigation bar and click ‘Add People’, and when the drop-down menu appears, click ‘Import People’

Now select which location that these imported people will work in, click the ‘Import or Upload a file’ drop down box, and scroll down to ‘Excel’.

A box will appear, which shows a list of steps to follow if you have not created the spreadsheet yet. This box also has a clickable link that allows you to download a spreadsheet template that you can fill in.

If you’ve already completed the spreadsheet, simply ignore the instructions. Click ‘Browse’ and locate the CSV file on your computer. When it says, ‘[filename].csv is ready to upload, click ‘Upload File’.

Now that the fields are auto-filled, double check that all details are correct, in the rare event of errors. If everything is correct, click Add People and they will be added to Deputy.

Did this answer your question?