“MEXC API and CSV Import Issues: Missing Cost Basis, Missing Earn Interest, and Incomplete Trade History”

Koinly Support
#1

Wallet: MEXC (MEXC)
Transactions: 206
Imported with: API

  1. This API has certain limitations:
  2. 34 transactions are missing purchase history
    ---- Missing 0.00016891 BTC between 2025-12-29 02:31:07 UTC and 2026-02-02 21:28:03 UTC
    ---- Missing 0.27465102 XRP between 2025-12-27 22:35:43 UTC and 2025-12-28 09:42:05 UTC
    ---- Missing 0.00257769 ETH between 2025-09-17 19:51:31 UTC and 2025-12-27 14:32:53 UTC
    ---- Missing 677.39236868 USDT between 2025-09-15 21:20:09 UTC and 2026-01-18 03:30:35 UTC
    ---- Missing 0.50848242 USDC on 2025-09-16 09:12:27 UTC
    ---- Missing 3.49 MX on 2025-09-19 07:29:21 UTC
    ---- Missing 0.02268444 SOL between 2025-12-30 08:54:30 UTC and 2026-01-13 13:29:52 UTC
    ---- Missing 0.0000396 MXSOL between 2025-12-28 09:42:05 UTC and 2026-01-02 20:51:29 UTC
    ---- Missing 60.9876594 MXPOINT between 2025-09-15 20:21:14 UTC and 2025-10-10 14:20:04 UTC

Describe the problem:
After syncing my MEXC wallet, several issues appeared.

  1. The MEXC API only imports trades from the last 7 days and deposits/withdrawals from the last 6 months.
  2. It doesn’t include margin or futures data.
  3. Koinly reports 34 transactions with missing cost basis.
  4. Earn (Flexible and Locked) interest payments are not showing anywhere — not as Reward, Lending Interest, Other Income, or Deposit. I need to know how to correctly record Earn interest and fix the missing cost basis transactions.

Which exchange/wallet is this regarding?
MEXC (connected via API and manual CSV import)

How did you import data into this wallet?

  • MEXC API (limited to recent data)
  • Manual CSV imports for:
  • Spot Trade History
  • Futures Trade History
  • Deposit History
  • Withdrawal History
  • P2P Orders There are no official CSVs for Earn Flexible/Locked.

What have you tried to fix this so far?

  • Deleted and reconnected the API.
  • Imported all available CSV files from MEXC.
  • Checked the Type and Tag filters in Transactions.
  • Searched for Earn interest under Reward, Lending Interest, Other Income, and Deposit.
  • Reviewed the “Missing cost basis” panel.
  • Verified that the CSV files were not empty.
  • Tried mapping Earn manually, but Koinly does not accept those files.
#2

Hi @Drivan

Unfortunately, the API MEXC provides has some limitations that makes it not very practical for tracking your tokens and having a complete history.
​
Check out API Sync: Exchange API limitations.
​
I suggest you delete the MEXC wallet in Koinly, create a new one, follow the instructions in the guide below to export your entire transaction history from MEXC, and import the files into the new wallet. Then you should see your balances correctly.

Also, mixing API and CSV in the same wallet is not recommended.

https://koinly.io/integrations/mxc/