Create New Employee from Excel Timesheet

For users with access to the payroll in the DataPay application they will have the option to import employees via the Excel Timesheet. 

It is recommended to always use an updated version of the timesheet before completing the New Employee Form. Click here to view the guide on Generating a new Excel Timesheet

We suggest that you have all of the required employee details on hand before using this method as incomplete employee forms will cause the upload to fail. 

Open the timesheet in Excel and click on the New Employee Form tab. 

Fields labelled in red are mandatory and must be completed. 

There are a number of fields which have pre-filled options and will display a validation message. Click on the drop-down arrow on the right to choose from the options. The timesheet will fail to upload if these options are not selected.

For further information on the TFN Declared By Field click here to view the guide.

Once complete, save the excel timesheet. 

To upload the New Employee form in the DataPay application, click on the Pay Run tab.

Right-Click the pay-run with the status of In Progress and select Import New Employee(s)

The Import New Employee Wizard will now open. In the first step click the Browse button to search for the excel timesheet then click Next.

The next step will run validation checks on the data entered in on the New Employee Form(s). If there are any errors it will be displayed in this section. 

You will need to correct the errors in the excel timesheet and upload it again. Otherwise click Next.

The final step will confirm if the employee import was successful.

By default a PDF report will generate to confirm the details imported for the employee(s). Click Finish to complete the process. 

Please note: the employee's work pattern and leave entitlements cannot be applied in this method and will need to be assigned from their employee profile.