Organize your cryptocurrency transactions for tax reporting. Tracks buys, sells, swaps, and income events. Calculates short-term and long-term capital gains using FIFO, and identifies potential wash sales.
This worksheet includes 4 sections covering everything you need.
All sell, swap, and spend events that trigger capital gains or losses.
| Date | Asset | Disposed Amount | Proceeds (USD) | Cost Basis | Gain/Loss | Holding Period | Short/Long Term |
|---|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- | --- |
Mining, staking, airdrops, and other income — taxed as ordinary income at fair market value.
| Date | Asset | Amount | Fair Market Value (USD) | Source | Reported On |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
FIFO lot tracking for each asset showing remaining basis.
| Asset | Acquisition Date | Amount | Cost per Unit | Total Cost | Remaining |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
Totals for Form 8949 and Schedule D.
| Short-Term Gains | Short-Term Losses | Long-Term Gains | Long-Term Losses | Net Gain/Loss | Ordinary Income |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
Follow these steps to get the most out of this template.
Export transaction history from every exchange and wallet you used during the tax year.
Categorize each transaction: buy, sell, swap, send, receive, mining income, staking reward, or airdrop.
For sells and swaps, calculate cost basis using FIFO (first-in, first-out) from your purchase lots.
Mark each disposition as short-term (held less than 1 year) or long-term (held 1 year or more).
Sum up all income events (mining, staking, airdrops) — these are taxed as ordinary income.
Transfer totals to IRS Form 8949 and Schedule D, or provide the worksheet to your tax preparer.
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.
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.
Yes. The IRS requires reporting of every taxable event including sales, swaps between cryptocurrencies, spending crypto on purchases, and receiving crypto as income. Transfers between your own wallets are not taxable but should be tracked for cost basis continuity.
FIFO (first-in, first-out) is the default and most commonly used method. Some taxpayers use specific identification to minimize taxes by selecting which lots to sell. Whichever method you choose, apply it consistently. Clarity automatically calculates FIFO cost basis.
Yes. Swapping one cryptocurrency for another (e.g., ETH to USDC) is a taxable disposition. You must calculate the gain or loss based on the fair market value at the time of the swap minus your cost basis in the disposed asset.
Other templates you might find useful.
Capital Gains Tracker
Track realized capital gains and losses across all asset types for tax planning. Separates short-term and long-term gains, tracks loss carryforwards, and helps estimate your tax liability before year-end.
CryptoCrypto Portfolio Tracker
Track your entire crypto portfolio across exchanges and wallets. Includes position tracking, cost basis per coin, portfolio allocation, and DeFi position monitoring.
CryptoCrypto Cost Basis Spreadsheet
Track the cost basis of every cryptocurrency purchase for accurate tax reporting. Uses FIFO lot tracking with support for buys, sells, swaps, mining income, and airdrops across multiple wallets and exchanges.
Clarity connects to your financial accounts and automates what this template does manually. Real-time data, zero data entry, and AI-powered insights.