RotkiX Documentation

Tracking Accounts & Balances

Managing your digital asset accounts is essential for comprehensive portfolio tracking. Navigate to the Accounts section from the left sidebar to configure and monitor your blockchain addresses.

Blockchain Account Management

RotkiX enables comprehensive balance monitoring across multiple blockchain networks. The platform continuously expands its blockchain coverage to provide broader asset tracking capabilities.

Supported Blockchain Networks

The following blockchain networks are currently integrated into the platform:

Ethereum Virtual Machine (EVM) Networks

Network Name	Chain Identifier	Network Type
Ethereum Mainnet	`eth`	Layer 1
Optimism	`optimism`	Layer 2
Polygon PoS	`polygon_pos`	Sidechain
Arbitrum One	`arbitrum_one`	Layer 2
Base Network	`base`	Layer 2
Gnosis Chain	`gnosis`	Sidechain
Scroll	`scroll`	Layer 2
BNB Smart Chain	`binance_sc`	Sidechain
Avalanche C-Chain	`avax`	Layer 1
zkSync Lite	`zksync_lite`	Layer 2

Bitcoin-Based Networks

Network Name	Chain Identifier	UTXO Model
Bitcoin	`btc`	Yes
Bitcoin Cash	`bch`	Yes

Substrate-Based Networks

Network Name	Chain Identifier	Consensus
Polkadot	`dot`	NPoS
Kusama	`ksm`	NPoS

Adding Individual Accounts

1

Navigate to your desired blockchain category page

2

Click Add Account button (located in the top-right corner)

3

Choose your target blockchain network

4

Input the wallet address in the Account field

5

Click Save to confirm the addition

Bulk Account Addition

For efficient management of multiple addresses:

Enable the Add multiple addresses checkbox
Input addresses as a comma-separated list in the text field
All addresses will be processed simultaneously

Universal EVM Account Addition

To add an account across all compatible EVM networks:

Select All Supported Chains from the network dropdown
The address will be automatically tracked on all EVM-compatible networks

Advanced Bitcoin Account Management

Bitcoin and Bitcoin Cash addresses can be managed through two distinct approaches:

Manual Address Entry

Direct input of individual wallet addresses for precise control

Extended Public Key (xPub) Integration

Automated address discovery using your wallet's master public key

Understanding Extended Public Keys (xPub)

An xPub is a cryptographic key that enables RotkiX to discover all associated wallet addresses without accessing your private funds. The system performs the following operations:

Generates wallet addresses locally using your xPub
Queries blockchain networks for transaction activity
Continues discovery until finding unused addresses
Stores all information securely in your local database

Bitcoin Address Format Types

Type Code	Format Name	Address Prefix	Characteristics
`P2PKH`	Legacy Format	`1`	Original Bitcoin addressing standard
`P2SH-P2WPKH`	Segwit Wrapped	`3`	Enhanced efficiency over legacy
`WPKH`	Native Segwit	`bc1`	Optimized transaction costs
`P2TR`	Taproot	`bc1p`	Latest format with privacy enhancements

xPub Implementation Guide

1

Identify the address format your wallet generates

2

Select the corresponding type from RotkiX's dropdown menu

Key Implementation Notes

xPub keys beginning with ypub or zpub are automatically detected
Hardware wallet users can extract xPub keys through device-specific procedures
Bitcoin Cash supports only Legacy (P2PKH) and Segwit (P2SH_P2WPKH) formats

Account Management Operations

Each tracked account provides comprehensive management options accessible through row-level action buttons:

Edit Account

Modify account labels and apply custom tags for better organization

Remove Account

Delete accounts from tracking while preserving historical data

Refresh Balances

Trigger immediate balance updates for specific accounts

Advanced Filtering and Views

EVM Chain Filtering

The EVM Chains section provides sophisticated filtering capabilities:

Filter accounts by specific blockchain networks (Ethereum, Gnosis, Polygon, etc.)
Apply multiple chain filters simultaneously for cross-network analysis
Toggle between aggregated cross-chain view and individual chain breakdown
Customize display preferences for optimal workflow efficiency

ENS Name Resolution

RotkiX automatically resolves Ethereum Name Service identities for enhanced user experience:

Primary ENS names display instead of raw addresses throughout the application
ENS avatars replace default address identicons when configured
Hover over ENS names to reveal underlying blockchain addresses
Full compatibility with Ethereum mainnet ENS records

Automated Token Discovery

EVM accounts benefit from intelligent token detection capabilities:

Global Token Refresh

Re-detect tokens across all EVM accounts and networks:

Navigate to the dashboard
Toggle the refresh arrow to enable Re-detect tokens and refresh balances
Execute global refresh to update all account tokens

Chain-Specific Token Refresh

Target token detection for specific blockchain networks:

Access the EVM accounts section
Click Re-detect tokens for the desired chain
All addresses on that network will be scanned for new tokens

Individual Account Token Refresh

Refresh tokens for a single account:

Locate the target account in the accounts list
Click the refresh button in the corresponding row
Token detection will run for that specific address

Historical Events

RotkiX provides comprehensive historical event tracking across multiple blockchain networks and exchange platforms. When accessing the History Events section, the system initiates automatic data retrieval and processing, displaying real-time status updates for each monitored address.

Automated Event Detection

The platform intelligently identifies and categorizes various transaction types and financial events across your connected accounts and exchanges. Event processing includes sophisticated decoding algorithms to extract meaningful financial data from raw blockchain transactions.

Supported Event Categories

RotkiX automatically detects and processes the following event types:

🔗

EVM Chain Transactions

Complete transaction history from registered EVM-compatible accounts across supported networks

₿

Bitcoin Network Events

Transaction records from Bitcoin and Bitcoin Cash wallet addresses

📊

Exchange Activities

Trading events, deposits, and withdrawals from connected exchange platforms

⚡

ETH Staking Events

Ethereum staking deposits, withdrawals, and block production rewards

💱

Asset Movements

Cross-platform deposits, withdrawals, and asset transfers

🔄

Swap Operations

Decentralized exchange trades and token swaps

Custom Event Management

Beyond automatic detection, you can manually add custom events to capture specialized transactions or activities not automatically recognized by the system.

Advanced Event Filtering

