Employee List to ROS - How to generate the XML submission file
Description
Cause
Resolution
Preparation
Open Sage Payroll 2018 and log in to a payroll as normal.
Check your version number is 21.1 or higher. You can find this in the top left-hand corner of your software.
From the menu bar at the top of your window, click Reports then click Validate Payroll Data.
If any errors appear on this report, you must resolve them now.
If you have more than one payroll, repeat steps 3 and 4 in each of them.
Generate the Employee List to ROS file
Do one of the following:
From the menu bar at the top of your window, Reports then click Payroll Reports.
From the process map in the centre of Sage Payroll, click Other Reports.
Click the Company tab.
Under File Exports, click Employee List to ROS.
For each payroll you want to include in the report, select the Include check box and enter the password if required.
If you have multiple payrolls setup within Payroll but you cannot see them in the Company Reports window, you may need to reassign a payroll to another company.
To proceed, click Continue.
If any issues are found in your data, an Errors and Warnings window appears. You must resolve all errors before you can proceed with creating the return.
Browse to where you want to save the XML data file, then click Save.
The Employee List to ROS - Complete window now appears.
Click View File Summary, then check the values are correct for each employee on this report.
To print a copy of this summary report for your own records, click File then click Print.
Ensure your printer details are correct, then click Print again.
To close the summary report, click File then click Exit.
Select the Open folder containing Employee List File check box, then click Done.
The location where the XML file is saved now opens automatically in Windows Explorer.
To close the Payroll Reports window of Sage Payroll, click Cancel.
Frequently asked questions
We've collated the questions you're asking us about the employee list for Revenue into a helpful guide.