Generate T4 and T4A

The Avionté application tracks and organizes employee data used to generate T4 and T4A reports for submission to the Canada Revenue Agency (CRA). Avionté renders T4/T4A data into summary reports for employer use, individual reports to be distributed to each employee, and XML that can be submitted directly to the CRA.

Form Definitions

Form Description
T4 A T4 slip, or Statement of Remuneration Paid, summarizes all money paid by an employer to an employee during a calendar year.

Information on T-4
T4A The T4A, also known as a Statement of Pension, Retirement, Annuity, and Other Income, is a catch-all slip that includes amounts or income categories that don't appear on other slips.

Information on the T-4A

User Permissions to View Generate T4/T4A via Weekly Process

Admin Tools > Config Option > Config Option by Property > Select Type = User > "username" > Config Option Type = "wkl_GenerateT4"

Config Option by Property screen
wkl_GenerateT4 config option

Application Field Definitions

Application field definitions diagram

General

Field Definition
Supplier The name of the staffing company employing the employee.
Year The year for which this data is being generated. Data may be generated for only one year at a time.

Company Summary

Field Definition
Registration Numbers for RPP or DPSP (071, 072, 073) The registration numbers for the staffing agency's Registered Pension Plan (RPP) or Deferred Profit Sharing Plan (DPSP).
SIN of the proprietors or principal owner(s) (074, 075) The Social Insurance Number of the staffing agency's proprietors or principal owners.

Contact Information

Field Definition
Person to contact about this return (076) The name of a staffing agency contact that may be reached for questions about T4A data.
Email The contact person's email.
Phone Number (078) The contact person's phone number.
Extension If applicable, the contact person's phone extension number.

Minus: Remittances

Field Definition
082 The dollar amount an employee already paid under the employee's payroll program account number.

The "Minus Remittances" field in the Generate T4/T4A window applies to T4A only. T4 remittances must be adjusted in Admin Tools > Supplier Properties.

File Info

Field Definition
XML Destination Folder

When data is generated into XML, it is saved to a designated location on the local PC. The path entered in this field determines where the XML file is automatically saved upon generation.

 

XML Destination Folder field

T4/T4A Data

Field Definition
View/Edit T4 Mapped Transactions This button is a placeholder for future functionality.

To view or edit T4 transaction mappings, navigate to Start Page > Actions Menu > Admin Tools > Transaction Type.
View/Edit T4A Mapped Transactions Enables an Avionté user to view which transactions are mapped to which box(es) in the T4 so data correspondence can be verified.
Generate T4 Data Generates T4 data existing at that moment for the selected supplier and year. The generated data may then be rendered into an Avionté T4 report (see Run T4 Report below).
Generate T4A Data Generates T4A data existing at that moment for the selected supplier and year. The generated data may then be rendered into an Avionté T4A report (see Run T4A Report below).
Generate T4 XML

Generates T4 data existing at that moment for the selected supplier and year, rendered into an XML document saved to the designated XML Destination Folder. The XML file can then be uploaded to the Canada Revenue Agency.

 

Generate T4 XML output
Generate T4A XML Generates T4A data existing at that moment for the selected supplier and year, rendered into an XML document saved to the designated XML Destination Folder. The XML file can then be uploaded to the Canada Revenue Agency.
Run T4 Report

Renders generated T4 data into an Avionté report format. Each page is separated by individual employee. The report reflects the format of the Canadian T4 slip and can be distributed to employees.

 

Run T4 Report output
Run T4A Report Renders generated T4A data into an Avionté report format. Each page is separated by individual employee. The report reflects the format of the Canadian T4A slip and can be distributed to employees.
Run T4 Company Summary

Renders generated T4 data into an Avionté report format as a one-page summary covering all employees. The report reflects the format of the Canadian T4 summary and can be submitted to the CRA.

 

Run T4 Company Summary output
Run T4A Company Summary Renders generated T4A data into an Avionté report format as a one-page summary covering all employees. The report reflects the format of the Canadian T4A summary and can be submitted to the CRA.
Email T4 Employees Mass email T4 notification to employees.
Email T4A Employees Mass email T4A notification to employees.

Setup

Before generating data and reports, Supplier Property values such as registration numbers or contact names can be edited in two ways: Avionté Admin Tools or the Generate T4/T4A window itself. Both areas communicate with each other, so a change in one location is saved to the other.

 

Setup - Admin Tools

