We’ve heard from a few customers that reminder message  for the “Name of foreign country” field on the T5 slip may not be visible to all.

The message is to remind users to choose a country when a client is reporting the foreign income or foreign tax paid on the boxes:
 

  • foreign tax paid (box 16) or,
  • foreign income (box 15) or,
  • foreign source equity linked notes interest (box 30)
The following message may not have been visible:

User-added image

Next Steps

If you have filed or are in the process of completing returns with foreign income, we recommend double-checking that a country has been selected on the T5 slip in order to ensure the foreign tax credit is calculated. If you have filed a return that is impacted by missing the country name in the T5 slip you will need to adjust the entry on the return and go through the ReFILE process with CRA wherever needed.

Help identifying returns to review

1. Follow this support article to enable the Client Explorer database.

 2. Click the “Filter” button in Client Explorer:
 
User-added image

The “Filters” window displays.

  3. Select “T1” clients only.

  4. Select tax year “2018” only:
 
User-added image

  5. Click on “Advanced” under the “Filters” section.

The “Advanced Filters” window displays.

  6. Click the “New” button and select the “Free form expression” radio button:

User-added image
 
  7. Paste the text below into the empty “Conditions” field. The text looks at the first 50 T5 slips on file and assesses each of them for the missing country code:

((T5Table[0,6]>0 or T5Table[0,7]>0 or T5Table[0,26]>0) and T5Table.S[0,1] = "")
or ((T5Table[1,6]>0 or T5Table[1,7]>0 or T5Table[1,26]>0) and T5Table.S[1,1] = "")
or ((T5Table[2,6]>0 or T5Table[2,7]>0 or T5Table[2,26]>0) and T5Table.S[2,1] = "")
or ((T5Table[3,6]>0 or T5Table[3,7]>0 or T5Table[3,26]>0) and T5Table.S[3,1] = "")
or ((T5Table[4,6]>0 or T5Table[4,7]>0 or T5Table[4,26]>0) and T5Table.S[4,1] = "")
or ((T5Table[5,6]>0 or T5Table[5,7]>0 or T5Table[5,26]>0) and T5Table.S[5,1] = "")
or ((T5Table[6,6]>0 or T5Table[6,7]>0 or T5Table[6,26]>0) and T5Table.S[6,1] = "")
or ((T5Table[7,6]>0 or T5Table[7,7]>0 or T5Table[7,26]>0) and T5Table.S[7,1] = "")
or ((T5Table[8,6]>0 or T5Table[8,7]>0 or T5Table[8,26]>0) and T5Table.S[8,1] = "")
or ((T5Table[9,6]>0 or T5Table[9,7]>0 or T5Table[9,26]>0) and T5Table.S[9,1] = "")
or ((T5Table[10,6]>0 or T5Table[10,7]>0 or T5Table[10,26]>0) and T5Table.S[10,1] = "")
or ((T5Table[11,6]>0 or T5Table[11,7]>0 or T5Table[11,26]>0) and T5Table.S[11,1] = "")
or ((T5Table[12,6]>0 or T5Table[12,7]>0 or T5Table[12,26]>0) and T5Table.S[12,1] = "")
or ((T5Table[13,6]>0 or T5Table[13,7]>0 or T5Table[13,26]>0) and T5Table.S[13,1] = "")
or ((T5Table[14,6]>0 or T5Table[14,7]>0 or T5Table[14,26]>0) and T5Table.S[14,1] = "")
or ((T5Table[15,6]>0 or T5Table[15,7]>0 or T5Table[15,26]>0) and T5Table.S[15,1] = "")
or ((T5Table[16,6]>0 or T5Table[16,7]>0 or T5Table[16,26]>0) and T5Table.S[16,1] = "")
or ((T5Table[17,6]>0 or T5Table[17,7]>0 or T5Table[17,26]>0) and T5Table.S[17,1] = "")
or ((T5Table[18,6]>0 or T5Table[18,7]>0 or T5Table[18,26]>0) and T5Table.S[18,1] = "")
or ((T5Table[19,6]>0 or T5Table[19,7]>0 or T5Table[19,26]>0) and T5Table.S[19,1] = "")
or ((T5Table[20,6]>0 or T5Table[20,7]>0 or T5Table[20,26]>0) and T5Table.S[20,1] = "")
or ((T5Table[21,6]>0 or T5Table[21,7]>0 or T5Table[21,26]>0) and T5Table.S[21,1] = "")
or ((T5Table[22,6]>0 or T5Table[22,7]>0 or T5Table[22,26]>0) and T5Table.S[22,1] = "")
or ((T5Table[23,6]>0 or T5Table[23,7]>0 or T5Table[23,26]>0) and T5Table.S[23,1] = "")
or ((T5Table[24,6]>0 or T5Table[24,7]>0 or T5Table[24,26]>0) and T5Table.S[24,1] = "")
or ((T5Table[25,6]>0 or T5Table[25,7]>0 or T5Table[25,26]>0) and T5Table.S[25,1] = "")
or ((T5Table[26,6]>0 or T5Table[26,7]>0 or T5Table[26,26]>0) and T5Table.S[26,1] = "")
or ((T5Table[27,6]>0 or T5Table[27,7]>0 or T5Table[27,26]>0) and T5Table.S[27,1] = "")
or ((T5Table[28,6]>0 or T5Table[28,7]>0 or T5Table[28,26]>0) and T5Table.S[28,1] = "")
or ((T5Table[29,6]>0 or T5Table[29,7]>0 or T5Table[29,26]>0) and T5Table.S[29,1] = "")
or ((T5Table[30,6]>0 or T5Table[30,7]>0 or T5Table[30,26]>0) and T5Table.S[30,1] = "")
or ((T5Table[31,6]>0 or T5Table[31,7]>0 or T5Table[31,26]>0) and T5Table.S[31,1] = "")
or ((T5Table[32,6]>0 or T5Table[32,7]>0 or T5Table[32,26]>0) and T5Table.S[32,1] = "")
or ((T5Table[33,6]>0 or T5Table[33,7]>0 or T5Table[33,26]>0) and T5Table.S[33,1] = "")
or ((T5Table[34,6]>0 or T5Table[34,7]>0 or T5Table[34,26]>0) and T5Table.S[34,1] = "")
or ((T5Table[35,6]>0 or T5Table[35,7]>0 or T5Table[35,26]>0) and T5Table.S[35,1] = "")
or ((T5Table[36,6]>0 or T5Table[36,7]>0 or T5Table[36,26]>0) and T5Table.S[36,1] = "")
or ((T5Table[37,6]>0 or T5Table[37,7]>0 or T5Table[37,26]>0) and T5Table.S[37,1] = "")
or ((T5Table[38,6]>0 or T5Table[38,7]>0 or T5Table[38,26]>0) and T5Table.S[38,1] = "")
or ((T5Table[39,6]>0 or T5Table[39,7]>0 or T5Table[39,26]>0) and T5Table.S[39,1] = "")
or ((T5Table[40,6]>0 or T5Table[40,7]>0 or T5Table[40,26]>0) and T5Table.S[40,1] = "")
or ((T5Table[41,6]>0 or T5Table[41,7]>0 or T5Table[41,26]>0) and T5Table.S[41,1] = "")
or ((T5Table[42,6]>0 or T5Table[42,7]>0 or T5Table[42,26]>0) and T5Table.S[42,1] = "")
or ((T5Table[43,6]>0 or T5Table[43,7]>0 or T5Table[43,26]>0) and T5Table.S[43,1] = "")
or ((T5Table[44,6]>0 or T5Table[44,7]>0 or T5Table[44,26]>0) and T5Table.S[44,1] = "")
or ((T5Table[45,6]>0 or T5Table[45,7]>0 or T5Table[45,26]>0) and T5Table.S[45,1] = "")
or ((T5Table[46,6]>0 or T5Table[46,7]>0 or T5Table[46,26]>0) and T5Table.S[46,1] = "")
or ((T5Table[47,6]>0 or T5Table[47,7]>0 or T5Table[47,26]>0) and T5Table.S[47,1] = "")
or ((T5Table[48,6]>0 or T5Table[48,7]>0 or T5Table[48,26]>0) and T5Table.S[48,1] = "")
or ((T5Table[49,6]>0 or T5Table[49,7]>0 or T5Table[49,26]>0) and T5Table.S[49,1] = "")

  8. Click the “Ok” button and save the query.

To identify client that were already electronically or paper filed, assign the following values:

 User-added image

To identify clients that are still in progress but require a country designation, assign the following values:

 User-added image

  9. Click the “Apply Filters” button.

Click the image to review a video tutorial (a new window will open) of the assessment process:

User-added image