Preparing T4A slips at year-end goes much smoother when you already have a running total per contractor on file, rather than reconstructing everything from invoices in the new year. This template tracks contractor payments throughout the year specifically for Canadian T4A reporting.
Included in the $7/mo Tools Club · Works in Excel or Google Sheets · Includes a built-in AI prompt
The new year is already busy with year-end close and tax prep — adding "reconstruct a year of contractor payments from scratch" makes it worse. Keeping this updated throughout the year means T4A season starts with the data already assembled.
Download and open in Excel or Google Sheets
Requires a Tools Club membership — log in first to access the file.
Set up a row per contractor with GST/HST status
Confirm registration status before or with the first payment.
Log every payment throughout the year
Real-time entry keeps the running total accurate.
Review your totals against current CRA T4A guidance
CRA’s specific requirements for reporting business services payments have evolved — verify current rules apply to your situation.
Run the built-in AI prompt as year-end approaches
Attach the saved file to ChatGPT or Claude and ask if your records look complete for T4A preparation.
Built-in AI prompt
Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on whether your contractor payment records look complete and ready for T4A preparation, and what’s commonly missing at this stage, no accounting background required.
Not confirming GST/HST registration status upfront
This affects how payments are recorded and reconciled — confirm before the first payment.
Missing payments made outside your normal invoicing process
A reimbursement or one-off payment can be easy to forget — log every payment, not just regular invoices.
Assuming T4A rules haven’t changed
CRA guidance on reporting payments for services has evolved over recent years — verify current requirements rather than relying on what applied previously.
Confusing contractor payments with employee payroll
Contractors should never be run through payroll — worker misclassification has real CRA consequences, so make sure the distinction is correct.
70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.
Join the Tools Club