T4 & T4A XML CRA Error Troubleshooting

T4 & T4A XML CRA Error Troubleshooting

GOAL: To provide a documented list of T4 and T4A XML errors that occur either from submitting to CRA, or upon running validation of the XML – and the associated steps to reconcile the data. 

ISSUE: <cppe_cntrb_amt> or <cpp_cntrb_amt> is negative. 

FIX: <cppe> correlates to CPP2, so this implies that the CPP or CPP2 deductions are negative which is impossible and should be reconciled for the impacted Employee. 

ISSUE: Province Code has a value of ‘00’ for out of country record. 

XML:580570,22: value '00' does not match any member types of the union

FIX: Province code for out of the country can be changed to ‘ZZ’ or noted back to the local province in certain cases. 

ISSUE: City Name has a value that has a length which exceeds 28 characters. 

XML:304325,48: value 'Mount Albert, East Gwillimbury' has length '30' which exceeds maxLength facet value '28'XML:304325,48: value 'Mount Albert, East Gwillimbury' has length '30' which exceeds maxLength facet value '28'

FIX: Shorten the city name code for all instances where this is happening. 

ISSUE: Address has a length that exceeds the maximum of 30 characters. 

XML:309936,63: value '4_ _________ ____. West, Mississauga' has length '35' which exceeds maxLength facet value '30'

FIX: Shorten the address in all instances where it is applicable to be below the maximum character value of 30. 

ISSUE: The Initial value is NULL, when this must be populated. 

XML:233060,14: value '' does not match regular expression facet '\p{L}{1}'

FIX: Populate the Initial value in all instances where it is NULL.  

NOTE: The<init> line is not required, if the line is removed the .XML file should not error - however, if it is present then the Initial value must be populated.