Templates · Tax
Free 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.
- Tax
- Worksheet
- Free template
What's included
This worksheet includes 4 sections covering everything you need.
Taxable Dispositions
Every sell, swap, and spend that triggers a gain or loss for tax purposes.
| Date | Asset | Disposed Amount | Proceeds (USD) | Cost Basis | Gain/Loss | Holding Period | Short/Long Term |
|---|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- | --- |
Income Events
Mining, staking, airdrops, and other crypto income — taxed as ordinary income at the value when you received it.
| Date | Asset | Amount | Fair Market Value (USD) | Source | Reported On |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
Cost Basis Lots
FIFO lot tracking for each asset so you know exactly what basis is left.
| Asset | Acquisition Date | Amount | Cost per Unit | Total Cost | Remaining |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
Tax Summary
Your totals, ready for Form 8949 and Schedule D.
| Short-Term Gains | Short-Term Losses | Long-Term Gains | Long-Term Losses | Net Gain/Loss | Ordinary Income |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
How to use this template
Follow these steps to get the most out of this template.
- 1
Export your transaction history from every exchange and wallet you used during the tax year.
- 2
Categorize each transaction: buy, sell, swap, send, receive, mining income, staking reward, or airdrop.
- 3
For sells and swaps, figure out your cost basis using FIFO (first-in, first-out) from your purchase lots.
- 4
Mark each sale as short-term (held under 1 year) or long-term (held 1 year or more).
- 5
Add up all your income events (mining, staking, airdrops) — these get taxed as ordinary income.
- 6
Transfer the totals to IRS Form 8949 and Schedule D, or hand the worksheet to your tax preparer.
Who this template is for
Crypto traders who need to report capital gains and losses on their tax return.
DeFi users with complex swap and yield farming transactions.
Miners and stakers who earn crypto as income.
Anyone who received airdrops or used crypto to make purchases.
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
Do I need to report every crypto transaction?
Yes, every taxable event — sales, swaps between coins, spending crypto on purchases, and receiving crypto as income. The IRS gets copies of your exchange data. Transfers between your own wallets are not taxable, but track them so your cost basis stays clean.
What cost basis method should I use for crypto?
FIFO (first-in, first-out) is the default and most common. Some people use specific identification to pick which lots to sell for a lower tax bill. Whatever you pick, stay consistent. Clarity calculates FIFO cost basis automatically.
Are crypto-to-crypto swaps taxable?
Yes. Swapping one crypto for another (like ETH to USDC) counts as a taxable sale. You need to figure out your gain or loss based on the fair market value at the time of the swap minus your cost basis in what you gave up.
Related templates
Other templates you might find useful.
Capital 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.
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.
CryptoCrypto 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.
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.