Field mappings for MYOB Acumatica — Workforce Management and Payroll integration

Title

Employees > Finance and Payroll

Title

First Name

Employees > Personal Information

First name

Middle Name

Employees > Personal Information

Middle name

Last Name

Employees > Personal Information

Last name

Email

Employees > Personal Information

Email

Phone 1 (Cell)

Employees > Personal Information

Mobile number

Phone 2 (Business 1)

Employees > Personal Information

Alternate phone number

Date Of Birth

Employees > Personal Information

Date of birth

Gender

Employees > Personal Information

Gender

Employee ID

Employees > Personal Information

Reference

Used to identify the employee in Advanced Payroll.

Employeee start date

Employees > Personal Information

Start date

Address Line 1

Employees > Address information

Address line 1

Address Line 2

Employees > Address information

Address line 2

Suburb

Suburb is used if

City

Employees > Address information

Town / City (NZ)

Suburb (Australia)

State

Employees > Address information

State

Australia only

Postal Code

Employees > Address information

Post code

Country

Employees > Address information

Country

Tax Code

Employees > Finance and Payroll

Tax code

IRD Number

Employees > Finance and Payroll

IRD number

ACC Code (Employee Defaults)

Employees > Finance and Payroll

Does the employee qualify for an ACC Earner Levy Exemption?

Selects the Exempt ACC code, set in Workforce Management preferences.

If there is no exempt ACC code you will get an error.

Repayment Rate %

Employees > Finance and Payroll

Student Loan Rate (%)

Only updates the value in MYOB Advanced Payroll if it is greater than the legal minimum.

Tax @ %

Employees > Finance and Payroll

Tax Rate (%)

Tax File Number (TFN)

Employees > Finance and Payroll

Tax file number

TFN declaration

Employees > Finance and Payroll

Tax declaration

Employment basis

Employees > Finance and Payroll

On what basis are you paid?

Levy Surcharge(MSL)

Employees > Finance and Payroll

Apply the levy surcharge?

Surcharge Rate

Employees > Finance and Payroll

Surcharge rate?

Levy exemption?

Full exemption?

Half exemption?

Employees > Finance and Payroll

Levy Exemption

Levy reduction?

Employees > Finance and Payroll

Has a Medicare Levy reduction? 

Has a spouse?

Employees > Finance and Payroll

Has a spouse?

Low income?

Employees > Finance and Payroll

Low income earner?

Dependent children?

Employees > Finance and Payroll

Has dependent children?

How many?

Employees > Finance and Payroll

How many dependent children?

Previous Last Name

Employees > Finance and Payroll

Previous family name

Residency?

Employees > Finance and Payroll

Is an Australian resident for tax purposes?

Is in Australia on a working holiday visa?

Claim seniors tax offset?

Employees > Finance and Payroll

Claim seniors and pensioners tax offset?

Single

Illness-separated couple

Couple

Employees > Finance and Payroll

Reason

Relates to the "Claim seniors and pensioners tax offset?" field.

Help or TSL

Employees > Finance and Payroll

Has a student loan (HELP, VSL, SSL, TSL) debt?

AUHasFsDebt

Employees > Finance and Payroll

Has a Financial Supplement (FS) debt?

Claims Tax-free Threshold

Employees > Finance and Payroll

Claim the tax-free threshold?

Australian Business Number

Employees > Finance and Payroll

Employing entity ABN

Claim zone / special tax offset?

Employees > Finance and Payroll

Zone Rebate

Claim overseas forces or dependent (invalid and carer) tax offset?

Dependant spouse?

Overseas forces?

Parent spouse or invalid relative?

Employees > Finance and Payroll

Reason

Relates to the "Claim zone / special tax offset?" field.

Employee start date

Employees > Personal Information

Start date

Hourly Rate

Hours Per Year

Employees > Finance and Payroll

Annual Salary

Hours per day

Days per week

The Hourly Rate (HRp) and Hours Per Year (HPYp) fields in Payroll are calculated from the Annual Salary (ASw), Hours per day (HPDw), and Days per week (DPWw) fields in Advanced Workforce Management.

Hours Per Year = 52(Hours Per Year × Days per week)

Hourly Rate = Annual Salary ÷ Hours Per Year

KiwiSaver Details

Employees > Finance and Payroll

Kiwisaver enrolment status

Kiwisaver details will be added for Opt-in, Auto Enrol, Already enrolled and Savings Suspension choices.

Opt-out is not currently supported. An Validating the MYOB Advanced Payroll synchronisation will be created for opted-out employees.

Fund Name

Employees > Bank Accounts > Superannuation information

Fund name

Fund are matched to those on the Superannuations Funds form (MPPP2152).

If there is no matching fund, an Validating the MYOB Advanced Payroll synchronisation will be created.

Member ID

Employees - Bank Accounts - Superannuation information

Member reference

Amount

Employees > Finance and Payroll

Employee contribution (%)

Will either update the Kiwisaver pay item value, or find another item of the same requested value.

If there is no Kiwisaver item, an Validating the MYOB Advanced Payroll synchronisation will be created.

Amount

Employees > Finance and Payroll

Employer contribution (%)

Will either update the Kiwisaver pay item value, or find another item of the same requested value.

If there is Kiwisaver item an Validating the MYOB Advanced Payroll synchronisation will be created.

Name On Account

Employees > Bank Accounts

Name on account

Account Number

Employees > Bank Accounts

Account number

BSB Number (AU)

Employees > Bank Accounts

Branch

Type (Balance)

Employees > Bank Accounts

Primary account?

Fund Name

Employees > Bank Accounts > Superannuation information

Fund name

USI (APRA)

Employees > Bank Accounts > Superannuation information

USI

Account name (SMSF)

Employees > Bank Accounts > Superannuation information

Name on account

BSB (SMSF)

Employees > Bank Accounts > Superannuation information

Branch

Account Number (SMSF)

Employees > Bank Accounts > Superannuation information

Account number

ABN (SMSF)

Employees > Bank Accounts > Superannuation information

ABN

ESA (SMSF)

Employees > Bank Accounts > Superannuation information

Electronic service address (esa)

Employees > Finance and Payroll

Has approved withholding variation

n/a

Creates an Validating the MYOB Advanced Payroll synchronisation.