Timesheet Template Upload

Timesheet Template Upload

This upload file will allow you to bulk change any pay or deduction element, with the calculation rule "Rate as Keyed" for multiple employees at once. The new rate for anyone on the upload file, will be applied to the next pay period or if your pay is already open, it will update the existing payroll.
We recommend reviewing the employee's Timesheet Templates after the upload by going to Reports > HR > Timesheet Templates.

Downloading the Template 

      1. People > Tools > Timesheet Template Transactions Upload
      2. Select Download Template



      3. Open the file
      4. Save the file 
      5. Review the existing rates for all employees. 
      6. Edit any employees that you wish to update the rate for - (Enable Editing may need to be selected)
      7. Delete any employees that you do not intend to change the rate for. 
      8. Make sure there are no formulas in the file, as the file will not upload.
      9. Save the file

Below is a sample file, column F being the current rate and the field to update


Uploading the Template 

      1. People >  Tools > Timesheet Template Transactions Upload
      2. Select > Choose File 
      3. Find your saved file
      4. Select > Upload 

Once uploaded, please go to Reports > HR > Timesheet Templates to review the changes.

    • Related Articles

    • Timesheet Template

      Each time you pay an employee, their Timesheet Template is copied into the current payroll. To save you a lot of time and effort each pay day, add all the permanent pay transactions (ones that do not change) here. When you first look at a Timesheet ...

    • Upload Pay Rates Tool

      Upload Pay Rates This upload file will allow you to change pay rates for several employees at once. The pay rate for anyone on the upload file will be applied to the next pay period or if your pay is already open, it will update the existing pay. We ...

    • Uploading Hours into an Open Payroll

      There are two types of timesheet files that can be uploaded into an open payroll in CloudPayroll. Both files can be uploaded once a payroll has been opened, under Payroll > 2. Enter > Upload. File Type 1 To download this template, please go to ...

    • Changing an Employees Employment Basis

      Changing an employee from Casual to Full Time/Part Time To change an employee from Casual to either Part Time or Full Time, you will need to firstly update their personal details page: 1. Go into the employees Personal Details page (People > View ...

    • Add an Employee

      To add a new employee to the organisation, select People > Add Person. Enter the employee's First Name and Surname, ID (optional) and Work State. Select Continue. You will be taken to a new page where you can enter additional details about the ...