Standard Canadian AQ - Check Register_CA AQ

Report Description

This report is a good resource to crosscheck with payroll before submission.

• Click here for information on Canada AQs
• Click here for information on Canada Reports

Parameters

Parameter Name	Options	Description
Branch (Payment Check)	Select a branch	Paycheck’s Branch
Date Type	Check Date, Accounting Period Date, ACH Generated Date, Positive Pay Generated Date
Start Date	Calendar date
End Date	Calendar date
SIN Ends with	Numeric	Filters results by Employee’s SIN
Show Earnings Details	Yes, No
Show Deductions Details	Yes, No
Show Benefits Details	Yes, No

Report Fields

Field Name	Description
Staffing Company	Paycheck’s Supplier
Branch	Paycheck’s Branch
PaymentBankID	Payment Bank’s unique ID
Payment Bank Name	Payment Bank’s Name
Payment Batch ID	ID of the Payroll Batch
Check Date	Paycheck’s Check Date
Accounting Period Date	Paycheck’s Accounting Period Date
AchGeneratedDateAndTime	Paycheck’s ACH Generated Date and Time
PositivePayGeneratedDateAndTime	Paycheck’s Positive Pay Generated Date and Time
DateCleared	Paycheck’s Cleared Date
CheckNumber	Paycheck’s Check Number
CheckDelivery	Paycheck’s Check Delivery
EmployeeID	Employee’s ID
BoldTalentID	Employee’s ID in AviontéBOLD (Front Office)
AgencyID	Agency’s ID
PayeeName	Employee’s Name
SIN	Employee’s SIN
Employee Status	Employee Status
EmailAddress	The employee's email address
PrimaryPhone	The employee's primary phone number
RegPayRate	Reg Pay Rate associated with the check. If there are more than one Reg, then it displays the reg rate of the one that has the most hours.
GrossAmount	Paycheck’s Total Gross Amount
TotalTaxes	Paycheck’s Total Employee’s Taxes
TotalDeductions	Paycheck’s Total Deduction Amount
TotalBenefits	Paycheck’s Total Benefit Amount
NetAmount	Paycheck’s Total Net Amount
IsT4	Employee uses a T4 or not? (check-box)
IsDirectDeposit	Is Direct Deposit or not? (check-box)
Prov.	Name of the province in which the employee works.
FedTaxes	Total Federal Tax Amount); VertexTaxId = 400
Prov. Taxes	Provincial taxes withheld
EI EE	Employee's earned employment insurance
CPP EE	Employee's earned Canadian pension plan
PPIP EE	Employee's earned Provincial Parental insurance plan
Other Taxes EE
EI ER	Employer's paid employment insurance
CPP ER	Employer's paid Canadian pension plan
PPIP ER	Employer's paid Provincial Parental insurance plan
EHT ER	Employer Health Tax paid by the employer
QHSF ER	Quebec Health Services Fund paid by the employer
CNT ER	Employer's amount paid to Commission des Normes du Travail (Commission of Labor Standards)
ADPFileStatus	ADP File Status
ADPFileGeneratedBy	User Description of the user who generates the ADP File
Earn: Vac – Units, Earn: Vac, Earn: Salary – Units, Earn: Salary, etc.	These Earnings, Deductions, and Benefits fields are dynamically pulled from your settings. These columns also depends on the parameters – “Show Earnings Details, Show Deductions Details, Show Benefits Details” value. If set to Yes, then the columns display.