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.
This spreadsheet includes 4 sections covering everything you need.
Every acquisition event that establishes cost basis.
| Date | Asset | Amount | Price per Unit (USD) | Total Cost | Source | Exchange/Wallet |
|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- |
Sells, swaps, and spend events matched to purchase lots via FIFO.
| Date | Asset | Amount | Proceeds (USD) | Matched Lot Date | Cost Basis | Gain/Loss | Holding Period |
|---|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- | --- |
Open purchase lots that have not been fully disposed of.
| Asset | Original Date | Original Amount | Remaining Amount | Cost per Unit | Remaining Basis |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
Cost basis established through mining, staking, airdrops, or payments received.
| Date | Asset | Amount | FMV per Unit | Total Basis | Source Type |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
Follow these steps to get the most out of this template.
Record every purchase of cryptocurrency as a new lot with the date, amount, and price paid.
For income events (mining, staking, airdrops), record the fair market value at the time received as your cost basis.
When you sell or swap, match the disposal to your oldest lot first (FIFO method).
Calculate the gain or loss as proceeds minus the matched lot's cost basis.
Track remaining lots to know your current cost basis for future disposals.
At tax time, sum up all gains and losses and transfer to your crypto tax worksheet.
Crypto traders who need to calculate accurate cost basis for tax filing.
Investors who bought the same asset at different prices over time.
Anyone who has received crypto through mining, staking, or airdrops and needs to establish basis.
People who want to understand their true profit or loss on crypto investments.
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.
FIFO (first-in, first-out) means when you sell crypto, you are selling your oldest purchased units first. This matters because it determines your cost basis and holding period, which directly affects your tax liability. FIFO is the IRS default method if you do not specify otherwise.
A swap is treated as selling one crypto and buying another. Calculate the gain/loss on the disposed crypto based on your cost basis. Your new cost basis in the acquired crypto is its fair market value at the time of the swap.
Your cost basis for airdropped tokens is the fair market value at the time you receive them (which is also reported as ordinary income). If the airdrop was worthless when received, your cost basis is zero.
Other templates you might find useful.
Crypto Tax Worksheet
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.
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.
TaxCapital 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.
Clarity connects to your financial accounts and automates what this template does manually. Real-time data, zero data entry, and AI-powered insights.