All Collections
Importing transactions
Common issues
Transactions imported incorrectly from CSV/XLSX file
Transactions imported incorrectly from CSV/XLSX file
E
Written by Eivind Semb
Updated over a week ago

If you import transactions by uploading CSV/XLSX files, you might experience some issues or unexpected transactions, which we will cover here.

Wrong symbol

This is a common issue that happens because CSV files exported from different exchanges or services might contain invalid symbols. A few examples are:

  • NEXONEXO

  • USDTERC20

  • USDT-TRX

While we do our best to interpret and identify currencies as accurately as possible and have already identified more than 600 symbol conflicts that are now handled correctly, this issue might still happen. The best way to get help with this is to create a post in our community forum or send a message in the Live Chat.

Missing or skipped transactions

Coinpanda can only import transactions and data that are recognized. Some files can contain data that we have never seen before, and these transactions will most likely be skipped for this reason. You can create a post about this in our community forum or send a Live Chat message.

Please note that Coinpanda will intentionally skip/ignore transactions that should not be imported. This includes internal transfers, transactions of zero amount, failed or canceled transfers, etc.

Fewer transactions were imported compared to the total number of rows

Some exchanges do not provide data that can be imported directly. One example is eToro, where Coinpanda needs to analyze the entire XLSX file and identify the transactions from a complex algorithm before the resulting transactions are imported to your wallet. This means you will see a very different number of transactions imported compared to the number of rows in the XLSX file. You will also most likely not recognize any of the values.

In other cases, Coinpanda will save a single daily transaction instead of importing hundreds or even thousands of transactions. This is typically done for trading fees and funding payments from futures exchanges such as Binance and Bitget.

More transactions imported compared to the total number of rows

For exchanges like Changelly, Easy Crypto, and Safello, you might see that the number of transactions imported is a lot higher than the total number of rows in the file. This happens because Coinpanda will automatically create a Receive + Trade + Send transaction for every row so that your internal transfers will be identified correctly.

Let's say you traded 1 BTC for 10 ETH on Easy Crypto. From this row in the CSV file, Coinpanda will import three transactions:

  • Receive: 1 BTC

  • Trade: 1 BTC β†’ 10 ETH

  • Send: 10 ETH

Did this answer your question?