TL;DR: The Missing Transactions Report in CoinTracking helps identify incomplete or mismatched transfers, primarily by checking for correctly paired deposits and withdrawals. Transfers are color-coded by match quality (Exact, High, Medium, Low, None). The goal is to ensure all your data is imported and matches correctly before generating a tax report. Common issues include missing exchange data, incorrect fees, wrong transaction types, or time mismatches. Fix these by ensuring all wallets/exchanges are imported, transaction types are correct, and fees and timestamps align.
What is the Missing Transactions Report?
The Missing Transactions Report is a tool in CoinTracking that shows transactions that lack a corresponding match (i.e., a deposit missing its withdrawal or vice versa). It's essential for identifying data gaps and ensuring accurate portfolio and tax reporting.
How Transfers Are Matched
CoinTracking considers a transfer as a pair: a withdrawal from one source and a deposit to another. The match quality is based on two main criteria:
Amount: Must match exactly or closely (default tolerance is ~95%).
Time: Must fall within a defined window (default: -24h to +48h).
Matches are color-coded:
Green (Exact/High): Ideal match. Amounts and times align perfectly or nearly so (may differ slightly due to fees).
Yellow (Medium): Deposit occurs before withdrawal, or amount is mismatched.
Orange (Low): Same as Medium but with greater discrepancy.
White (None): No corresponding match found..
Why Do Transactions Show as Missing?
Only one side of the transfer was imported (e.g., Binance but not Kraken).
Time gap between withdrawal and deposit exceeds 72 hours.
Incorrect/missing fees.
Duplicate transaction IDs from exchanges.
Merged deposits/withdrawals (e.g., multiple transactions grouped as one).
Wrong transaction types (e.g., airdrop incorrectly set as deposit).
Purchases marked as deposits instead of trades.
Expenses or losses marked incorrectly.