Standard Excel Register

* Available at an additional charge *

The Standard Excel Register provides the ability to turn your payroll data into insight. Each pay, your payroll register detail, in MS Excel format, is delivered directly to Powerpay. Payroll codes are accompanied by short descriptions of the Earning, Deduction and Accrual codes reflect your payroll setup to make it easier to identify the relevant fields.

Based upon your payroll setup, fields may include:

Payment details

  • Cheque Type

  • Pay Period Number

  • Gross Pay Current

  • Gross Pay YTD

  • Net Pay YTD only

  • Net Pay

  • Current Employee Hourly Rate or Salary (RA or SA)

Employee details

  • Employee Number

  • Name

  • SIN

  • Address

  • City

  • Province

  • Postal Code

  • Employee Status

  • Salary/Hourly indicator

  • Start Date

  • Leave Date

Earnings/Hours

  • Earnings/Hours Current & YTD

  • Regular

  • Overtime Hours YTD (OT DT XT YT)

  • Overtime Earnings YTD (OT)

  • Statutory Holiday (XT/YT)

  • Sick Current, YTD & Accumulator

  • Vacation Hours/Earnings/Accumulator

  • Holiday Hours/Earnings/Accumulator

  • XE Earnings (includes X1-X5)

  • Codes O10-O99

  • Codes X1, X2, X3, X4, X5

  • Current Insurable Hours

  • Current Insurable Earnings

  • Lifetime Hours YTD

  • Lifetime Earnings YTD

Statutory Deductions/ Contributions

  • Federal Tax Deduction Current

  • Federal Tax Deduction YTD

  • CPP Employee Deduction – Current and YTD

  • CPP Employer Contribution – Current and YTD

  • EI Employee Deduction – Current and YTD

  • EI Employer Contribution – Current and YTD

  • WCB Current & YTD Assessable Earnings

  • Provincial Medical (EHT) Current and YTD

Deductions/Contributions

  • 10E-99E Current & YTD

  • 10R-99R Current & YTD

Cheque/EFT Details

  • Payment Sequence Number

  • Banking Institution Number

  • Bank Transit No.

  • Banking: Account Number

Distribution Information

  • Department Codes, X, Y, Z codes

Miscellaneous

  • HR Contribution - Current and YTD

  • TC Code

Request report:

  • Email your request to [email protected]. Include the payroll numbers that require this report.

    Note: This report cannot be provided retroactively.

See also