Comprehensive filtering capabilities allow precise event analysis and review:

Event Management Operations

Data Export Capabilities

Export comprehensive event data for external analysis:

CSV Export

Click the Export CSV button to generate detailed event reports in comma-separated format, compatible with spreadsheet applications and accounting software.

Accounting Integration Control

Manage which events are included in financial calculations:

Toggle event processing for accounting calculations
Use the three-dot menu to access Ignore events in accounting options
Maintain clean financial records by excluding irrelevant transactions
Easily reverse decisions with Unignore events in accounting

Event Refresh & Synchronization

Multiple refresh options ensure your data stays current across all connected platforms:

Global Refresh

Use the main Refresh button to update all events across all connected accounts and platforms simultaneously.

Selective Refresh Options

By Chain Network

Refresh specific blockchain networks, with optional account-level filtering for targeted updates.

Exchange Events

Update events from specific exchange platforms without affecting blockchain data.

ETH Staking Events

Refresh Ethereum staking-related activities, including withdrawals and block production rewards.

Protocol Events

Update events from specific DeFi protocols and services, enriching blockchain data with protocol-specific information.

Refresh Process Overview

1

System queries transactions from the last update timestamp to current time

2

For EVM events, transactions undergo intelligent decoding processes

3

Decoded events appear in the interface with full contextual information

EVM Transaction Management

Event Redecoding

When transactions require reprocessing, RotkiX provides flexible redecoding options:

Individual Transaction Redecoding

Access the three-dot menu for specific transactions
Select Redecode events to reprocess individual transactions
Choose whether to reset custom events during the process

Bulk Transaction Redecoding

Use Redecode EVM Events at the page top
Reprocess all previously queried EVM transactions
Monitor progress through Transaction Decoding Status

Missing Transaction Recovery

Recover transactions that may have been missed during initial synchronization:

Manual Transaction Addition

Add specific transactions using their transaction hash through the Add transaction by hash feature.

Bulk Transaction Re-pulling

Use Repull transactions to recover missed transactions within specific time ranges, addressing issues from RPC errors or indexer problems.

Recovery Process

1

Select account(s) and time range for transaction recovery

2

System searches for previously missed transactions

3

Recovered transactions undergo automatic or manual decoding

4

Processed events appear in the history view with full details

Custom Event Management

Accounting Rule Validation

Missing Accounting Rule Indicators

Warning indicators highlight events that lack proper accounting rules, potentially affecting financial calculations. Address these by editing events or adding missing accounting rules.

Event Type Categories

RotkiX supports six distinct event types for comprehensive transaction categorization:

Transfer Events

Configure Event Type: Transfer with Event Subtype: None for non-taxable transfers between personal accounts.

Deposit/Withdrawal Events

Set Event Type: Deposit/Withdrawal with appropriate subtypes for exchange or protocol interactions that shouldn't affect taxable calculations.

Bridge Operations

Use Event Type: Withdrawal/Deposit with Event Subtype: Bridge for cross-chain asset movements.

Trading Events

Configure swap pairs with sequential Event Type: Trade events using Spend and Receive subtypes with proper sequence indexing.

Reward & Airdrop Events

Categorize rewards with Event Type: Receive and Event Subtype: Reward/Airdrop for proper tax classification.

DeFi Protocol Interactions

Handle wrapped token interactions with Receive Wrapped/Return Wrapped subtypes for protocol-specific events.

Staking & Migration Events

Use Event Type: Staking for staking deposits and Event Type: Migration for protocol migrations with balanced spend/receive pairs.

Informational Events

Set Event Type: Informational with Event Subtype: None for events that provide context but shouldn't affect accounting calculations.

Customization Tracking

Modified events display visual indicators in the interface, ensuring transparency about which transactions have been manually adjusted for accurate reporting.

Query Status Monitoring

Real-time status tracking provides visibility into event processing operations, including individual address breakdowns and overall system progress indicators.

Staking Tracking

RotkiX provides comprehensive staking reward tracking across multiple networks and protocols. Monitor your staking positions, rewards, and performance metrics with detailed analytics and real-time balance updates.

Supported Staking Protocols

⚡

Ethereum Staking (ETH2)

Complete validator tracking with consensus layer rewards and MEV earnings

🏛️

Liquity Protocol

LQTY staking rewards and stability pool participation monitoring

🐙

Kraken Exchange

Centralized staking rewards across multiple supported assets

Ethereum Validator Management

Track Ethereum validators through two distinct approaches:

Automatic Validator Detection

Add the Ethereum account that initiated validator deposits. The system automatically identifies and tracks all associated validators.

Manual Validator Addition

1

Navigate to Accounts → EVM Account → Validators

2

Click Add account button

3

Input validator's public key and/or index number

4

Optional: Configure ownership percentage for shared validators

Validator Status Monitoring

Track validator lifecycle stages with comprehensive status indicators:

PENDING

Awaiting activation in validator queue

ACTIVE

Currently validating and earning rewards

EXITING

Initiated exit process from validation duties

EXITED

Completed exit with funds available for withdrawal

CONSOLIDATED

Merged with another validator post-Pectra upgrade

Validator Consolidation (EIP-7251)

Enhanced Ethereum Staking

The Pectra upgrade introduced validator consolidation, increasing maximum effective balance from 32 ETH to 2048 ETH. Validators with CONSOLIDATED status have been merged to optimize staking efficiency.

Consolidation Requirements:

Validator conversion to accumulating status
Withdrawal credentials update (0x00/0x01 → 0x02)
Additional ETH deposits capability
Cross-validator balance consolidation

Comprehensive Profit Tracking

Ethereum staking profits are calculated from multiple revenue sources:

Outstanding CL Rewards

Consensus layer balance exceeding maximum effective balance (32/2048 ETH)

CL Skimming Withdrawals

Automated profit withdrawals from consensus layer operations

Block & MEV Rewards

Block production rewards and MEV earnings (requires tracked receiving address)

Exit Calculations

Final profit calculation upon validator exit (exit amount minus deposits)

Daily Earnings Analytics

Access detailed staking performance through Staking → ETH menu. Track daily earnings summaries, current ETH price valuations, and historical reward calculations with CSV export capabilities for comprehensive analysis.

