Running T4,T4A reports

Run T4,T4A Reports (PR242) to balance to year-end totals.

Running a report for negative wages

Before you create your T4,T4A slips or magnetic media, run T4,T4A Reports (PR242) for Report Options equal 3 for negative wages. If you have any employees who have negative wages, you must correct the wages before you print the year-end slips. For more information on adjusting an employee's wages, see Making adjustments.

T4,T4A slips or electronic files are not created for employees with negative data. These employees print on the Error report with an error message, and appear on the Detail and Summary Edit reports and the Negative Wage report.

Run a T4,T4A report

  1. Access T4,T4A Reports (PR242).

    If PR242 is populated from a previous run, clear all the fields on the form.

  2. Select the company for which to run the report.

  3. Specify the reporting year in the Payroll Year field.

  4. On the Main tab, specify this information:

    Type of Process

    Select whether to process T4s or T4As. This determines which parameters are used from Year End Parameters (PR27.1).

    Employee Group

    Specify the employee group to be processed. If you specify an Employee Group, you can not use the Employee range.

    Employee

    Specify the beginning employee number in a range to determine which employees to process. If an employee range is selected, an Employee Group can not be used.

    Note: The rates for 2014 default into the Rates tab regardless of the year you specified in the Payroll Year field. You can manually override the fields, if necessary.

  5. On the Rates tab, define override rates, if applicable:

    EI Prem Rt Employee

    The EI Premium Rate for Employee contributions. This is the percentage rate from which the employee premiums are calculated. This amount is used in combination with other EI amounts to report errors in limits/maximums.

    Quebec EI Rate for Employee

    Specify the Quebec EI Rate for Employee contributions. This is the percentage rate from which the employee premiums are calculated. The current year's rate defaults but that value may be overridden if you are processing for a previous year. This amount is used in combination with other EI amounts to report errors in limits/maximums.

    CPP Contrib Rate

    Specify the CPP contribution rate for the payroll year you are processing. This is the percentage rate that is applied toward the applicable earnings to calculate the employee's contributions.

    QPP Contribution Rate

    Specify a QPP contribution rate for the payroll year you are processing. This is the percentage rate that is applied toward the applicable earnings to calculate the employee's contributions. The current year's rate defaults but that value may be overridden if you are processing for a previous year.

    CPP Exempt Amt

    The CPP annual dollar amount which is exempt from Pensionable earnings.

    QPP Exempt Amt

    Specify the QPP annual dollar amount which is exempt from Pensionable earnings. The current year's amount defaults but that value may be overridden if you are processing for a previous year.

    QPIP Contrib Rate

    Specify the QPIP contribution rate for the payroll year you are processing. This is the percentage rate that is applied toward the applicable QPIP earnings to calculate the employee's contributions. Although the value defaults from the system, it is overridden if the job is being processed for the past years.

    EI Earnings

    The maximum insurable earnings for EI for the year. This is the amount which EI employee premiums are based. This amount is used in combination with other EI amounts to report errors in limits/maximums.

    Quebec EI Earnings

    Specify the maximum insurable earnings for the Quebec Year Earnings for QPIP. This is the amount which Quebec EI employee premiums are based. The current year's amount defaults but that value may be overridden if you are processing for a previous year. This amount is used in combination with other Quebec EI amounts to report errors in limits/maximums.

    CPP Earnings

    The maximum annual CPP earnings. This is the maximum earnings on which the employee's CPP contributions are based. This amount is used in combination with other CPP amounts to report errors in limits/maximums.

    QPP Earnings

    Specify the maximum annual QPP earnings. This is the maximum earnings on which the employee's QPP contributions are based. The current year's amount is calculated by the program but that value may be overridden if you are processing for a previous year. This amount is used in combination with other QPP amounts to report errors in limits/maximums.

    QPIP Earnings

    Specify the QPIP Earnings. This is the maximum annual QPIP earnings where the employee QPIP contributions are based on. Although the value defaults from the system, it is overridden if the job is being processed for the past years.

  6. Define report options.

  7. Specify this information:

    Report Option

    Select type of report to generate.

    Summary report produces an edit report in summary by company, process level, or head process level. This is the default.

    Detail Report produces an edit report in detail by employee.

    Negative Wage Report produces a listing of all employees with negative data for the payroll year.

    Report Sort

    Select which order the report will print.

    This uses information from the Quarterly Deduction history file at the time of the payment. The employee records are reported using the Employee Sequence in combination with the sort order defined in this field.

    Note: If you use PR242 and PR245 reports to balance against the slips, the Slip Sort option being used within PR240 and PR243 must have Payroll Account Number as the highest level so that Summary/Segment reports are produced. That's because not all PR240/PR243 sort options allow Summary/Segment reports to be selected. For example, if you are balancing T4s and the PR240 were run for Slip Sort 2 (PR Acct Nbr), then PR242 would be run for Report Sort Option 1 (PR Acct Nbr).
    Employee Sequence

    Select which employee sequence is used on the report. Select alpha, employee number, or SIN.

    Print Code Detail

    Select whether to print T4 or T4A Other Information codes and amounts.

  8. Run the report.