Accounting Finance:T5 Slips

T5 Slips

The software to produce T5 slips is TaxCycle (Xero) and this software has to be purchase every year.

TaxCycle website

T5 Slips Preparation

To begin, open the T5 software icon.

Prepare an Excel import file using the template from TaxCycle.

• The template can be retrieved clicking on the Create Excel template function.

• Retrieve worksheet from manager and prepare the data to template for import.

Categories that are used to prepare T5 slip:

• Recipient Type (eg. Corporation, Individual)
• Social Insurance Number
• Individual First Name
• Individual Last Name
• Business Name
• Business Number
• Recipient Address Line 1
• Recipient Address Line 2
• Recipient Address City
• Recipient Address Province
• Recipient Address Postal Code
• Recipient Address Country
• Footnote (eg. Eligible Class G Dividend / Promissory Notes Interest / Class E & G Premium on Redemptions)
• Actual amount of dividends other than eligible dividends [Box 10]
• Interest from Canadian Sources [Box 13]
• Actual amount of eligible dividends [Box 24]

Click on Excel import when ready.

To view previous template used, the files are saved on TaxCycle Directory ("""\\superserver.unipharm.local\Accounting\TaxCycle\""")

T5 Slips Review

Review the information (eg. business name, addresses) and amounts on the T5 slips are correct.

Review the slip total on the T5 Summary.

Print T5 (Hard Copy and PDF’s) and send to manager.

T5 Slips Transmission

When the file is ready for transfer, choose options under file to click on Slips Accounts. Enter Account Number and Web Access Code. 'Transmitter Number' can be empty and software will assign a number.

Account Number: 105448567RZ0001

Web Access Code: D00Z42

Click “Agree” to continue with T5 submission.

Once T5 have been submitted, save a PDF copy that confirms the T5 submission.

The XML file can be saved in History under File. Click on the icon at the far right to save XML file.