How to Use QuickBooks Online | Focus on Bookkeeping
QBO T4A Reporting Workaround

by Tiffany J. Stewart, CPA CMA

(Guest Author)

Article reprinted with permission

As the end of February deadline approaches, we are all scrambling to complete the required T-slips.  Quickbooks Online (QBO) has the ability to prepare the T4s but the T4As and T5018s are some of the additional slips that need to be prepared and are not organically available (yet) in QBO.

Chat Continues Below Advertisement

T4A reporting slips...

Generally, you need to complete a T4A slip for suppliers if you are a payer of other amounts related to employment.


CRA website explains types of income to report on a T4A reporting slip.CRA website explains types of income to report on a T4A reporting slip.


In this blog, we will be discussing gathering the information for “fees or other amounts for services”.  Since you need to report the amount paid to the Supplier for the calendar year net of any taxes, the best report to start with is the Profit and Loss report.  Run a Profit and Loss.  Click Customize.  Change the Report period to Last Calendar Year.  Under the Accounting method, click Cash. Click on >Rows/Columns.  Click on Columns and pick Supplier.


How to a customize T4A report in QBO.How to a customize T4A report in QBO.


This will give you the total amount paid excluding GST/HST for all suppliers.  Once you determine which suppliers require the T4A use the PROFIT figure in the appropriate box of the T4A.


QBO T4A reporting totalQBO T4A reporting total


NOTE:  This will only work for participating provinces that have Harmonized Sales Tax.  Any provinces with separate GST and Provincial Sales tax will need to use an alternate method as the PST will be included in the above figures.

And now those ever popular T5018 slips...


A T5018 slip is the Statement of Contract Payments and is required to be completed for your suppliers when your primary source of business income (50% or more) is derived from construction activities.  In many cases there are businesses which have significant amounts of construction done for them or by them, but this activity is not their principal business and they do not have to report under the Contract Payment Reporting System (CPRS).  However, the T4A requirements may apply.

Since you need to report the total payments to subcontractors for construction services, including any GST/HST and provincial/territorial sales tax, the best report to start with is the Bill Payment List which can be found in the Manage Accounts Payable group of reports.


Customize QBO's Bill Payment List Report to collect your T5018 information.Customize QBO's Bill Payment List Report to collect your T5018 information.


You can report payments on a calendar year basis or based on your fiscal year end.  Once you choose a reporting period, subsequent returns must be filed for the same reporting year unless otherwise authorized in writing by the CRA.   Click on Customize and change the Reporting period to either Last Calendar Year or Last Fiscal Year.  Click on Rows/Columns and change Group by to Supplier.

QBO T5018 Customize ReportQBO T5018 Customize Report


This will give you the total amount paid including applicable taxes for all suppliers.  Once you determine which suppliers require the T5018 enter the total in box 22.


QBO T5018 detail supplier listQBO T5018 detail supplier list


You can click on the upside down triangle beside each supplier name to collapse the details and reduce the size of the report.


QBO Supplier Collapsed Report ViewQBO Supplier Collapsed Report View
Tiffany J Stewart CPA CMATiffany J Stewart CPA CMA


About the Author:

Tiffany J. Stewart CPA CMA resides in Toronto, Ontario and is self employed. She is an Advanced Certified ProAdvisor for QuickBooks Online and Desktop and can be contacted through Linked-In or Facebook.






10 Part QuickBooks® Primer
Click on any image below to go to the chat.

How to use QuickBooks to create customized reports.

Part 1

Accounting System Flowchart

Learn How To Customize Reports

Closing Procedures, Tracking GST/HST/PST

How to record a foreign wire transfer in QBO

Part 2

Recording Foreign Wire Transfers
in QuickBooks Online 


Part 3

Setup Meals Sales Tax Code

Differences/Limitations

Part 4

Setup Self Assessing PST Codes
in QuickBooks Online 

You've got this!

Part 5

Supplier Refunds & Credits

Marnie's Shortcut

Part 6

Debit Card Refunds

Learn How To Use QuickBooks

Part 7

Beginner's Tips on A/R, A/P, Banking

Period End Closing Adjusting Entries

Shortcuts, QBO apps, Beginner's FORUM

Part 8

QuickBooks Desktop to Online
Conversion Problems 

Handling Inventory Returns for Damaged Goods

Part 9

Handling Inventory Returns for Damage Goods

Part 10

Recording CBSA Duties & GST

QuickBooks® is a registered trademark of Intuit Inc. Screen shots © Intuit Inc. All rights reserved.

Click here to subscribe to QuickBooks Online Canada. I do not receive any commissions for this referral.



T5018 and T4A Reporting in QBO

Share this page:
Enjoy this page? Please pay it forward. Here's how...

Would you prefer to share this page with others by linking to it?

  1. Click on the HTML link code below.
  2. Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.

Enjoy A Tea Break With
Me Today. Let's Chat!

Use the search feature to quickly find the
information you're looking for.



SHORTEN
Your Learning Curve!

 



Warm up your tea cup and check out these chats ...

Click on image above to read the chat.








Join Me On Facebook

Help support this site by "liking" me! Here's where I post current information.

Listed Under Websites NOT Local Business.
This website is NOT associated with the business operating in Bonnyville AB.


A Handy Reference