TWSS Reconciliation - Line Item ID error

 NOTE: All payroll related Covid-19 subsidy schemes have now ended, with the last of them, the extended scheme EWSS-PHR, ending on the 31 May 2022.

You can follow the steps in this handy guide to Disable all employees from Covid-19 subsidy schemes.

In some cases, the line item ID is missing for some pay periods for some employees when submitting your TWSS to revenue.

This issue is currently under investigation.

The Revenue have now allowed payroll resubmissions to be carried out for payroll periods that included the TWSS subsidy in the transitional phase of the scheme. 

NOTE: The TWSS subsidy value was only included in payroll submissions after installing Sage Payroll v23.2.

1. Ensure the Update employees and create a reconciliation CSV file routine has been completed and the employees' ETP has been updated to include the TWSS subsidy value processed. 
2. Make note of each period that has been updated to include the TWSS subsidy value.
3. Complete a payroll re-submission for each period. 

Once this processed has been completed for all periods where TWSS subsidy was paid, there is no requirement to process the TWSS reconciliation CSV file.

Alternatively, you must retrieve the line item ID for the missing employees from the submission details within your ROS account.

1. Open the CSV file created by the TWSS reconciliation wizard in Excel.
2. Locate the empty cells in column B - this is column for the line item ID.
3. The corresponding entry in column A refers to the Payroll Run Reference which ends with a reference to the period submission. Copy this entry for a later step.
   

   NOTE: The payroll run reference is formatted as a unique string, suffixed by the period number, the period type and the tax year.
   Example: 0ba084e6-d453-4503-898d-d31e7f801c4f15N2020

   Unique String	0ba084e6-d453-4503-898d-d31e7f801c4f
   Period Number	15
   Period Type	N
   Tax Year	2020

4. Login to your ROS account.
5. Select My Services, then Employer Services, then click View Payroll.
6. In the Search by field, select Payroll Run Reference and enter the Payroll Run Reference from the TWSS reconciliation file.
7. A list of employee submission details are shown - click View on the relevant employee.
8. Copy the line item ID and paste it into the TWSS reconciliation CSV file.
9. Repeat for each missing line item ID. 
10. Once complete, save the amended TWSS CSV file and upload it to your ROS account.

NOTE: The deadline for appealing the Revenue Assessment of TWSS comes to an end this week. You can find details on the appeals process on Revenue's website >