TLDR: CoinTracking supports importing MEXC transactions via API or CSV, but both methods have limitations. Spot trades should be imported using only one method (API or CSV) to avoid duplicates. Several transaction types are not supported due to incomplete or missing data from MEXC's side. Neither the CSV nor the API import can ever be 100% complete or accurate, so some manual rework is usually needed to get a fully correct portfolio and tax report.
Are There Limitations When Importing MEXC Transactions?
Yes, there are CSV import limitations on the MEXC side. MEXC CSV export file contains only the data from the past 540 days (18 months).
In general, keep in mind that data provided by MEXC (via CSV or API) is not always complete or 100% correct. Even after a successful import, some manual corrections may be necessary to make sure your trades, cost basis, and balances are accurate.
Can I Use Both CSV and API Importers?
No. The MEXC API and CSV importers are not compatible for spot trades. Using both methods at once may result in duplicate transactions.
Recommendation: Delete all previously imported transactions before switching import methods.
What Does the API Import Exclude?
Due to limitations in the API, the following transaction types will not be imported:
- P2P Trading
- PUSH Trading
- Margin PnL
- Futures PnL
- Earn Features
- Leverage & Index ETFs
What Does the CSV Import Exclude?
Similarly, the CSV exports provided by MEXC do not contain complete data for the following:
- P2P Trading
- PUSH Trading
- Margin PnL
- Earn Features
- Leverage & Index ETFs
- Internal Transfers
Which File Should I Use for the MEXC Excel Import?
When using the Excel Import for MEXC, make sure to use the Trade History file. The Order History file does not contain the correct data and should not be used for import.
Why Are My USDT Purchases Missing or Incorrect?
Not all USDT purchases are delivered correctly by MEXC through the CSV or API import. If you notice missing or incorrect USDT buy transactions, you can manually correct this by converting the entry into a Trade: Buy USDT / Sell EUR (or the fiat currency you actually used).
Why Is My Profit or Cost Basis Incorrect?
If transactions are missing or incomplete (for example due to the exclusions listed above, or the USDT purchase issue), the cost basis for a coin may be missing. When the cost basis is missing, CoinTracking has no purchase price to offset against the sale, which means the full sale amount may be taxed as profit instead of just the actual gain.
To avoid this, make sure all buy/acquisition transactions are present in your account. Manually adding missing trades restores the correct cost basis and profit calculation.
What Should I Do If My Transactions Are Missing?
You can manually add the missing data using:
- The Transactions page
- The Excel Import (using the Trade History file for MEXC)
- The Custom Exchange Import
These methods are flexible and support bulk uploads.
For more complex cases, for example large amounts of missing data, unclear cost basis, or intricate tax situations, it's recommended to use the Premium/Full Service or consult a tax advisor to make sure your data and tax report are correct.