Home Features Pricing FAQ Blog Help Privacy Policy Terms of Service
Beginner Education

Crypto P&L Calculator for iPhone — Stop Using Spreadsheets

Learn what crypto P&L means, how to calculate it, and why a dedicated iPhone app beats spreadsheets. Includes realized vs unrealized P&L and average cost basis explained.

← All posts
Beginner Education 6 min read
Share this article:

You bought Ethereum at $1,800, then again at $2,400, then sold some at $3,100. How much profit did you actually make? If you're doing this in a spreadsheet, you know how quickly the math gets messy. Here's a simpler way to calculate your crypto P&L on your iPhone — and why it matters.

If you're calculating crypto P&L in a spreadsheet, you know how quickly the math gets messy.


What is crypto P&L?

P&L stands for Profit and Loss. It tells you how much money you've made or lost on your crypto investments. Simple in concept, but tricky in practice — because most people buy the same coin multiple times at different prices.

📝 Note
P&L gets tricky when you buy the same coin at different prices over time. That's why cost basis calculation matters.

Realized vs unrealized P&L

There are two types of P&L, and they mean very different things:

Both numbers matter. Unrealized P&L shows your current position. Realized P&L shows your actual results — and it's what you'll owe taxes on.

Unrealized P&L = what your holdings are worth now vs what you paid. Realized P&L = actual profit or loss from coins you already sold. Both matter.

The pain of manual P&L calculation

Here's a common situation. You made 4 buys of the same coin over 6 months:

  1. Bought 0.5 ETH at $1,800 = $900
  2. Bought 0.3 ETH at $2,200 = $660
  3. Bought 0.2 ETH at $2,600 = $520
  4. Sold 0.4 ETH at $3,100 = $1,240

Now answer this: what was your profit on that sale? It depends on which coins you "sold" first. Did you sell from the $1,800 batch? The $2,200 batch? A mix? This is where cost basis comes in.

⚠️ Warning
The cost basis method you choose changes your taxable gain. Same trade, different tax bill — so this decision matters.

Cost basis explained (simply)

Cost basis is the average price you paid for a coin. There are different ways to calculate it:

Using the example above with average cost: you bought 1.0 ETH total for $2,080 ($900 + $660 + $520). Your average cost per ETH is $2,080. When you sold 0.4 ETH at $3,100 each, your profit was (3,100 - 2,080) x 0.4 = $408.

Doing this math once is fine. Doing it across 10 coins with dozens of transactions? That's where spreadsheets break down.

Doing cost basis math once is fine. Doing it across 10 coins with dozens of transactions? That's where spreadsheets break down.


How Coinlio calculates P&L for you

Coinlio handles all of this automatically. When you log a buy or sell transaction (or sync from an exchange), the app calculates:

On the free plan, you get basic P&L (profit/loss and allocation). Coinlio Pro adds win rate, average ROI, benchmark comparison against BTC and ETH, and full chart history.


How to read your P&L in Coinlio

Here's what you'll see on your portfolio dashboard:

💡 Tip
Green = profit, red = loss. The percentage shows your return from cost basis. Simple at a glance, detailed when you need it.

Why this matters for taxes

In most countries, you owe taxes on realized gains — the profit from coins you sold. If you don't track your cost basis, you won't know your actual taxable gain. Many people overpay taxes because they can't prove what they originally paid.

Coinlio Pro includes tax reports for the US, UK, Germany, Australia, and Vietnam — exported as CSV and PDF. That's a feature that standalone tax tools like Koinly charge $49 to $179 per year for.


Spreadsheet vs P&L app — the real difference

TaskSpreadsheetCoinlio
Track cost basisManual formulasAutomatic
Update current pricesCopy-paste from webReal-time via CoinGecko
Calculate realized P&LComplex formulasLogged per transaction
See unrealized P&LManual calculationLive on dashboard
Handle multiple buysOne row per buy + formulasAutomatic average cost
Generate tax reportNot possibleCSV + PDF export (Pro)
Time to maintain30+ min/weekZero

Ready to ditch the spreadsheet?

Your crypto P&L should be calculated for you, not by you. A dedicated app handles the math, updates in real time, and gives you a clear answer: am I making money or losing it?

Your crypto P&L should be calculated for you, not by you. Let a dedicated app handle cost basis, realized gains, and tax reports automatically.

Want to understand cost basis methods? Read our guide on FIFO vs average cost for crypto.

Try Coinlio free — automatic P&L, average cost basis, zero formulas. <a href="https://apps.apple.com/app/coinlio/id6761177479">Download on the App Store</a>.

Try Coinlio Free

3 portfolios, unlimited assets, zero data selling. Download now on the App Store.

Try Coinlio Free →
Link copied!