Liquity Protocol Integration

Monitor LQTY staking positions and stability pool participation with detailed reward tracking.

Stability Pool Tracking

Current LUSD deposits in stability pool
Unclaimed ETH and LQTY rewards
Historical deposit and withdrawal tracking

LQTY Staking Management

Staked LQTY balance monitoring
Available ETH and LUSD claim amounts
Comprehensive staking event history

Advanced P&L Calculations

Liquity statistics utilize queried events for precise calculations. Values can be displayed using historical prices (event-time) or current market prices.

Stability Pool Metrics

Total Gains: Combined value of claimed ETH and LQTY rewards
Net Deposits: LUSD deposited minus withdrawn amounts
Estimated P&L: Returns after LUSD-to-ETH/LQTY exchanges

P&L Formula Components:

A = Total Deposits - Total Withdrawals

B = Total Gains + Current Rewards

C = (A - Current Deposits) × Current Price

P&L = B - C

Kraken Exchange Staking

Track centralized staking rewards across Kraken's supported asset portfolio. Monitor gains and staking events for various digital assets through integrated exchange connectivity.

Multi-Asset Staking Support

Comprehensive tracking of staking rewards across Kraken's entire supported asset ecosystem with detailed event logging and reward calculations.

Statistics

Unlock powerful portfolio analytics with comprehensive statistical insights. Access detailed performance metrics, asset distribution analysis, and historical trend visualization through the Statistics section.

Portfolio Analytics Dashboard

Navigate to Statistics → Graph from the left sidebar to access your comprehensive analytics dashboard with advanced charting and performance metrics.

Net Value Progression

Monitor your complete portfolio evolution through time-series analysis of total net worth across all tracked assets and locations.

Snapshot-Based Analysis

Historical data begins from your first application usage, utilizing daily snapshot collection. Future enhancements will incorporate historical event data for extended timeline analysis.

Individual Asset Performance

Analyze specific asset performance with dual-layer visualization showing both quantity holdings and USD valuations over time.

Missing Snapshot Control

Configure the Missing snapshot multiplier to optimize graph display during zero-balance periods

Interactive Zoom Controls

Left-click and drag for range selection, or use bottom selectors. Double-click to zoom out completely

Historical Events Integration

Switch to Historical events and prices for detailed intraday data beyond snapshot intervals

Advanced Price Data

Automatic Price Population

Click Fetch prices to populate missing historical price points and enable detailed price movement analysis with daily granularity.

Data Source Comparison

Compare snapshot data with historical events simultaneously. Enable snapshot overlay through legend controls for direct data validation.

Persistent Preferences

Use Remember your selection to maintain preferred data source settings for individual assets across sessions.

Data Integrity Monitoring

Balance Mismatch Detection

Warning indicators highlight discrepancies between historical events and current balances. Common causes include incomplete data loading, manual balance configurations, or unrecorded staking/DeFi accruals.

Typical Resolution Steps:

Wait for complete data source synchronization
Verify manual balance and custom event consistency
Check for pending staking or DeFi reward events
Review event decoding accuracy and completeness

Portfolio Distribution Analysis

Location-Based Distribution

Visualize net worth distribution across different storage locations including exchanges, wallets, and traditional banking institutions. Assess counterparty risk exposure and diversification strategies.

Asset-Based Distribution

Analyze portfolio composition across individual assets and asset classes. Essential tool for rebalancing decisions and risk management strategies.

Snapshot Data Usage

Distribution charts utilize latest snapshot data rather than real-time balances. Create new snapshots to view most current distribution analysis.

Activity Event Analysis

Access comprehensive activity summaries through Statistics → Event Analysis menu for detailed transaction pattern analysis.

Transaction Summary

ETH spending patterns and gas usage analytics

Platform Usage

Exchange and protocol interaction frequency

Payment Analytics

Gnosis Pay and payment platform usage tracking

Strategic Insights

Event analysis provides actionable intelligence for optimizing transaction costs, identifying usage patterns, and improving portfolio efficiency across connected platforms and protocols.

Profit/Loss Report

Generate comprehensive profit and loss reports to analyze your portfolio performance and tax obligations. RotkiX processes your complete transaction history using advanced accounting methodologies to deliver accurate financial insights.

Advanced Accounting Methods

Choose from multiple industry-standard accounting approaches to match your regional requirements and tax strategies:

Available Calculation Methods

FIFO (First In - First Out)

Default method treating earliest purchases as first assets sold

LIFO (Last In - First Out)

Most recent acquisitions are considered first for sale calculations

HIFO (Highest In - First Out)

Highest-cost basis assets are prioritized for disposal calculations

ACB (Average Cost Basis)

Uses weighted average purchase price across all asset acquisitions

Tax-Free Period Configuration

Regional Tax Compliance

Configure tax-free holding periods to match your jurisdiction's regulations. Navigate to Accounting Settings to specify the required holding duration in days for tax-exempt status.

Intelligent Balance Management

RotkiX employs sophisticated balance tracking to ensure report accuracy across custom time periods:

Smart Period Calculation Example

1

Historical trading activity from 2017 to 2019

2

0.1 BTC balance recorded on December 31, 2017

3

2018-2019 report automatically includes 0.1 BTC as opening balance

4

Ensures complete accuracy for partial-period analysis

Report Generation Process

Step-by-Step Creation

1

Access Profit and Loss Report from the left navigation menu

2

Select your preferred time period from preset options or choose Custom for specific date ranges

3

Click Generate to initiate comprehensive report processing

4

Monitor progress during calculation period (may require several minutes for extensive histories)

Pre-Generation Checklist

Verify all transactions are properly imported and categorized
Review accounting settings in the Accounting settings section
Ensure historical price data is available for all relevant assets
Confirm tax-free period settings match your jurisdiction requirements

Report Management & Storage

Report History

Access all previously generated reports from the main interface
View, review, or export historical calculations
Storage limit of 20 reports for optimal performance

Export & Analysis

CSV export functionality for spreadsheet integration
Google Sheets optimization for seamless import
Detailed event breakdowns with cost basis information

Report Analysis & Interpretation

Comprehensive Financial Overview

Generated reports provide multi-layered analysis including:

Total Profit/Loss Summary

