How to export time attendance records | WorkTimeManager

How to export time attendance records

Export Time Attendance Records to MYOB
Before you get started you’ll need to make sure:
  1. Employee External-ID   matches the Employee Card ID in MYOB.
  2. You will also need to check that Employee Names are identical in both systems, and optionally also that the Site & Locations External ID (ClickTime)  and Job (MYOB) Codes are the same.
  3. You must also ensure that the Leave names in ClickTime and MYOB match up.
  4. 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.

Configuring MYOB
  1. Make sure that the system is set to accept time sheets as an import.
  2. Some businesses use Standard Pay hours to make processing pay quicker. As we’re sending timesheet hours from ClickTime, if you have Standard Pay hours as well, you’ll be doubling up. You’ll want to remove this for all Full Time, Part Time and Casual Staff
  3. Check and make sure that “Payroll Categories” is set to Base Hourly. You may also choose to have custom Saturday, Sunday and Public Holiday rates.
  4. Standard Pay Hours must be set to $0.00 on each relevant employee’s card.
  5. You may set the value of  "Base Hourly" = 0  for your employees.This is needed, so MYOB AccountsRights, will only read and consider the ClickTime hours as the only timesheet hours, otherwise, AccountsRights will double up and will add the  (Base Hourly value of the employees) to the ClickTIme imported time sheet hours
  6. Ensure that salary employees are listed as salary and have their standard hours set to the accurate auto-pay amount in MYOB.

Exporting Time Attendance or Timesheet Data

  1. Select Time Attendance Screen from main menu if you want to export time attendance record
  2. Select Export Tab
  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 particular site, departments or pay groups.
  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











    • 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 ...

    • What is the Site and Project External ID

      Site or Project External ID It is an additional identification number that you can use to reference and link the site , location or job & project with other systems. This filed will be used when you export WorkTimeManager timesheet or time attendance ...

    • Export Timesheet Records to WageEasy

      Before You Begin: WageEasy has it's own Award Interpreter, so in the Export we're just sending Employee ID, Times & Leave. Break Time Deduction. ClickTime will export time sheet data to Wedge Easy, automatically deducting break times from total shift ...

    • Understanding Time Attendance Status & Flags

      Time Record Status When employee clock-in and out, the time record is will automatically have a PENDING status. Timesheet admin with the proper authority to manage time attendance can APPROVE, REJECT, LOCK, UNLOCK and VOID  the time records    VIDEO ...

    • 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 ...