How do I import timesheets from MYOB AccountRight into MYOB Payroll?
Answer
In MYOB Payroll
- Open your accounting product and print off a copy of the Activity ID’s (These must be set up in Time Billing using an Uppercase font)
- Open Payroll and set up your Departments/Cost Centres using the identical names given to the Activity ID’s.
- Set up the Pay codes ALSO using the same identical names as the Activity ID’s and then go to Maintain Employees/Pay Default-Totals and set up the required pay codes for each employee.
In MYOB AccountRight
- When ready to export the data Open MYOB AccountRight
- Choose File, Export Data, Activity Slips from the menu
- In the Export Data dialog box
- Select Comma Separated & Data Record
- Select the From & To dates
- Click Continue
- Choose the following fields in this order. (It is assumed that the start & Stop times will be blank, if not then choose other fields that will be blank.) If the times are to be allocated against departments/jobs then choose the Job field instead of stop time. (The employees default department will be used and the Job will override the employees default cost centre).
Date
Emp Co./last name
Activityid
Start time
Stop time or Job
Units
- Click Export, Save & Yes to save the file into the MYOB Premier folder
Open Payroll and use the Import Timesheets browser button to find the file (SLIPS.TXT) to import this data into the Payroll.