Complete period performance with taxable and non-taxable breakdowns

Event Category Analysis

Detailed contribution analysis by transaction type and tax category

Individual Event Tracking

Transaction-level profit/loss calculations with complete audit trails

CSV Export Specifications

Export Process

Click Export CSV to generate spreadsheet-compatible files optimized for Google Sheets integration. Select destination directory and import files through the Google Sheets import interface.

Export Limitations

CSV export functionality applies only to the most recently generated report within the current session. Historical reports require regeneration for export access.

Cost Basis Analysis

Cost basis calculations provide essential acquisition price information for accurate tax reporting across all supported trading platforms and protocols.

Supported Trading Venues

Centralized Exchanges

Complete trade history from all integrated exchange platforms

Decentralized Protocols

AMM transactions from Uniswap, SushiSwap, Balancer, and other supported DEXs

Manual Entries

User-defined trades and custom transaction records

Accessing Cost Basis Information

Report Table Navigation

Expand individual trades in generated P&L reports using arrow controls for detailed cost basis breakdowns

Spreadsheet Integration

Export reports to CSV format for comprehensive cost basis analysis in Google Sheets or LibreOffice Calc

Common Issues & Resolutions

Missing Acquisition Events

Problem Description

RotkiX cannot locate acquisition records for sold assets, preventing accurate cost basis calculations.

Resolution Steps

Add manual trades to document asset acquisition history
Create acquisition history events for missing purchase records
Verify all exchange connections and data imports are complete
Check for unsupported exchange or protocol transactions

Price Data Unavailability

Problem Description

Missing historical price data prevents accurate profit/loss calculations for specific timestamps.

Resolution Steps

Manually input missing prices through the price management interface
Access Manage historical price cache for bulk price additions
Ensure profit currency matches your reporting requirements
Verify asset-to-currency price pairs are properly configured

Google Sheets Import Issues

Problem Description

CSV formula import errors due to regional language configurations in Google Sheets.

Resolution Steps

Navigate to File → Spreadsheet settings → General → Locale
Change locale setting to "United States"
Re-import CSV files using updated language configuration

Unexpected Results

Problem Description

Generated P&L results don't match expectations based on trading activity.

Resolution Steps

Review accounting method settings for appropriate calculation approach
Verify tax-free period configuration matches jurisdiction requirements
Check event categorization and custom transaction labels
Validate all trading data imports are complete and accurate

Advanced Debugging Support

Debug Data Export

Developer Support Tool

For complex errors during report generation, export P&L debug data enables complete issue replication and resolution. Share debug data exclusively with developers due to sensitive information content.

When to Use Debug Export

Multiple event processing errors during report generation
Persistent calculation inconsistencies across reports
Unresolved issues after standard troubleshooting steps
Complex multi-platform trading scenario conflicts

Tag Management

Organize and categorize your accounts, transactions, and assets using RotkiX's comprehensive tagging system. Access tag management through the left sidebar for streamlined portfolio organization.

Tag Creation & Management

Create custom labels to enhance portfolio organization and analysis. Tags provide flexible categorization for accounts, transactions, and manual balances.

Unique Label System

Each tag requires a unique identifier, preventing duplicate labels across your portfolio

Multi-Context Creation

Create tags directly when adding blockchain accounts or manual balances

Visual Customization

Assign custom colors and descriptions for enhanced visual organization

Flexible Application

Apply tags across accounts, transactions, and custom events for comprehensive categorization

Tag Management Process

1

Navigate to Tag Management from the left sidebar

2

Create new tags or edit existing ones through the management interface

3

Configure tag properties including name, description, and color coding

4

Apply tags to relevant accounts, balances, and transactions for improved organization

Assets Management

Manage your comprehensive asset database with RotkiX's advanced asset management system. Configure supported assets, create custom entries, and maintain accurate price feeds for optimal portfolio tracking.

Asset Management Categories

Asset management is organized into specialized sections for efficient administration:

Standard Assets

Manage the complete database of supported digital assets with full editing capabilities

Custom Assets

Create entries for unique holdings including real estate, collectibles, and traditional investments

Exchange Mappings

Configure asset mappings between exchanges and RotkiX's internal database

Token Detection

Review and manage newly discovered tokens with spam filtering capabilities

Adding Standard Assets

Create comprehensive asset entries with full metadata and price oracle integration:

Required Information

Core Details

Asset type classification
Blockchain network (for EVM tokens)
Token contract address
Asset name and symbol
Decimal precision configuration

Price Oracle Integration

CoinGecko identifier for price feeds
CryptoCompare identifier as backup
Custom icon upload capability
Automatic metadata fetching from contract

Price Oracle Setup

CoinGecko Integration

Obtain CoinGecko identifiers from the API endpoint or URL structure. For example, Ethereum uses ethereum as its identifier, derived from the CoinGecko URL structure.

CryptoCompare Configuration

Configure CryptoCompare identifiers as secondary price sources. Extract identifiers from CryptoCompare URLs - for example, ETH from the coins section identifier.

Optional Configuration Fields

Asset Lifecycle

Define asset deployment timestamp and existence parameters

Protocol Association

Link assets to specific protocols (Uniswap, Aave, Yearn, etc.)

Token Relationships

Configure token swaps and underlying asset compositions

Weighting Systems

Define underlying token weights totaling 100% for complex assets

Custom Asset Creation

Create entries for non-traditional assets that require manual tracking:

Real Estate Properties

Exchange-Traded Funds

Collectibles & Art

Traditional Investments

Custom Asset Configuration

Descriptive asset name (required)
Asset type classification with memory of previous types
Optional notes for additional context and documentation

Exchange Asset Mapping

Resolve asset recognition issues by creating mappings between exchange identifiers and RotkiX's asset database:

CEX Mapping Management

Link centralized exchange asset identifiers to prevent Asset XXX is not supported errors and ensure accurate balance tracking.

Counterparty Mappings

Configure asset recognition for any counterparty or protocol to maintain comprehensive tracking coverage.

Token Detection & Spam Management

Manage newly discovered EVM tokens with intelligent spam filtering:

Detection Workflow

1

Review newly detected tokens in the dedicated management section

2

Accept legitimate tokens for portfolio inclusion

3

