Chapter 13 - Payroll > Payroll exports

XERO will accept the MYOB format for import

Client specific cost centre override possible for MYOB export

When running client based cost centres and MYOB payroll - ManStat sends shift date per line not week ending date

If not using card ID in MYOB the last two items must be de-selected after using Match All in MYOB import, otherwise import may fail regardless of match settings.

If using Card ID then deselect company name

Note: Should MYOB include additional ordinary hours in the import:

1.	Open up an Employees Card.

2.	Go to the Payroll Details Tab.

3.	Choose Standard Pay (Down the left)

4.	Put 0 Hours on the column corresponding to Base Hourly.

Timesheets Fields

Emp. Co./Last Name,Emp. First Name,Payroll Category,Job,Cust. Co./Last Name,Cust. First Name,Notes,Date,Units,Emp. Card ID,Emp. Record ID,Start/Stop Time

Smith,Stephen,Base Hourly,,,,,24/11/2008,2.25,STEVE,,

Field descriptions for importing and exporting

Field

Description and Character Limits

*Emp. Co./Last Name

When importing, must match a preexisting employee card or supplier card in the MYOB Premier company file.

•	If a company name (no first name), 50 characters, alphanumeric.

•	If a last name, 30 characters, alphanumeric.

(If the card is an individual, Premier matches the last name, followed by a comma and a space and the first name.)

Emp. First Name

20 characters, alphanumeric

^Emp. Card ID

15 characters, alphanumeric

^Emp. Record ID

10 characters, numeric

*Payroll Category

31 characters, alphanumeric

Job

15 characters, alphanumeric. When importing, must match a preexisting job in the MYOB Premier company file.

Cust. Co./Last Name

When importing, must match a preexisting customer card in the MYOB Premier company file.

•	If a company name (no first name), 31 characters, alphanumeric.

•	If a last name, 15 characters, alphanumeric.

(If the card is an individual, Premier matches the last name, followed by a comma and a space and the first name.)

Cust. First Name

15 characters, alphanumeric

Notes

255 characters, alphanumeric

Date

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.

*Units

11 characters, numeric, including 2 decimal places

^Conditional Fields: When importing, one or more fields must contain valid entries for matching fields in the company file.

*Required Field: When importing, this field must have a valid matching import field.

Refer to MYOB help file for Timesheet Setup