The exchange shows a number. Your bank shows another.
Exchange P&L screens mix unrealised moves, funding and transfers. What you actually locked in is buried in thousands of fills.
Free tool · no account · no API key
Crypto P&L calculator for your exchange trade history
Drop the trade-history file from Bybit or Binance and see what you actually made: realised profit and loss per coin, every fee added up, win rate, best and worst trade, month by month.
- Runs in your browser — nothing uploaded
- No sign-up, no API key
Drop your Bybit or Binance trade export here
CSV files · drop several at once (spot and derivatives)
Your file never leaves this browser. It is read and calculated on your device — nothing is uploaded, stored or sent to us.
Sample data is synthetic: Bybit spot sample · Bybit closed P&L sample
Why your exchange P&L never adds up
Fees eat more than you think
Maker, taker, funding, fees charged in BNB or in the coin you bought. Add them up once and the “winning” month often isn't.
Three exchanges, three spreadsheets
Every venue exports a different file with different columns and date formats. Matching buys to sells across them by hand takes a weekend.
The tax deadline doesn't move
US returns are due in April, UK Self Assessment in January. Knowing your realised gain early is the difference between a plan and a panic.
Exchanges write the column names in the language your account is set to. Keep it on English when you export — the tool reads the English column names.
Bybit
How to export your Bybit trade history
Bybit gives you a separate file for spot fills and for closed derivatives positions. Drop both for the full picture — the tool reads them together.
Spot trade history
Every spot fill with price, quantity and fee. Use this for spot P&L.
01
Log in on bybit.com and open Orders → Unified Trading Order.02
Choose Spot, then the Trade History tab (not Order History).03
Click Export, pick the time range (up to 6 months per file, within the last 2 years) and confirm with Export Now.04
Download the CSV and drop it above. Repeat for earlier periods if you need them.
Derivatives Closed P&L
One row per closed position, after fees. Use this for futures and perpetuals.
01
Open Orders → Unified Trading Order and choose Futures (Derivatives).02
Open the Closed P&L tab.03
Click Export, select All contracts and the time range, then Export Now.04
Download the CSV and drop it above together with your spot file.
Transaction log (optional)
Every balance change including funding. Use it instead of the two files above if you prefer one export.
01
Open Assets → Unified Trading Account → History Records.02
Choose Transaction Log and click Export.03
Pick the date range (up to 6 months) and click Export Now.04
Download the CSV and drop it above.
- Bybit limits Orders-page exports to 6 months per file and 10,000 rows, with a daily cap on the number of exports.
- For up to 12 months in one file, use Account → Data Export. It arrives by email as a zip of CSV files — unzip it and drop the CSVs.
- Fees paid in MNT are listed separately and not converted to USD.
Binance
How to export your Binance trade history
Binance generates statements in the background and notifies you when they are ready. Switch your Binance language to English first — the column names are translated otherwise.
Spot trade history
Every spot fill with the coin, amount and fee. Use this for spot P&L.
01
Log in on binance.com and open Orders → Spot Order.02
Open the Trade History tab and click Export Trade History.03
Set the dates in the calendar (up to 1 year per file) and click Generate.04
When the notification arrives, click Download and drop the CSV above.
Futures trade history
Every USDⓈ-M futures fill with its realised profit and fee.
01
Open Orders → Futures Order and choose USDⓈ-M.02
Open the Trade History tab and click Export.03
Pick the date range and generate the file.04
Download it. If it arrives as Excel, open it and save it as CSV, then drop it above.
Transaction history statement
Every balance change across spot, futures and conversions in one file.
01
Open Assets → Asset History (Transaction History).02
Click the export icon, then Export Transaction Records.03
Choose the range (Customize for older dates), all accounts and all coins, and CSV as the format.04
Click Generate, wait for the email or SMS, then Download and drop the CSV above.
- Binance allows a limited number of statements per month and download links expire after 7 days.
- Fees paid in BNB are listed separately and not converted to USD.
- Times in Binance files follow the timezone set on your account; the tool reads the offset from the header.
Files it reads
The tool recognises each export by its header row. CSV only.
Bybit spot trade history
Spot Pairs, Order Type, Direction, feeCoin, ExecFeeV2, Filled Value, Filled Price, Filled Quantity, Fees, Transaction ID, Order No., Timestamp (UTC)
Bybit derivatives Closed P&L
Market, Order Quantity, Entry Price, Exit Price, Trade Type, Realized P&L, Trade time
Bybit Unified Trading Account transaction log
Currency, Contract, Type, Direction, Quantity, Position, Filled Price, Funding, Fee Paid, Cash Flow, Change, Wallet Balance, Action, Time
Binance spot trade history (amount and coin in one cell)
Date(UTC), Pair, Side, Price, Executed, Amount, Fee
Binance spot trade history (separate fee coin column)
Date(UTC), Pair, Base Asset, Quote Asset, Type, Price, Amount, Total, Fee, Fee Coin
Binance USDⓈ-M futures trade history
Date(UTC), Pair, Side, Price, Quantity, Amount, Fee, Realized Profit
Binance futures transaction history
Date(UTC), type, Amount, Asset, Symbol, Transaction ID
Binance transaction history statement
User_ID, UTC_Time, Account, Operation, Coin, Change, Remark
Questions
Is my trade history uploaded anywhere?
No. The file is read and calculated entirely in your browser with JavaScript. Nothing is uploaded, stored or sent to TheCryptoHub, and you can disconnect from the internet after the page loads and it still works.
Which exchanges and files does it support?
Bybit spot trade history, derivatives Closed P&L and the Unified Trading Account transaction log; Binance spot trade history, USDⓈ-M futures trade history, futures transaction history and the transaction history statement. Files must be CSV. More exchanges are coming.
How is the P&L calculated?
Buys and sells are matched first-in, first-out (FIFO) per asset, with fees added to the cost of buys and taken off the proceeds of sells. Derivatives use the realised P&L the exchange reports per closed position. USD and USD stablecoins are counted 1:1; other quote currencies are shown separately, never converted.
Why does it say I sold more than I bought?
An export only covers the dates you picked, and coins you deposited were bought somewhere else. Sales with no matching buy in the file are flagged and left out of the total instead of being counted as pure profit.
Can I use this for my tax return?
Use it to see where you stand, not to file. Tax rules differ by country — the UK uses share matching, the US needs every lot on Form 8949 — and one export misses transfers, staking and your other exchanges. A TheCryptoHub account builds the full report for your country.
What does an account add?
Your result is saved, more exchanges are linked automatically, and the official tax report is generated for your country. TheCryptoHub connects exchanges with read-only or trade keys — never withdrawal keys — so it can never move your funds.
Your P&L is not your tax bill
This result uses FIFO on one file. Your country decides how gains are matched, which holding periods count and what is taxed at all. Read the guides on our blog before you file.
Crypto tax guides