Skip to content
The title slide and first slides of the Crypto Tax Transaction Log template

Crypto Tax Transaction Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 15, 2026

Every slide (5)

Overview

People who buy, sell or earn crypto use this transaction log to keep a record that is ready for a tax professional. The Transactions tab has one row per event with the type, asset, account, quantity, price, fee and cost basis, and calculates the value and the gain or loss on each disposal. The Accounts tab tracks every exchange and wallet and whether you saved its full history. The Dashboard totals gains, reward income and fees and splits activity by type and asset.

Enter the cost basis for every sale, swap or spend, because that is what turns a price into a gain or loss. Save each exchange's history file at year end, since exchanges may limit how far back you can download. Keep the log factual and let a tax professional decide how each type of event is treated.

Useful for

  • Keep a clean record of every buy, sale and swap
  • Total reward income and fees for the year
  • Make sure every exchange and wallet has a saved history export

What's included

  • 4 tabs: Dashboard, Transactions, Accounts, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Transactions: a table
  • Accounts: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Transactions tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Which crypto records matter at tax time?

Keep the date, type, asset, quantity, price, fees and cost basis of every transaction, plus an export of each account's history. This log holds the figures and the Accounts tab tracks the exports.

How do I calculate gain or loss on a crypto sale?

Take the value you received, subtract the fee and subtract the cost basis of what you sold. The Gain or loss column handles that for every sale, swap and spend row.

Do I need to log transfers between my own wallets?

Usually a move between your own wallets is not a sale, but any fee you paid may matter. Add a note, and discuss transfers and fees with a tax professional.

  • #tax-tracker
  • #crypto-tax-transaction-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…