Tracking a crypto portfolio

02 September 2026

Keeping accurate records across wallets and exchanges is the single most important skill in cryptocurrency that has nothing to do with price. Every transfer, trade, stake, airdrop, and swap creates a data point that must be recorded correctly - or you will pay for the mistake later, either in lost assets or in a tax bill you cannot justify. This page maps the full territory: the tools people use, the errors that break those tools, the decisions that determine whether your records hold up under scrutiny, and the misconceptions that lead to bad recordkeeping in the first place.

Why portfolio tracking is harder than it looks

A crypto portfolio is not a single account. It is a collection of wallet addresses on multiple blockchains, exchange accounts that may or may not still exist, DeFi positions that change composition every time someone else trades, and staking rewards that arrive at irregular intervals. Each of these sources produces transaction data in a different format, at a different level of detail, and with a different definition of what counts as a completed transaction. The result is that no single tool can pull everything in perfectly.

The two foundational concepts that underpin every tracking decision are cost basis assignment methods and the distinction between realized versus unrealized gains. Cost basis methods - FIFO, LIFO, HIFO, and specific ID - determine which tax lots you are deemed to have sold when you dispose of an asset. The method you choose changes your tax bill, sometimes dramatically. For a full explanation of each method and how to pick one, see the spoke page How to Choose a Cost Basis Method for Crypto Taxes. The other fundamental is understanding exactly when a gain becomes taxable. Many people assume a gain is realized only when crypto hits their bank account. In reality, trading one token for another, spending crypto on goods, and even some wallet-to-wallet transfers can trigger a taxable event. Realized vs Unrealized Gains in Crypto and When You Owe Tax covers the precise moment each action becomes reportable.

Tools: what exists and what each one actually does

The portfolio tracking tool landscape breaks into three categories: dedicated crypto tax and portfolio software, block explorer transaction exports, and manual spreadsheets.

Dedicated trackers include CoinTracker, Koinly, CoinLedger (formerly CryptoTrader.Tax), TokenTax, Rotki, Delta Investment Tracker, CryptoTaxCalculator, TaxBit, Blockpit, and Accointing. Each ingests transaction data through API connections or CSV file uploads and attempts to compute gains, losses, and tax reports. They vary significantly in which blockchains they support, how they handle DeFi and NFT transactions, and whether they can reconstruct cost basis when records are missing. The most common comparison people make is between CoinTracker and Koinly, which are the two most widely used services. CoinTracker vs Koinly Which Crypto Tax Software Is Better examines which one handles complex transactions more accurately and where each falls short.

Block explorers such as Etherscan, Arbiscan, Polygonscan, Solscan, and BscScan provide raw transaction history exports for individual wallet addresses. They are useful as a fallback when API syncs fail, but they have a critical limitation: they show only on-chain activity. Transactions that happen inside an exchange's database - trades between users, limit order fills, staking programs that credit rewards internally - never appear on a block explorer. Relying solely on block explorer exports misses the majority of exchange activity.

Portfolio dashboards like DeBank, Zapper, and Zerion offer a consolidated view of DeFi positions across multiple chains. They are good for seeing what you hold right now but generally do not produce tax-ready transaction logs. They also depend on the same API infrastructure that dedicated trackers use, so they suffer from the same sync gaps.

Hardware wallet companion apps - Ledger Live and Trezor Suite - track transactions made through the device itself. They are reliable for on-chain activity conducted via their own interfaces, but they do not capture trades made on exchanges or transactions sent through browser wallets like MetaMask or Phantom.

Manual spreadsheets remain a viable option, especially for small portfolios or for users who need custom tracking logic that no existing tool provides. Google Sheets with custom API scripts can pull balances and transactions, but the setup is time-consuming and the maintenance is ongoing. Crypto Portfolio Tracker vs Spreadsheet Which Is Better breaks down the transaction volume and portfolio complexity thresholds that make paid software worth the cost over a manual approach.

The choice between a universal tracker that pulls from all sources and each exchange's built-in portfolio tool is a recurring decision point. Exchange-native tools are free, require no API key sharing, and are perfectly accurate for activity on that exchange. But they show only that exchange. Universal Crypto Tracker vs Exchange Built-In Portfolio Tools examines the portfolio complexity level at which juggling multiple exchange dashboards becomes unworkable.

