Coinpanda will calculate your portfolio balance based on the data imported. Because of small rounding errors in the data exported from exchanges, you might see a small (dust) balance for several coins/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.

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

Solution 1 - Add Send transactions

  1. Create a custom wallet, and give it a name like "Portfolio adjustment" for example

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

  3. Upload the Excel file to your custom wallet

Step 1 is strictly not necessary since you can upload the generic Excel file to any wallet, but we recommend uploading the file to a separate wallet to keep your transactions organized better.


You have some LTC and BNB dust and a few scam tokens you want to remove from your portfolio and tax report. Here is how 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:

Just upload the file to your wallet and the amount will disappear!

Solution 2 - Tag as Ignore

This will only work if you have received tokens that you want to remove from your portfolio/holdings, for example if you have received scam tokens to your ETH or BSC wallet.

Find the transaction on the Transactions page, and change the tag to Ignore by clicking the three dots menu and then Ignore. Transactions tagged as ignore will be excluded completely from all calculations.

Did this answer your question?