Single Touch Payroll import specification document

GovReports accepts STP in CSV file format. The specification of the file is given below:

Click on the file name to download the template file STP_Template.csv.

 

S.No. Item Data Type Length Mandatory Sample Description
1 PayrollID string 200 Yes 55698 Employee Payroll ID
2 TFN string 9 Yes 100000001 Employee TFN
3 ContractorABN string 41000003001 Contractor ABN
4 FamilyName string 40 Yes John Employee Family Name
5 FirstName string 40 Yes Peter Employee First Name
6 OtherName string 40 Rob Employee Other Name
7 DateofBirth String Format : ddMMYYYY 26071980 Employee Day of Birth
8 AddressLine1 string 38 Yes Walker Street 1 Employee Address Line 1
9 AddressLine2 string 38 Mall Road Employee Address Line 2
10 Suburb/Town string 46 Yes Sydney Employee Suburb/Town
11 State/Territory string Yes NSW Employee State/Territory
12 Postcode Int Yes 1001 Employee Postcode
13 Country string Yes Australia Employee Country
14 Email string 200 Employee E-mail Address
15 PhoneNumber string 16 Employee Phone Number
16 CommencementDate String Format : ddMMYYYY 11022017 Employee Commencement Date
17 CessationDate String Format : ddMMYYYY 11022018 Employee Cessation Date
18 PayrollStartDate String Format : ddMMYYYY Yes 10042018 Period Start Date
19 PayrollEndDate String Format : ddMMYYYY Yes 30042018 Period End Date
20 IsFinalEvent Boolean String Final Event Indicator: Yes/No
21 IndividualNonBusinessGrossPayment Decimal (13,2) Employee Gross Payments
22 IndividualNonBusinessCDEPPayment Decimal (13,2) Employee CDEP Payment Amount
23 IndividualNonBusinessTaxWithheld Decimal (13,2) Employee Total INB PAYGW Amount
24 IndividualNonBusinessExemptForeignIncome Decimal (13,2) Employee Exempt Foreign Income Amount
25 VoluntaryAgreementGrossPayment Decimal (13,2) Employee Voluntary Agreement Gross Payment
26 VoluntaryAgreementTaxWithheld Decimal (13,2) Employee Total Voluntary Agreement PAYGW Amount
27 LabourHireArrangementGrossPayment Decimal (13,2) Employee Labour Hire Gross Payment
28 LabourHireArrangementTaxWithheld Decimal (13,2) Employee Total Labour Hire PAYGW Amount
29 SpecifiedByRegulationGrossPayment Decimal (13,2) Employee Other Specified Gross Payments
30 SpecifiedByRegulationTaxWithheld Decimal (13,2) Employee Total Other Specified Payments PAYGW Amount
31 JointPetroleumDevelopmentAreaGrossPayment Decimal (13,2) Employee JPDA Foreign Employment Income Gross Amount
32 JointPetroleumDevelopmentAreaForeignTaxPaid Decimal (13,2) Employee JPDA Foreign Employment Income Foreign Tax Paid
33 JointPetroleumDevelopmentAreaTaxWithheld Decimal (13,2) Employee Total FEI JPDA PAYGW Amount
34 WorkingHolidayMakerGrossPayment Decimal (13,2) Employee Working Holiday Maker Gross Payment
35 WorkingHolidayMakerTaxWithheld Decimal (13,2) Employee Working Holiday Maker PAYGW Amount
36 ForeignEmploymentGrossPayment Decimal (13,2) Employee Gross Payments Foreign Employment
37 ForeignEmploymentForeignTaxPaid Decimal (13,2) Employee Foreign Employment Income Foreign Tax Paid
38 ForeignEmploymentTaxWithheld Decimal (13,2) Employee Total FEI PAYGW Amount
39 EmploymentTerminationPaymentCode String R,O,S,P,D,B,N,T ETP Code – Must be any one from the following:

