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. This report is one part of the broader 'How to validate my account' process, which also includes the Transaction Flow Report and the ValiCheck pages.
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.
How Do I Find Warnings in My Account?
To locate warnings related to missing or mismatched transactions, go to your transaction list and search for the term "Warning" combined with the relevant date. This lets you quickly jump to the specific entries that CoinTracking has flagged, instead of scrolling through your entire transaction history.
What Is the Most Common Cause of a Warning?
The two most frequent reasons a transfer triggers a warning are:
Incorrect transfer order – the deposit is recorded as happening before the withdrawal (it should always be withdrawal first, deposit second).
Incorrectly entered fees – fees that don't match the actual amount deducted during the transfer, which throws off the amount-matching logic.
In What Order Should I Fix Missing Transactions and Warnings?
To work through issues efficiently, it's recommended to follow this order:
First, resolve all missing transactions (i.e., transfers with no matching counterpart at all).
Then, work through your oldest warnings first and move forward chronologically.
Fixing issues in this order prevents newer, correct entries from being affected by unresolved older discrepancies.
How Can I Use the Transaction Flow Report to Check Warnings?
The Transaction Flow Report provides an additional way to review warnings, including an option for portfolio separation, which makes it easier to see where a mismatch originates when you're tracking multiple wallets or exchanges. Use this report alongside the Missing Transactions Report to get a fuller picture of where your data doesn't line up.
What Are ValiCheck Pages and How Do They Help?
The ValiCheck pages are part of CoinTracking's account validation tools and come with their own FAQ covering the validation process step by step. If you're unsure how to interpret a specific warning or match quality, the ValiCheck FAQ is a good place to check for guidance tailored to that page.
Why Do Missing Transactions Cause Errors in My Tax Report?
If a transaction is missing its matching counterpart (for example, a deposit with no corresponding purchase or withdrawal), your tax report may show errors. Most commonly because there is no matching purchase on record for a sale or transfer. This can lead to incorrect gain/loss calculations. Resolving missing transactions and warnings before generating your tax report helps ensure the figures are accurate.
Can CoinTracking Support Fix Missing Transactions For Me?
Support is not able to make changes directly in a customer's account. If you'd like someone to review and correct your data on your behalf, this is handled through the Full Service offering rather than standard support.