STP not reporting Lump Sum E amount

On-premise customers

To check if you're affected, either contact your MYOB PayGlobal account manager to arrange a consultant to check for you (chargeable), or follow these instructions to check yourself:

1. Go to the allowances screen, and check which allowance have Tax override type set to Lump sum in arrears.
2. Run the File Analysis Report (CSV) - PGPRHIST003V.
3. Set these filters for the 2022-23 tax year:
   • Period Type: Y.YTD
   • Period Range: 2022/23 tax year
   • Allowances: All allowances with Tax override type set to Lump sum in arrears (as above).
4. On the Sorting tab,sort by Employee.Employeecode and Virtualhistoricaltransaction.PaySequence.
5. Set the output to CSV.
6. Check whether you are affected:
   • If no records are returned, you are not impacted by this issue.
   • If records are returned, check whether any employees are over the threshold.
7. If you are affected, process the CSV file:
   1. Open the file in Microsoft Excel
   2. Consolidate the figures to year-to-date amounts.
   3. Filter out employees with a year-to-date total less than $1200.
8. If you turned on STPv4 2021/22 tax year, repeat this process, using the filter Period Range: 2021/22 tax year.

If you have any employees remaining on your report after completing this process then you are affected, and will need to correct your records before finalising.

For online services customers

We will contact you soon with a report showing any impacted employees and pay sequences.

Only employees with Lump Sum in Arrears payments are affected by this issue.

If you don't have any employees in this situation, you are unaffected – you don't need to do anything at all.

The ATO’s preference is that you send an Update Event to un-do the Finalisation, i.e. let the ATO know some/all of your data is not tax ready yet.

Once the missing data has been added to your database you can re-finalise (i.e. send a new Finalisation Event).

If not all employees are impacted you may want to complete this step just for those employees that are impacted.

You will need to get the missing data added to your database before sending the finalisation for 2022/23.

This data can only be updated via the backend (via SQL) and not via the front end (MYOB PayGlobal Application). If you require assistance with this you will require a consultant to be engaged, as mentioned.

Firstly you will need to review the extracted transaction data to identify whether the “Lump sum in Arrears” payments related to a single tax year or if the transaction needs to be split across multiple tax years. This task can only be completed by you.

Then you need convert the extracted transaction(s) into an SQL Query that can be used to populate the HistoricalLumpSumE and  CurrentLumpSumE tables.

The HistoricalLumpSumE and  CurrentLumpSumE tables are structured as follows:

 

Field Name	Details
EmployeeCode	Identifies the employee the Lump Sum E payment belongs to
PaySequence	Identifies the pay sequence the payment came from
PayPeriodYTDCode	This is the YTD Code representing the ‘Lump Sum E Derived Tax Year’. e.g. if the payment was linked to a pay with the Tax Year YTD code 2022/23, then Lump Sum E derived tax year must be 2021/22 or earlier.
Total Amount	This is the consolidated total amount from the ‘Lump sum in arrears’ allowances for the same employee, pay sequence and ‘Lump Sum E Derived Tax Year’.

Download LumpSumE_ScriptCreation.xlsx to help creating the relevant SQL Queries based on the information entered.

Please remove sample data entered and drag the scripts down to populate the relevant rows, then run the update scripts.

 

If you are using excel for this data, leading zero's on numeric fields will be removed.

Please ensure that you test this import via your test database first to ensure there are no errors and it is behaving as expected then backup Live before applying the changes.

 

For online services customers

An MYOB PayGlobal consultant will contact you to let you know if you are affected by this issue, and how to review the data to see what changes need to be made.

Once you have completed this review, our professional services team will update your database for you. Note that this is chargeable work and will be charged at time and materials rates due to the varying transaction volumes per customer database.

For on-premise customers

You can engage with our professional services team to complete this task for you. This is chargeable work and will be charged at time and materials rates due to the varying transaction volumes per customer database.