ProConnect HelpProfile HelpIntuit

T5 Slip Foreign Country Name Notice

SOLVED•by Intuit•Updated 1 year ago

In some cases, the 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 the 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. The Filters window displays.

User-added image

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. Expand the section below and paste the text 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 clients 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.

Was this helpful?

You must sign in to vote, reply, or post
ProFile Tax

Sign in for the best experience

Ask questions, get answers, and join our large community of Profile users.