Find answers in our knowledge base
 
Namely
Article

How to Integrate With and Export Timesheets to MYOB

« Go Back

Article Detail

 
Rich Text Description

How to Setup the Integration

  1. In TSheets, in the Employee Editor:
  • Add the MYOB Employee Card ID into the Employee Number field
  • Add the MYOB Employee Record ID into the Payroll ID field
  1. Jobs in TSheets must match Jobs in MYOB (Jobs)
  2. Time off codes in TSheets must match PTO codes in MYOB (Feature Add-ons > Time Off Codes)
  3. Under Feature Add-ons > Manage Add-ons 
  4. Find the MYOB Integration and click “Get

How to Export Timesheet Data for MYOB

  1. In TSheets, go to Reports MYOB Report 
  • Next to Report Dates, select a date range
  • Do one of the following:
  • To include all employees in the spreadsheet: Leave Filter by set to all employees
  • To include select employees in the spreadsheet: Click all employees, select the employees or groups, and click OK
  • Click Download CSV, and save the file
  1. In MYOB, go to the Timesheets module and use the Import function
  • There are a few selections the you will need to make here, like file type (.csv)

How to Read the MYOB Export Spreadsheet

  • Employee Co./Last Name: Last Name
  • Employee First Name: First Name
  • Payroll Category: Hourly/Overtime/etc (can be customized)
  • Job: Jobcode
  • Customer Co./Last Name: Blank
  • Customer First Name: Blank
  • Notes: Notes field
  • Date: Start Date (dd/mm/yyyy)
  • Units: Hours (decimal)
  • Employee Card ID: Employee Number
  • Employee Record ID: Payroll ID
  • Start/Stop Time: Blank
  • Customer Card ID: Blank
  • Customer Record ID: Blank

NOTE: If the report doesn’t quite match your needs, please reach out to our Support team. We can make adjustments to the report export to ensure it has the correct information.


Need help? We’re here for you.
Phone
Mon-Fri, 5am – 9pm MST
Sat – Sun, 8am – 5pm MST
Chat with us!
us: +1 (888) 836-2720
au: +1 (800) 989-143
uk: +44 (808) 164-0610

Was this document helpful?

 
   

Sorry this document wasn’t helpful. How can we improve it?

Characters Remaining 255