Reject spam assets by adding to the ignored tokens list

4

Use whitelist functionality to prevent legitimate tokens from being auto-flagged

Asset Merging Operations

Consolidate duplicate asset entries to maintain database integrity:

Common Merge Situations

Custom to Official Migration

Merge custom asset entries with newly supported official assets to prevent balance splitting

Database Recovery

Resolve unknown asset notifications by re-adding deleted entries and merging old IDs

Merge Procedure

Access Merge Asset functionality from Asset Management
Input source asset identifier (copy from asset table or notification)
Select target asset for consolidation
Execute merge and refresh balances to reflect changes

Special Asset Categories

Configure specialized assets requiring unique handling:

LP Token Tracking

Configure Uniswap/SushiSwap liquidity pool tokens using UNI-V2 protocol designation for automatic balance and price queries

Yearn Vault Integration

Set up Yearn vault tokens with yearn_vaults_v2 protocol and specify underlying token relationships with 100% weight allocation

Asset Filtering & Whitelisting

Control which assets appear in calculations and balance queries:

Individual Asset Control

Toggle ignore status for specific assets through table switches or asset overview pages

Bulk Management

Use checkboxes for simultaneous ignore/unignore operations across multiple assets

NFT Filtering

Navigate to Balances → NFT Balances for NFT-specific ignore controls and filtering

Spam Protection Whitelist

Automatic Spam Detection

RotkiX employs intelligent algorithms to automatically identify and ignore spam assets. Use the whitelist feature to prevent legitimate tokens from being incorrectly flagged.

Whitelist Management

Review ignored assets through Manage Assets → Assets with ignore filter
Add legitimate assets to whitelist to remove from ignore list
Whitelisted assets are protected from future automatic spam detection

Token Detection Troubleshooting

Resolve missing token issues through systematic verification:

1

Search for missing tokens in Manage Assets → Assets

2

Verify token is not ignored or marked as spam

3

Unignore tokens if incorrectly flagged, or whitelist to prevent future issues

4

Execute manual token detection to refresh asset discovery

Add Missing Prices

Maintain accurate portfolio valuations by manually adding price data when automatic price feeds are unavailable. Access comprehensive price management through the Manage Prices section.

Price Data Categories

RotkiX supports two distinct price data types for comprehensive valuation coverage:

Latest Price Entries

Current market prices displayed when showing real-time asset valuations

Historical Price Data

Time-specific pricing for accurate historical portfolio analysis and tax calculations

Manual Price Entry Process

1

Navigate to Manage Prices from the main menu

2

Click the plus button to open the price addition form

3

Select the target asset and specify price value

4

Configure date/timestamp for historical entries or current pricing

5

Save the entry to update the price database

Price Entry Configuration

Asset Selection

Search and select from complete asset database
Support for both standard and custom assets
Real-time asset validation

Price Specification

Precise decimal price entry
Currency pair configuration
Timestamp specification for historical data

Manual Price Visualization

UI Price Indicators

Manually defined latest prices display with distinctive orange indicators in the interface, accompanied by tooltips reading "Manually defined price" for clear identification.

Common Price Management Scenarios

Unsupported Assets

Add pricing for custom assets or newly launched tokens lacking automatic price feed integration

Historical Analysis

Populate missing historical prices for accurate tax reporting and performance analysis

Oracle Failures

Provide backup pricing when primary and secondary price oracles encounter data availability issues

Custom Valuations

Override automatic pricing for assets requiring specialized valuation methodologies

Best Practices

Accuracy Verification

Cross-reference manual prices with multiple sources to ensure valuation accuracy

Regular Updates

Establish routine price update schedules for assets requiring manual management

Documentation

Maintain records of price sources and methodologies for audit trail purposes

Address Book

Streamline blockchain address management with RotkiX's comprehensive address book system. Access through Manage Address Book in the sidebar to replace complex addresses with meaningful names across the entire application.

Address Book Categories

RotkiX provides dual-layer address management for flexible naming conventions:

Global Address Book

System-wide address names accessible to all users and sessions

Private Address Book

User-specific address names that override global entries for personalized organization

Address Entry Management

Create meaningful address labels that enhance transaction readability and portfolio organization. Use Save this name for all chains to apply names across all supported blockchain networks where the address appears.

Address Resolution Priority

RotkiX follows a structured resolution hierarchy for address display:

1

Private Address Book entries (highest priority)

2

Blockchain Account Labels

3

Global Address Book entries

4

Ethereum Token names

5

Hardcoded system mappings

6

ENS names (lowest priority)

Customizable Resolution Order

Modify address resolution priority through general user settings to match your preferred naming conventions and organizational requirements.

Bulk Address Import

Efficiently manage multiple address entries through CSV import functionality:

CSV Import Process

Access import feature through the three-dots menu
Prepare CSV file with required address and name fields
Optional blockchain and location specifications
Import multiple entries simultaneously for efficient setup

CSV Format Requirements

Required Fields

address - Blockchain address (required)
name - Display name (required)

Optional Fields

blockchain - Specific chain ID (blank for all chains)
location - global or private (defaults to private)

Address Book Benefits

Enhanced Readability

Replace complex blockchain addresses with meaningful names across all transactions and reports

Multi-Chain Consistency

Apply consistent naming across all supported blockchain networks for unified address management

Privacy Control

Maintain separate private and global address books for personalized organization

Bulk Management

Import multiple address entries efficiently through CSV format support

API Keys

Configure essential API integrations to unlock RotkiX's full functionality. Access comprehensive API key management through the API Keys menu in the sidebar for exchanges, external services, and premium features.

API Integration Categories

RotkiX Premium Integration

Configure premium API credentials to access advanced features and enhanced functionality. Manage API key and secret pairs directly through the premium settings interface.

Premium Key Management

Input premium API key and secret credentials
View existing premium subscription details
Replace or disassociate keys as needed
Delete premium credentials through the same interface

Exchange API Integration

Connect your trading accounts for comprehensive portfolio tracking across multiple platforms:

Supported Exchange Platforms

Kraken

Binance

Coinbase

Poloniex

Bitmex

Gemini

Bitstamp

Binance US

Bitfinex

Bitcoin.de

Iconomi

KuCoin

Independent Reserve