The data pipeline: how transactions actually get into your records

Every tracking system relies on one of two data ingestion methods: real-time API sync or periodic CSV export. API Auto Sync vs Manual CSV Export for Crypto Portfolio Tracking weighs the convenience of automatic updates against the security risk of granting read access to your exchange accounts. API keys for portfolio trackers are typically read-only, but a compromised key still reveals your entire holdings and transaction history. CSV exports avoid that risk but introduce data lag and require manual reformatting.

When data does arrive, the most common breakdowns are predictable. API Sync Gap Missing Transactions in Crypto Portfolio Tracker explains why transactions can go missing even when the connection status shows green. The causes include rate limits on the exchange's API, transactions that were dropped and replaced on-chain, and internal transfers that the exchange does not expose through its API endpoints.

CSV imports have their own failure mode. How to Fix CSV Import Column Mismatch in Crypto Tax Software addresses the error that occurs when the column headers in your exchange's export file do not match what the tax software expects. The fix usually involves renaming columns, reordering fields, or converting date formats, but the exact steps vary by exchange and software combination.

Duplicate Transaction Import Inflating Crypto Portfolio Balance is a particularly insidious problem. It happens when the same transaction enters the tracker through two channels - for example, an API import pulls it in, and then a CSV import adds it again. The result is a portfolio that shows double the actual balance and double the cost basis. Removing duplicates safely requires identifying them correctly without deleting real transactions that happen to look similar.

The hard problems: missing records, lost exchanges, and reconstructing history

The most difficult tracking problems arise when the original source of data no longer exists. Cost Basis Showing Zero for Old Crypto Wallets How to Fix addresses the situation where a wallet you used years ago shows a cost basis of zero because the exchange you bought from has deleted its records or gone offline. Reconstructing cost basis in this scenario requires gathering whatever evidence still exists - old emails, bank statements showing the fiat deposit, screenshots of the original trade - and constructing a defensible estimate.

Exchange Bankruptcy Lost Crypto Transaction History Recovery is worse. When an exchange shuts down or enters bankruptcy, users often lose access to their transaction history entirely. The spoke page covers how to pull whatever data remains from cached pages, archived emails, and blockchain records of withdrawals, and how to document the loss for tax purposes.

For assets that never had a clear cost basis to begin with, the challenges multiply. When Are Crypto Staking Rewards Taxable at Receipt or Sale answers the question of whether staking rewards become taxable income the moment they are credited or only when sold. In most jurisdictions, staking rewards are income at receipt, which means they add to your cost basis at that moment's fair market value. Failing to record them means selling the staked asset later with an artificially low cost basis and overpaying tax.

How to Determine Fair Market Value of Crypto Airdrops for Tax addresses the problem of valuing a token on the claim date when there is no established market. The IRS and most tax authorities require the fair market value at the time you gain dominion and control over the asset. If the token has no exchange listing, the valuation is inherently uncertain, but you still need a defensible number. The spoke page covers sources of price data, the risk of using post-listing prices, and how to document your valuation methodology.

Tracking DeFi LP Positions as Single Token or Component Assets explores the accounting question that arises whenever you deposit into a liquidity pool. Do you record the deposit as a single LP token, or do you treat it as two separate disposals of the underlying assets? The answer affects both your realized gains at deposit and your cost basis when you withdraw. Most tax software handles this poorly, so understanding the logic yourself is essential.

Errors that look like your fault but usually aren't

Some tracking errors originate in the infrastructure, not in user behavior. "Transaction not found" on block explorer happens when the explorer's node has not indexed the transaction yet, or when the transaction was sent on a chain the explorer does not monitor. "Invalid address" format error on withdrawal occurs when the destination address uses a different encoding standard than the wallet expects - for example, a legacy address format sent to a SegWit-only wallet.

"Insufficient gas" or "out of gas" failed transaction is a network error, not a recordkeeping error, but it creates a phantom transaction in your history that must be reconciled. The transaction appears in your wallet as pending or failed, and some trackers import it as though it succeeded. "Nonce too low" replacement transaction error and "Dropped and replaced" transaction status are Ethereum-specific issues where a transaction is replaced with a higher gas fee before the original is confirmed. The original transaction never completes, but it may still appear in some data sources.

