Templates · Crypto
Free Crypto Cost Basis Spreadsheet
Track the cost basis of every crypto purchase so your taxes are accurate. Uses FIFO lot tracking and handles buys, sells, swaps, mining income, and airdrops across all your wallets and exchanges.
- Crypto
- Spreadsheet
- Free template
What's included
This spreadsheet includes 4 sections covering everything you need.
Purchase Lots
Every time you bought or received crypto, logged as a separate lot.
| Date | Asset | Amount | Price per Unit (USD) | Total Cost | Source | Exchange/Wallet |
|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- |
Disposal Events
Sells, swaps, and spending matched to your purchase lots using FIFO.
| Date | Asset | Amount | Proceeds (USD) | Matched Lot Date | Cost Basis | Gain/Loss | Holding Period |
|---|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- | --- |
Remaining Lots
Purchase lots you still have open (not fully sold or swapped).
| Asset | Original Date | Original Amount | Remaining Amount | Cost per Unit | Remaining Basis |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
Income Basis
Cost basis from mining, staking, airdrops, or getting paid in crypto.
| Date | Asset | Amount | FMV per Unit | Total Basis | Source Type |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
How to use this template
Follow these steps to get the most out of this template.
- 1
Every time you buy crypto, add a new lot with the date, amount, and price you paid.
- 2
For income events (mining, staking, airdrops), record the fair market value when you received it — that is your cost basis.
- 3
When you sell or swap, match the disposal to your oldest lot first (that is FIFO).
- 4
Your gain or loss is simply proceeds minus the matched lot's cost basis.
- 5
Track remaining lots so you always know your current basis for future sales.
- 6
At tax time, sum everything up and transfer the numbers to your crypto tax worksheet.
Who this template is for
Crypto traders who need accurate cost basis for their tax return.
Investors who bought the same coin at different prices over time.
Anyone who has received crypto through mining, staking, or airdrops and needs to establish basis.
People who want to know their true profit or loss on crypto investments.
Why use Clarity instead?
This template is great for manual tracking, but Clarity automates everything for you. Connect your bank accounts, brokerages, exchanges, and wallets and see real-time data without entering a single number.
- Automatic transaction imports from 12,000+ institutions
- Real-time portfolio values and net worth tracking
- AI-powered spending insights and budget recommendations
- Tax-ready reports with automatic cost basis calculations
- One dashboard for banks, brokerages, crypto, and DeFi
Frequently Asked Questions
What is FIFO and why does it matter?
FIFO stands for first-in, first-out. When you sell crypto, you are selling your oldest units first. This determines your cost basis and holding period, which directly affects how much tax you owe. It is the IRS default if you do not pick a different method.
How do I track cost basis for crypto-to-crypto swaps?
Treat a swap as selling one coin and buying another. Calculate the gain or loss on what you gave up based on your cost basis. Your new basis in the coin you received is its fair market value at the time of the swap.
What is my cost basis for an airdrop?
Your basis is whatever the tokens were worth when you received them (which you also report as ordinary income). If the airdrop had no value when it landed in your wallet, your basis is zero.
Related templates
Other templates you might find useful.
Crypto Tax Worksheet
Get your crypto transactions organized for tax time. This worksheet covers buys, sells, swaps, and income events. It calculates short-term and long-term capital gains using FIFO and flags potential wash sales.
CryptoCrypto Portfolio Tracker
See your entire crypto portfolio in one view, no matter how spread out it is across exchanges, wallets, and DeFi protocols. Track positions, cost basis per coin, overall allocation, and DeFi positions.
TaxCapital Gains Tracker
Stay on top of your realized gains and losses across all asset types so tax season does not catch you off guard. This tracker separates short-term and long-term gains, manages loss carryforwards, and helps you estimate your tax bill before year-end.
Ready to go beyond spreadsheets?
Clarity connects to your financial accounts and automates what this template does manually. Real-time data, zero data entry, and AI-powered insights.