CCA Depreciation Schedule (Canada)

Download and open in Excel or Google Sheets

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

List each asset and assign it to the correct CCA class

CRA prescribes specific classes and rates — verify the correct class for each asset type.

Enter the asset cost and acquisition date

This forms the capital cost the CCA calculation builds from.

Review the automatic declining-balance CCA calculation

This applies the prescribed rate for each class to calculate the year’s CCA and remaining UCC.

Run the built-in AI prompt to flag items to review

Attach the saved file to ChatGPT or Claude and ask which assets or classes are worth discussing further with your accountant.

Assigning an asset to the wrong CCA class

Each class has a different prescribed rate — an incorrect classification directly produces an incorrect CCA calculation.

Using straight-line depreciation instead of CCA’s declining-balance method

CCA specifically uses declining-balance calculations by class — this is fundamentally different from book depreciation and shouldn’t be substituted.

Forgetting the half-year rule in the year of acquisition

CRA generally applies a half-year rule limiting the CCA claim in the year an asset is acquired — verify how this applies to your specific assets and any exceptions.

Claiming maximum CCA every year without considering the tradeoff

CCA is optional up to the maximum each year — claiming less in a lower-income year to preserve UCC for a higher-income future year is a legitimate strategic choice worth discussing with your accountant.