A crypto portfolio rarely lives in one place: part on exchanges, part in a non-custodial wallet, part in a DeFi protocol, something bought for cash that never showed up anywhere. Tracking cryptocurrency is a data-aggregation problem; the crypto category collects the tools, and there are three approaches: a cloud tracker with automatic connections, the wallet as source of truth, and local analytics on your own hardware.

The fragmentation problem: exchanges, wallets, DeFi, and off-chain trades

Four sources mean four formats and four blind spots:

  • Exchange accounts. History comes via API or CSV export, in each exchange’s own format and retention window.
  • Non-custodial wallets. Everything on-chain is visible from a public address.
  • DeFi positions. Pool liquidity or lending collateral isn’t a “balance” but a share in a smart contract.
  • Off-chain operations. P2P purchases, service payments, transfers between your own addresses — no API knows them; unlabeled self-transfers get double-counted in the portfolio and the tax base.

Portfolio trackers: exchange API keys and the risk of them leaking

The fastest way to assemble one report is a tracker with automatic connections: CoinStats aggregates 1,000+ exchanges, wallets, and DeFi protocols via API keys and public addresses; Delta goes broader still — crypto, stocks, and ETFs in one app, part of eToro since 2019.

Connection security comes down to a few rules:

  • Read-only only. No trading or withdrawal rights: a leaked key exposes your history but can’t move your assets.
  • Short lifespan. IP restrictions, rotation every few months; a key issued “forever” is a password you’ve forgotten.
  • Know where the key lives. In a cloud tracker, keys sit on the service’s servers — your history’s safety depends on someone else’s infrastructure.

A tracker is a business too: Accointing, after a couple of resales, shut down on January 31, 2024; users migrated to Blockpit, exporting history to XLS. A cloud history lives as long as the service — check export options early.

Non-custodial wallets as the source of truth

The wallet is the only place you physically hold the keys, so its data is the most trustworthy. Many wallets go beyond a plain balance: Zerion indexes assets, NFTs, DeFi positions, and transaction history by address — even addresses that aren’t yours; Ledger Wallet builds a portfolio across dozens of networks alongside the hardware wallet.

A wallet sees honestly everything on-chain for your addresses, rewards and swaps included. What it doesn’t know:

  • exchange balances and trades — those live off the blockchain;
  • the cost basis of purchases from another venue — trade-date prices must be pulled in separately;
  • links between your own addresses: a transfer from wallet A to B looks like a sale to an outsider.

So the wallet is the source of truth about what you own, not how much you’ve earned.

Self-hosted analytics for privacy-minded users

Whoever won’t hand API keys to a cloud should track locally. rotki is an open-source desktop app (AGPLv3): it connects exchanges, wallets, and blockchains, stores data encrypted on your device, and produces profit-and-loss reports fit for tax accounting. The base version is free; higher limits cost from €25 a month. History stays yours even if the project shuts down.

A separate niche is off-chain operations that appear in no API: a cash purchase, a payment to a freelancer, a transfer between your own accounts. They fit best where you keep the rest of your budget — an offline-first app with no external integrations such as onbalance: several currencies including cryptocurrencies, works offline. Not a tracker replacement — just where manual trades don’t get lost.

Staking, farming, and derivatives: income beyond spot

Spot is the easy part. Everything else surfaces at tax time:

  • Staking. Each payout is a transaction with a date and a value; two or three positions mean hundreds of lines a year. Ledger Wallet warns rewards through its built-in providers aren’t guaranteed — reconcile them by hand.
  • Liquidity pools and farming. Pool entry and exit, accumulated fees, impermanent loss: “exited the position” isn’t “sold,” and classification depends on the jurisdiction.
  • Derivatives. Funding, liquidations, expirations — flows that don’t exist in spot history.

Awaken automates this, classifying swaps, staking, liquidity pools, yield farming, and NFT sales, with FIFO/LIFO/HIFO and average cost — the user’s job is not to lose the data stream.

Preparing your trade history for tax calculations ahead of time

Crypto tax calculations don’t break on arithmetic; they break on holes in the history. Three steps before the year ends:

  1. Gather every source into one service early. Koinly imports from 800+ exchanges and wallets, generating reports for 100+ countries; CoinTracker covers 500+ integrations and reconciles form 1099-DA. Free tiers of both give tracking and a tax preview — pay last minute, but import the history months ahead.
  2. Export a CSV from every venue and keep a copy. An exchange can leave the market, cut API access, or paywall exports — and years of data go with it. A CSV copy under the 3-2-1 rule beats any loss.
  3. Label internal transfers. Matching self-transfers separates a real report from a doubled tax base: cloud services do it for you; in local tracking, rotki and your own hands.

On pricing: Koinly’s paid plans run $49–$179 per tax year; Blockpit sells a one-time license with country templates prepared with KPMG. Holes in the history first, the bill second — the worst order.