Standard Canadian AQ - Check Register_CA AQ

Report Description

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

mceclip4.png

 

 

Parameters

mceclip0.png

 

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

mceclip1.png

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)

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.

 

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share