Making your payroll system compatible with Record of Employment on the Web (ROE Web)

Employers, payroll service providers and payroll software developers can write computer programs to extract data from a payroll system and act as an interface to the ROE Web application.

To make your payroll system compatible with ROE Web:

  1. Request access to the ROE Web training environment

    Access to the ROE Web training and evaluation site is required to test the ROE Web payroll extract files. This environment allows you to upload payroll extract files and ensure they meet requirements to be submitted by employers to Service Canada.

  2. Become familiar with the technical specifications and edit rules of the ROE Payroll Extract file

    Learn the different specifications and edit rules to create a properly structured XML file and ensure quality of the data to process ROEs.

  3. Develop an interface to generate an extract file

    Build an interface within your payroll system to extract payroll data into an XML file. Once the file is created, it can be uploaded through the ROE Web application.

  4. Validations of extract file

    Use the following two XSD files - BulkRoeHeader.xsd (4 kb) and BulkRoe.xsd (11 kb) to validate the payroll extract file. In order to perform this kind of validation, a tool that is capable of validating an XML schema is required.

DID YOU KNOW? ROE Web also has an import feature to extract pertinent information from the ROE Web database into an XML file. Data can be imported back into the payroll software. The import feature can be used to issue amended ROEs in batches. The layout for the import XML file format is based on the requirements as described in Appendix C of the User Requirements.