Standard Canadian Report - T4_CA

On This Page

Report Description

Parameters

Report Fields

Status Indian Tax Exemption (Box 71)

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
CPP2 EE	Employee's second-tier Canadian Pension Plan (CPP2) deduction
PPIP EE	Employee's earned Provincial Parental Insurance Plan
Other Taxes EE	Other employee tax amounts not captured in the dedicated tax columns
EI ER	Employer's paid employment insurance
CPP ER	Employer's paid Canadian Pension Plan
CPP2 ER	Employer's second-tier Canadian Pension Plan (CPP2) contribution
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 depend on the parameters – Show Earnings Details, Show Deductions Details, Show Benefits Details. If set to Yes, then the columns display.

Status Indian Tax Exemption (Box 71)

Under the Indian Act, employment income earned by a Status Indian on a reserve is exempt from federal and provincial income tax and Canada Pension Plan (CPP) contributions. Employment Insurance (EI) premiums still apply. Income exempt under these provisions must be reported in Box 71 of the T4 slip rather than Box 14 (Employment Income).

Avionté Classic Back Office supports this reporting through Transaction Type configuration. When a Transaction Type is mapped to W2 Box 71, Avionté will automatically exclude that income from Box 14 and include it in Box 71 when T4 data is generated.

Note: Each employee claiming this exemption should have a completed TD1-IN (Determination of Exemption of a Status Indian's Employment Income) form on file. This form is used to determine which portion of the employee's income qualifies as non-taxable and serves as CRA backup documentation. See CRA guidance on payments to First Nations for eligibility details.

Setup -- Transaction Type

1. Navigate to Start Page > Actions Menu > Admin Tools > Transaction Type.
2. Select the Transaction Type used for Status Indian earnings (or create a new one).
3. In the W2 Box field, enter 71.
4. Click Save.

T4 Output

When T4 data is generated for an employee with transactions mapped to Box 71:

• Box 14 (Employment Income) — Reduced to reflect only taxable earnings. Income mapped to Box 71 is excluded.
• Box 71 (Indian (exempt) employment income) — Populated with the total exempt earnings.
• EI insurable earnings — Still calculated and reported, as EI applies regardless of the exemption.

Note: Box 71 must be set manually per Transaction Type on each applicable employee profile. There is no automatic detection of reserve-based work — the W2 Box mapping drives the T4 output.