P2PTab

Binance to Koinly

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

Based on Binance'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 Binance

On the website, open Assets, then Asset History, and choose Export Transaction Records. Use Customize to request one calendar year per file, then download it within seven days, before the link expires. The file lists every balance change across Spot, Funding and Earn. Step-by-step: how to export Binance transaction history.

If you're opening an account now, the sign-up guide covers the settings worth switching on first.

2. What changes in the file

Binance transaction history statement
Column in the exportWhat we take from it
UTC_TimeTransaction time (already UTC). Rows with the same time and account are grouped into one trade.
AccountUsed only to group a trade's rows together. Spot, Funding and Earn are treated as one Binance account for cost basis.
OperationTransaction type: trade side, fee, deposit, withdrawal, interest, staking reward, distribution.
CoinAsset ticker.
ChangeAmount with a sign: negative is what left your balance, positive what arrived.
RemarkNot used.
Koinly universal template
Koinly columnFilled from
DateTransaction time in UTC, written as YYYY-MM-DD HH:MM:SS
Sent Amount / Sent CurrencyThe side that left your balance
Received Amount / Received CurrencyThe side that arrived
Fee Amount / Fee CurrencyFee, in the asset it was charged in
Net Worth Amount / CurrencyDollar value, only when the exchange file states it
Tagreward (staking and other rewards), lending interest, airdrop or other income for income rows; empty otherwise
DescriptionOriginal operation name for income rows
TxHashThe transaction ID on the blockchain, when the file has one

3. Import into Koinly

In Koinly, open Wallets, add a wallet named after the exchange, then choose Import from file and upload the converted CSV. Koinly reads its own universal template directly.

Known problems with this pair

  • Trades against USDT carry no dollar value in the file. Koinly fills these from its own price data after import.
  • Small-balance conversions to BNB ("Small assets exchange BNB") are left out and listed in the converter report. Enter them in Koinly by hand as one trade per coin.