Topic: CoinTracking - Profit/Loss Portfolio and Tax Reporting for Digital Currencies - page 3. (Read 121790 times)

I've started receiving an error when the Gemini API import runs.
 
Error: Unsupported trade type: {"type":"Reward","status":"Complete","timestampms":1665291311158,"eid":146441192981,"currency":"SOL","am) "

I've also tried creating new API keys, but receive the same error.
Looking at the error message, perhaps related to the fact I had recently signed up to the Gemini Debit card and had SOL as the reward type at one point?

Thanks for any pointers.

Updates and Improvements

API
- Renamed exchange OKEX to OKX
- Bybit (more spot and deposit transactions, Live balance view)
- Coinbase (API update: support of Advanced Trades)
- Independent Reserve (Self Trades improved)
- Coinspot (Staking optimized)

CSV
- New CSV import: Phemex
- BSDEX (duplicate deposits removed)
- Nexo (credit card payments with loans improved, Transfers Nexo PRO added)
- Bybit (support for new format)
- Bitpanda (support for new format, Staking now supported)
- Bitpanda PRO (support for new format)
- Iconomi (new transaction types added)
- IDEX (date format adjusted)
- Binance (new EARN transaction types added, new format added)
- KuCoin (fees improved)
- Exodus (improved duplicate check)
- Poloniex (support for new format)
- Swissborg ('Thematic' trades added)
- Coinmerce (support for new format)

Blockchain
- Improvements for Elrond, Polkadot, Terra, Ethereum (see FAQ "My blockchain transactions are not imported correctly. Why?")
- Live View added for AVAX, BSC, Polygon and Fantom
- BTC xpub option to aggregate internal transfers

Other
- Several Coin Ticker updates
- Tax reports optimized (Germany, Austria, Excel Export options for some countries)
- 'NFT conversion' and 'price per unit' options added to 'Group edit'
- Jump button added to 'Trade List' and 'Transaction Flow Report'
- 'Enter Coins' view extended with additional columns
- iOS and Android App Fixes and Updates

Source: https://cointracking.info/new_features.php

There is no report for tax loss harvesting per se, but you can use the instant gain calculator to predict realized gains for a coin. You find this calculator on the gains page: https://cointracking.info/gains.php
Specific lot choose is not possible. You can use HIFO or any other method for your whole account.
But you could use depot/lot separation to reach the same target: https://cointracking.freshdesk.com/a/solutions/articles/29000038566?lang=en

For Loss harvesting

I've been buying and selling bitcoin to loss harvest bout $40k in unrealized $BTC gains.

But it's not showing up on my losses on cointracking.

Can you not quickly buy and sell for tax loss harvesting?

for instance if I had $10k on an exchange could I quickly buy and sell the $10k back and forth 4 times until the $40k is realized??

Updates and Improvements

API
- OKEX (new API version and optimizations)
- Poloniex (new API version)
- Bitfinex (new API version, futures PnL, Live Balance)

CSV
- Gemini (optimization of Earnings)
- Trezor (support for new format)
- Crypto.com exchange (support for new format)
- HitBTC (support for new format)
- Binance (import of cash voucher distribution)
- Coinbase (import of Learning Rewards, Advanced Trades via CSV only)
- Idex (support for new format)
- Nexo (support for new format)

Blockchain
- Improvements for Cardano (see FAQ "My blockchain transactions are not imported correctly. Why?")
- Cardano Live balance, Aggregate internal transfer option

Other
- Several Ticker updates for correct assignments and price history
- New Android app version
- Improvements for tax reports (Germany)
- Custom prices and NFT center
- 'Missing Transactions' report ("Jump" icon, new filter options & settings)
- New BETA imports and improvements (thank you for your feedback)

Source: https://cointracking.info/new_features.php

Are you still having this issue? I've been having the same issue.

Interestingly, I also don't see them listed in the "Buy, Sell & Convert History" .csv report.

Just try to hit "check now" or "update trade pairs". If it remains over the next days please let us know via ticket/E-Mail with details and your account name.

Then you have formatting issues in your Excel file e.g. ",," or "space bar at the end of an entry" etc. Please check the cells in your file again. And make sure you are using exactly our prefilled transaction types and avoid adding your own words there.

hi, thanks for your answer

now Im having an issue trying to import a modified excel template. import goes throught without any errors but entries are not appearing at the trade list page

@rndlvr
This blockchain is not supported by us yet. We are working on Top20 coin direct blockchain imports first. Once in place, we will announce it on our "new features pages". Thank you for your patience.
For now, you can enter the transactions either manually on the "Enter Coins" page, with the "Excel Import" or with the "Custom Exchange Import". Both are very flexible and customizable and data can be uploaded in a bulk action.

Hi,

Is https://andromeda-explorer.metis.io/ supported?

I have like 2000 trades on that chain... doing it manually would take a lot of time

Updates and Improvements
   
API
- Gemini (update for fees)
- OKEX (update for fees + fix for passphrase bug)
- Kraken (optimization for 'move to EARN')
- KuCoin (optimization for loans)
- Bibox (support for live balance)
- Binance (support for futures)
- Bybit (support for spot transactions)

CSV
- Trezor (update for Wallet ID Option)
- Binance (import of futures and cashback vouchers)
- NEXO (optimization for repayment and loans)
- Cake Defi (import of withdrawal fees)
- Swyftx (import of airdrops)
- OKCoin (import of fees)
- Coinmerce (support for new format)

Blockchain
- Optimization for Ethereum + Solana

Other
- Several updates to coin tickers
- BETA program (can be found in the advanced settings)

Source: https://cointracking.info/new_features.php

I am using https://cointracking.info. I am going thru the validation now, i just don't understand why these values would be pulling from two seperate locations, it seems like they should match.

@rdnkjdi
We are from CoinTracking.info. Cointracker might be another tool.
As always when there are warning please go through all Validation Checks as shown here: https://cointracking.freshdesk.com/a/solutions/articles/29000035339?lang=en

Cointracker shows I have 9403 balance on Solana. When I enter a sale transaction for this amount of Solana, it says that 18 Solana don't have a purchase price. Can someone explain what is happening? Screenshots here - https://imgur.com/a/hhPhyjM

Then you need to add custom price to those if they are not listed on our price sources. See those articles:
https://cointracking.freshdesk.com/en/support/solutions/articles/29000007214
https://cointracking.freshdesk.com/de/support/solutions/articles/29000007203-entering-ico-coins-and-non-listed-assets/en

Thank you!  I don't know how to handle Xsurge coins, there value is not pegged to the real coin.  There SBTC doesn't equal actual SBTC. So the normal article on handling wrapped and bridged assets doesn't work.

MOON2 will now be imported correctly via ETH Importer.

The MOON2 is coming in from an ETH wallet 0x452E2B704B863d774195Fb47C11Fd89ce383B872 as MOON

@bitkraft
It depends how LP is handled in your country - starting/ending LP as taxable or non taxable.