How to Track Your Crypto Portfolio

Most crypto investors lose track within their first year. Coins live on multiple exchanges, in cold wallets, in DeFi positions, in staking validators, in LP tokens — and prices, balances, and cost basis all move constantly. Without a tracking system, you can't answer basic questions: "Am I up or down?" "What's my cost basis on this ETH?" "How much do I owe in taxes?"

This guide shows you how to build a tracking workflow that scales from a handful of holdings to a portfolio spread across ten venues. We'll cover three approaches (spreadsheet, dedicated app, hybrid), the data points worth tracking, how to handle the messy parts (DeFi, NFTs, lost wallets), and how to keep records that double as your tax substantiation.

Quick Answer / TL;DR

A complete portfolio tracker should record, per holding:

1. Asset: ticker and chain (e.g., USDC on Ethereum vs USDC on Polygon)
2. Quantity: current balance
3. Cost basis per unit and total: what you paid in USD
4. Current price and current value: pulled from a price feed
5. Unrealized P&L: current value − cost basis
6. Location: which wallet or exchange
7. Acquisition date(s): for tax holding-period purposes
8. Income separate from price: staking, mining, airdrops

Three viable approaches:

• Spreadsheet: maximum control, good for ≤30 holdings, hands-on
• Dedicated app (CoinTracker, Koinly, Zerion, DeBank): scales better, syncs automatically, costs money
• Hybrid: app for tracking, spreadsheet for review and tax planning

Pick one and commit. The worst portfolio tracker is the one you don't update.

🧮 Try it: Crypto Profit & Loss Calculator

Step 1: Inventory Every Wallet and Account

Before you can track, you need to know what to track. Make a list of:

• Every centralized exchange where you have a balance (Coinbase, Kraken, Binance.US, smaller exchanges, etc.)
• Every self-custody wallet (MetaMask, hardware wallets, mobile wallets)
• Every DeFi protocol where you have a deposit (Aave, Compound, Uniswap LPs, staking platforms)
• Every staking validator (Ethereum staking, Solana stake accounts, etc.)
• Every NFT marketplace where assets sit

For self-custody wallets, list the public addresses (not private keys). For exchanges, list the account email or username. This document — kept securely — is your ground-truth list.

Many people discover dust positions they forgot about. A 500 SHIB balance from a 2021 airdrop is real and (in the US) tracks as an income event you may not have reported.

Step 2: Pick Your Tracking Method

Option A: Spreadsheet

A Google Sheet or Excel workbook is the simplest tracker. Pros: free, transparent, fully customizable, works offline, no API risks. Cons: manual updates, no real-time prices unless you wire in an API, harder to handle DeFi and high-volume trading.

Minimum columns:

| Asset | Chain | Wallet | Quantity | Avg Cost USD | Cost Basis Total | Current Price | Current Value | Unrealized P&L | Acquired |

For automatic prices, use Google Sheets' =GOOGLEFINANCE("BTCUSD") for major coins, or import from CoinGecko via ImportJSON for altcoins.

Option B: Dedicated App

Apps like CoinTracker, Koinly, Zerion, DeBank, CoinStats, and Rotki ingest data via exchange APIs and read-only wallet addresses. They auto-categorize transactions, compute cost basis with various methods, and generate tax reports.

Free tiers handle small portfolios. Paid tiers (typically $50–$300/year) handle higher transaction volumes and tax reports.

Pros: minimal maintenance, handles DeFi well, generates tax forms. Cons: subscription cost, some platforms have spotty support for newer chains/protocols, you're trusting their cost basis logic.

Option C: Hybrid

Use an app for day-to-day tracking and tax prep, plus a personal spreadsheet for high-level review and decision-making. Most serious investors land here.

Step 3: Decide What Counts as "Cost Basis"

In US tax terms, cost basis is what you paid (in USD) plus acquisition fees. But for tracking purposes, you can apply different lenses:

• Per-lot tracking: every separate purchase is its own lot with its own basis (most accurate, matches IRS-allowed specific identification)
• Average cost: total spent / total quantity (simplest, but only allowed for some asset classes — and the IRS expects FIFO or specific ID for crypto)
• FIFO: first-in-first-out, the IRS default for crypto if you don't specify

For tax reporting, lots and specific ID give you the most control over realized gains. For mental tracking, average cost is easier to think about. Many investors keep both views.

Income tokens (staking rewards, airdrops) have a cost basis equal to their FMV at receipt. That FMV is also the amount you reported as income. When you eventually sell, the gain/loss is proceeds − FMV at receipt.

See Crypto Tax Reporting in the US for more.

Step 4: Pull Live Prices

Manual price entry is fine for an annual snapshot. For ongoing tracking, automate.

Free price feeds

• CoinGecko API (generous free tier)
• CoinMarketCap API (limited free tier)
• Binance public API (major pairs)
• Exchange-native (Coinbase, Kraken) for assets they list

In Google Sheets

=GOOGLEFINANCE("BTC-USD")  // major coins only

Or for any coin via CoinGecko + ImportJSON script:

=ImportJSON("https://api.coingecko.com/api/v3/simple/price?ids=ethereum&vs_currencies=usd","/ethereum/usd")

Cache results to avoid rate limits. Refresh hourly, not every cell update.

In apps

Most apps update prices every few minutes automatically. Watch out for thinly-traded altcoins with bad pricing data — verify against a major source.

Step 5: Handle Multi-Chain Holdings

The same ticker on different chains is different inventory:

• USDC on Ethereum ≠ USDC on Polygon ≠ USDC on Solana
• WETH ≠ ETH (technically the same value, but different contracts)
• BTC ≠ wBTC ≠ renBTC

