TOOLS CLUB TEMPLATE

Independent Contractor Payment Tracker (Canada)

Canadian businesses that pay contractors for services typically need to track those payments for T4A reporting — and reconstructing a year of contractor payments right before the filing deadline is a stressful way to close out the year. This tracker keeps a running total all year.

Join the Tools Club — $7/mo Already a Member? Log In

Included in the $7/mo Tools Club · Works in Excel or Google Sheets · Includes a built-in AI prompt

Who this is for

Canadian businesses that regularly pay independent contractors
Anyone responsible for T4A preparation at year-end
Bookkeepers managing contractor payments for a Canadian business client
Businesses wanting a clean audit trail of contractor payments

What's included

Per-contractor payment log with date and amount
Automatic running year-to-date total per contractor
GST/HST registration status tracking per contractor
Built-in AI prompt to flag contractors likely needing a T4A

Why use a template instead of starting from scratch?

Reconstructing a full year of contractor payments from invoices and bank records right before a T4A filing deadline is stressful and error-prone. Logging each payment as it happens keeps an accurate running total ready well before you need it.

How to Use This Template

Download and open in Excel or Google Sheets

Requires a Tools Club membership — log in first to access the file.

Set up a row for each contractor

Include GST/HST registration status alongside their payment history.

Log every payment as it’s made

Date and amount, tied to the right contractor.

Review the automatic year-to-date total per contractor

This is what you’ll need for T4A preparation.

Run the built-in AI prompt near year-end

Attach the saved file to ChatGPT or Claude and ask which contractors likely need a T4A based on year-to-date payments.

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 which contractors likely need a T4A based on year-to-date payments and current CRA guidance, no accounting background required.

Common Mistakes to Avoid

Not confirming GST/HST registration status upfront

Whether a contractor charges GST/HST affects how you record and reconcile their payments — confirm this 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 T4A reporting for business services has evolved — verify current requirements rather than relying on what applied in a prior year.

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.

Frequently Asked Questions

Who needs to receive a T4A in Canada?

Generally, businesses paying for services from unincorporated contractors may need to issue a T4A, though CRA guidance has specific rules and exceptions — verify current requirements or check with an accountant.

Do I need to track GST/HST separately for contractors?

Yes, if the contractor is GST/HST registered and charging it — this affects how the payment is recorded in your books, separate from the T4A income reporting.

Is this included in the free plan?

No, this is a Tools Club template. iLuvAccounting also has a free Invoice Template if contractors are billing you directly.

How is this different from the standard Independent Contractor Payment Tracker?

This version is built specifically around Canadian requirements — T4A reporting and GST/HST tracking — rather than U.S. 1099 reporting.

What’s the difference between a contractor and an employee under Canadian law?

This is a legal classification based on factors like control and independence, with real CRA consequences for misclassification — consult an accountant or employment lawyer if you’re unsure.

When are T4As due in Canada?

T4A filing deadlines follow CRA’s annual schedule — verify the current deadline each year, as it’s subject to CRA guidance.

Should incorporated contractors be tracked here too?

Payments to incorporated contractors are generally treated differently than unincorporated ones for T4A purposes — confirm with your accountant based on each contractor’s specific business structure.

Related Templates

Related Resources

Want the Full Template Library?

70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.

Join the Tools Club