The values in the T4/T4A Generator are auto-populated based on Supplier Properties in Admin Tools. These values are typically set when a supplier is created but can be edited at any time by a user with Admin rights.

  1. Navigate to Start Page > Actions Menu > Admin Tools > Category = Employer > Employer > Detail tab.
     

    T4 Supplier Properties in Admin Tools
  2. Enter "T4" into the Property column's filter cell. This narrows the list to only Supplier Properties with "T4" in the title.
  3. Mouse-over a cell in the Value column to reveal an Edit button.
     

    Edit button revealed on Value cell hover
  4. Click Edit. A Value editor displays.
     

    Value editor window
  5. Click on the text to edit.
     

    Editing a value in the Value editor
  6. Click OK to save the change.
  7. The edit appears in the Value column. Click Save to save the Supplier Property.
     

    Save button for Supplier Property
  8. A confirmation window displays. Click OK.
     

    Save confirmation dialog


    The updated value is also saved to the corresponding field in the Generate T4/T4A window.
     

    Updated value reflected in the Generate T4/T4A window

T619, Electronic Transmittal

The first element in the XML file will always be the T619 if the T4 Transmitter Account Number is entered.

T619 Electronic Transmittal XML element
  • Fields Removed — The following fields will no longer appear in the XML:
    • rpt_tcd
    • trnmtr_nbr
    • trnmtr_tcd
    • trnmtd_addr/ (including addr_l1_txt, addr_l2_txt, cty_nm, prov_cd, and pstl_cd)
  • Fields Updated — These fields have been renamed for clarity:
    • TransmitterName/l1_nm (previously trnmtr_nm/l1_nm)
    • TransmitterCountryCode (previously trnmtd_addr/cntry_cd)
  • New Field Added: T4 Transmitter Account Number
    Based on a new Supplier Property: "T4 Transmitter Account Number". This field appears in the XML if it matches one of the following formats:
    • bn15 — 15 alphanumeric characters
    • bn9 — 9 numeric characters
    • trust — 1 alpha + 8 numeric characters
    • nr4 — 3 alpha + 6 numeric characters
  • New Field Added: T4 Transmitter Rep. ID
    Based on a new Supplier Property: "T4 Transmitter Rep. ID". This field appears in the XML if it matches the following format:
    • TransmitterRepID — 7 alphanumeric characters (Representative Identifier). Required if logged in using the Represent a Client (RAC) application.
Note: If a Transmitter Account Number value does not match one of the accepted formats, an error will be triggered.

Setup - Generate T4/T4A Window

As an alternative to Admin Tools, T4/T4A values can be edited directly in the Generate T4/T4A window and saved by clicking Save Company and Contact Info. Values saved here are also saved to Admin Tools > Supplier Properties.

  1. Navigate to Main Menu > Back Office > Weekly Process > Actions Menu > Generate T4/T4A.
     

    Navigation path to Generate T4/T4A
  2. The Generate T4/T4A window displays. Click into any field to edit the properties.
  3. Click Save Company and Contact Info to save edited data.
     

    Save Company and Contact Info button
  4. A save confirmation displays. The updated values are also saved to Supplier Properties in Admin Tools. Click OK.
     

    Save Company and Contact Info confirmation dialog

Generate Data and Reports

Following setup, data can be generated from the Generate T4/T4A window.

Generate T4/T4A window

Generate T4 Data

Click Generate T4 Data to generate all available T4 data at that moment. A confirmation dialog appears.

T4 Data successfully generated confirmation
  • Click Run T4 Report to render the generated data into an individual T4 report for each employee. The report can be saved and printed with each employee's page separated.
Sample T4 2023 slip
  • Click Run T4 Company Summary to render the generated data into a one-page summary for the entire agency.
Sample T4 summary

Generate T4 XML

Click Generate T4 XML to generate all available T4 data at that moment in XML format. The XML can be saved and submitted to the CRA website.

Note: A file path must be entered in the XML Destination Folder field before generating. If no path is entered, the following message will appear:
File path required message

Enter the file path in the File Info / XML Destination Folder field:

XML Destination Folder field

Generate T4A Data

Click Generate T4A Data to generate all available T4A data at that moment. A confirmation dialog appears.

T4A Data successfully generated confirmation
  • Click Run T4A Report to render the generated data into an individual T4A report for each employee. The report can be saved and printed with each employee's page separated.
Run T4A Report output
  • Click Run T4A Company Summary to render the generated data into a one-page summary for the entire agency.
Run T4A Company Summary output

Generate T4A XML

Click Generate T4A XML to generate all available T4A data at that moment in XML format. The XML can be saved and submitted to the CRA website.

Note: A file path must be entered in the XML Destination Folder field before generating. If no path is entered, the path required message will appear.
File path required message

Errors

If errors occur during generation, error dialogs will appear. For example:

Errors generated during T4 Data generation

A summary of errors can be reviewed by clicking the Errors tab on the right-hand side.

Errors tab

T4/T4A Setup and Generation Errors and their resolutions

 

Third-party link disclaimer: These links are provided as a convenience and for informational purposes only; they do not constitute an endorsement or approval by Avionté of any products, services, or opinions of any corporation, organization, or individual. Avionté bears no responsibility for the accuracy, legality, or content of the external site or for that of subsequent links. Contact the external site for answers to questions regarding its content.

 

Articles in this section

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

Comments

0 comments

Please sign in to leave a comment.