Track chain explicitly. Bridging from one chain to another is a movement of your own assets and shouldn't be a taxable event — but tax software sometimes misclassifies bridges. Review and correct.

Step 6: DeFi Positions

DeFi is where most trackers fall apart. The complications:

• LP tokens: you hold one token that represents shares of two underlying assets, plus accrued fees, plus impermanent loss
• Staked positions: staked ETH, locked tokens, vesting schedules
• Lending: deposited into Aave/Compound earning interest, often represented by aTokens/cTokens
• Vaults: Yearn-style vaults that compound automatically
• Derivatives: perp positions, options

For LP tokens, track the underlying pool's two assets and accrued fees separately from the LP token balance. For lending, track the principal and interest accrued. Most dedicated apps (DeBank, Zerion, Zapper) do this for you — that's their main value-add.

If you're rolling your own spreadsheet, link to the protocol's frontend or use Etherscan to manually pull underlying balances.

For background, see DeFi Yield Farming Explained.

Step 7: Track NFTs Separately

NFTs don't fit neatly into a fungible-asset tracker. Most investors:

1. Track each NFT individually with cost basis, current floor price, and any income (royalty payments, rentals)
2. Mark a status (held, listed, sold)
3. Calculate notional value using floor — but treat as illiquid

NFT tax treatment in the US is unsettled in places. Some NFTs may qualify as collectibles (28% max long-term gain rate). For more, see NFT Investment Guide for 2026.

Step 8: Record Every Income Event

Income (staking rewards, mining, airdrops, lending interest, referral rewards) needs separate tracking because:

• It's taxable as ordinary income at FMV on receipt
• That FMV becomes the cost basis for the eventual sale
• Tax authorities expect a date-by-date log

Minimum income columns:

| Date | Asset | Source | Quantity | FMV USD per unit | FMV USD total |

Apps with exchange integrations capture most of this automatically. For DeFi income, you may need to query the protocol or use a tax tool that supports it.

Step 9: Set a Review Cadence

Tracking is worthless if you don't look at it. Recommended cadence:

• Weekly: glance at total value, check for unauthorized activity
• Monthly: reconcile balances against exchanges and wallets, note any discrepancies
• Quarterly: full review of allocation, P&L, rebalance if needed
• Annually: tax-ready records, lot-by-lot review, planning for the next year

Set calendar reminders. Most portfolio drift happens because nobody is looking.

🧮 Try it: Crypto Compound Interest Calculator

Step 10: Back Up and Secure Your Tracking Data

Your tracker contains sensitive information (wallet addresses, exchange links, holdings). Protect it:

• For spreadsheets: encrypted cloud storage with 2FA on the account, not just "shared with my email"
• For apps: enable 2FA, prefer apps that use read-only API keys (never trade-enabled or withdrawal-enabled)
• Export a CSV/PDF backup monthly
• Never share screenshots of full holdings publicly

If you use exchange API keys, restrict them to read-only and IP-whitelist if supported. A compromised "trade" or "withdrawal" API key can drain your account.

Common Mistakes and Tips

Mistake 1: Tracking value without tracking cost basis. "I have $40,000 in crypto" tells you nothing about whether you're up or down or what taxes you owe.

Mistake 2: Forgetting wallet-to-wallet transfers. Moving 1 ETH from Coinbase to your MetaMask isn't a sale — but if your tracker counts it as one, your P&L is wildly wrong.

Mistake 3: Updating only when prices are up. Confirmation bias. Track regardless of the market.

Mistake 4: Not tracking dust and small balances. $20 of an altcoin might not seem worth tracking, but airdrops you forgot about are taxable events and clutter you'll have to reconcile someday.

Mistake 5: Trusting one source for cost basis. Exchange-reported basis is sometimes wrong, especially for transferred-in assets. Keep your own records as the source of truth.

Tip: Use read-only public wallet addresses with apps — never share private keys or seed phrases with any service, ever.

Tip: Periodically reconcile your tracker totals against on-chain balances. Block explorers (Etherscan, Solscan) show real balances; if your tracker disagrees, find the missing transaction.

Tip: Snapshot prices at year-end (December 31). This is your starting point for next year's unrealized P&L.

FAQ

Q: Spreadsheet or app — which is better?

Depends on volume. Under 30 holdings and a few dozen trades per year, a spreadsheet works great and gives you full control. Above that, an app pays for itself in time saved and tax accuracy. Many people use both.

Q: Do I need to track every micro-transaction?

For tax purposes, yes — every disposal is a taxable event. For day-to-day portfolio management, you can roll up small transactions but make sure they end up in your annual tax export.

Q: How do I track NFTs that don't have a clear price?

Use floor price as a notional value but flag it as illiquid. Don't include NFT notional value in your "liquid net worth." For tax purposes, you only realize gain or loss on actual sale.

Q: What about lost or hacked crypto?

Document the loss with on-chain evidence (transaction hash, address). For US tax treatment, theft losses on investment crypto are heavily restricted post-2017. Consult a CPA. Either way, remove from your tracker once you accept it as unrecoverable.

Q: Can I track my portfolio anonymously?

Self-custody wallets + a self-hosted spreadsheet or tool like Rotki give you the most privacy. Centralized apps require exchange API keys and email signup, which links your identity to balances. Choose based on your threat model.

Conclusion

A good portfolio tracker is unglamorous infrastructure — it's not exciting, but it's the difference between knowing your real performance and guessing. Inventory every wallet and account, pick a method (spreadsheet, app, or hybrid), track cost basis lot-by-lot, automate prices, and review on a regular cadence. The first month of setup is the hard part; after that, it runs on a few minutes a week.

For one-off P&L checks across multiple assets, dedicated calculators speed things up.

🧮 Try it: Crypto Profit & Loss Calculator

Last updated: February 2027