Trouble with Importing Transactions from Multiple Exchanges - Assistance Needed!

Hi everyone,

I’ve recently started using Koinly to track my crypto transactions and calculate my taxes, but I’ve run into a few issues while importing data from multiple exchanges. I’m hoping someone here can help me troubleshoot this!

Here’s the situation:

  1. Exchange Data Import Problems: I’m using APIs to connect Koinly to Binance, Kraken, and Coinbase, but it seems like some transactions are missing or not categorized correctly. For example:
  • Binance API is skipping certain spot trades from a specific date range.
  • Kraken’s import isn’t picking up staking rewards.
  • Coinbase seems to duplicate some transactions, which throws off my portfolio balance.
  1. Manual CSV Upload Confusion: I tried manually uploading CSV files from these exchanges as a backup, but now I’m seeing duplicates of certain trades. Is there a proper process for reconciling this?
  2. Handling Transfers Between Exchanges: I frequently transfer assets between exchanges, but Koinly doesn’t always seem to recognize them as internal transfers. Instead, they show up as withdrawals/deposits, creating taxable events where there shouldn’t be any.

Questions I have:

  • How can I ensure API imports are accurate and complete?
  • What’s the best way to delete duplicates after CSV uploads without losing data?
  • Is there a workaround to make Koinly consistently recognize internal transfers?

I’d really appreciate any advice or tips from users who’ve dealt with similar issues. Are there specific msbi settings or steps I might be missing?

Thanks in advance for your help!

Regards
Ellis

Hi @EllisV

Thanks for your detailed message.

If you have duplicate transactions, it may mean that you are doing something wrong as in mixing API and CSv for the same wallet.

If the transfers between wallets are shown as deposits and withdrawals, it generally indicates that you have not added all your wallets, or in case the wallets (or one of them) were added via CSV files, the files have a different timezone that UTC+0:

How Koinly handles transfers between your own wallets

If you wish to ensure everything in your account is accurate, there are no duplicates and the transfers between wallets have been automatically picked up, I suggest you go through the steps in the article below:

How to ensure your Tax Report is accurate