← Back to perly.io
Perly

How to track a crypto portfolio

Published 10 November 2026

To track a crypto portfolio, keep one ledger of every buy, sell, transfer and fee across all your exchanges and wallets, and work out your holdings, cost basis and profit from that ledger rather than from any one exchange's dashboard. An exchange only knows what happened on it. Your ledger knows everything, so it is the only place where the numbers add up.

Why an exchange dashboard is not enough

Most people who have held crypto for a while use more than one place: an exchange or two, a hardware wallet, perhaps a mobile wallet for small amounts. Each shows its own balance. None knows what you paid for coins you moved in from elsewhere, so a coin withdrawn from one exchange and deposited on another arrives with no cost attached. The second exchange shows its value, and your profit on it becomes a guess. A portfolio is the sum of all of those places, and only a ledger you keep yourself holds the whole of it.

What to record for every transaction

  • Date and time, ideally in UTC. Order matters: cost basis is worked out in the order trades happened.
  • Type: buy, sell, transfer between your own wallets, deposit, withdrawal, or income such as staking rewards.
  • Asset and quantity, to the full precision the exchange shows. A bitcoin has eight decimal places.
  • Price per unit and the currency you paid in, so a coin bought with bitcoin is recorded against bitcoin.
  • Fee, in the asset it was charged in. Fees belong in your cost basis on the way in and come off your proceeds on the way out.
  • Where: the exchange or wallet, so you can match the ledger against each balance later.

A transfer between two of your own wallets is not a sale. It moves coins and costs a network fee, and the coins keep the cost they had. (Some tax rules treat the fee itself, paid in the coin, as a small disposal; check yours.) Recording it as a sell and a buy is the most common way a tracked portfolio drifts from the truth.

Four ways to keep the ledger

A spreadsheet. Free, entirely yours, and as accurate as your typing. It needs a formula for average cost or FIFO, and it watches nothing while it is closed: no prices, no alerts. Fine for a handful of trades a year.

A tracker connected by API key. You give the tracker a read-only key and it fills itself in. It is the fastest start, and it leaves a key that reads every balance and trade sitting on somebody else's server for as long as the key exists. Our guide to private portfolio trackers goes through what that hands over.

A tracker fed from CSV exports. Every major exchange lets you download your history as a file — here is how on Binance, Coinbase and Kraken. You import it, check it, and nothing stays connected afterwards. It takes a few minutes per exchange, a few times a year.

Watching public addresses. For coins in your own wallet, a tracker can read a public Bitcoin address or extended public key (xpub) and list what arrived and left. It cannot spend anything, but it now knows those addresses are yours, and on a public chain an address shows its whole history to whoever has it.

The numbers worth watching

Once the ledger is complete, four figures tell you where you stand: holdings (what you own now, per asset), cost basis (what those holdings cost, fees included), unrealized profit (current value minus cost basis) and realized profit (what your sales actually made). The arithmetic is in how to calculate crypto profit. If you hold mostly bitcoin, it is worth also measuring the rest of the portfolio in bitcoin: a coin up 30% in dollars while bitcoin rose 60% has lost you bitcoin.

Keeping it private

A complete portfolio is a precise map of what you own, and that map is worth protecting. Three habits keep it yours: never give a tracker a seed phrase or private key, prefer CSV imports to API keys, and prefer a tracker that encrypts your amounts in your browser, so its own servers hold only ciphertext. The rest of the security side is in hot vs cold wallets and how to store a seed phrase.

A routine that keeps it accurate

  • Import or type in new trades monthly, or after any large one.
  • Once a quarter, compare each exchange's and wallet's balance with what the ledger says it should be. A difference is almost always a missed fee or transfer.
  • Keep the original CSV files. If a tax question comes up years later, they are your evidence.

Where Perly fits

Short answers

What is the best way to track a crypto portfolio?

One ledger that covers every exchange and wallet, filled from CSV exports or by hand, with cost basis worked out from the full history. Whether that ledger is a spreadsheet or an app matters less than whether it is complete.

Can I track crypto without connecting my exchange?

Yes. Download your trade history as a CSV from each exchange and import it into a tracker or a spreadsheet. Nothing stays connected, and no key sits on anyone's server.

Should a transfer between my own wallets count as a sale?

No. It moves coins you already own and costs a network fee. The coins keep their original cost basis.

How often should I update my portfolio tracker?

Monthly is enough for most people, plus a quarterly check of every balance against the ledger. Active traders import more often.

This guide explains how things work. It is not financial, investment or tax advice. Something wrong? Write to hi@perly.io and we will correct it.

← Back to perly.io

© 2026 Perly. All rights reserved.