TOOLS CLUB TEMPLATE

Charitable Donation Tracker (Canada)

Charitable donations can provide a valuable tax credit or deduction in Canada, but only with a proper official donation receipt from a registered charity — and donations scattered across the year, without a running log, are easy to under-total or under-document by year-end. This tracker keeps a running record.

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 make regular charitable donations
Anyone who has struggled to reconstruct a year of giving at tax time
Business owners donating both cash and non-cash items
Businesses wanting clean documentation to support a donation claim with CRA

What's included

Cash donation log with date, registered charity, and amount
Non-cash donation log with description and estimated fair market value
Official donation receipt reference field per donation
Built-in AI prompt to flag donations missing supporting documentation

Why use a template instead of starting from scratch?

A donation without an official CRA-compliant receipt generally can’t be claimed — and reconstructing that documentation months later is often impossible. Logging each donation as it happens, with a reference to its official receipt, keeps the record complete and defensible.

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.

Confirm the recipient is a registered charity

Only donations to organizations with valid registered charity status generally qualify for an official donation receipt.

Log cash donations as they’re made

Date, registered charity, and amount, referencing the official donation receipt.

Log non-cash donations separately

Description and a reasonable estimated fair market value, with documentation.

Run the built-in AI prompt before filing

Attach the saved file to ChatGPT or Claude and ask which donations look like they’re missing sufficient documentation.

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 logged donations look like they may be missing sufficient documentation to support the claim under CRA rules, no accounting background required.

Common Mistakes to Avoid

Donating to an organization without confirming registered charity status

Only registered charities can issue official donation receipts CRA recognizes — verify status before assuming a donation qualifies.

Not keeping the official donation receipt

CRA specifically requires an official receipt with prescribed information — a generic thank-you letter generally isn’t sufficient.

Estimating non-cash donation value inaccurately

Fair market value for donated goods needs a reasonable, defensible basis, and larger non-cash donations may require additional documentation or appraisal.

Confusing a business donation with a sponsorship expense

These are typically treated differently for tax purposes — check with your accountant on how to categorize a specific arrangement correctly.

Frequently Asked Questions

Are business charitable donations tax deductible or creditable in Canada?

This depends on your business structure — corporations generally deduct donations, while unincorporated businesses may claim a personal tax credit — rules and limits apply either way, so confirm with an accountant.

What makes a donation receipt "official" under CRA rules?

CRA requires specific information on the receipt, including the charity’s registration number — a general thank-you note from the organization typically isn’t sufficient on its own.

How do I value a non-cash donation for CRA purposes?

Generally at fair market value, though larger non-cash donations may require additional documentation or a formal appraisal — check current CRA guidance.

Is this included in the free plan?

No, this is a Tools Club template. iLuvAccounting also has a free Business Tax Deduction Tracker (Canada) for your other deductible expenses.

Is there a non-Canada version of this tracker?

Yes — iLuvAccounting has a general Charitable Donation Tracker without CRA-specific receipt requirements.

Is sponsoring a local event the same as a charitable donation in Canada?

Not necessarily — sponsorships with a genuine marketing/advertising benefit are sometimes treated as a business expense rather than a charitable donation. Check with your accountant on how to categorize a specific sponsorship.

Should donation claims be reviewed by an accountant?

For anything beyond small, straightforward cash donations, yes — donation limits, receipt requirements, and non-cash valuation rules have enough nuance that professional review is worthwhile.

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