Generating the Electronic File for Relevé 1s
You can create Relevé 1 information to a file that you can submit to Revenu Québec, by diskette, CD, or electronically.
For the year you select, the payroll program generates the Relevé 1 information to a file in the format required by Revenu Québec.
Note: Sage HRMS Payroll uses Sage Payroll Tax Forms and eFiling by Aatrix services for printing and filing most government reports and forms. To learn more about this functionality, read About Sage Payroll Tax Forms and eFiling by Aatrix.
Before you start
To generate the Relevé 1 electronic file
- From Government Reports, select R1s Electronic Filing.
- In the Payment Year field, enter the year of the Relevé 1s you are filing.
- In the Selection List field, you can choose a selection list to include the employees in that list.
- Choose a range of employees for whom Relevé 1s will be processed (in addition to or instead of a selection list).
- Choose how to sort the employees.
- Optionally select employees who are assigned a particular EI rate. For example, if you use two EI rates in your Payroll system, and you want to select only the employees who are assigned to the second rate, then select the Rate 2 check box. Similarly, to select employees who are exempt from EI premiums, select the EI Exempt check box.
- Complete the information on all tabs of the window, using publications from Revenu Québec to guide you. You must complete the information on the Employer and Transmitter tabs, even if the employer is also the transmitter.
- Complete the following fields at the bottom of the window:
- Local File Path. Enter the location on your hard drive where the file will be created. Do not include the file name.
- Starting Slip Number. Enter the starting slip number to be used. This number should be the same as the eFile Starting Number that you enter on the Payroll Relevé 1s window used to print the paper Relevé 1 slips.
- File Type. From the list, choose one of the options that have been defined by the Revenu Québec.
- Original file if generating an original file for submission.
- Amended file if generating an amended file.
- Cancelled file if generating a cancelled file.
- Test file for original if generating a test file for the original file. You should submit a test file to the Revenu Québec before submitting the “live” original file.
- Test file for amended if generating a test file for an amended file.
- Test file for cancelled if generating a test file for a cancelled file. (click here for more information)
- File Sequence No. Enter the sequence number of the file, as described in Revenu Québec’s publication, Guide for Transmitting RL Slip Data (General and Technical Information). This number is used as the last 3 characters of the file name.
- The payroll program automatically assigns a name to the file, based on these fields that you enter:
- Payment Year (at the top of the window)
- Transmitter Number (on the Transmitter Info II tab)
- File Sequence No. (at the bottom of the window)
- File Name
- Click to start the file generation.
- The system verifies your data.
- If the system finds invalid data, it informs you and stops processing. Edit your data, and then restart the file generation.
- If no errors are found, the program creates an XML file at the location specified in the Local File Path field.
- Click .
Note: The Rate 1 to Rate 5 check boxes and the EI Exempt check box apply to both the federal EI and Quebec EI.