How to Reconcile Missing or Duplicate Crypto Transactions

This guide walks you through finding and fixing missing or duplicate cryptocurrency transactions in your records before you file taxes. You’ll learn to compare your wallet and exchange data against your tax software, correct errors, and end up with a complete, accurate report that matches your actual activity.

What You’ll Need

Your crypto tax software account (or spreadsheet if you do it manually)
Access to every exchange and wallet you used during the tax year
Your transaction history exports (CSV files) from each platform
Your wallet addresses and any staking or DeFi platform records
A list of transfers between your own wallets (these often cause duplicates)

Step-by-Step

Export all transaction history. Log into each exchange and wallet, and download the full transaction history for the tax year. Use the platform’s official export feature (usually under Reports or Statements). Save each file in a clearly named folder.
Import everything into your tax software. Upload or connect each exchange and wallet. If you’re using a spreadsheet, paste all transactions into one master sheet with columns for date, type, amount, asset, value, and platform.
Run a preliminary report. Generate an unrealized or realized gain report for the tax year. Note the total number of transactions and the final gain/loss figure. This is your baseline.
Check for missing transactions. Compare your software’s transaction list against your exchange exports. Look for gaps in dates, missing types (like airdrops, staking rewards, or fees), or assets that appear in the export but not in the software. Add any missing entries manually.
Identify duplicates. Sort transactions by date and amount. Look for identical entries that appear twice—often caused by importing the same CSV twice, or by software that pulls data from both an API and a manual import. Mark duplicates for removal.
Reconcile transfers between your own wallets. For each transfer, ensure it appears as an outgoing transaction on one wallet and an incoming on another. If both are present, they should not be double-counted as a sale or purchase. In most software, you can link them as a “transfer” to avoid creating a taxable event.
Match cost basis across wallets. If you moved coins from one wallet to another, your software should carry over the original cost basis. Verify that the acquisition date and cost basis for each coin in the receiving wallet match the sending wallet’s records.
Correct any errors. Fix wrong dates, amounts, or missing fee entries. Ensure that every transaction has a fair market value in USD (or your local currency) on the date it occurred. Use a reliable price source if your software didn’t auto-fill it.
Re-run your report. After adding missing items and removing duplicates, generate the report again. The transaction count and gain/loss should change. Compare against your baseline to confirm the differences make sense.
Do a final sanity check. Review the summary totals for each asset. Confirm that the ending balance for each coin matches your actual wallet balances as of December 31. If not, trace back to find the missing or extra transaction.

Common Mistakes

Importing the same CSV twice—this is the most common cause of duplicates. Always check your import history.
Ignoring small amounts—even tiny airdrops or staking rewards are taxable income in many jurisdictions. Missing them will cause a mismatch.
Mixing up transfers and trades—a transfer between your own wallets is not a taxable event, but a trade is. Make sure your software categorizes them correctly.
Using the wrong cost basis method—if you change methods (e.g., FIFO to specific identification), your gains will change. Stick to one method for consistency.
Forgetting about fees—transaction fees paid in crypto are often deductible as part of the cost basis or as an expense, but they must be recorded separately.

Tips

Do this before you start your tax return—it’s much easier to fix errors now than after you’ve filed.
Use a dedicated crypto tax tool—it will automatically fetch prices and handle many of these steps, but you still need to verify.
Keep a log of what you did—if you manually add or delete transactions, note the reason and date. This helps if you’re audited.
Check your wallet addresses—if you reused an address, ensure all transactions are captured. Some software might miss deposits to an address you didn’t import.
Reconcile monthly—if you have a lot of activity, do this monthly so you don’t face a huge backlog at tax time.

Troubleshooting

Your software shows a different balance than your wallet. This usually means a transaction is missing or duplicated. Export your wallet’s raw transaction list and compare it line by line with your software’s list for that asset.
You can’t find a transaction that your exchange says exists. Your exchange might have delayed the export. Try exporting again after a few hours, or check if the transaction is pending.
Your cost basis is wrong after a transfer. Some software doesn’t automatically link transfers. Manually set the acquisition date and cost basis on the receiving side to match the sending side.
You have too many transactions to manually check. Use your software’s “duplicate finder” feature if available. Otherwise, filter by date and amount—duplicates often have identical timestamps.
You’re still off by a small amount. Check for rounding differences in the price data. Use the same price source for both sides, and ensure you’re using the same decimal places.

Frequently Asked Questions

What counts as a duplicate transaction?

Any transaction that appears more than once in your records. This often happens when you import the same CSV twice, or when your software pulls data from both an API and a manual upload.

Do I need to report transfers between my own wallets?

Yes, you need to report them for tracking purposes, but they are not taxable events. You’re just moving your own assets, so there’s no gain or loss.

What if I can’t find a transaction’s historical price?

Use a reputable price aggregator that provides historical data. Many crypto tax tools have built-in price oracles. If you’re doing it manually, use the price at the exact timestamp if possible, otherwise use the daily average.

Can I just estimate missing transactions?

No. Estimates can lead to underreporting or overreporting, which may trigger penalties. It’s better to spend time finding the exact data. Most exchanges keep records for years.

What if my exchange was hacked and I lost records?

You should have your own records from when you made the transactions. If not, contact the exchange’s support for a statement. If that’s impossible, consult a tax professional about how to handle it.

How do I know if my cost basis method is correct?

You should have chosen a method (like FIFO, LIFO, or specific identification) when you first started using crypto tax software. Consistency is key. If you’re unsure, check your software’s settings or ask your tax advisor.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →