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











    • 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

      Why it’s important You will use the External ID when exporting ClickTime timesheet or time‑attendance data to third‑party payroll or accounting systems such as: MYOB KeyPay ADP Other integrated platforms Ensuring successful data export To avoid ...

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

    • Export Time Attendance Records to MYOB AccountRight

      Summary of what can be transferred: Regular hours Overtime hours Jobs ==> Site in ClickTime Paid Time Off (PTO) Export Time Attendance Records to MYOB This document is specifically for MYOB business. ClickTime uses the following four key fields to ...

    • Understanding Time Attendance Status & Flags

      In ClickTime Australia, each time attendance record carries a status flag that determines how it can be edited, approved, or exported to payroll. From Pending entries awaiting review to Voided records that release a shift, understanding these flags ...