STP V2 Employee Integration / CSV Mapping Changes
Overview
The introduction of Single Touch Payroll V2 has brought updates to the employee record for AU employees. This article provides details on these changes to assist with updating CSV imports, and 3rd Party Integrations.
The changes can be summarised as follows:
Addition of new AU tax fields
Deprecation of existing AU tax fields
Change in business logic for setting tax scales
The impact of this will mean that you will need to:
Understand some fields are now deprecated and will not produce the expected behaviour in terms of setting employee tax scale
Additional STP V2 employee fields now need to be set
Certain employee tax scales are being deprecated
- 1 Overview
- 2 Employee Field Changes
- 3 Change to Employee Tax Scale
- 4 Integration Use Cases
- 5 Termination Reason Codes
- 6 Data Dictionary
- 6.1 Tax Category
- 6.2 Tax Option
- 6.3 Medicare Surcharge
- 6.4 Medicare Exemption
- 6.5 Medicare Reduction
- 6.6 Employment Basis
- 6.7 Income Stream
- 6.8 Termination Reason
- 7 Frequently Asked Questions:
Employee Field Changes
The following table outlines the field changes on the employee record.
Field Name | Field ID | Field Type | Change | Details |
---|---|---|---|---|
Has STSL | custentity_pr_au_has_stsl | Checkbox | Add | Replaces the deprecated “HELP/VSL/FS/SSL/TSL TYPE” field and is used to set the employee tax scale |
Tax Treatment Code | custentity_pr_au_tax_code | Text | Add | This is a string that represents 1 char for each of the following fields: |
Tax Category | custentity_pr_au_tax_category | List / Record | Add |
|
Tax Option | custentity_pr_au_tax_option | List / Record | Add |
|
Medicare Levy Surcharge | custentity_pr_au_medicare_surcharge | List / Record | Add | Replaces “APPLY MEDICARE LEVY SURCHARGE”, Field would only be set based on a Medicare Levy Variation Form. |
Medicare Levy Exemption | custentity_pr_ml_exemption | List / Record | No Change | Field would only be set based on a Medicare Levy Variation Form. |
Medicare Levy Reduction | custentity_pr_au_medicare_reduction | List / Record | Add | New option Field would only be set based on a Medicare Levy Variation Form |
Employment Basis | custentity_pr_au_employment_basis | List / Record | Add | The employment basis automatically sources from the “Payroll Employment Status” field for Full Time, Part Time and Casual. |
Income Stream | custentity_pr_au_income_stream | List / Record | Add | New field |
Home Country (WHM Only) | custentity_pr_au_income_country | List / Record
| Add | Currently only required for Working Holiday Makers, sources onto payslip details. |
Income Type | custentity_pr_income_type | List / Record | Deprecated | Automatically sourced from Resident Status: |
HELP/VSL/FS/SSL/TSL TYPE | custentity_pr_help_sfss_var | List / Record | Deprecated | No longer used see has STSL checkbox. |
APPLY MEDICARE LEVY SURCHARGE | custentity_pr_include_mls | Checkbox | Deprecated | No longer used see medicare levy surcharge. |
CLAIM SENIOR AUSTRALIAN TAX OFFSET | custentity_pr_claim_senior_tax_offset | Checkbox | Deprecated | No longer used senior couple information is now represented by:
|
Senior Couple Status | custentity_pr_senior_couple_status | Checkbox | Deprecated | |
Termination Type | custentity_pr_termination_reason | List / Record | Updated Values | We have added additional options and split Normal Termination (Dismissal) into its own type |
Payroll Employment Status | custentity_employment_status | List / Record | Updates Type | Change from Custom list to Custom Record to allow defaulting of employment basis. No change required |
Change to Employee Tax Scale
With the introduction of our STP V2 release the employee tax scales have been simplified the key changes:
Update the client side logic that sets Employee Tax Scale to work with the new Tax Category / Tax Option
Deprecate duplicate legacy tax scales
Simplify Working Holiday Maker Tax Scale and support Un registered
Remove Flat Tax Scale
Supported Tax Scales
With the introduction of our STP V2 release the employee tax scales have been simplified the following table are now supported, these should be referenced by external ID in integrations as the internal ids may differ between accounts.
Employee Tax Scale | Resident Status | External ID | Status |
---|---|---|---|
Tax-free threshold claimed (2) | Resident | 2 | No Change |
Tax-free threshold claimed (2a) with STSL debt | Resident | 2a | No Change |
No tax-free threshold (1) | Resident | 1 | No Change |
No tax-free threshold (1a) with STSL debt | Resident | 1a | No Change |
No tax file number (4) | Resident | 4 | No Change |
Foreign resident (3) | Non-Resident | 3 | No Change |
Foreign resident (3a) with STSL debt | Non-Resident | 3a | No Change |
No tax file number (4a) | Non-Resident | 4a | No Change |
Full Medicare exemption (5) | Resident | 5 | No Change |
Full Medicare exemption (5a) with STSL debt | Resident | 5a | No Change |
Half Medicare exemption (6) | Resident | 6 | No Change |
Half Medicare exemption (6a) with STSL debt | Resident | 6a | No Change |
Senior Australian:Couple | Resident | s3 | No Change |
Senior Australian:Illness-Separated Couple | Resident | s2 | No Change |
Senior Australian:Single | Resident | s1 | No Change |
Working Holiday Maker (WHM-UREG) | Working Holiday Maker | hu | New |
Working Holiday Maker (WHM-REG) | Working Holiday Maker | hr | New |
Seasonal Worker Programme | n/a | wp | New |
Nil Tax Withheld | Non Resident | nil |
|
Manual Tax Component | n/a | mt | New |
Merged Tax Scales
The following employee tax scale are now deprecated, integrations and csv imports should be updated to match the supported list above but will be supported for the 22/23 Tax Year.
Deprecated Tax Scale | Migrate to Tax Scale |
---|---|
No tax-free threshold (1b) with STSL debt | No tax-free threshold (1a) with STSL debt |
No tax-free threshold (1c) with STSL debt | |
Tax-free threshold claimed (2.) | Tax-free threshold claimed (2) |
Tax-free threshold claimed (2.a) with STSL debt | Tax-free threshold claimed (2a) with STSL debt |
Tax-free threshold claimed (2b) with STSL debt | |
Tax-free threshold claimed (2.b) with STSL debt | |
Tax-free threshold claimed (2c) with STSL debt | |
Tax-free threshold claimed (2.c) with STSL debt | |
Foreign resident (3b) with STSL debt | Foreign resident (3a) with STSL debt |
Foreign resident (3c) with STSL debt | |
Full Medicare exemption (5b) with STSL debt | Full Medicare exemption (5a) with STSL debt |
Full Medicare exemption (5c) with STSL debt | |
Half Medicare exemption (6b) with STSL debt | Half Medicare exemption (6a) with STSL debt |
Half Medicare exemption (6c) with STSL debt |
Deprecated Tax Scales
Flat Tax Scales (12) | ||
50% Flat Tax Rate | 30% Flat Tax Rate | 15% Flat Tax Rate |
45% Flat Tax Rate | 25% Flat Tax Rate | 10% Flat Tax Rate |
35% Flat Tax Rate | 20% Flat Tax Rate | 5% Flat Tax Rate |
7% Flat Tax Rate | 47% Flat Tax Rate | 49% Flat Tax Rate |
Redundant WHM Threshold Scales (4) | ||
H - Working Holiday Maker to 45000 (WHM1) | H - Working Holiday Maker 45001 to 120000 (WHM2) | H - Working Holiday Maker 120001 to 180000 (WHM3) |
H - Working Holiday Maker over 180000 (WHM4) |
|
|
Integration Use Cases
For integrations and CSV Imports the following examples provide the most common variations that need to be supported, and less common including the medicare levy variations.
Common
TFN | Resident Status | Claim Tax Free | Cat (Char 1) | Option (Char 2) | Has STSL (Char 3) | MLS (Char 4) | MLE (Char 5) | MLR (Char 6) | Tax Code | Employee Tax Scale |
---|---|---|---|---|---|---|---|---|---|---|
Valid | Resident | Yes | Regular (R) | Tax Free Threshold (T) | No | None | None | None | RTXXXX | Tax-free threshold claimed (2) |
Valid | Resident | No | Regular (R) | No Tax Free Threshold (N) | Yes | None | None | None | RNSXXX | No tax-free threshold (1a) with STSL debt |
Valid | Working Holiday Maker | No (N/A) | Working Holiday Maker (H) | Registered Payer (R) | No (N/A) | None | None | None | HUXXXX | Working Holiday Maker (WHM-REG) |
Valid | Non Resident | No (N/A) | Foreign Resident (F) | Foreign Residency (F) | Yes | None | None | None | FFSXXX | Foreign resident (3a) with STSL debt |
Invalid (000000000) | Resident | No (N/A) | No TFN (N) | Australian Resident (A) | No (N/A) | None | None | None | NAXXXX | No tax file number (4) |
Invalid (000000000) | Non Resident | No (N/A) | No TFN (N) | Non Resident (F) | No (N/A) | None | None | None | NFXXXX | No tax file number (4a) |
Less Common Medicare Variation
Medicare variations are only available to employee’s who are Resident, and only the surcharge tier can be claimed if the employee is not claiming the tax free threshold. As a result the typical variations are as follows:
TFN | Resident Status | Claim Tax Free | Cat (Char 1) | Option (Char 2) | Has STSL (Char 3) | MLS (Char 4) | MLE (Char 5) | MLR (Char 6) | Tax Code | Employee Tax Scale |
---|---|---|---|---|---|---|---|---|---|---|
Valid | Resident | No | Regular (R) | No Tax Free Threshold (N) | Yes | 1% (Tier 1) | None | None | RNS1XX | No tax-free threshold (1a) with STSL debt |
Valid | Resident | Yes | Regular (R) | Tax Free Threshold (T) | No | 1% (Tier 1) | None | None | RTX1XX | Tax-free threshold claimed (2) |
Valid | Resident | Yes | Regular (R) | Tax Free Threshold (T) | No | None | Full Exemption | None | RTXXFX | Full Medicare exemption (5) |
Valid | Resident | Yes | Regular (R) | Tax Free Threshold (T) | No | None | Half Exemption | None | RTXXHX | Half Medicare exemption (6) |
Valid | Resident | Yes | Regular (R) | Tax Free Threshold (T) | No | None | Half Exemption | 1 Children (1) | RTXXH1 | Half Medicare exemption (6) |
In Summary:
If an employee is making a Medicare Levy Surcharge they cannot also claim an exemption or reduction
If an employee is claiming a full or half exemption they cannot pay a surcharge
If an employee is claiming a full exemption they cannot claim a medicare levy reduction
Termination Reason Codes
With the introduction of the STP V2 release the termination reason codes custom list has been updated to reflect a more granular approach of reporting termination reasons. The supported list is now as follows:
Data Dictionary
Tax Category
Custom Record: AU Tax Treatment Category (customrecord_au_tax_treatment_category) | ||
---|---|---|
| ||
Internal ID | Name | Notes |
1 | Regular | Set For Resident |
4 | Seniors & Pensioners (S) |
|
5 | Working Holiday Makers (H) | Set For Working Holiday Maker |
6 | No TFN (N) | Set For No TFN |
7 | ATO-Defined (D) |
|
8 | Voluntary Agreement (V) |
|
10 | Foreign Resident (F) | Set For Non Resident |
Tax Option
Custom Record: AU Tax Treatment Option (customrecord_au_tax_treatment_option) | ||
---|---|---|
The Tax Option is filtered by the Tax Category Option, attempting to set a tax option which is not available for a tax category will result in an invalid record ref error | ||
Internal ID | Name | Tax Category Available For |
2 | Tax Free Threshold (T) | Regular (R) |
3 | No Tax Free Threshold (N) | Regular (R) |
4 | Single (S) | Seniors & Pensioners (S) |
5 | Member of Couple (M) | Seniors & Pensioners (S) |
6 | Illness Seperated Couple (I) | Seniors & Pensioners (S) |
7 | Registered Payer (R) | Working Holiday Makers (H) |