Canadian Crypto Records Spreadsheet | ACB Tracker, Staking Log, Superficial Loss Flags | Excel & Google Sheets | NWW

Keep your crypto records organized in Canadian dollars, with no monthly subscription.

The Canadian Crypto Records Kit by NorthWest Wa is a spreadsheet workbook plus two printable PDFs for Canadians who buy, sell, swap or stake crypto. It helps you organize your transactions and gives you running estimates of your adjusted cost base (ACB) using the average-cost method, the gain or loss on each sale or swap, the staking income you've recorded, and a year-end summary to review with your accountant.

WHAT'S INCLUDED
• Excel workbook (.xlsx), which also opens in Google Sheets and LibreOffice:
- Start Here: step-by-step instructions and links to official CRA guidance
- Wallet & Exchange Log
- Transactions: buys, sells, swaps, spends and transfers in CAD
- ACB Calculator: running average cost per coin, with an estimated gain or loss on each disposal
- Staking Income Log: fair market value in CAD when each reward is credited
- Superficial Loss Flag: prompts you to review losses where the same coin was acquired from 30 days before to 30 days after a sale and is still held 30 days later
- Annual Summary: choose a year to see organized totals per coin
- Worked example rows so you can see how everything fits together
• Self-Custody & Seed-Backup Checklist (printable PDF, 2 pages)
• How-To Guide (PDF, 4 pages) with a worked example

WHO IT'S FOR
Canadians holding crypto as an investment who want tidy records for themselves and their CPA.

GOOD TO KNOW
• Instant digital download. Nothing physical ships.
• All amounts in CAD. Room for 500 transactions and 500 staking rewards.
• The workbook never asks for a seed phrase or private key, and it should never contain one.
• Results are estimates based on the numbers you enter. Accuracy depends on your records.
• Links to publicly available CRA guidance are included.
• It doesn't model complex DeFi, NFTs, mining businesses, or frequent trading that may be business income. Ask a CPA about those.

DISCLAIMER: Not financial advice. For educational purposes only. This is not tax advice. It helps you organize records; confirm all figures with a CPA. Not affiliated with or endorsed by the Canada Revenue Agency. Digital downloads can't be returned. If a file doesn't open, message us and we'll help.

© NorthWest Wa. For personal use only. Please don't resell or share.