Payroll Register Export
This comma-separated values (.CSV) file includes the payroll activity and wage amounts for each employee, for a specific pay period. Basic information is included such as the number of hours that each employee has worked, their gross pay, net pay, deductions, and the pay period dates.
Detailed information is also included such as the employee's Start Date and Birth Dates, Distribution (Department), Taxable earnings, EI Insurable Hours, and more. The report is useful to verify the accuracy of the current payroll calculations, and to provide a historical record for a given pay period.
Header Row
The top row in the spreadsheet lists the items and classes that are included in the report. The remaining rows show the details and amounts for each employee, based on the settings in various program screens, and the values that have been calculated. Employees are ordered by their Surname by default (this setting can be changed in the Payroll Processing - Reports screen's Order cell).
The first set of report columns focus on the current payroll:
- company - This column displays the Company Name.
- payType - This column displays the payroll's Pay Type.
- startDate - This column displays the payroll's Start Date.
- endDate - This column displays the payroll's End Date.
- payDate - This column displays the payroll's Pay Date.
- groupName - This column displays the name of the group (if you are using the Group option for the report). The group name will be based on the item that is selected in the Order cell.
- payRun -This column displays the payroll's Year, Sequence Number, and Pay Period number.
- closedPay -This column displays the state of the payroll. This can be either Open (TRUE), or Closed (FALSE).
- payroll -This column displays the payroll's Name.
The next set of report columns focus on specific employee data:
- employeeName -This column displays the employee's name, ordered by Surname and Given Name.
- employeeNumber -This column displays each employee's Employee Number.
- employeeSin - This column displays the employee's Social Insurance Number (SIN).
- employeeBirthday - This column displays the employee's Birth Date.
- employeeTaxProvince - This column displays the employee's Tax Province.
- employeeBusinessNumber - This column displays the CRA Business Number that was used when calculating the employee's payroll information.
- employeeEiHours - This column displays the employee's EI Insurable Hours.
- employeeEiableAmount - This column displays the employee's earning amounts that are subject to EI.
- employeeChequeNumber - This column displays the employee's Cheque Number (if you have previously created the Pay Statements with Cheques report).
- employeeTaxableAmount - This column displays the employee's Taxable Amount.
- employeeNetPay - This column displays the employee's Net Pay.
- employeeGrossPay - This column displays the employee's Gross Pay.
- employeeGrossYtd - This column displays the employee's year-to-date totals for their Gross Pay.
- employeeDeductionTotal - This column displays the total amount of deductions for each employee.
- employeeDeductionYtd - This column displays the employee's year-to-date totals for their deductions.
- employeeBenefitTotal - This column displays the total amount of benefits for each employee.
- employeeBenefitYtd - This column displays the employee's year-to-date totals for their benefits.
- employeePreArrears - This column displays the employee's Pre Arrears.
- employeeArrears - This column displays the employee's Arrears.
- employeeAddress - This column displays the employee's Address.
- employeePostalCode - This column displays the employee's Postal Code.
- employeeProvince - This column displays the employee's Province of residence.
- employeeDistribution - This column displays the employee's assigned Distribution code.
- employeeCity - This column displays the employee's City.
- employeeStartDate - This column displays the employee's Start Date.
- definitionClass - This column displays the class (type) for the row item. This is an internal designation and it not editable.
- definitionName - This column displays the name of the row item.
- rate - Applicable for earning items only, this column displays the earning's assigned Rate.
- hours - Applicable for Hourly earning items only, this column displays the number of hours that the employee worked.
- amount - This column displays the current amount for the corresponding row item. For rows where both deductions and benefits apply (e.g. CPP, and EI), this column displays the employee's portion of the deduction.
- ytd - This column displays the employee's year-to-date amount for the corresponding row item. For rows where both deductions and benefits apply (e.g. CPP, and EI), this column displays the employee's portion of the deduction.
- bonus - This column indicates whether the employee's bonus earning is using the Bonus Tax Calculation method.
- amount2 - This column displays the year-to-date amount for the employer's (benefit) portion for the corresponding deduction.
- ytd2 - This column displays the year-to-date amounts for the employer's (benefit) portion for the corresponding deduction.
See Also