Free Download · Rates Verified July 2026

A Fixed Asset Register Template Built for Canadian Books

Most asset register templates are generic American spreadsheets with a straight-line column bolted on. This one is built around what your accountant actually asks for at year-end: a proper register and a CCA worksheet laid out like T2 Schedule 8.

Asset Register

14 columns: FA number, description, category, CCA class, location, serial number, acquisition date, cost, residual, book method and rate, disposal date, proceeds, notes. Three sample rows show you the format.

CCA Worksheet

One row per class, laid out like T2 Schedule 8 / T2125 Area A. Enter opening UCC, additions, and dispositions — maximum CCA and closing UCC calculate automatically. 2026 rates prefilled for 11 common classes, with a first-year factor for the RIIP (0.5) or the half-year rule (−0.5).

How to Use

Instructions, a CCA quick reference with class rates, and the rules the formulas can't handle (100% write-off classes) flagged clearly, so nothing is silently wrong.

Excel (.xlsx), 18 KB  ·  Works in Google Sheets via File → Import  ·  No locked cells

Get the Template

The download starts right away. We don't send anything else unless you tick the box.

Your download is starting.

If it doesn't, download the template here. Using Google Sheets? File → Import → Upload the .xlsx.

What's Different

Built Around Schedule 8, Not a Generic Ledger

The CCA worksheet mirrors the columns your T2 Schedule 8 or T2125 Area A actually needs, with 2026 first-year rules built into the formula.

2026 First-Year Rules Included

The first-year factor column applies the Reaccelerated Investment Incentive (1.5× the rate for most property acquired 2025–2029) or the half-year rule with one cell change. The claim formula caps at remaining UCC automatically.

Max CCA = rate × (UCC + factor × net additions)
0.5 = RIIP · −0.5 = half-year · 0 = none

Honest About Its Limits

Classes with 100% first-year write-offs — Class 53 machinery, Class 54 zero-emission vehicles, computers acquired after April 15, 2024 — don't fit a one-formula model. The worksheet flags them for manual entry instead of calculating something wrong.

A negative closing UCC stays visible, because that's recapture your accountant needs to see — not an error to hide.

Where the Spreadsheet Stops

A spreadsheet can hold your register and your annual CCA claim. What it can't do: calculate book depreciation daily, keep an audit trail of who changed what, or produce a mid-quarter report without new formulas.

That's the line where faManager takes over — the register carries straight across. Free for up to 50 assets.

FAQ

Template Questions

Yes. Enter your email and the download starts immediately — no credit card, no trial, no locked cells. The workbook is yours to edit, copy, and share inside your business.

Yes. In Google Sheets: File → Import → Upload, and select the .xlsx file. The register, the CCA worksheet formulas, and the formatting all carry over.

Three sheets. Asset Register: a 14-column register with sample rows — FA number, description, CCA class, dates, cost, residual, disposal, proceeds. CCA Worksheet: one row per CCA class laid out like T2 Schedule 8, with maximum CCA and closing UCC calculated by formula, 2026 rates prefilled, and a first-year factor for the RIIP or half-year rule. How to Use: instructions and a CCA quick reference verified July 2026.

It's how we find people who might eventually want faManager, our fixed asset software. You get the template either way, and the updates list is strictly opt-in — we only email you future guides and tools if you tick the box.

Reading Up Before You Fill It In?

Our plain-language CCA guide covers the half-year rule, the 2026 Reaccelerated Investment Incentive, recapture, and how CCA differs from your book depreciation.

Read the CCA Guide Try the CCA Calculator

Built by Cloudtric Inc. in Brandon, Manitoba