Bitpanda

OKX

Woo

Bybit

HTX

Exchange API Setup Process

1

Generate API credentials on your exchange platform with read-only permissions

2

Navigate to API Keys → Exchanges in the left sidebar

3

Click Add an exchange to open the configuration menu

4

Enter API Key, API Secret, and additional credentials as required

5

Configure synchronization settings and save the integration

API Key Permissions

Security Best Practices

RotkiX requires only read-only permissions for secure account access. Most exchanges group read-only permissions under "read" or "view" categories for simplified configuration.

Permission Configuration Guidelines

Start with minimum read-related permissions and test connectivity
Add additional read permissions if initial connection fails
Never grant trading or withdrawal permissions
Consult exchange documentation for granular permission schemes

Platform-Specific Configuration

Kraken Integration

Specify your Kraken account verification level when configuring API access. Account type selection depends on your verification status within the Kraken platform.

Binance Optimization

Enhance query performance by specifying target market pairs in the Filter market pair(s) configuration. This reduces API requests and prevents rate limit issues.

Synchronization Management

Enable or disable exchange synchronization as needed
Consider disabling frequent syncs to avoid IP restrictions
Monitor connection status and resolve timestamp synchronization issues
Note: Margin and futures trading are not currently supported

External Service APIs

Integrate essential external services for comprehensive data access and enhanced functionality:

Why External APIs Are Essential

Historical Price Data

Access comprehensive price feeds for accurate portfolio valuation

Transaction Data

Retrieve complete EVM transaction histories from blockchain indexers

Enhanced Performance

Significantly improve query speeds and data availability

Essential Service Integrations

Etherscan API

Strongly recommended for EVM chain data. Free API keys provide substantial speed improvements over public endpoints. One unified key works across all EVM networks.

The Graph Protocol

Required for Balancer balance queries and ENS data retrieval. Ensure API key authorization for relevant subgraphs after creation.

CoinGecko API

Primary price data provider. Free tier available with paid options offering higher rate limits for intensive usage.

DefiLlama Integration

Alternative price data source. API key optional but provides enhanced rate limits for premium users.

Specialized Protocol Integration

Loopring Balance Access

Configure Loopring API access for complete balance detection:

Visit Loopring Security interface and unlock your account
Select Export Account from available options
Add generated API key to RotkiX Loopring section
Verify balance integration in the main dashboard

Monerium Integration

Enhanced Transaction Data

Monerium integration enriches blockchain transactions with banking information across Mainnet, Polygon, and Gnosis chains, displaying IBAN details and bridging data.

Security Considerations

Monerium currently uses basic authentication requiring username and password storage. Credentials are encrypted but consider security implications before proceeding.

Gnosis Pay Integration

Premium feature providing comprehensive transaction import capabilities:

Session Token Configuration

1

Login to Gnosis Pay web application

2

Open browser developer tools and navigate to Application tab

3

Access Cookies section and locate __Secure-authjs.session-token

4

Copy token value and paste into RotkiX Gnosis Pay configuration

Token Security

Session tokens provide read-only access to Gnosis Pay data with no trading or transfer capabilities.

API Management Best Practices

Security First

Always use read-only API keys and regularly rotate credentials for enhanced security

Rate Limit Management

Monitor API usage and consider paid tiers for services with usage limitations

Connection Monitoring

Regularly verify API connections and update expired or deprecated credentials

Import CSV

Integrate trading data from external exchanges and platforms through RotkiX's comprehensive CSV import system. Access import functionality through Import Data menu in the sidebar for seamless data migration.

CSV Data Import Process

Import exchange data from platforms without API integration or for comprehensive historical data beyond API limitations:

1

Export CSV files from your trading platform or exchange

2

Navigate to Import Data section in RotkiX

3

Select your CSV file and configure data source settings

4

Configure custom date formats if required

5

Execute import and verify data integration

Date Format Configuration

Custom Date Format Settings

When your CSV file uses non-standard date formatting:

Enable Use custom date format option during import
Specify your CSV's exact time format pattern
Verify format compatibility before proceeding with import

Supported Exchange Platforms

RotkiX provides specialized import support for numerous exchange platforms:

Cointracking.info

Trade CSV import with data completeness warnings

Binance.com

Enhanced CSV support beyond API capabilities

BitMEX

Complete trade and transaction history import

Bitstamp

Trading data with import validation

Bittrex

Legacy exchange data for historical records

Bisq

Decentralized exchange trading records

BlockFi

Dual CSV support for trades and transactions

Blockpit

Trading and activity data integration

Bitcoin.tax

Trades, income, and spending records

Crypto.com Mobile

Mobile app transaction data import

KuCoin

Trading CSV file integration

Nexo

Transaction history import support

ShapeShift

Trade data with DEX transaction filtering

Uphold

Activity page transaction history

Enhanced Import Capabilities

Binance Advanced Features

Import trades, deposits, withdrawals, BNB conversions, ETH 2.0 staking, Launchpool interests, and POS savings beyond API limitations

BlockFi Comprehensive Data

Separate CSV imports for trading activities and general transaction records

Uphold Transaction Processing

Automatic differentiation between transactions and trades based on currency pairs

Generic Import System

Import data from unsupported platforms through RotkiX's flexible generic import framework:

Generic Trades Import

Standard trading data format for universal exchange compatibility:

Required CSV Headers

Location: Data source identifier

Spend Currency: Asset sold or spent

Spend Amount: Quantity spent

Receive Currency: Asset acquired

Receive Amount: Quantity received

Timestamp: UTC milliseconds timestamp

Optional Fields

Fee and Fee Currency for transaction costs
Description for trade context and notes

Generic Events Import

Comprehensive event tracking beyond standard trading activities:

Supported Event Categories

Deposit

Withdrawal

Income

Loss

Spend

Staking

Event Import Format

Type - Event category from supported list
Location - Platform or service identifier
Currency and Amount - Asset and quantity
Timestamp - UTC milliseconds precision
Optional fee and description fields

Asset Identification System

Asset Identifier Requirements

Assets must be specified using RotkiX internal identifiers rather than symbols. ERC-20 tokens follow CAIP-19 format, while other assets use symbols or custom identifiers.

CAIP-19 Format Examples

