Reconciliation CSV File

Introduction

This information is only for companies that operated any of the Wage Subsidy schemes, up to 31 August 2020.

Revenue has a requirement for an accurate reconciliation between subsidy amounts refunded by Revenue to employers and the amounts of subsidy that were paid to employees by employers.

To do this reconciliation, Revenue have instructed employers to report the actual subsidy that they paid to employees on each pay date to determine whether the employer has to pay money to Revenue, or if they are due a refund.

Payback uses CSV upload to do this. This appears to be the easiest way of doing this with the least impact on the submissions you've already submitted. Rather than have to re-submit everything, you'll be able to upload one file that contains all the pay dates. There is also the option to inspect and manually adjust figures before upload.

Important: We have removed this utility from the 2021 version of Payback. If you have not yet uploaded the subsidy file and have already upgraded to version 2021, please download and install this version:

https://www.cloudpay.ie/downloads/setup2020_17.exe

Create the CSV File

Click on the Revenue> Covid19 Menu option at the left of the screen.

This was the screen you may have used to import the TWSS CSV files for the operational phase. You will notice that there is now two tabs at the top of the screen, one of which is for the Reconciliation phase.

Select the Company and Payment frequency and then click the Load Data button.

It may take a while to fill the grid as Payback has to make calls to the Revenue Server to retrieve data for each employee. Once the grid has filled, check the figures to make sure you are happy they are correct. The Subsidy Paid figure for each pay date should match the Covid Subsidy payment on the payslip. (Any Top up amounts are not included)

Click the Save CSV button to save the File. You will need to upload this to ROS.

Upload the file to ROS

The next step is to log into ROS.ie. You will see a new option called TWSS Reconciliation. Click this link.

A new screen will appear that will guide you through the steps for uploading your file

Upload Success

When you have completed the steps you should see a screen that says 'Subsidy Data Received'. You can check to ensure that there were no errors with the upoad.

It is possible to upload multiple files for the same company, for example if you have many payment frequencies, or made a mistake with a previous upload.

The deadline to upload files is 31 Oct 2020.

If your data does not appear - Mapping Elements

If the Subsidy data screen is blank, this can happen if the Covid Subsidy elements were not set up with the correct element type of Covid-19.
You can check this by going to the Payroll screen and selecting one of the pay dates. Select an employee who had a subsidy and click the More>> button at the top right of the elements grid.
(see where the 'Type' column is here: Click here

It should say 'Covid-19' and not 'Normal' for the element type.

If the subsidy elements say 'Normal', you can map them to 'Covid-19' using the Map facility. To do this, please back up your data and upgrade to version 2020.16

Click the Map Elements button.
For each Subsidy element only, select the type 'Covid-19' using the dropdown next to the element
Click the Save button when you've finished

Only map the subsidy elements ('Covid19 Temp Wage Subsidy' or 'GovC19 WageSub' or whatever description you used). Do not map the 'Additional taxable' or top up elements.

When you have done this, try loading the data again.

Try out a fully functional version of Payback. You can process payroll for all your employees for 2 pay periods.

Try Now

Visit our secure webstore

Buy Now

Download a Free Trial

Get started with a free trial. You can process two full payments and be confident that Payback does everything you require at no risk.

Free Trial