Understanding STP Reporting

Overview

STP Reporting refers to the step displayed from the pay run when the STP report button is pressed, or when an STP update is initiated from the navigation menu. The reporting step displays summary data that will be sent as a Submit or Update pay event.

The  19.2 update (released late June '19) introduced a number of usability improvements:

  • added granular detail to help with reconciliation prior to declaration
  • removed restriction whereby an employee who was inactive couldn't be included in STP report until they were made active again.
  • process improvements for finalisation
  • column name changes for readability.

User Interface

The following table illustrates the key differences between the two reporting variations of Submit and Update:


Submit EventFeatures


The Submit Event is associated with a pay run and should be sent on or before the payment date, which displays as the transaction date.

It displays all of the same information as an update, with the addition of "This Period" information that is used to pre-fill the Business Activity Statement W1 and W2.


Overview Tab Displays:

  • Employees set from payslips on payrun
  • Period Gross Pay / Period Tax Withheld 
  • Includes Onboarding TFN Declarations
Update EventFeatures

The Update Event can be sent at any time, and requires employees to be selected to send an update as of the transaction date (defaults to current date).

If you need to send an update for the prior tax period select the period, which will refresh the page and the transaction will update. All prior tax period updates are sent with the transaction date set as the last day of the period.

Overview Tab Displays

  • Employees Selectable by Update checkbox
  • Buttons to Mark All / Unmark All / Finalise



The page is split into 3 main groups:

  • Primary Info: displays the criteria for the data collated in the tabs (branch, tax period, transaction date), and summary information for the data collated.
  • Declaration: displays the acceptance declaration required for every STP submission.
  • Tabs: Overview , the other tabs provide granular information for review.


The overview tab provides 

  • highlights validation errors against the employee
  • allows employees to be selected for update (update only)
  • allows an employee to be marked as finalised and highlights the date when most recently finalised


In addition to the overview tab additional detail tabs that display more granular information:

  • INB (Individual Non Business Summary)
  • WHM (Working Holiday Maker Summary)

  • ETP (Employee Termination Payment)

  • Super

  • Allowances

  • Deductions

  • FBT (Fringe Benefit Tax)

  • Lump Sum

For more details on how this data is collated and grouped see the Data Collation section.


If you hover over blue tags in the additional info column you will see a tool tip displaying quick information from the corresponding tab.





Update Pay Event: Finalise

The introduction of STP has significantly simplified the end of year process. Once you have completed your payroll activities for the tax year (and entered FBT information XXXXX fill in link), you then need to send an update event for all employees with the "Finalise Tax Year" checked. 


To simplify this we have added a new button "Finalise All For Tax Period", which when clicked ask for confirmation and then automatically select all employees, and check the "Finalise Tax Year" column. 

In this screen shot the first employee has already been finalised as a date is shown in the final sent column.

when Finalise All For Tax Period is clicked the following confirmation is displayed.

For more information on finalising the tax year, see our guide. XXXXXXXX replace ME XXXXXXX


Data Collation

The data presented 

the data reporting comes from 4 different sources within NetSuite:

  • employee record (for the personal information)
  • summarise of information in payslip detail records
  • fbt records
  • tfn declaration (if submit)

Employee Reporting

An employee is included for reporting if they meet one of the following criteria:

  • they have a payslip detail record for the specified branch, in the current tax year on or before the transaction date
  • they have an FBT summary record for the specified branch, and tax year

An employee must have either a payslip detail or FBT summary record to be included for reporting; setting just the branch on an employee record does not add them.


Pay Data Summarising

The STP reporting format requires the pay data to be summarised into groups, the first groups correspond to payment summary types and are determined as follows:

INB (Individual Non Business)WHM (Working Holiday Maker)Employee Termination Payment
  • Income Type Code = S

Payment Summary Location:

  • Gross Payments Box
  • Tax Withheld
  • CDEP

Income Type Code = H

Payment Summary Location:

  • Gross Payments Box
  • Tax Withheld


Payment Summary Location:

  • ETP Taxable Component
  • ETP Tax Free Component
  • ETP Tax Withheld


ETP Note: An employee can have multiple ETP termination payment summaries they are grouped by pay date and ETP code. Any adjustment to an ETP needs to have the same code and payment date.


Payment Summary LocationColumn
Allowances
Allowances Box Car, Laundry, Meals, Transport, Travel, Other 
Deductions
Union / Professional Association FeesFees
Workplace GivingWork Place Giving
Lump Sum
Lump Sum Payments A:A
-A Type (defaults to R if A is set)
Lump Sum Payments B:B
Lump Sum Payments D:D
Lump Sum Payments E:E



Sub TypeColumn

Super

Sum of PSD is OTE checkedOTE Amount
Employer SuperSGC
RESCRESC (Reportable Employer Super Contribution) - xsc
Additional Employer Super, Salary Sacrifice-Superannuation



FBT


Fringe Benefit Tax information is sourced from the Employee FBT Summary record directly mapping the field


FBT Summary FieldColumn
REPORTABLE FBT FOR PAYG SUMMARY (custrecord_pr_reportable_fbt)Taxable Amount
PAYEE RFB EXEMPT AMOUNT (custrecord_pr_fbts_exempt_amount)Exempt Amount


only displayed if the taxable amount exceeds the FBT threshold (currently $3,773.00 in 18/19)


Summary Information

We now display additional year to date summary information with both Update and Submit Events. 

  • Submit  information is based on only the employees included on the pay run you are reporting.
  • Update  information is based on all employees listed in the overview (irrespective of whether they are checked for update)


Year To Date
LabelSource Information
Combined Gross

Sum of the Total Row Gross Pay Column from the INB / WHM / ETP Sub Tabs. The Gross Pay for each Sub Tab is calculated based on

  • reportable date in tax year on or before transaction date
  • branch = branch 
  • payment summary location = Gross Payments Box
Combined PAYGW

Sum of the Total Row Tax(PAYGW) Column from INB/ WHM / ETP Sub Tabs. The Tax PAYGW for each Sub Tab is calculated based on

  • reportable date in tax year on or before transaction date
  • branch = branch
  • payment summary location = Tax Withheld
Individual Non Business (INB)

Total employees with an INB Summary

Working Holiday Maker (WHM)Total employees with a WHM Summary
Emp Termination Payment (ETP)

Total employees with an ETP Summary (an employee can have more than 1)

Pay Runs SubmittedTotal payruns that have been reported as Submit Pay Events with a response status of Success or Partial Success




Frequently Asked Questions

Can I export this data to excel ?
Yes click the 'Export To Excel' button at the top of the page.