"Pending" transaction stuck for hours or days on a congested network can cause balance discrepancies that look like tracking errors. The transaction has not failed, but it has not confirmed either, and trackers vary in how they handle this state. Some show the outgoing balance immediately; others wait for confirmation. Either way, the discrepancy resolves when the transaction confirms, but in the meantime it looks like an error.

Wrong network selected during deposit (ERC-20 sent to BEP-20) is a common and costly mistake. Tokens sent to an address on the wrong network are not accessible through the receiving wallet's normal interface. Sent Crypto on Wrong Network ERC-20 to BEP-20 Recovery explains the recovery options, which depend on whether the receiving address has a matching key on both networks and whether the recipient is willing to cooperate.

Strategic decisions: cost basis, utxos, and recordkeeping philosophy

Beyond the mechanics of importing data, several strategic decisions determine whether your tracking system will work for years or collapse under its own complexity.

Choosing a universal tracker versus exchange-native tracking is not a one-time decision. As your portfolio grows across more platforms, the cost of maintaining multiple dashboards increases. The spoke page on this topic identifies the specific signs that you have outgrown exchange-native tools - repeated manual reconciliation, missing cross-exchange transfers, and an inability to see total portfolio value in one place.

Should staking rewards be included in crypto cost basis tracking is a question with a clear answer: yes, because excluding them creates an artificially low cost basis that increases your taxable gain at sale. The spoke page walks through the math of what happens when you sell a staked asset without having recorded the rewards as income.

Free vs Paid Crypto Portfolio Tracker Which One Do You Need provides the specific transaction count thresholds where free tiers stop being sufficient. CoinTracker's free tier, for example, supports only a limited number of transactions and wallets. CoinTracker Plans and Pricing Per Wallet Transaction Limits details exactly what each paid tier includes and what the free version omits.

FIFO versus HIFO cost basis method is the most consequential tax decision most crypto holders make. FIFO - first in, first out - sells your oldest lots first, which tend to have the lowest cost basis and therefore the highest gains. HIFO - highest in, first out - sells your highest-cost lots first, minimizing gains in the current year. The choice depends on your tax situation, your holding period, and whether you expect rates to change.

Risks that persist even with perfect records

Good recordkeeping reduces risk but does not eliminate it. Entering wrong wallet address and losing funds irreversibly is a human error that no tracking system can reverse. Exchange API key compromise exposing portfolio data is a security risk that increases with every API connection. Clipboard malware replacing copied wallet address bypasses all software safeguards because the attacker's address looks correct in the paste preview.

Exchange bankruptcy making transaction history inaccessible is a risk that materializes periodically. The collapse of an exchange does not destroy the on-chain record, but it can destroy the internal trade history that determines your cost basis. The spoke page on this topic covers proactive measures - exporting history regularly, keeping withdrawal records, and maintaining independent records of deposits and trades.

Tax underreporting penalty from incomplete DeFi records is the most common serious consequence of poor tracking. DeFi interactions - liquidity pool deposits, yield farming positions, borrowing and lending - generate transactions that are difficult to decode and easy to miss. The IRS and other tax authorities have become more aggressive about crypto reporting, and incomplete records are not a valid defense.

Public wallet address linking entire financial history is a privacy risk that many people discover only after a reporter or investigator traces their on-chain activity. Portfolio trackers that store your addresses on their servers create an additional attack surface. Rotki, an open-source desktop tracker, addresses this by keeping all data local. CoinTracker vs Koinly does not cover privacy specifically, but the tradeoff between cloud-based convenience and local control is a factor in every tool decision.

Where to go next

This page has mapped the full scope of crypto portfolio tracking. The individual spoke pages under it contain the detailed procedures, tool comparisons, and error-resolution steps that turn this overview into actionable knowledge:

• How to Choose a Cost Basis Method for Crypto Taxes
• Realized vs Unrealized Gains in Crypto and When You Owe Tax
• **Crypto Portfolio Tracker