TWSS Reconciliation - Errors and solutions

This guide gives a list of Temporary Wage Subsidy Scheme reconciliation errors and how to resolve each one in Sage Payroll.

Whilst using the TWSS reconciliation wizard, you may receive some errors when creating the CSV file. To help you resolve these errors, please click on one of the links below:

One or more of the employees are missing the following information:

• Payroll Run Reference
• Line Item ID
• PPSN
• PSR Date
• Employment ID
• Employee Reference

 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.

Payroll Run Reference

This warning will appear where Sage Payroll cannot populate the Payroll Run Reference for the period included in the reconciliation CSV file.

What is the Payroll Run Reference?

This is the unique identifier sent to Revenue identifying the payroll submission for the period.

In most cases, this warning will appear where a payroll submission has not been sent to Revenue, but there is an entry in the ETP for this pay period. To send a payroll submission for a previous period, follow the steps in this guide. Once complete, the CSV reconciliation file can be recreated using the create the CSV reconciliation file option.

Line Item ID

This warning will appear where Sage Payroll cannot populate the Line Item ID for one or more periods included in the reconciliation CSV file.

What is a Line Item ID?

This is a unique identifier included in all payroll submissions to Revenue identifying each employee and the payroll submission values associated with that period.

In most cases, this warning will appear if the payroll submission was not sent to Revenue, or the employee was not included on the Payroll submission:

• A timesheet was not saved (there is no row on the ETP for that period).
• Gross Pay of 0.01 cent was NOT saved (there is an ETP row but as there was zero ‘Taxable’ pay (0.00) that employee’s information was not included on the Payroll Submission).

If no Payroll Submission was originally sent to Revenue – see above entry for Payroll Run Reference to correct this.

If the employee was excluded from the original Payroll Submission:

• When no timesheet was saved – you will need to contact Revenue for advice on how to proceed.
• Gross Pay of 0.01 was not entered – manually correct the ETP record to enter the missing 0.01 in the ‘Taxable’ and ‘Gross Pay’ fields, and send a correction submission for that period. Once that correction submission has been successfully sent to Revenue, recreate the CSV file, where the missing LineItemId should now be showing.

If these steps do not resolve the issue, please follow this guide to update the TWSS file manually Read More >

PPS Number, PSR Date & Employment ID

This error will appear where one or more of the entries in the ETP for an employee does not contain either the employee's PPS number, employment ID or the Pay Date (PSR Date). This means the CSV file will be be rejected by Revenue when uploaded.
To correct this, you must review each employee's ETP record to ensure that each period in the range of periods included in the reconciliation contains a valid employee PPS number, employment ID and Pay Date.

Once complete, you can use the Create CSV option to recreate the CSV reconciliation file.

Employee Reference

This error will appear where Sage Payroll cannot populate the Employee Reference in the reconciliation CSV file.

What is the Employee Reference?

This is the unique identifier sent to Revenue each pay period that helps ROS identify an employee and match their records. It is held within each employee record, but cannot be edited.

To rectify this either error, please contact Sage support.

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 >