P2PTab

Kraken to Koinly

Download your Kraken 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 Kraken'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 Kraken

Open your profile menu, then Documents, Exports and Create Export. Choose Ledgers, set the start and end dates, keep all fields and pick CSV. Kraken says an export can take from a few minutes to several days and doesn't email you, so check the Exports page. If the download is a zip, use the ledgers.csv inside it.

2. What changes in the file

Kraken ledgers export
Column in the exportWhat we take from it
txidKraken's entry number. Lines without one haven't settled yet and are skipped.
refidLinks the two lines of a trade (or a spend and receive pair).
timeTransaction time in UTC.
type / subtypetrade, spend, receive, deposit, withdrawal, staking, earn reward. Moves between your own Kraken accounts are skipped.
assetKraken code, translated to a plain ticker (XXBT to BTC, ZUSD to USD, DOT.S to DOT).
amountAmount before the fee; negative means it left your balance.
feeFee charged on that line, in that line's asset.
balance, wallet, aclassNot 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

  • Moves between Kraken spot and staking wallets are skipped; they aren't taxable and Koinly would otherwise show them as transfers with no match.