T4/T4A XML Creation
The T4/T4A XML Creation allows you to generate the XML file for submission to CRA. Note: the XML Creation process will convert all Province fields to ZZ for addresses with a country code other than Canada (CAN) or USA, as per the CRA instructions.
All Non-amended/non-cancelled T4/T4A CRA files will be generated as 'O’riginal data. All Amended T4/T4A CRA files will be generated as ‘A’mended data and all Cancelled data will be created as ‘C’ancelled data. Note: The Amended and Cancelled data contains a header and trailer of ‘A’ as both of those submissions are to be applied to the originally submitted Original data. The body or employee detail on an Amended XML will be set to ‘A’ for Amend while the Cancellation with be set to ‘C’ for Cancel.
Once the process has completed, the number of T4/T4A slips generated will be displayed for verification. You can use the Payroll Email File Process to email the XML file to yourself for XML validation and submission.
The regular XML file is generated from the values of the CRA File named:
FFORM#.Tyywhere # is the tax group and yy the last 2 digits of the taxation year for T4's.
AFORM#.Tyywhere # is the tax group and yy the last 2 digits of the taxation year, for T4A's.
The Amended XML file is generated from the values of the CRA File named:
AM_###_FFORM#.Tyy where ### is the Amend number, where # is the tax group and yy the last 2 digits of the taxation year for T4's.
AM_###_AFORM#.Tyy where ### is the Amend number, where # is the tax group and yy the last 2 digits of the taxation year, for T4A's.
CN_###_FFORM#.Tyy where ### is the Cancel number, where # is the tax group and yy the last 2 digits of the taxation year for T4's.
CN_###_AFORM#.Tyy where ### is the Cancel number, where # is the tax group and yy the last 2 digits of the taxation year, for T4A's.
The location of the CRA files and the newly created XML file is defined by the logical ATRIEVEERP$OPSWRK. This logical is setup in the LOCICALS.COM for each individual payroll.
The Merged XML file is generated from the values of the CRA File named:
FFORM####.Tyy where #### is the applicable RP number and yy the last 2 digits of the taxation year for T4's.
AFORM####.Tyy where #### is the applicable RP number and yy the last 2 digits of the taxation year, for T4A's.
The Merged Amended XML file is generated from the values of the CRA File named:
AM_###_FFORM####.Tyy where ### is the Amend number, where #### is the tax applicable RP number and yy the last 2 digits of the taxation year for T4's.
AM_###_AFORM####.Tyy where ### is the Amend number, where #### is the applicable RP number and yy the last 2 digits of the taxation year, for T4A's.
CN_###_FFORM####.Tyy where ### is the Cancel number, where #### is the tax applicable RP number and yy the last 2 digits of the taxation year for T4's.
CN_###_AFORM####.Tyy where ### is the Cancel number, where #### is the applicable RP number and yy the last 2 digits of the taxation year, for T4A's.
The location of the Merged CRA files and the newly created XML file is defined by the logical ATRIEVEERP$OPSMRG. This logical is setup in the PRDLOGIN.COM for all payrolls.
Generate T4 or T4A XML File [T4/T4A] <T4>
- Press 'Enter' or enter 'T4' to generate a T4 XML file.
- Enter 'T4A' to generate a T4A XML file.
Regular Or Merge Statements
Enter ‘R’ to process the T4/T4A submission from the current payroll information.
Enter ‘M’ to process the merged T4/T4A submission for a specific RP number.
When Regular T4/T4A was selected:
Enter Tax Group
Enter tax group 6, 7 or 8.
When Merged T4/T4A was selected:
Enter RP Number
Enter the applicable RP number to process Merged T4/T4As.
Enter Taxation Year
Enter the 4-digit applicable taxation year. The name of the XML files includes a portion of the taxation year to allow multiple years of T4/T4A information to be maintained.
Regular, Amended Or Cancelled Statements
- Enter ‘R’ to select the regular T4/T4A CRA file.
- Enter ‘A’ to select an Amended T4/T4A CRA file.
Enter ‘C’ to select an Cancelled T4/T4A CRA file.
When ‘A’MENDED Statement was selected:
Amended T4/T4A File
Automatically, all Amended T4/T4A CRA files for this tax group and tax year are displayed, as shown below. You may scroll up and down to select the correct file.
Enter xml file name [CCCCC###.xml]
A default file name for regular T4/T4As is supplied. CCCC_FFORM#_YY_001.XML for T4s or CCCC_AFORM#_YY_001.XML for T4A, where CCCC is the payroll ID, # is the tax group and YY is the taxation year. The default file name for Merged T4/T4As is supplied as MERG_FFORM####_YY_###.XML or MERG_AFORM####_YY_###.XML, where #### is the applicable RP number, YY is the taxation year.
CRA requires the XML file name use a file extension of XML and that the last 3 positions of the file name be 001 for the first submission. If you send a second submission you would change the 001.XML to 002.XML.
The default file name for amended T4/T4A is CCCC_AM_FFORM#_YY_###.XML for T4S or CCCC_AM_AFORM#_YY_###.XML for T4A, where CCCC is the payroll id, # is the tax group, YY is the taxation year and ### is taken from the Amended number of the selected file. The default file name for merged amended T4/T4As is MERG_AM_FFORM####_YY_###.XML or MERG_AM_AFORM####_YY_###.XML, where #### is the applicable RP number, YY is the taxation year and ### is taken from the Amended number of the selected file.
The default file name for Cancelled T4/T4A is CCCC_CN_FFORM#_YY_###.XML for T4S or CCCC_CN_AFORM#_YY_###.XML for T4A, where CCCC is the payroll id, # is the tax group, YY is the taxation year and ### is taken from the Cancel number of the selected file. The default file name for merged amended T4/T4As is MERG_CN_FFORM####_YY_###.XML or MERG_CN_AFORM####_YY_###.XML, where #### is the applicable RP number, YY is the taxation year and ### is taken from the Cancel number of the selected file.