Exporting: Timesheets to Payroll System | WorkTimeManager Help

Export Timesheet Records to WageEasy

Before You Begin:

  1. WageEasy has it's own Award Interpreter, so in the Export we're just sending Employee ID, Times & Leave.
  2. Break Time Deduction. ClickTime will export time sheet data to Wedge Easy, automatically deducting break times from total shift hours. This means break times will not be listed separately as start and end times
  3. Timesheet must be approved. To export timesheets from ClickTime, they must be approved. ClickTime will only export timesheet records that have been approved. On the list of employees to be exported, only those with approved timesheets will appear. If an employee's name does not appear on the list, please ensure that their timesheet records have been approved.

To ensure a successful export to WageEasy:

1. Department & Job Site
    Make sure the Job Site External Export Code in ClickTime matches the Department number
    in WageEasy

2. Emp. Card ID
  1.  This is the Payroll External ID set in the employee profile in ClickTime. It is important that this is identical to the Card ID in WageEasy.
  2.  In WageEasy, navigate to the "Security" section to locate the "Time Card No". Enter this same code in ClickTime under the "Payroll" section on the  "Employee Page".
  3.  Make sure there are no trailing spaces after the entered text in either WageEasy or ClickTime.
    
    


3. Employee Name
  1. The Employee Names are identical in both systems
  2. Make sure that the staff name in WageEasy is spelled identically in ClickTime. Ensure that there are no spaces after the typed name text in  WageEasy or ClickTime and no empty spaces after the typed text.


4. The Leave names and Export codes in ClickTime and WageEasy match up.
    Leave Type name must be identical in ClickTime and WageEasy.
  1.     In ClickTime, Make sure the leave "Export Code" is identical in WageEasy leave type 
  2.     If you receive the error "WageEasy does not support the leave type" you should check the export code
  3.     by reviewing the leave export code to be match he leave "short description" on WageEasy.
   
    In ClickTime, navigate to Setting > Setup table > Leave Policies  and check the export
    code for each leave policy.
    
    

In WageEasy
Navigate to File> Company Details>other> Leave options





5. Pay Period.  
    IMPORTANT: Please check the pay period in WageEasy; it is set to the same range as your
    export period in ClickTime


Exporting Time Attendance or Timesheet Data
  1. Navigate to  Time Attendance Screen from the main menu and select Export Tab
  2. Alternatively, from the main menu, under time attendance menu item, select "Export Timesheet"  
  3. Click and select the time period to be exported 
  4. Click On the filter icon    to display the filter area. You can filter and select to export a particular site, department or pay group.
  5. On the left employee panel, select and De-select the employee records to be exported
  6. On the displayed time records, you may also select to export particular records only. Tick and UN-tick the desired records to be exported
  7. Click on the Export button to display the export window.
  8. On the new displayed export window , Click on the the [Export To] drop down list and select "WageEasy Aus (File Download)" 
           
  1. The system will download the file in ".wtc" file on your  "Downloads" folder. 
  2. Once you have created your export file,  go to WageEasy and import the file you just exported. 







WageEasy Import

You can now import this file using the processing wizard in Wage Easy:
 
1. Click on Wages, then Auto. 
2. The wizard will open, and you can select the file you exported from Click. 
3. Choose the Import Time Cards checkbox, then click Next to begin the import.
4. Once processed, check for errors and click Finish to continue.


Common Export Errors

Department Codes
The most common error is when the code for the external/payroll id  in the site record is omitted. To rectify this error, navigate to the relevant job site in ClickTime and change the external/payroll id  to the name/number given to the corresponding ‘Department Number’ or job Number in WageEasy.


Leave Codes
You must also ensure that the Leave names and Export codes in ClickTime and WageEasy match up.
If you receive the error "WageEasy does not support the leave type" you should check the export code by reviewing the leave entitlements.
in ClickTime you can navigate and go to Setting > App Setting > Setup > Leave    and make sure each leave type export code match with the relevant leave type in WageEasy 


Common Errors during Importing into WageEasy

There are errors that may occur during the import process. The most common ones are listed below:

Unable to Match Employee

If WageEasy is unable to match the employee in the export file from ClickTime, an error message will be displayed. with this regard.
Make sure that Payroll External ID set in the employee profile in ClickTime is matching & identical to the employee Card ID in WageEasy.

Incorrect Pay Period

Make sure the export pay period in ClickTime match the WageEasy Pay period / Timesheet period

Incorrect Department Number

If the Department number in WageEasy is not identical to the Export Code in ClickTime , an error message with be displayed with this regard
To rectify this error, navigate to the relevant job site in ClickTime and change the External/Payroll Id  to the name/number given to the corresponding ‘Department Number’ in WageEasy. 


    • Related Articles

    • Export Timesheet Records to KeyPay

      Export Time Attendance Records Note: We currently export to KeyPay using an Export file. This document is specifically for the KeyPay Export file using Excel export format. Before you get started you’ll need to make sure: Employee External-ID matches ...

    • How to export time attendance records

      Export Time Attendance Records to MYOB Before you get started you’ll need to make sure: Employee External-ID matches the Employee Card ID in MYOB. You will also need to check that Employee Names are identical in both systems, and optionally also that ...

    • Why i cannot see my employee timesheet on the time attendance screen

      I have scheduled my employees on the scheduler, but when I go to the time attendance screen, I am unable to see the employee's records on the time attendance screen? Answer Please make sure of the following: Make sure the employee shifts are ...

    • Troubleshooting Xero Export

      Validation Exception Error Possible Reasons Leave names do not match between ClickTime and Xero Hire date is after the start of the pay period Solutions Check leave items in the timesheets, and use this to match the leave name in Xero - they must ...

    • Pay Categories & Export Codes Explained

      Pay Categories & Export Codes Pay categories & export codes are labels used to identify pay rate multipliers – they allow you to apply pay rate multipliers to users' time. They are used in overtime rules and pay rules and payroll calculations, and ...