Pensionable and insurable earnings review (PIER) – SPD681 report

<< Click to Display Table of Contents >>

Pensionable and insurable earnings review (PIER) – SPD681 report

The Pensionable & Insurable Earn report, specially designed to allow you to verify if differences exist between the contributions withheld from employee pay
(QPP/CPP, EI, or QPIP) and the contributions required based on the insurable earnings reported. You can thus make your adjustments during the year.

Warning If the necessary corrections are not made prior to tax slip production, the federal government may send you a notice of assessment..

Desj-pointer

⇨A payroll preview is useful for employers who wish to view payroll processing results prior to the actual processing.
The PIER report will allow you to view the deficiencies prior to the actual processing and correct them immediately in the current pay.

⇨The report will be generated automatically with each payroll processing if deficiencies are present. If there are no deficiencies: the report will not be produced.

⇨Should you fail to correct the deficiencies indicated on the report, they will be carried over to the next one produced.

⇨It can be accessed on the payroll application, under the Payroll reports (XML, CSV) function (Reports > Payroll results > Payroll reports (XML, CSV)).
hmtoggle_plus1Viewing the report (column description)

Complet EN -sept21

DESJ BullesD_BlocCieEN

The heading contains the following information pertaining to your company file:

1Report title and subtitle

2Report production date

3Amount of minimum deficiency for the company

4Company number

5Company name

6Company province

7Fiscal year of the report

8Number of pay periods

9Starting and Ending date of the report

DESJ BullesD_BlocEmployéEN-sept 21 (FIG 3)

The block contains the following employee information:

10Employee number

11Employee Name

12Employee First name

13Employment date

14Rehire date

15Age

16Employee status

17Employment insurance rate

18Work province

19Number of exemptions calculated

All targeted deduction blocks (EI, CPP, QPIP, and QPP) contain the same columns in which employee year-to-date data is indicated. If an employee does not have year-to-date data for certain deductions, the corresponding cell under that column will remain blank.

DESJ BullesD_BlocDNEN

20Name of deduction (EI, CPP, QPIP, or QPP)

21The company’s maximum annual contribution

22The company’s total exemption amount (does not apply to EI)

23Amount from box G1 on the tax slip (QPP only)  

24Employee exemption amount

25Total eligible earnings

26Contributions section:

oPaid: Total paid by the employee

oScheduled: Total that should have been paid by the employee

oDeficiency: difference between the amount Paid and the amount Scheduled

Things to remember

✓Amount Box G1 column: This column will only appear in the QPP deduction block.

✓If you have no employees in Québec: the columns for the Québec deductions will not appear.
hmtoggle_plus1Where do these differences come from?

The following table includes the situations most likely to cause deficiencies and may serve as a guide to help you.

Types of action

Deficiency causes

Tools available on the portal

Manual payment
          or

Cancelled payment

▪Omitting to enter deductions

▪Omitting to calculate exemptions

▪Omitting the required deductions when making a special payment or a separate payment.

▪Stop payment made without making the required adjustments.

▪Manual transaction (manual check) without required deductions or with erroneous deductions.

Payroll record - SPD603

The history of Year-to-dates, Payments or Eligible earnings (Access: Employee file > History)  

Addition/removal
of earnings

When eligible earnings (distribution codes) are created without opening the deductions in the matrix.

Validation of distribution codes - SPD655 report

Other

27e or 53e pay period

Exemption on 26 or 52 periods

Modifying the age of an employee

Modification History

Complementary tips

If you changed payroll frequency during the year:

✓This may have an impact on the number of exemptions allotted, as the number of exemptions is tied to the number of payrolls processed until the maximum contribution is reached.

✓Note that the report does not perform this operation. If applicable, you must do the calculation yourself and make the necessary adjustments in your current pay.

The age of the employee is important. For example:

✓QPP and CPP calculation starts one month following their 18th birthday.

✓CPP calculation stops the month following their 70th birthday.

✓Do not hesitate to refer to the governments for the conditions surrounding the age of an employee.

If an employee has more than one employee number:

✓If year-to-date amounts are combined for all employee numbers attributed to the same employee, the maximum contribution could be exceeded.

✓Note that the report does not perform this operation. If applicable, you must do the calculation yourself and make the necessary adjustments in your current pay.
hmtoggle_plus1How to correct Year-to-dates? (Internet only)

You can adjust the employee year-to-date amounts in the application during current payroll data entry as well as by making YDT adjustments.

Access in the payroll application

Payroll > Data Entry > Pay and adjustments > Enter pay

Payroll > Entry > Pay and adjustments > YTD adjustment

Access in the payroll application

Year-end > Enter YTD adjustments > YTD adjustment

hmtoggle_plus1How to correct Year-to-dates? (Telephone only)

Adjustments for fewer than five (5) employees

Adjustments for more than five (5) employees

To make year-to-date adjustments for fewer than five (5) employees, you must provide your payroll agent with the adjustment amounts for each employee during the current payroll.

To make year-to-date adjustments for more than five (5) employees, you must send an email request two business (2) days prior to the date of your payroll data entry.

Warning After the payroll is processed, you are responsible for verifying your payroll reports to ensure that the requested adjustments
    have been made and the amounts are accurate.

For year-to-date adjustments during the year-end period, you must fill out the Excel spreadsheet available in our application’s
Documentation section and send it to our customer service by using the Contact us function (Docum > Contact us).

Access : docum > Documentation > Forms > Year-end- Year-to-date Adjustments and Pension Adjustment