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:
- 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.
- 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.
- 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.