All Collections
Calculations / cost basis
Common issues
Spam tokens and dust included in the tax report
Spam tokens and dust included in the tax report
Written by Eivind Semb
Updated over a week ago

Coinpanda will calculate your portfolio balance based on all transactions imported. Because of small rounding errors in the data exported from exchanges, you might see a small (dust) balance for several tokens that you actually don't own anymore. You might also see unknown tokens of insignificant value that were airdropped to your wallet without your knowledge, which are spam or phishing attacks in many cases.

Here is what you can do if you want to "clean up" your portfolio by removing such tokens:

Solution 1 - Add Send transactions

  1. Create a custom wallet, and give it a name like "Portfolio adjustment" or similar

  2. Add a Send transaction to the generic Excel file for every coin or token you want to remove. The amount should equal what you currently have in your portfolio

  3. Upload the Excel file to your custom wallet

The first step is strictly not necessary since you can upload the generic Excel file to any wallet, but uploading the file to a separate wallet might help organize your transactions better.


You have some LTC and BNB dust and a few spam tokens you want to remove from your portfolio and tax report. Here is what the Dashboard page looks like:

The next step is to add Send transactions in the Excel file for the coins you want to have removed. The coins will disappear from your portfolio after uploading the file to your wallet!

Solution 2 - Tag as Ignore/Spam

This will only work if you have received tokens you want to remove from your portfolio, such as spam tokens sent to your Ethereum or Polygon wallet.

Find the transaction on the Transactions page, and change the tag to Ignore by clicking the three dots menu and then Ignore. You can also select Spam, which will give the same result. Transactions tagged as ignore or spam will be excluded completely from your portfolio and all calculations.

Did this answer your question?