How do I print individual T5018's for subcontractors?

Anonymous · ‎March 11, 2019

I already have the T5018 report but need the individual T5018's so I can mail out to my subcontractors

impossible · ‎March 11, 2019

The actual forms cannot be printed from QB. The Report with the all details can, however, be created in QB.

ShiellaGraceA · ‎March 11, 2019

Thanks for sharing your need for help in printing T5018.

In order to print the individual slips, you need to visit the CRA website and print. Printing this report/slips isn't available in QuickBooks yet.

You might find this article helpful: Process T4A and T5018 forms

Please don't hesitate to reach out if you have any other questions.

Onyxfire Online · ‎March 20, 2019

OK then how do we print from the CRA?

I need to send 80 T5018 slips and do not want to manually generate them.

Thank you

Constructor · ‎March 24, 2019

Uploading the .xml file from Quickbooks will file the 80 T5018s but not actually print them for the subcontractors. So you have two options to file and submit T5018s. Manually type and submit your 80 entries through the CRA website or use an external software to upload the .xml file. I am looking at TaxCycle to do this - at an additional cost.

I am very disappointed with Quickbooks as it was advertised as doing T5018s. So much for paying extra for the construction version.

Anonymous · ‎April 25, 2019

This is completely unacceptable. For someone who needs to file 3 years of T5018s because the previous bookkeeper didn't realize they were supposed to, and now CRA is breathing down the owner's neck, to go to all the work of editting 300 subcontractors to select the little checkbox for T5018, and input the BN, and then we cannot even print them to file a paper return, is utter lunacy. Tell me there is a way to at least export to excel or something!

impossible · ‎April 25, 2019

You can export the Report as a List to Excel but a list in excel is no better than a list in Quickbooks. Still won't complete the forms.

FYI, the paper forms require the same info - Business Numbers of each Vendor - so that has to be done no matter what. However, it is only recommended (not mandatory) that a copy be sent to the Vendor.

To catch up, I would upload the XML file to the CRA (they are quite willing to help you with the process) and skip the Vendor copies this time.

Anonymous · ‎April 25, 2019

Thanks for the reply.

I can import from Excel into TaxPrep Forms, so that might actually help, if I have to go that route.

Can I actually I send the xml files for prior years to CRA? QuickBooks claims it cannot be done. I was thinking of changing the date on my computer to make QB think that 2016 is the previous year, just to generate the xml file, and then submit to CRA through Represent-a Client. then change dates for 2017, and repeat. Do you have any idea if this will work? I REALLY don't want to manually enter all these slips through Web Forms, or even through my TaxPrep Forms, as this client uses a lot of sub-contractors, and we have several years to file!

Onyxfire Online · ‎April 25, 2019

That should work. Run it I and see. I always use rep a client to upload not the online auto connection.

Pampalm · ‎June 05, 2020

What is the report called in QBs?

AddieC · ‎June 05, 2020

Hi there, Pampalm. Thanks for joining the thread. For the T5018 summary in QuickBooks Desktop to be accurate, you need to ensure that all the transactions for your T5018 suppliers have been entered properly. You can do so by reviewing the T5018 Summary report, which shows a summary of each subcontractor's T5018 total, including GST/HST, and where applicable, PST or QST.

For more information about T5018s in QBDT, take a look at this helpful article: T4A and T5018 forms. If you have any other questions, please reach out to our tech support team.

Have a nice day.

Topics

Training

Community

Resources

How do I print individual T5018's for subcontractors?