P2PTab

Coinbase to CoinLedger

Download your Coinbase history, drop it in below, and you get a file in CoinLedger's own import layout plus a list of anything that needs a manual fix.

Based on Coinbase's help pages and sample files; check the first rows after you import

Your file is read in this browser tab and never uploaded.

1. Export from Coinbase

On the website, open your profile menu, then Settings, Accounts and Statements, and generate a custom statement in CSV for all assets and transaction types. Use Statements, not the tax reports. The file starts with a few lines above the column headers; leave them in, the converter skips them.

2. What changes in the file

Coinbase transaction history CSV
Column in the exportWhat we take from it
IDKept as the transaction id when present.
TimestampTransaction time in UTC.
Transaction TypeBuy, Sell, Advanced Trade, Convert, Send, Receive, staking and rewards income.
AssetAsset ticker.
Quantity TransactedCrypto amount. Whether it came in or went out is taken from the transaction type, not the sign.
Price CurrencyCurrency of Subtotal and fees, usually USD.
SubtotalDollar value before fees: cost of a buy, gross proceeds of a sale, value of income.
Fees and/or SpreadFee, kept separately in the price currency.
NotesRead only for Convert rows, to find what was received.
Total (inclusive of fees and/or spread)Not used; it equals Subtotal plus or minus the fee.
CoinLedger universal manual import
CoinLedger columnFilled from
Date (UTC)Transaction time in UTC, MM/DD/YYYY HH:MM:SS
Platform (Optional)Exchange name
Asset Sent / Amount SentThe side that left your balance
Asset Received / Amount ReceivedThe side that arrived
Fee Currency / Fee AmountFee, in the asset it was charged in
TypeTrade, Deposit, Withdrawal, Staking, Interest, Income or Airdrop
Description (Optional)Original operation name for income rows
TxHash (Optional)The transaction ID on the blockchain, when the file has one

3. Import into CoinLedger

In CoinLedger, open Import, choose Manual import or Universal template, and upload the converted CSV.

Known problems with this pair

  • Staking and rewards income keep Coinbase's dollar value, so CoinLedger doesn't need to price them again.