Uploading Payroll Timesheet CSV file
Hi, I am trying to figure out how to load timesheets into Myob using a csv folder if you can give me instructions on how to to that and also what format the csv folder needs to be? thank you for ...
Forum Discussion
Hello SoChlo
To be able to import timesheets you will need to do the following
-
Open the MYOB company file you want to import the timesheets into.
-
Start the import assistant via the File menu, and choose to import Timesheets.
-
Browse to select the Excel file to be imported.
-
Leave the file format options at their default settings:
File format is Tab-delimited,
First line/record is Header Record
Match/identify cards by Emp. Co./Last Name -
Match the fields from the import file with the corresponding fields in your company file:
Match these fields in the import file… With these fields in your company file… Last Name Employee Co./Last Name First Name Employee First Name Payroll Category Payroll Category Date Date Units Units
To match a field, click the field in the Import fields list, then click the corresponding field in your company file. - Complete the import process.
I have also linked a Help Article on timesheets in AccountRight as you are able to track this in AccountRight without needing to import them.
Please let me know how you go.
Hello Chris,
We are trying to import a payroll file from Human Force to MYOB Accountright and the file has 'invalid date' errors. Can you let me know how to fix this? I do have a csv file with the error to send through if that helps.
thanks
