How to Get CSV from Kraken: Complete Guide to Export Tax Data
Step-by-step guide to correctly export your complete Kraken history in CSV format. Learn how to download transactions, trades, conversions and staking for your tax return and AEAT compliance.
Cleriontax Team
Crypto Tax and Data Analysis Experts

Kraken is one of the most respected and regulated cryptocurrency exchanges in Europe, especially popular among Spanish users for its support for native EUR pairs (BTC/EUR, ETH/EUR) and tax transparency.
However, when it comes time to prepare your tax return and you need to justify your cryptocurrency operations to the Spanish tax authority (AEAT), many users face the same critical question: How do I correctly export all my Kraken data for tax purposes?
Unlike Binance, which is more complex, Kraken offers a significantly simplified data export system. But still, there are specific steps you must follow to ensure you get all relevant tax information without missing any operations.
Exporting your Kraken data incorrectly can result in:
- Incomplete tax returns that lead to sanctions from the tax authority
- Inability to justify operations and gains to the AEAT
- Incorrect calculations of acquisition cost using the FIFO method
- Loss of unreported staking rewards
- Lack of traceability for deposits and withdrawals
In this complete and up-to-date guide, we'll teach you exactly how to export all your Kraken data in CSV format, what information each file contains, how to interpret it correctly, and how to organize it for your precise and complete tax return.
Why is Kraken Different from Other Exchanges?
Kraken's Tax Advantages for Spanish Users
Kraken has several characteristics that significantly differentiate it from other exchanges for users in Spain:
1. Direct EUR Pairs:
Unlike Binance, which primarily uses USDT as the divisor, Kraken offers direct euro pairs like BTC/EUR, ETH/EUR, and ADA/EUR. This means your operations are recorded directly in euros, eliminating the need for additional conversions and reducing rounding errors.
This feature is crucial for taxation because:
- The price is recorded directly in the declaration currency (EUR)
- You reduce the risk of deviations from exchange rate fluctuations
- It facilitates justification to the tax authority of the prices used
- It greatly simplifies data processing for FIFO
2. European Regulation and Transparency:
Kraken is regulated in Europe and complies with much stricter transparency and reporting standards. The platform actively cooperates with European tax authorities, including Spanish ones.
This has direct tax implications:
- Exported data is documentarily reliable and defensible before the tax authority
- Kraken may be required by the AEAT to provide information about Spanish users
- The company maintains detailed records for years
- Exports are backed by internal audit systems
3. Permanent Transaction History:
Unlike some exchanges that delete histories after a certain time, Kraken maintains permanent records of all your operations from when you created your account. This means that even if you were trading 5 years ago, you can still export that information.
Specific Tax Obligations with Kraken in Spain
As a Kraken user in Spain, you must comply with tax obligations similar to those of other exchanges, but with some particularities derived from the nature of the platform:
Capital Gains from Trading:
Each buy-sell operation on Kraken generates a capital gain or loss subject to taxation. Since Kraken offers direct EUR pairs, you have an advantage: prices are already in the declaration currency.
These gains are taxed in the savings base with rates of 19%, 21%, 23% and 27% depending on the total volume of capital gains for the year. If you made gains on Kraken during 2024, you must declare them in your form 100 using the correct FIFO method calculation.
Staking Rewards:
Kraken offers staking programs for Ethereum, Cardano, Polkadot and other proof-of-stake cryptocurrencies. Each reward received constitutes a capital income that must be declared as income in the year it is received.
Staking rewards are declared in the savings base (although with specific treatment as income). They must be valued at the price of the cryptocurrency on the exact day of receipt.
Form 721 Obligation:
If the total balance of your cryptocurrencies on Kraken (and other exchanges) exceeds €50,000 on December 31, you are obligated to file form 721 for declaration of crypto-assets abroad.
The penalty for failing to file form 721 is severe: €1,500 minimum and up to 150% of the undeclared value. That's why it's essential that when exporting your Kraken data, you also capture the final balance in euros at the end of the fiscal year.
DAC8 Directive Compliance:
Kraken, as a regulated European exchange, is obligated to communicate information about users to tax authorities under the DAC8 Directive. Although this occurs without your intervention, it's important that you're aware that your operations may be automatically reported to the tax authority.
Types of Data You Can Export from Kraken
Unlike Binance, Kraken groups data types in a more simplified way. Let's see what you can export and when you need each type:
1. Trade History (Spot Trading)
The trade history includes all orders you've executed in Kraken's spot market: purchases, sales, and exchanges.
Each operation records:
- Exact date and time (UTC):
- Trading pair: BTC/EUR, ETH/EUR, ADA/USD, etc.
- Order type: Market, Limit, Stop-Loss
- Side of the operation: Buy (purchase) or Sell (sale)
- Unit price:
- Executed quantity:
- Fee paid:
- Total value in the reference currency:
Tax Importance: This is the most critical file for your declaration. Each line represents a tax event (capital gain or loss) that must be included in your FIFO calculation.
2. Deposit and Withdrawal History (Funding)
This file includes all fund movements in and out of your Kraken account:
Deposits (Inbound):
- EUR bank transfers you've deposited
- Cryptocurrency deposits from other wallets
- Income from commissions or referrals
Withdrawals (Outbound):
- Transfers to your bank account
- Cryptocurrency sends to other wallets or exchanges
- Dust conversions that don't appear in the trade history
Tax Importance: It's essential for documenting the traceability of your funds and proving the origin of your capital. If the tax authority requires it, this history is your evidence of where the money came from with which you bought cryptocurrencies.
3. Conversion and Exchange History
Kraken allows you to instantly convert between cryptocurrencies, similar to Binance's Convert function. This file records:
- Origin cryptocurrency and quantity converted
- Destination cryptocurrency and quantity received
- Exact date and time
- Conversion fee or spread
Tax Importance: Each conversion between cryptocurrencies constitutes a barter (exchange of goods), which is a tax event that generates capital gain or loss according to the correct classification of operations.
This is a common mistake: many users don't export conversions thinking they're not "real" operations. However, from a tax perspective, converting BTC to ETH is just as important as selling BTC for EUR.
4. Staking and Rewards History
If you've participated in proof-of-stake staking on Kraken, you can export:
- Each staking reward received
- Exact date of receipt
- Quantity received
- Market price at that time (although you'll need to find it separately)
Tax Importance: Each staking reward is a tax income that must be declared as capital income. The AEAT requires that you demonstrate when you received each reward and at what market price.
5. Fee History
Kraken allows you to see a detailed breakdown of all fees paid, grouped by:
- Type of fee (trading fee, withdrawal fee, etc.)
- Currency paid
- Time period
Tax Importance: Fees are deductible expenses that reduce your taxable base. It's important to document them correctly, especially if you pay fees in cryptocurrencies (for example, if you paid a commission in BTC, that amount should be deducted from the capital gain value).
6. Balance Summary (Holdings)
Kraken allows you to export a summary of your current holdings or holdings at a specific date:
- Each cryptocurrency
- Total quantity
- Current market price or price at the selected date
- Total value in EUR
Tax Importance: This file is crucial for determining whether you need to file form 721 (€50,000 limit). You must export your balances specifically on December 31 of the fiscal year you're reporting.
Step-by-Step Guide: Export Data from Kraken
Now let's see exactly how to export each type of data from your Kraken account.
Prerequisites
Before you start exporting, make sure you have:
- ✅ Access to your verified Kraken account
- ✅ Identity verification (KYC) completed at the highest level
- ✅ Two-factor authentication (2FA) activated for security
- ✅ History viewing permissions enabled
- ✅ Stable internet connection
- ✅ Disk space to save multiple CSV files
- ✅ Updated web browser (Chrome, Firefox, Safari, Edge)
Step 1: Access Your Data History
- Log in to your Kraken account (www.kraken.com)
- In the upper right corner, click on your name or profile icon
- Select "Settings" (Configuration)
- In the side menu, look for "Manage Data" or "Data Export"
- If you don't see it immediately, it may be under "Security" or "Privacy"
Note: Kraken has reorganized this menu several times in 2024-2025. If you can't find these options, search for "Account Statement" instead of "Data Export".
Step 2: Export Trade History (Spot Trading)
This is the most important export for calculating your capital gains.
Location:
- Go to "Settings" → "Manage Data" → "Export Data"
- Select "Trades"
- Choose the desired time period (you can export complete years or specific periods)
- Select format: CSV (not JSON)
- Click "Generate Export"
Period Options:
- Kraken allows you to export in blocks of up to 1 year
- If you've traded over multiple years, make separate exports for each fiscal year (2024, 2023, 2022, etc.)
What You'll Receive:
A CSV file with columns like:
txid,refid,time,type,ordertype,pair,amount,price,cost,fee,volume,margin,misc
1234567,TRAD1234,2024-01-15T14:32:00Z,buy,limit,XBTEUR,0.05,42500.00,2125.00,6.38,0.05,0,
Column Explanation:
- txid: Unique transaction ID
- refid: Order reference ID
- time: Date and time in UTC
- type: "buy" (purchase) or "sell" (sale)
- ordertype: Type of order (limit, market, stop-loss, etc.)
- pair: Trading pair (XBTEUR, ETHEUR, etc.)
- amount: Cryptocurrency quantity traded
- price: Unit price
- cost: Total cost (quantity × price)
- fee: Commission paid
- volume: Volume (equals cost in most cases)
- margin: Indication if it was a leveraged operation
Step 3: Export Deposit and Withdrawal History (Funding)
This file documents all the traceability of incoming and outgoing funds.
Location:
- Go to "Settings" → "Manage Data" → "Export Data"
- Select "Ledger" (not "Trades")
- Optionally filter by:
- Asset: You can export all currencies or just specific cryptocurrencies
- Type: Filter by "deposit" or "withdrawal"
- Select desired period (1 year maximum per export)
- Format: CSV
- Click "Generate Export"
What You'll Receive:
A detailed CSV file with each movement:
refid,time,type,subtype,aclass,asset,amount,balance,fee,description
DEP12345,2024-01-10T09:15:00Z,deposit,,,ZEUR,5000.00,5000.00,0.00,EUR Deposit
WIT67890,2024-01-20T11:30:00Z,withdrawal,,,XXBT,0.5,0.0,0.0005,BTC Withdrawal
Key Columns:
- refid: Unique movement ID
- time: Date and time in UTC
- type: "deposit" or "withdrawal" mainly
- asset: Currency (ZEUR for euros, XXBT for Bitcoin, XETH for Ethereum)
- amount: Amount deposited or withdrawn
- balance: Balance after the operation
- fee: Withdrawal fee (normally 0 for deposits)
Important Note: On Kraken, cryptocurrencies use special codes. XXBT = BTC, ZEUR = EUR, XETH = ETH, XADA = ADA. You'll need to know these codes to correctly process the data.
Step 4: Export Conversion History
Many users forget to export conversions because they don't appear in the regular trade history. This is a serious tax error.
Location:
- Go to "Settings" → "Manage Data" → "Export Data"
- Look for "Convert" or "Conversion History"
- If you don't see it in Export Data, go to "Funding" and look for transactions of type "convert"
- Alternatively, in the general ledger, filter for transactions with description "convert" or "conversion"
If You Can't Find a Direct Option:
The conversion export option may not be available in your version of Kraken. In that case:
- Go to your "Account Activity" or "Funding History"
- Manually filter for conversions (search by "convert")
- Take screenshots or manually copy each conversion
- Create your own CSV with dates, quantities, and converted pairs
Step 5: Export Staking and Rewards History
If you've participated in staking, this is a critical file you must not forget.
Location:
- Go to "Settings" → "Manage Data" → "Export Data"
- Select "Rewards" or "Staking History"
- Select the period (you can export several years)
- Format: CSV
- Generate the export
What You'll Receive:
date,asset,amount,reward_type
2024-01-15,XETH,0.00523,ethereum2.s
2024-01-22,XETH,0.00518,ethereum2.s
Important: The market price of the reward is NOT included in the Kraken CSV. You'll need to get the price for each reward day separately using:
- CoinGecko (Historical API)
- CoinMarketCap
- Kraken's own price history
Step 6: Export Balances at Specific Date (December 31)
To determine if you need to file form 721, you need your total balance on December 31 in euros.
Location:
- Go to your "Funding" or "Spot Wallet"
- On the balance page, take a screenshot showing:
- Each cryptocurrency you own
- The exact quantity
- The value in EUR (if Kraken shows it) or current EUR price
- Note the date of this screenshot (December 31 ideal, or the closest available date)
- Save as evidence
Alternatively:
- Go to "Settings" → "Account Statement"
- Generate an account statement for the period that includes December 31
- This statement will include a final balance summary
How to Interpret Kraken's Exported Data
Once you've downloaded the CSV files, it's important to understand exactly what the data means and how to process it for your tax return.
Cryptocurrency Codes on Kraken
Kraken uses special codes for cryptocurrencies in its exports. These are the most common:
| Code | Currency | Code | Currency |
|---|---|---|---|
| XXBT | Bitcoin | XETH | Ethereum |
| XADA | Cardano | XDOT | Polkadot |
| XLTC | Litecoin | XXMR | Monero |
| ZEUR | Euros | ZUSD | US Dollars |
| ZGBP | Pounds | ZJPY | Yen |
Important: When processing your data, replace these codes with standard names (BTC, ETH, etc.) to avoid confusion.
Interpretation of Buy and Sell Operations
Purchase (BUY):
time: 2024-03-15T14:30:00Z
type: buy
pair: XBTEUR
amount: 0.05 BTC
price: 52000.00 EUR
cost: 2600.00 EUR
fee: 5.20 EUR
Tax Interpretation:
- March 15, 2024 (at 14:30 UTC)
- You purchased 0.05 BTC
- At a unit price of €52,000
- You paid €2,600 total (not counting commission)
- Commission: €5.20
- Total acquisition cost: €2,600 + €5.20 = €2,605.20
- Cost per BTC: €52,104
This information is used to build your purchase record for the FIFO method.
Sale (SELL):
time: 2024-06-20T10:15:00Z
type: sell
pair: XBTEUR
amount: 0.05 BTC
price: 58000.00 EUR
cost: 2900.00 EUR
fee: 5.80 EUR
Tax Interpretation:
- June 20, 2024 (at 10:15 UTC)
- You sold 0.05 BTC
- At a unit price of €58,000
- You received €2,900 (minus commission)
- Commission: €5.80
- Net income: €2,900 - €5.80 = €2,894.20
Following the FIFO method:
- Acquisition cost (purchase of March 15): €2,605.20
- Sale price (sale of June 20): €2,900
- Capital gain: €2,900 - €2,605.20 = €294.80
- Tax to pay (19%): €55.93
Handling UTC Dates
All Kraken data is exported in UTC (Coordinated Universal Time), but Spain is in:
- Winter time: UTC + 1
- Summer time: UTC + 2
This is especially important for operations just before or after time changes.
Problem Example:
- Operation on Kraken: 2024-12-31 23:45:00 UTC
- Time in Spain (winter): 2025-01-01 00:45:00
- Tax year: 2025, not 2024
You must convert each UTC date to Spanish local time to determine the correct tax year.
Identification of Tax Events
Events that GENERATE taxation:
- ✅ BUY followed by SELL (buy and sell generates gain/loss)
- ✅ Conversion of crypto to EUR (sale)
- ✅ Crypto-to-crypto conversion (barter, is a capital gain/loss)
- ✅ Sale at loss (capital loss that offsets gains)
- ✅ Staking rewards (capital income)
Events that DON'T generate immediate taxation:
- ❌ Purchase of cryptocurrency (only acquisition cost is recorded)
- ❌ Deposit to your Kraken account (not tax income)
- ❌ Withdrawal of cryptocurrency to another wallet (no gain generated)
- ❌ Transfer between your own Kraken wallets
Common Problems with Kraken Data
Problem 1: Decimal Separators Kraken uses a period (.) as the decimal separator (English format), but Excel in Spanish uses a comma (,). When opening the CSV:
- Right-click → File Properties
- Select "Encoding" → Unicode (UTF-8)
- In Excel: Data → Get Data → From Text File
- Specify "Decimal separator: period"
Problem 2: Very Small Quantities Some operations may show very small quantities (e.g., 0.00001234 BTC). Make sure your calculation software maintains full precision without rounding.
Problem 3: Leveraged Operations If you've done margin trading or futures on Kraken, these operations may have different tax treatment than spot. The "margin" field in the CSV will tell you if it was leveraged.
Critical Errors When Exporting Kraken Data (and How to Avoid Them)
Error 1: Not Exporting Crypto-to-Crypto Conversions
This is the most common error. Many users forget that Kraken records instant conversions between cryptocurrencies in a different place than the trade history.
Converting 1 BTC to 16 ETH is fiscally a barter (exchange of goods) that generates a capital gain or loss. Failing to declare it is:
- Incomplete (income omission)
- Punishable by the AEAT
- Subject to late payment interest
Solution:
- Actively search for "Conversions" history in Kraken
- If you can't find a direct CSV, manually copy each conversion
- Value each conversion at the EUR price at that time
- Include all conversions in your FIFO calculation
Error 2: Forgetting to Include Staking Rewards
If you've participated in Kraken Staking (especially ETH 2.0), each reward received is a tax income.
Failing to declare them is particularly serious because:
- The AEAT can cross-check data with Kraken
- Rewards are recorded with exact date
- Their omission is easy to detect in an audit
Solution:
- Specifically export "Rewards"
- For each reward, find the EUR price of the cryptocurrency on that exact day
- Declare each reward as capital income in the corresponding tax year
Error 3: Not Converting Correctly to Euros
Some Kraken data may be in USD (ZUSD) or GBP (ZGBP) instead of EUR, especially if you traded those pairs.
Not correctly converting to EUR results in:
- Incorrect declared values
- Possible sanctions for manifest error
- Misalignment with information Kraken provides to the tax authority
Solution:
- For USD pairs: find the USD/EUR exchange rate for that exact day
- Source: European Central Bank, CoinGecko, Kraken historical
- Example: Sale of 1 ETH at 1,500 USD on 15/03/2024
- USD/EUR rate on 15/03: 0.92
- EUR price: 1,500 × 0.92 = €1,380
Error 4: Using Dates Without Converting from UTC
Not converting UTC dates to Spanish local time can result in assigning operations to the wrong tax year.
Solution:
- Convert manually or with Excel:
UTC_Date + 1 hour (winter) + 2 hours (summer) - Use the TIMEVALUE function in Excel for automatic conversion
- For operations near December 31, especially important
Error 5: Loss of Commission Data
Some commissions on Kraken may be paid in different currencies. If you don't record them correctly, you unjustifiably reduce the taxable base.
Solution:
- Each commission reduces the capital gain (if in EUR)
- If the commission is in cryptocurrencies, it must be valued at the price of that day
- Use the complete "Ledger" file to audit all commissions
Error 6: Not Verifying Balance Coherence
Kraken may occasionally have errors or you yourself could have incomplete data. Verifying coherence protects you.
Solution:
- Sum all your BTC deposits
- Subtract all your BTC withdrawals
- Sum/subtract buy-sell operations
- Compare the result with your current balance on Kraken
- If it doesn't match, investigate what's missing
How to Organize and Process Exported Data
Once you've downloaded all CSV files, you need to organize them systematically so you can process them correctly.
Recommended Folder Structure
Organize your Kraken files clearly and professionally:
📁 Kraken_Tax_2024/
├── 📁 1_Original_Exports/
│ ├── 📄 Kraken_Trades_2024.csv
│ ├── 📄 Kraken_Trades_2023.csv
│ ├── 📄 Kraken_Ledger_2024.csv
│ ├── 📄 Kraken_Conversions_2024.csv
│ ├── 📄 Kraken_Rewards_2024.csv
│ └── 📄 Kraken_Holdings_2024-12-31.csv
├── 📁 2_Processed_Data/
│ ├── 📄 Consolidated_All_Trades.xlsx
│ ├── 📄 FIFO_Calculations.xlsx
│ └── 📄 Converted_to_EUR.xlsx
├── 📁 3_Evidence/
│ ├── 📄 Export_process_screenshot.png
│ ├── 📄 Kraken_confirmation_email.pdf
│ └── 📄 Quotations_used_notes.txt
└── 📁 4_Final_Report/
└── 📄 Kraken_Tax_Summary_2024.xlsx
This structure allows you to:
- Save evidence of where the data comes from
- Keep original data unmodified
- Document your processing process
- Facilitate audits if the tax authority requires
Consolidation and Data Cleaning
If you've exported multiple files (several years of trades, for example), you need to consolidate them:
Step 1: Combine Multiple Files of the Same Type
- Open the oldest file in Excel
- Copy all rows (without headers) from newer files
- Paste them at the end of the first one
- Sort by date ("time" column)
- Verify there are no duplicates
Step 2: Verify Data Coherence
- ✅ All dates are in consistent format
- ✅ No duplicate records
- ✅ Final balances of one operation match initial balances of the next
- ✅ No unexplained time gaps
Step 3: Add Processing Columns
Create additional columns for processing:
- Local_Date (converted from UTC)
- Tax_Year (extracted from local date)
- Price_EUR (manual lookup or tools)
- Gain_Loss (calculated per FIFO)
- Operation_Type (tax classification)
Manual Price Conversion to EUR
For operations in USD or GBP, you need to obtain historical quotations.
Method 1: CoinGecko API
https://api.coingecko.com/api/v3/coins/bitcoin/history?date=15-03-2024&vs_currencies=eur
Responds with the EUR price of BTC on March 15, 2024.
Method 2: CoinGecko Website Manually
- Go to https://www.coingecko.com/
- Search for the cryptocurrency (e.g., Bitcoin)
- Click "Historical Data"
- Find the specific date
- Copy the EUR price
Method 3: Kraken Historical Data
- Go to Kraken's charts page
- Search for the EUR pair (e.g., BTC/EUR)
- Set the date
- Read the price
Calculation of Capital Gains with FIFO Method
This is the most critical step and where many users make serious errors.
Complete Example:
Purchase History:
- January 10, 2024: You purchase 0.3 BTC at €40,000 = €12,000
- February 15, 2024: You purchase 0.5 BTC at €45,000 = €22,500
- March 20, 2024: You purchase 0.2 BTC at €50,000 = €10,000
Sales History: 4. June 1, 2024: You sell 0.7 BTC at €52,000 = €36,400
FIFO Calculation (first purchases = first sales):
- You sell first the 0.3 BTC from 1/10 (cost: €12,000)
- You then sell 0.4 BTC from the 0.5 of 2/15 (cost: €22,500 × 0.4/0.5 = €18,000)
- Total acquisition cost: €12,000 + €18,000 = €30,000
- Sale income: €36,400
- Capital gain: €36,400 - €30,000 = €6,400
- Tax (19%): €1,216
Remaining Portfolio Balance:
- 0.1 BTC from the 2/15 purchase (cost: €4,500)
- 0.2 BTC from the 3/20 purchase (cost: €10,000)
- Total: 0.3 BTC with accumulated cost of €14,500
This record is essential for future operations.
Tools to Automate Processing
If you have many operations, manual processing is impractical. These specialized tools can help:
Integrated Tax Tools:
-
Koinly (https://koinly.io/)
- Direct import from Kraken (automatic linking)
- Support for multiple exchanges and wallets
- Automatic FIFO calculation per Spanish regulations
- Report generation for form 100
- From €49/year
-
CryptoTax (https://www.cryptotax.io/)
- Specialized in Spanish taxation
- Kraken CSV import
- Calculation of forms 100, 721, 714
-
Accointing or CoinTracking
- Integration with Kraken
- Tax report generation
Clear Advantages:
- ✅ Complete EUR conversion automation
- ✅ Correct FIFO application without errors
- ✅ Handling of multiple exchanges simultaneously
- ✅ Ready-to-file report generation
- ✅ Saving of dozens of hours of manual work
Disadvantages:
- ❌ Initial cost (though less than a tax advisor)
- ❌ Initial learning curve
- ❌ You must verify results (don't blindly trust)
At Cleriontax we offer complete analysis of Kraken data with automated processing, manual verification and ready-to-file reports. If you prefer not to process manually, we can do it for you.
Verification of Integrity and Completeness
Before using your data for your tax return, you must verify that it is complete and coherent.
Verification Checklist
Verification 1: Have I Exported Everything?
- ✅ Trades from all years I've operated on Kraken
- ✅ Deposits and withdrawals (Ledger) complete
- ✅ Crypto-to-crypto conversions
- ✅ Staking rewards (if I participated)
- ✅ Balances on December 31 for form 721 calculation
- ✅ Commission data
Verification 2: Are Balances Coherent?
Manual verification for each major cryptocurrency:
BTC Balance Verified:
BTC Deposits (from Ledger): +1.5
BTC Withdrawals (from Ledger): -0.3
BTC Purchases (from Trades buy): +0.8
BTC Sales (from Trades sell): -0.9
Calculated Balance: 1.1 BTC
Actual Balance on Kraken: 1.1 BTC ✅
If it doesn't match:
- Missing exported conversions
- Missing staking transactions
- BTC commissions not accounted for
- Transfers between your own internal wallets
Verification 3: Are All Dates Correct?
- ✅ Dates in chronological order
- ✅ No duplicates
- ✅ No large time gaps without explanation
- ✅ Dates correctly converted from UTC to local time
Verification 4: Are They Correctly Valued?
- ✅ All prices in EUR (or converted to EUR with documented exchange rate)
- ✅ Commissions included in acquisition cost
- ✅ Quantities in BTC, ETH, etc. maintain full decimal precision
Documentation of Sources for Audit
If the tax authority requires, you must be able to justify:
1. Origin of Quotations
Create a document with notes like:
Operation: Sale of 0.05 BTC on 15/03/2024
Price Used: €52,000
Source: Kraken historical - BTC/EUR chart
Screenshot: kraken_btc_eur_15_03_2024.png
Operation: Sale of 1 ETH on 20/05/2024 at 1,500 USD
USD/EUR Rate: 0.92 (date 20/05/2024)
Source: European Central Bank
EUR Price: 1,500 × 0.92 = €1,380
2. Export Process
Save screenshots of the process:
- Access to "Settings" → "Manage Data"
- Selection of data type (Trades, Ledger, etc.)
- Export generation
- Kraken confirmation email
3. File Integrity
Keep an unmodified copy of the original CSV files (folder "1_Original_Exports"). Never edit the originals.
Special Cases and Complex Situations
What If I Can't Access My Old Kraken Account?
If you closed your account or lost access and need old data:
Option 1: Contact Kraken Support
- Go to https://support.kraken.com
- Open a ticket requesting historical data export
- Provide verification information
- The process can take 2-4 weeks
Option 2: Manual Reconstruction
- Use your bank statements for fiat deposits/withdrawals
- Use block explorers (Etherscan, BscScan) for crypto movements
- Estimate operations based on your memory
- Document that there's missing information but that you made due diligence
What If I Exported Some Data But Not Completely?
If you exported only 2024 but have operated since 2021:
Problem: You won't be able to correctly calculate the FIFO method because you don't know the acquisition cost of cryptocurrencies bought before 2024.
Solution:
- Try to export data from previous years from Kraken
- If Kraken doesn't have data (account closed), reconstruct with blockchain
- Document in your return "Incomplete data from year X due to access impossibility"
- Consult with a tax advisor on how to proceed
What About Compounded Staking?
If you've staked for several years and your rewards were automatically reinvested:
Each reward received is a separate tax event with its own date and price.
Example:
- January 1, 2024: You receive 0.05 ETH from staking (value: €100)
- January 8, 2024: You receive 0.05 ETH from compound staking (value: €103)
- January to December 2024: 50+ separate staking events
You must declare ALL of them, not just the annual total.
Did I Trade with Leverage (Margin) on Kraken?
Leveraged operations may have special tax treatment.
Considerations:
- Margin gains/losses are taxed as capital gains
- Interest paid for the leverage loan is a deductible expense
- Liquidated positions may have legal implications beyond taxes
If you have margin operations, consult with a specialized tax advisor.
Preparation of Final Tax Report
Once you've exported, processed and verified all your Kraken data, the final step is to prepare a consolidated document.
Recommended Consolidated Summary
Create a report in Excel or PDF that contains:
1. Cover and Executive Summary:
- Tax period covered (01/01/2024 - 31/12/2024)
- Kraken username and taxpayer ID of the owner
- Report generation date
- Total operations processed
2. Results Summary:
KRAKEN TAX RESULTS 2024
Capital Gains (spot operations): +€15,250
Capital Losses (offset): -€3,100
Net Capital Gain: +€12,150
Staking Rewards: +€450
Portfolio Value on 31/12/2024: €47,300
(Below the €50,000 threshold for form 721)
Estimated Tax to Pay: €2,309
(19% on capital gains)
3. Operations Detail (Sample):
| Date | Type | Pair | Quantity | Price | Gain/Loss EUR |
|---|---|---|---|---|---|
| 15/03 | SELL | BTC/EUR | 0.05 | €52,000 | +€294 |
| 20/05 | BUY | ETH/EUR | 2 | €2,100 | - |
| ... | ... | ... | ... | ... | ... |
4. Staking Rewards Detail:
| Date | Asset | Quantity | Price_EUR | Value_EUR |
|---|---|---|---|---|
| 10/01 | ETH | 0.0052 | €2,100 | €10.92 |
| ... | ... | ... | ... | ... |
5. Balances on 31/12/2024:
| Cryptocurrency | Quantity | Price 31/12 | Value EUR |
|---|---|---|---|
| BTC | 0.15 | €42,000 | €6,300 |
| ETH | 1.5 | €2,200 | €3,300 |
| ... | ... | ... | ... |
Total Value: €47,300
6. Compliance Statement:
"I certify that this export and processing of Kraken data is complete and accurate according to my records. The data comes directly from Kraken.com through official CSV export on [DATES]. I have verified the coherence and completeness of the data."
Supporting Documents to Keep
Keep for at least 4 years (better 6 years):
- ✅ Original Kraken CSV files unmodified
- ✅ Screenshots of the export process
- ✅ Kraken confirmation emails
- ✅ Spreadsheets with calculations and conversions
- ✅ References to historical quotations used
- ✅ Bank statements (deposits/withdrawals fiat)
- ✅ Notes on missing data or anomalies
Integration with Tax Analysis Tools
Many users prefer to use specialized tools once they've exported their Kraken data.
How to Use Kraken Data in Koinly (Recommended)
Option A: Connect Automatically (Easiest)
- Create account on Koinly.io
- Go to "Add Exchange"
- Select "Kraken"
- Click "Connect" (automatic authorization)
- Access your Kraken account when requested
- Koinly will automatically download all your data
Option B: Import CSV Manually
- In Koinly, go to "Manual Transactions" or "Import"
- Select the data type (Trade, Deposit, etc.)
- Upload your Kraken CSV
- Koinly will automatically process the data
Advantages:
- Automatic FIFO calculation
- Tax report generation for Spain
- Automatic date and value conversion
- Form 100 declaration generation
For a complete guide on integrating tax tools, check our specialized services.
Conclusion: Exporting Data from Kraken is Easier Than Other Exchanges
Kraken significantly facilitates the export of tax data compared to other exchanges. Its direct EUR CSVs and organized system make the process much less complex than with Binance.
Key Points to Remember
- ✅ Export Everything: Trades, Ledger, Conversions, Rewards
- ✅ Preserve Complete Years: From your first deposit to today
- ✅ Convert Dates: UTC to Spanish local time
- ✅ Verify Balances: They must match your actual wallet
- ✅ Document Sources: Quotations and export process
- ✅ Keep Originals: Save CSV unmodified
- ✅ Calculate FIFO Correctly: First purchases = first sales
- ✅ Include Commissions: They are deductible expenses
- ✅ Don't Forget Rewards: They are income that must be declared
- ✅ Consider Tools: Koinly or similar save lots of time
Your Next Step
If you've exported your Kraken data but:
- Feel overwhelmed with FIFO processing
- Are unsure about quotations or conversions
- Need to generate a professional tax report
- Want expert validation in crypto taxation
At Cleriontax we can help you. Our Kraken portfolio analysis service includes:
- Complete processing of your Kraken CSVs
- Accurate FIFO calculation per Spanish regulations
- Generation of tax report ready for form 100
- Determination of whether you need form 721
- Data integrity validation and verification
- Support for tax authority requests
Request Your Kraken Tax Analysis
Comply with the tax authority without uncertainty. We process your Kraken data.
Disclaimer: This article is informative and educational. It does not constitute personalized tax advice. Taxation is subject to changes and each situation is unique. Always consult with a professional tax advisor. Cleriontax is not affiliated with Kraken.
Last Updated: January 2026
Published by: Cleriontax Team - Experts in Crypto Taxation and Data Export
Did you find this article helpful?
Share it with other investors who might need it


