Skip to main content

Some transactions are missing

Written by Jack

After importing all your wallets, you may notice that the data is incomplete. This can usually be identified by:

  • End balances (calculated) in the wallets do not match your actual holdings

  • Multiple "missing purchase history" warnings

This article outlines steps that can be taken to resolve the incomplete data before attempting any time-consuming manual fixes and also provides tips on how to approach them if manual edits cannot be avoided.

🧑‍🔧 How to fix incomplete data

Expand the relevant section for step-by-step instructions:

Exchange wallet (Coinbase, Kraken, etc.)

API-imported exchange

Try the steps below if you're facing incomplete data issues after syncing your centralized exchanges (Binance, Coinbase, Mexc, ByBit, etc.) using API:

  1. 👀 Review API limitations
    Check the known limitations of our integration - possibly, the data is not available and you need to add it manually or switch to a CSV import
    ​

  2. 🔄 Resync the wallet
    ​Trigger a full resync of the wallet
    ​

  3. 🆕 Recreate the wallet
    If resyncing didn't help - delete the wallet and add it again using API - be sure to follow our integration instructions precisely

    • This helps especially if you have a wallet added some time ago and we updated our integration since
      ​

  4. 🕵️‍♂️ Try to identify missing transactions
    If recreating the wallet didn't help - check if maybe only a few transactions are missing. Sometimes adding one-two transactions manually is all it takes. See How to Add Transactions Manually
    ​

  5. 🐞 Check for known issues (bugs)
    Go to our Feedback Portal (https://feedback.koinly.io) to see if there's a known issue for this exchange reported in "API/CSV issues" board - there's usually a workaround you can follow to fix the problem.

    • If you believe your wallet is affected by a new bug, contact our Support via our in-app chat
      ​

  6. 📄 Revert to a CSV import
    If there are too many errors to try to pinpoint the issue - delete the wallet and add it again using CSV files only (without connecting the API) due to Exchange API limitations.

    • Remember not to mix API and CSV together in one wallet as it often creates hard-to-find duplicates

    • As always, follow our integration instructions precisely
      ​

  7. 🔄 Reconnect API
    🚨 This step is not recommended as, usually, if the API was incomplete once it will continue providing incomplete data

    • If you still want to try connecting the API, then create the API key according to our integration instructions

    • When adding the API key/secret, you have to add the "Start import from" date (under advanced)

    • The date selected should be the date when the CSV files imported finished to avoid overlapping and potential duplicates

CSV-imported exchange

Try the steps below if you're facing incomplete data issues after importing your centralized exchanges (Binance, Coinbase, Mexc, ByBit, etc.) using CSVs:

  1. 👀 Review CSV limitations
    Check for known limitations in out integration instructions - possibly, the exchange doesn't provide your full transaction history and some activity has to be added manually.
    ​

  2. 🆕 Recreate the wallet
    ​Delete the wallet and add it again - be sure to follow our integration instructions precisely:

    • Check that you import only the files our instructions require - Importing other files may create duplicates

    • Avoid opening the files in Excel before importing them to Koinly

    • Be mindful of timezones - if the files are not in UTC, you need to offset them back to UTC (no matter your own timezone) - How to import a CSV file using a different timezone

    • You need to import your CSVs in the correct timezone before you attempt fixing any unmatched transfers

  3. 🐞 Check for known issues (bugs)
    Go to our Feedback Portal (https://feedback.koinly.io) to see if there's a known issue for this exchange reported in "API/CSV issues" board - there's usually a workaround you can follow to fix the problem.

    • If you believe your wallet is affected by a new bug, contact our Support via our in-app chat

Blockchain wallet (Ethereum, Solana, etc.)

API-imported blockchain

Try the steps below if you're facing incomplete data issues after syncing your self-custodial wallets (Ethereum, Solana, Cardano, XRP, etc.) using API:

  1. 👀 Review API limitations
    Check the known limitations of our integration - possibly, the data is not available and you need to add it manually
    ​

  2. 🔄 Resync the wallet
    ​Trigger a full resync of the wallet
    ​

  3. 🆕 Recreate the wallet
    If resyncing didn't help - delete the wallet and add it again using API - be sure to follow our integration instructions precisely

    • This helps especially if you have a wallet added some time ago and we updated our integration since
      ​

  4. 🕵️‍♂️ Review/adjust the imported data
    Possibly - the data isn't missing, it's just not properly interpreted.
    Blockchain activities tend to be more complicated than that on centralized exchanges. This is something you would fix while following How to ensure your Tax Report is accurate.
    ​

  5. 🐞 Check for known issues (bugs)
    Go to our Feedback Portal (https://feedback.koinly.io) to see if there's a known issue for this exchange reported in "API/CSV issues" board - there's usually a workaround you can follow to fix the problem

    • If you believe your wallet is affected by a new bug, contact our Support via our in-app chat

🕵️‍♂️ How to find missing transactions

If following the steps above didn't help, you may need to investigate the discrepancy in detail. It's often hard to find the missing data since it's, well, missing - it's hard to say what isn't there!

Often, the only way to do it is by cross-referencing what you see in Koinly with what you see on the Exchange in question:

Side-by-side comparison

  1. View transactions in Koinly
    Go to the "Transactions" page in Koinly and filter by the exchange you want to investigate (e.g. Kraken)
    ​

  2. View transactions on the exchange
    Open a new tab in your browser, go to this exchange's website (e.g. kraken.com) and log in, then open the Transaction History section there
    ​

  3. Compare each transaction one-by-one:

    • Are the amounts the same in Koinly and on the exchange?

    • Is the fee accounted for (either separately or in sent/received amounts)?

    • Is the net change (e.g. how much USDT was deducted from your account) the same?

    • Is the time of the transaction the same (adjusting for the timezone)?

    • Is some transaction missing from Koinly that you can see on the exchange (usually - airdrops, loans, etc.)
      ​

  4. Add missing data
    If you find an error, you can edit the faulty transaction in Koinly or add the missing transaction manually. See How to add transactions manually

✳️ Common reasons for incomplete data

API-imported exchange wallet

  • Known limitations or issues (bugs)

  • CSVs added to an API-synced wallet

  • Missing token migrations or symbol changes

  • Manual edits

CSV-imported exchange wallet

  • Not all CSV required were imported

  • CSVs that aren't required were imported

  • Files imported in the wrong timezone

  • Historical data (previous years) wasn't imported

  • Known limitations or issues (bugs)

  • Manual edits

API-imported blockchain wallet

  • Known limitations or issues (bugs)

  • Missing deposits to EVM L2 when using native bridges

  • Data review not yet completed, in particular:

    • Staking/unstaking

    • Unrecognized liquidity transactions

    • Wrong token identified

  • Rules that delete legit transactions (spam rules, edit rules)

  • Manual edits

↩️ How to undo manual changes

Sometimes you notice that the changes introduced did more harm than good and you want to undo them. To do so:

Often it's easier and faster to just delete the wallet and start over than trying to pinpoint every incorrect edit done.

Did this answer your question?