Exporting: Timesheets to Payroll System | WorkTimeManager Help

Export Time Attendance Records to MYOB

Export Time Attendance Records to MYOB
Note: We currently export to MYOB Desktop. This document is specifically for MYOB Desktop.

Before you get started you’ll need to make sure:
  1. All timesheet records must be approved before ClickTime can export them 
  2. Employee External-ID   matches the Employee Card ID in MYOB.
  3. You must also ensure that the Leave names in ClickTime and MYOB match up.
  4. Employee Names are identical in both systems.
  5. Site & Locations External ID in (ClickTime) and Job (MYOB) Codes are the same.
            NOTE: in ClickTime , the site External/payroll ID represent the job that will be exported 
                        and matched with MYOB

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






Exporting File Type

To export your data for use in MYOB AccountRight, follow these steps:

  1. Click the Export button in your ClickTime interface.

  2. A popup window will appear.

    • From the Export Type dropdown, select MYOB Desktop (File Download).

    • Then choose the Export Format:

      • Comma Delimited (.csv)

      • Tab Delimited (.txt)

  3. Click Export to begin the process.

  4. Wait while ClickTime prepares your export file.

  5. Once the file is ready, it will be available for download.

  6. After downloading, you can import the file directly into your MYOB Desktop system.





    • Related Articles

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

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

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

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