How to export time attendance records | WorkTimeManager

How to export time attendance records

Exporting Time Attendance Records to MYOB

Before exporting Time Attendance data from ClickTime to MYOB, make sure the following setup requirements are completed. These checks ensure that MYOB can import the export file successfully and without errors.


1. Match Employee Identifiers

To ensure MYOB recognises each employee correctly:

  • Employee External ID (ClickTime) must match the Employee Card ID (MYOB).

  • Employee Names must be identical in both systems (same spelling, spacing, and formatting).


2. Match Site / Location / Job Identifiers (Optional but Recommended)

If you are exporting data linked to Sites or Jobs:

  • Site or Location External ID (ClickTime) should match the Job Code (MYOB).

  • This ensures MYOB can correctly allocate hours to the right job or cost centre.

3. Match Leave Names

If your export includes leave entries:

  • Leave names in ClickTime must match the corresponding Leave Categories in MYOB.

  • This prevents MYOB from rejecting leave-related lines during import.


4. Ensure Timesheets Are Approved

ClickTime only exports approved timesheet records.

  • Only employees with approved timesheets will appear in the export list.

  • If an employee is missing from the export screen, check that their timesheet has been approved for the selected period.


Configuring MYOB for ClickTime Time Attendance Imports

Before importing Time Attendance records from ClickTime into MYOB AccountRight, you must configure MYOB correctly to ensure hours are imported accurately and without duplication.

1. Enable Timesheet Import in MYOB

Make sure MYOB is set up to accept timesheets as an import source. This allows MYOB to read and process the hours sent from ClickTime.

2. Remove Standard Pay Hours (to avoid double‑counting)

Many businesses use Standard Pay to pre-fill weekly hours. However, because ClickTime sends actual worked hours:

  • Do NOT use Standard Pay hours for Full-Time, Part-Time, or Casual employees.

  • If Standard Pay remains active, MYOB will double up the hours (Standard Pay + ClickTime hours).

You must set:

  • Standard Pay Hours = 0.00 for all employees whose hours come from ClickTime.


3. Set Payroll Categories Correctly

Ensure the correct payroll categories are used:

  • The default payroll category should be Base Hourly.

  • You may also configure custom categories for:

    • Saturday rates

    • Sunday rates

    • Public Holiday rates


4. Set “Base Hourly” Amount to Zero

To prevent MYOB from adding extra hours or pay:

  • Set the Base Hourly value = 0 for each employee.

This ensures MYOB only uses the ClickTime imported hours and does not add any additional default hours from the employee card.

5. Configure Salary Employees Correctly

For employees paid on a salary:

  • Ensure they are marked as Salary in MYOB.

  • Their Standard Hours should reflect the correct auto‑pay amount.

  • Salary employees typically do not receive imported timesheet hours unless your business requires it.



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