How to Import a Kraken Ledger with Staking and Trades Mixed
To import a Kraken ledger that contains both staking rewards and trades, you need to separate the two activities in your export or use portfolio software that can parse Kraken's combined CSV format correctly. The main challenge is that Kraken reports staking rewards as separate "staking" transactions that typically have a zero cost basis, which can distort cost calculations if treated as ordinary trades.
Understanding kraken's ledger format
Kraken provides a comprehensive CSV export from its "History" → "Ledger" section. This file includes every transaction type: trades, deposits, withdrawals, staking rewards, and fee refunds. Each row contains fields like refid, time, type, asset, amount, fee, and balance. The type field distinguishes "trade" from "staking" entries. If you import this raw file into generic portfolio software without filtering, it will treat staking rewards as equivalent to trades, creating a misleading cost basis.
Step 1: Export the Correct File
From your Kraken account, navigate to "History" → "Ledger" → "Export". Choose the CSV format. Set the date range to cover all transactions you need. Kraken allows exporting up to a year at a time; for longer periods, export multiple files. The exported file will contain both trades and staking activities mixed together.
Step 2: Separate Trades and Staking in the CSV
Before importing, split the CSV into two files using spreadsheet software or a text editor:
- Trades file: Filter rows where
typeequals "trade". These rows represent buy/sell orders, including their fees. Keep all columns. - Staking file: Filter rows where
typeequals "staking". These rows show rewards paid into your account. Theamountis the reward quantity, andfeeis typically zero. Thebalancecolumn reflects the running total.
If you have other transaction types like "deposit" or "withdrawal", keep those separate as well. Most portfolio software will handle deposits and withdrawals automatically, but mixing them with staking or trades can cause reconciliation errors.
Step 3: import each file separately
Most crypto portfolio tracking tools (like Koinly, Cointracker, or Accointing) allow importing multiple CSV files. Import the trades file first, then the staking file. When you add the staking file, the software should recognize it as income or rewards rather than trades. If the software asks for a transaction type during import, select "staking" or "reward" rather than "trade". This ensures the cost basis of staking rewards is treated as zero, which is correct for tax purposes in most jurisdictions.
Step 4: Verify the Import
After importing both files, check your portfolio balance matches what Kraken shows. Common issues:
- Duplicate transactions: If the same staking reward appears in both the trades and staking files, delete the duplicate.
- Missing staking entries: Kraken sometimes batches staking rewards into a single entry per day. Check the export date range covers all periods.
- Balance mismatch: If your portfolio balance is higher than Kraken, you likely imported a transaction twice. If lower, a transaction is missing.
Handling mixed transactions in software
Some portfolio tools (like Koinly or Cointracker) can directly import the raw Kraken ledger CSV without splitting. They automatically identify "staking" rows and assign a zero cost basis. If you use such software, you can skip steps 2 and 3. However, always verify the import after it completes. Open the transaction list and confirm staking entries show a cost basis of zero and are not double-counted.
Staking rewards and cost basis
When staking rewards appear in your ledger, they generally have a zero cost basis. This means if you later sell those rewards, the entire proceeds are considered taxable gain. Most tax software handles this automatically when you import staking as a separate category. If you mistakenly import staking rewards as trades, the software might assign a fair market value at receipt, which could lead to an incorrect cost basis.
What to do if your software can’t separate staking
If your portfolio tool cannot distinguish staking from trades, you have two options:
- Edit the CSV manually: Change the
typefield of staking rows to "staking" or "reward" before import. Some tools accept custom transaction types. - Use a dedicated tax tool: Services like Koinly, Cointracker, or TaxBit are designed to parse Kraken’s ledger format correctly. They handle staking and trades without manual splitting.
Final Check
After importing, run a reconciliation report. Compare the total staking rewards in the software to what Kraken shows under "Staking" in your account. Also, compare the number of trades. Any discrepancy indicates an import error. Fix it before relying on the data for tax reporting.
For most users, the simplest method is to export the full ledger CSV and import it into a tool that supports Kraken natively. Only split the file if your software struggles with mixed transaction types.
Not financial advice. venko.tech publishes market data and general information about digital assets. Crypto assets are volatile and you can lose everything you put in. Nothing here is a recommendation to buy, sell or hold, and we make no price predictions.
Prices are sourced from third parties and may be delayed or wrong. Verify anything you intend to act on against a primary source.