Crypto Profit & Loss Tracker
Log crypto buys and current prices to see profit/loss per coin and total portfolio return in real dollars.
Published by Blueprint Dynamics. Planning tools, not professional advice. Read the formula, assumptions, and examples below before relying on a result. Independent professional review is not claimed. Learn more about our methodology →
AllTemplates • Blueprint Dynamics • hello@bpdynamics.io. Educational worksheet; entries and assumptions are not independently verified. This document is not tax, legal, medical, investment or engineering approval. Review current official rules and seek a qualified specialist where appropriate.
Specialist review required for real decisions
No live prices, legal due diligence or return guarantees. Model financing, vacancy, tax, insurance and transaction costs separately; have an adviser review a real investment decision.
Primary reading context, not an endorsement or evidence that the linked organization reviewed this tool. No independent professional sign-off is claimed.
About the Crypto Profit & Loss Tracker
Crypto positions are notoriously hard to keep straight because they are often spread across multiple exchanges and wallets, priced in fractions of a coin, and bought in a flurry of small transactions. This profit-and-loss tracker collapses all of that into a single table where each coin's real dollar performance is plain to see, measured against what you actually paid.
For every coin you enter the amount held, your average buy price, and the current price. The tool then computes how much you invested, what the position is worth now, your profit or loss in dollars, and your return percentage, before rolling everything into total invested, total value, total profit or loss, and overall return. Fractional amounts like 0.5 BTC are handled naturally.
Unlike a hype-driven ticker, this view keeps you anchored to cost basis. Seeing that a coin is up in percentage terms but represents a small slice of your invested capital, or that a large position is barely breaking even, is the kind of grounding that helps you size positions and take profits deliberately rather than emotionally.
How the Crypto Profit & Loss Tracker works
Each row's invested amount equals the coin amount multiplied by your buy price, and its current value equals the amount multiplied by the current price. Profit or loss is current value minus invested, and the return percentage is that profit divided by the invested amount. Losses render in red so drawdowns are impossible to miss.
The buy price should be your average cost across all purchases of that coin. Because crypto is frequently accumulated in many small buys, enter the weighted average: total dollars spent on the coin divided by the total units acquired. This keeps the return honest across a dollar-cost-averaged position.
Portfolio totals sum invested and value across every coin. Total profit or loss is total value minus total invested, and total return is that figure divided by total invested. This is a straightforward return on capital deployed; it does not annualize, does not track individual tax lots, and does not deduct trading or network fees unless you fold them into your buy price.
Worked example
The default portfolio holds three coins. BTC: 0.5 units bought at $45,000 (a $22,500 cost) now trading at $68,000 is worth $34,000, a profit of $11,500. ETH: 4 units from $2,500 to $3,500 means $10,000 invested is now $14,000, up $4,000. SOL: 25 units from $95 to $150 means $2,375 invested is now $3,750, up $1,375.
Adding the rows, total invested is $34,875 and total current value is $51,750, so total profit is $16,875 and the overall return is $16,875 / $34,875 = 48.4%. Bitcoin alone accounts for $11,500 of that gain, more than two-thirds of the total dollar profit.
This is where the dollar column earns its keep. SOL shows a strong percentage move, but because the position is small it contributes the least profit in dollars. When you decide how much to take off the table, the profit column tells you which position is actually moving your net worth.
Tips & common mistakes
- Enter your weighted average buy price, not the price of your most recent purchase. Crypto is usually accumulated over many transactions, and only the blended cost basis produces a meaningful profit figure.
- Fold exchange and network fees into your buy price when you can. Trading fees, gas, and withdrawal costs quietly raise your true cost basis, and ignoring them flatters your returns.
- Track coins held on different exchanges as separate rows if their cost bases differ, or combine them into one weighted-average row if you want a single position view. Just be consistent so totals are not double-counted.
- Do not read percentage return as tax owed. Profit shown here is unrealized until you sell or trade, and in many jurisdictions crypto-to-crypto swaps are themselves taxable events, so keep separate records of realized transactions.
- Update current prices from a source you trust and at a consistent moment. Prices can vary between exchanges and move fast, so a snapshot from one reference like a major exchange keeps your comparisons apples-to-apples.
Crypto Profit & Loss Tracker: frequently asked questions
How do I enter a coin I bought across many small purchases?
Use a weighted average buy price. Add up every dollar you spent on that coin and divide by the total units you received, then enter that blended figure as the buy price along with your total amount held. This gives an accurate cost basis for the whole position rather than distorting it with a single transaction's price.
Does the tracker account for trading and gas fees?
Not automatically. The math uses your buy price and current price directly. To reflect fees, increase your effective buy price to include what you paid in exchange commissions, network gas, and withdrawal charges. Doing so lowers your displayed profit but makes it match what actually landed in your wallet.
Is my displayed profit the amount I will be taxed on?
No. The profit shown is unrealized, meaning it exists only on paper until you sell, spend, or swap the coin. Tax treatment varies widely by country, and importantly, trading one crypto for another is often a taxable event even if you never touch cash. Keep a separate log of your realized transactions for tax purposes.
Why does a coin with a big percentage gain add so little total profit?
Because dollar profit depends on position size, not just the percentage move. A coin that doubles on a small holding adds far fewer dollars than a modest gain on a large holding. The tool's separate dollar and percentage columns exist precisely so you can tell the difference when deciding what to hold or sell.
Can I track stablecoins or staking rewards here?
You can list a stablecoin as a row, though its buy and current price will be near $1 so it will show little profit or loss. Staking or yield rewards are not tracked automatically; you can approximate them by adding the reward units to your amount held while keeping their cost basis at zero, which will show them as pure gain.