The Crypto Tax Problem Nobody Talks About
Every April, millions of crypto investors face the same nightmare: reconstructing a year of transactions across multiple exchanges, wallets, and chains — just to figure out what they owe in taxes.
I know this because I lived it.
The popular crypto tax services — Koinly, CoinTracker and the rest — were not an option for me. Some of them do not support every exchange and chain I use; all of them charge $49–$199 a year, which felt like a tax on top of a tax. So I built my own system: an offline Excel workbook that calculates capital gains using all three accounting methods (FIFO, LIFO, HIFO) on the same dataset, with no account, no API keys and no subscription.
In this guide, I’ll show you exactly how to do it yourself.
Why Crypto Taxes Are Different
Crypto is not taxed like a savings account. In most jurisdictions it is treated as property, and that single fact creates five problems that stock investors never deal with.
- Every transaction is a taxable event. Selling for fiat is obvious, but swapping ETH for USDC, paying gas in a native token, or buying an NFT with ETH are all disposals that trigger a gain or a loss.
- Multiple accounting methods. FIFO, LIFO and HIFO can produce completely different tax bills from an identical set of trades — and the method you pick has to be applied consistently and documented.
- Cross-chain complexity. The same portfolio may live on Ethereum, Arbitrum, BNB Chain, Solana and two centralized exchanges, each with its own export format, timestamp convention and fee currency.
- Staking, airdrops and DeFi follow different rules. Most of these are ordinary income at the moment you gain control, valued at fair market value — and that value becomes the cost basis for the later disposal.
- Record-keeping is on you. Exchanges delete history, close accounts and change export formats. If you cannot show acquisition date, cost basis and disposal proceeds, the conservative default is a zero cost basis — which means you pay tax on the entire proceeds.
The Three Accounting Methods Explained
All three methods answer one question: when you sell part of a holding you bought at several different prices, which units did you sell? Assume you bought 1 BTC at $20,000 in January, 1 BTC at $45,000 in July, and 1 BTC at $60,000 in November, then sold 1 BTC for $70,000.
FIFO (First-In, First-Out)
Definition. The oldest units are sold first. In the example above you dispose of the January coin: a $50,000 gain, held more than a year, so it is long-term.
When to use it. FIFO is the default in most tax codes and the safest choice if you never explicitly elected a method. It also tends to convert gains into long-term gains, which are usually taxed at a lower rate.
Pros: universally accepted, simple to defend, favours long-term rates. Cons: in a rising market it realises the largest gains first, so your bill in a bull year is the highest of the three.
LIFO (Last-In, First-Out)
Definition. The newest units are sold first. Here you dispose of the November coin: a $10,000 gain, held a few weeks, so it is short-term.
When to use it. When recent purchases are close to the current price and you want to defer gains on cheap, older coins. It is not permitted everywhere — confirm it is allowed in your jurisdiction before you rely on it.
Pros: smaller gains in a rising market, defers the tax on your earliest buys. Cons: gains are usually short-term and therefore taxed at the higher ordinary rate, and the method is not universally accepted.
HIFO (Highest-In, First-Out)
Definition. The most expensive units are sold first, regardless of when they were bought. Here you dispose of the November coin as well ($60,000 basis) because it is the highest-cost lot.
When to use it. For active tax optimisation: HIFO minimises the realised gain of each individual sale. In most jurisdictions it is treated as a form of specific identification, so it is only valid if your records identify the exact lot at the moment of sale.
Pros: the lowest taxable gain in the current year. Cons: it demands the strictest record-keeping, gains are typically short-term, and it leaves you holding low-basis coins that will produce large gains later.
The Same Trades, Three Different Tax Bills
This is what the choice is worth on a realistic mid-size portfolio — identical transactions, three methods:
| Method | Short-Term Gain | Long-Term Gain | Tax Owed |
|---|---|---|---|
| FIFO | $2,400 | $800 | $1,120 |
| LIFO | $1,800 | $1,400 | $980 |
| HIFO | $1,200 | $2,000 | $840 |
Two takeaways. First, the method is worth real money, so it deserves a deliberate decision rather than a default. Second, you cannot know which method is best until you can run all three over the same data — which is exactly why the workbook below calculates all three side by side.
Five Mistakes That Cost People the Most
- Not tracking cost basis properly. A missing purchase price does not mean “no gain” — it usually means a zero basis and tax on the full proceeds. Record the acquisition date, price and fee at the moment you buy, not in April.
- Forgetting airdrop and staking income. These are ordinary income when you gain control, and they are reported by the protocols and exchanges you used. Skipping them is the single most common mismatch on a tax notice.
- Mixing personal and business transactions. Freelance income received in crypto, NFT sales and trading profits sit on different lines of a return. Separate the wallets, or at least tag every transaction with its purpose.
- Not documenting wallet-to-wallet transfers. Moving your own coins between your own wallets is not a taxable event — but if it is not documented, software and auditors read it as a sale on one side and a purchase on the other, inventing a gain that never existed.
- Using average cost when it is not allowed. Average-cost basis is permitted in some countries (the UK’s pooling rules, for example) and disallowed in others. Using it by habit because a spreadsheet made it easy is a genuine audit risk.
A Five-Step Tax Tracking System
Step 1 — Gather all transaction data
Pull the full-year CSV export from every centralized exchange, the transaction history of every wallet address (block explorers export CSVs per address), and every DeFi protocol you interacted with. Do this in one sitting and archive the raw files unchanged — they are your evidence.
Step 2 — Classify each transaction
Assign one of six types to every line: Buy, Sell, Trade, Transfer, Income, Expense. Transfers between your own wallets are excluded from gain calculations but must stay in the log. Income (staking, airdrops, mining, paid work) carries a fair-market value at receipt.
Step 3 — Calculate cost basis
For each acquisition record the date, the unit price in your reporting currency, and the fees paid. Fees paid on acquisition are added to your basis; fees paid on disposal reduce your proceeds. Both directions reduce your tax — and both are routinely forgotten.
Step 4 — Calculate gains and losses
Match each disposal to acquisition lots using your chosen method, split the result into short-term and long-term by holding period, and net losses against gains. Run all three methods once before you commit — the comparison takes minutes and often changes the answer.
Step 5 — Generate the tax report
Produce a summary by transaction type (capital gains, income, expenses) plus a line-level detail schedule — in the US this is the Form 8949 layout: description, date acquired, date sold, proceeds, cost basis, gain or loss. Keep the raw exports, the workbook and the summary together; that package is what makes an audit a twenty-minute conversation instead of a month of archaeology.
Try Our Crypto Tax Tracker
If you would rather not build all of this from scratch, the workbook described above is available for the price of a coffee. It includes:
- Transaction log with dropdowns and validation
- FIFO / LIFO / HIFO calculations on the same dataset
- Income tracker for staking, airdrops, mining and client payments
- Portfolio dashboard and a print-ready tax summary sheet
- 25-page companion guide plus a year-end checklist and glossary
This is the same system I use for my own crypto taxes. Everything runs offline in Excel: no wallet connection, no API keys, no subscription — and five chains (Bitcoin, Ethereum, Solana, BNB Chain and Polygon) are supported out of the box. See the full Crypto Tax Tracker for the complete feature list.
Frequently Asked Questions
Do I need to pay taxes on crypto I haven’t sold?
Simply holding an asset that went up is not a taxable event in most jurisdictions — there is no gain until you dispose of it. But “not sold” is narrower than people think: swapping one token for another, spending crypto, and paying gas in a native token are all disposals. Income is different again — staking rewards and airdrops are taxable when you gain control, even if you never sell them.
How do I track transactions across multiple chains?
Normalise before you calculate. Export each chain and exchange separately, convert every file to the same column layout (date, type, asset, quantity, price, fee, wallet), stamp each row with its source, then merge into a single chronological log. Cost basis follows the asset, not the chain, so bridged tokens keep their original basis — the bridge is a transfer, not a sale.
Can I use different methods for different assets?
Sometimes, but not casually. Several tax authorities allow the method to be chosen per asset or per account as long as it is applied consistently within that unit and documented. Switching methods mid-year on the same asset to lower a bill is the fastest way to lose the argument. Decide once, write down the decision, and keep the calculations that support it.
What happens if I lose my transaction records?
Rebuild what you can: block explorers hold on-chain history permanently, most exchanges keep several years of statements, and bank or card records date your fiat purchases. Document your reconstruction method and your assumptions. An honest, documented estimate is defensible; a missing basis usually is not, because the default is to treat it as zero.
Where to Go Next
Taxes are only one part of an on-chain year. If you also farm airdrops, the Airdrop Tracker records claim dates and token values as they happen — which is precisely the income data your tax report needs later. And if you want the whole workflow in one place, the Web3 Creator Power Kit bundles tax tracking, airdrop farming and NFT launch planning with an integration guide that connects them.