Ethereum Mainnet USDT

eip155:1/erc20:0xdAC17F958D2ee523a2206206994597C13D831ec7

Format Structure

eip155:[CHAIN_ID]/erc20:[CONTRACT_ADDRESS]

Finding Asset Identifiers

Access asset identifiers through Manage Assets → Assets section and copy the identifier for any required asset.

Supported Location Identifiers

Use these location identifiers in your CSV imports:

Major Exchanges

kraken binance coinbase poloniex bittrex bitmex gemini bitstamp kucoin

DeFi Protocols

uniswap sushiswap balancer loopring

Other Categories

external blockchain banks equities realestate commodities

Calendar

Organize and track important portfolio-related events with RotkiX's integrated calendar system. Monitor upcoming deadlines, set reminders, and maintain comprehensive activity scheduling.

Calendar Management Features

The calendar interface provides comprehensive event tracking with customizable notifications and reminder systems:

Event Scheduling

Create custom events with detailed descriptions and categorization

Reminder System

Configure advanced notification timing for important deadlines

Today's Overview

View current day events and upcoming activities in the right panel

Automatic Events

System-generated events based on blockchain activity analysis

Event Creation & Configuration

Create detailed calendar events with comprehensive notification and management options:

Event Configuration Options

Notification Settings

Notify me at event time - Real-time event notifications
Customizable reminder timing before events
Multiple notification methods available

Event Management

Delete event once it has passed - Automatic cleanup
Event categorization and tagging
Detailed descriptions and context notes

Storage Optimization

Enable automatic event deletion after completion to maintain optimal system performance and reduce storage requirements.

Automated Event Detection

RotkiX intelligently generates calendar events based on blockchain activity analysis:

Supported Automatic Events

ENS Domain Management

Domain expiration notifications
Renewal deadline reminders
Registration timeline tracking

Automatic Event Configuration

Customize automatic event generation through the calendar settings interface:

Configure notification timing for automatic events
Enable or disable specific automatic event categories
Adjust detection sensitivity and frequency
Set custom reminder periods for different event types

Event Notification System

Comprehensive notification framework ensures you never miss important portfolio-related deadlines:

Event Reminders

Configurable advance notifications before scheduled events with customizable timing

Real-time Alerts

Immediate notifications when events occur, with optional disable functionality

Google Calendar Integration

Synchronize RotkiX calendar events with Google Calendar for unified schedule management:

Integration Setup Process

1

Click the settings cog button on the calendar page

2

Select Connect to Google Calendar to initiate authentication

3

Complete Google authentication in the opened browser window

4

Choose your Gmail account and grant calendar access permissions

5

Click Sync Now to transfer events to Google Calendar

Integration Benefits

Cross-Platform Access

Access RotkiX events through Google Calendar on any device

Enhanced Notifications

Leverage Google's notification system for comprehensive alerts

Unified Schedule

Integrate portfolio events with personal and professional calendars

Linux Desktop Integration

Linux Electron app users may experience authentication in a clean browser window. For enhanced compatibility with passkeys or existing Google sessions, copy the authentication URL to your default browser.

Calendar Usage Best Practices

Event Organization

Use descriptive event titles and categories for easy identification and filtering

Reminder Timing

Set multiple reminders for critical events with varying advance notice periods

Automatic Cleanup

Enable event deletion after completion to maintain clean calendar views

Global Search

Accelerate your workflow with RotkiX's comprehensive global search functionality. Access instant navigation and actions through the search icon in the top bar or keyboard shortcut Ctrl+/ (Mac: Cmd+/).

Search Functionality

Global search provides instant access to navigation, actions, and information across the entire RotkiX platform:

Universal Navigation

Jump directly to any page or section within the application

Quick Actions

Execute common tasks like adding new trades without manual navigation

Asset Overview Access

Navigate directly to detailed asset information pages

Location Insights

Access comprehensive location-specific data and analytics

Using Global Search

1

Activate search using top bar icon or Ctrl+/ keyboard shortcut

2

Type your query for pages, actions, assets, or locations

3

Select from filtered results or execute suggested actions

4

Navigate instantly to selected destination or complete the action

Productivity Benefits

Rapid Navigation

Eliminate manual clicking through menus with instant page access

Context Switching

Seamlessly move between different portfolio areas and functions

Action Efficiency

Execute frequently used actions without interface navigation

Settings

Customize RotkiX to match your specific requirements and regional preferences. Access comprehensive configuration options through the user icon in the top right corner and select Settings.

Profit Currency Configuration

All calculations, including profit/loss reports, are computed in your selected fiat currency. Default currency is USD, but can be modified through the currency icon in the top right menu.

Account & Security Settings

Manage user credentials and security preferences through User & Security section:

Password Management

Update user password for enhanced account security through the dedicated password change interface.

General Application Configuration

Customize core application behavior and functionality:

Privacy & Analytics

Anonymous Usage Analytics - Optional data collection for application improvement
Anonymized metrics with no sensitive information transmission

Token Detection & Automation

Auto detect tokens - Automatic token discovery and balance refresh
Periodic historical event monitoring for new assets

Data Management

CSV Export preferences including date formats and delimiters
Automatic database sync with size discrepancy handling
Balance Snapshots Saving Frequency configuration

Ethereum Integration

Treat Staked ETH as ETH - Combined ETH/ETH2 display
EVM Chains for Automatic Detection configuration

Bitcoin Configuration

BTC Derivation Gap Limit for xPub address derivation
Customizable derivation parameters for wallet compatibility

Display & Formatting Options

Date & Time Configuration

Customize date display and input formats using standard formatting patterns like %m/%d/%Y %H:%M:%S for comprehensive time representation.

Amount Display Settings

Floating Precision - Decimal places for numerical display
Thousands Separator - Symbol for large number formatting
Decimal Separator - Floating point representation
Subscript Format - Consecutive zero formatting for small numbers
Amount Rounding - Round up, down, or half-even methods
Currency Location - Symbol placement before or after amounts

Large Number Handling

Configure Abbreviation for large numbers to display values like 1,234,567 as 1.23M with customizable minimum thresholds.

NFT Display Settings

Portfolio Integration

Include NFTs in Graphs and Total Amounts - Control NFT inclusion in net worth calculations and visual representations.