R = ETP made because of one of the following: early retirement scheme, genuine redundancy, invalidity, or compensation for personal injury, unfair dismissal, harassment, or discrimination.
O = Other ETP not described by R (for example: golden handshake, gratuity, payment in lieu of notice, payment for unused sick leave, or payment for unused rostered days off).
S = ETP code R payment received in the current year and received another ETP (code R or code O), or a transitional termination payment, in an earlier income year for the same termination of employment.
P = ETP code O payment received in the current year and received another ETP (code R or code O), or a transitional termination payment, in an earlier income year for the same termination of employment.
D = Death benefit ETP paid to a dependant of the deceased.
B = Death benefit ETP paid to a non-dependant of the deceased and a termination payment was made to the non-dependant in a previous income year for the same termination.
N = Death benefit ETP paid to a non-dependant of the deceased.
T = Death benefit ETP paid to a trustee of the deceased estate.

40 EmploymentTerminationPaymentDate String Format : ddMMYYYY 30042018 Employee ETP Payment Date
41 EmploymentTerminationPaymentTaxFreeComponent Decimal (13,2) Employee Termination Payment Tax Free Component
42 EmploymentTerminationPaymentTaxableComponent Decimal (13,2) Employee Termination Payment Taxable Component
43 EmploymentTerminationPaymentTaxWithheld Decimal (13,2) Employee Total ETP PAYGW Amount
44 LumpSumPaymentACode String R,T Employee Lump Sum Payment A Type – Must be any one of the following:

R = where payment was for a genuine redundancy, invalidity or under an early retirement scheme.
T = where payment was not a payment for a genuine redundancy, invalidity or under an early retirement scheme.
Blank fill this field if Lump sum payment A field is zero.

45 LumpSumPaymentA Decimal (13,2) Employee Lump Sum Payment A
46 LumpSumPaymentB Decimal (13,2) Employee Lump Sum Payment B
47 LumpSumPaymentD Decimal (13,2) Employee Lump Sum Payment D
48 LumpSumPaymentE Decimal (13,2) Employee Lump Sum Payment E
49 AllowanceTypeCode String Allowance Type – Must be any one of the following:

Car = Car expense allowance.
Transport = Award transport payments up to reasonable amounts.
Laundry = Laundry allowances.
Meals = Award overtime meal allowance.
Travel = Domestic or overseas travel allowance above the reasonable limit and all overseas accommodation allowances.
Other = All other allowances for expected deductible expenses.

50 OtherAllowanceType String 40 Other Allowance Type
51 AllowanceAmount Decimal (13,2) Employee Allowance Amount
52 DeductionType String Deduction Type – Must be any one of the following:
Fees, Workplace Giving
53 DeductionAmount Decimal (13,2) Employee Deduction Amount
54 SuperLiabilityAmount Decimal (13,2) Super Guarantee Amount
55 OrdinaryTimeEarningsAmount Decimal (13,2) Yes OTE Amount
56 ReportableEmployerSuperContribution Decimal (13,2) Reportable Employer Super Contribution
57 ReportableFringeBenefitsTaxableAmount Decimal (13,2) Employee RFB Taxable Amount
58 ReportableFringeBenefitsExemptAmount Decimal (13,2) Employee RFB Exempt Amount
59 TerminatedIndicator Boolean String Employee Terminated Indicator:
Yes/No
60 ResidencyStatus String Employee Residency Status – Must be any one of the following:
Resident = Resident
Non-Resident = Non-Resident
Working Holiday Maker = Working Holiday Maker
61 PaymentBasisCode String F,P,C,L,S Employee Employment Type Code – Must be any one of the following:
F = Full time payees; P = Part time payees; C = Casual payees; L = Labour hire payees; S = Pension or Annuity payees
62 IsTaxFreeThresholdClaimed Boolean String Employee Tax Free Threshold Claimed:

Yes/No

63 StudyAndTrainingLoanRepaymentIndicator Boolean String Employee Higher Education Loan Program (HELP) Indicator:
Yes/No
64 SFSSIndicator Boolean String Employee Student Loan Indicator:
Yes/No
65 DeclarationAcceptedIndicator Boolean String Employee Declaration Acceptance Indicator:
Yes/No
66 DeclarationSignedDate String Format : ddMMYYYY 1005218 Employee Declaration Date
Print Friendly

Leave your Comments

comments

Posted in Uncategorized and tagged .