Image Rendering

NFT Images Rendering Setting - Privacy-focused image loading from all domains or specified whitelist only.

Database Administration

Database Information

Monitor user and global database metrics including directory location, storage size, and version information.

Backup Management

Create comprehensive database backups
Manage existing backup files with deletion capabilities
Local backup storage for data security

Data Purging

Clean cached data through Manage Data section. Remove exchange-specific data by first deleting associated API keys.

Asset Database Reset

Soft Reset - Preserve user-added assets
Hard Reset - Complete asset database restoration

Asset Migration

Cross-System Transfer

Export and import user assets between computers using zip archive format. This function facilitates system migration but cannot serve as version-compatible backup solution.

Accounting Configuration

Professional Tax Guidance Required

Consult qualified tax advisors before modifying accounting settings. Current defaults follow German tax regulations with FIFO methodology and one-year tax-free holding periods.

Trade Settings

Digital Asset Trading Rules

Crypto to Crypto Trades - Taxation of digital asset exchanges
EVM Gas Costs - Transaction fee treatment as losses
Tax Free Period - Holding period exemptions
Cost Basis Method - FIFO, LIFO, HIFO, or ACB selection
Include Fees in Cost Basis - Trading fee integration

Advanced Accounting Rules

Configure custom accounting rules based on event types, subtypes, and counterparty specifications for specialized tax scenarios.

ETH Staking Configuration

Omit ETH Staking Events - Control taxation timing for staking events relative to merge completion and withdrawal availability.

Price Oracle Management

Oracle Priority Configuration

Customize price source query sequence for both current and historical pricing data. Configure primary, secondary, and fallback oracle preferences.

DeFi Oracle Integration

Uniswap V2 and V3 oracles provide on-chain pricing data exclusively from Ethereum network sources. Slower queries but enhanced decentralization with potential price variations from centralized sources.

Historical Price Caching

Optimize performance through strategic price cache creation for frequently accessed asset pairs. Configure cache parameters through Oracle cache section with asset pair specifications.

Cache Administration

Create targeted asset pair caches using Cache pair prices
Manage existing cache entries with date range inspection
Delete outdated or unnecessary cache data

Blockchain Network Settings

RPC Node Configuration

Manage blockchain connectivity through custom node configuration with status monitoring and priority weighting:

Real-time node status indicators (green/red connectivity status)
Priority weighting system with percentage-based selection
Custom node addition with endpoint configuration
Automatic fallback to public nodes when private nodes are unavailable

Specialized Client Connections

Substrate Networks

Configure Kusama (port 9933) and Polkadot RPC endpoints with external service fallback capabilities.

Ethereum Consensus Layer

Set beacon node RPC endpoints with beaconcha.in fallback integration for validator tracking.

Module Performance Optimization

Module Activation Control

Optimize query performance by enabling only required modules and specifying target addresses for focused data retrieval.

Performance Enhancement Strategies

Selective module activation to reduce unnecessary queries
Address-specific filtering for targeted data collection
Re-login requirement for module configuration changes

Interface Personalization

Language & Localization

Experimental multi-language support with community translation contributions available.

Performance Optimization

Animation Effect reduction for improved performance
Automatic Balance Refresh configuration with interval settings
Periodic Status Query frequency adjustment

Privacy Features

Data Scrambling - Randomize displayed amounts and dates for secure screenshot sharing. Non-persistent privacy protection.

Graph Configuration

Dashboard Graph Default Timeframe pre-selection
Graph Basis - Y-axis origin configuration (zero vs. minimum value)

Address Display

Alias Name for Addresses - Configure resolution order for ENS names, address book entries, and account labels.

Premium Customization

Premium subscribers access advanced theme customization with color scheme modification for both light and dark mode interfaces.

Backend System Settings

Data Directory Management

Desktop application users can modify data and log directories through login screen backend settings. Previously created accounts require manual migration to new locations.

Advanced Configuration Parameters

Max log size - Single run log file size limits
Max number of log files - Backup log retention
Instructions per SQLite context switch - Database threading optimization
Log from other modules - Dependency library logging inclusion

System Tray Configuration

Control application tray icon visibility through View menu with Display Tray Icon toggle functionality.

Open Source Portfolio Analytics

Privacy First

Comprehensive Tracking

Open Source

Tracking Accounts & Balances

Blockchain Account Management

Supported Blockchain Networks

Ethereum Virtual Machine (EVM) Networks

Bitcoin-Based Networks

Substrate-Based Networks

Adding Individual Accounts

Bulk Account Addition

Universal EVM Account Addition

Advanced Bitcoin Account Management

Manual Address Entry

Extended Public Key (xPub) Integration

Understanding Extended Public Keys (xPub)

Bitcoin Address Format Types

xPub Implementation Guide

Key Implementation Notes

Account Management Operations

Edit Account

Remove Account

Refresh Balances

Advanced Filtering and Views

EVM Chain Filtering

ENS Name Resolution

Automated Token Discovery

Global Token Refresh

Chain-Specific Token Refresh

Individual Account Token Refresh

Historical Events

Automated Event Detection

Supported Event Categories

EVM Chain Transactions

Bitcoin Network Events

Exchange Activities

ETH Staking Events

Asset Movements

Swap Operations

Custom Event Management

Advanced Event Filtering

Account & Time Filters

Protocol & Location Filters

Advanced Technical Filters

Event Management Operations

Data Export Capabilities

CSV Export

Accounting Integration Control

Event Refresh & Synchronization

Global Refresh

Selective Refresh Options

By Chain Network

Exchange Events

ETH Staking Events

Protocol Events

Refresh Process Overview

EVM Transaction Management

Event Redecoding

Individual Transaction Redecoding

Bulk Transaction Redecoding

Missing Transaction Recovery

Manual Transaction Addition

Bulk Transaction Re-pulling

Recovery Process

Custom Event Management

Accounting Rule Validation

Missing Accounting Rule Indicators

Event Type Categories

Transfer Events

Deposit/Withdrawal Events

Bridge Operations

Trading Events

Reward & Airdrop Events

DeFi Protocol Interactions

Staking & Migration Events

Informational Events

Customization Tracking

Query Status Monitoring