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

2 questions on using Uniswap

Many coins listed on DEXes have 'tax' to buy/sell said coin. 

Ex. Buy 1000 COIN but receive only 950 COIN with 50 COIN as tax, many times this goes to fund their devs/marketing whatever.  This is in addition to the ETH fee when executing transaction.

1. I'm assuming user can declare whichever they choose as the 'Fee' and 'Fee Currency' when importing the trade (COIN or ETH).  Or is there clarification on this?

2. How exactly are fees figured into the overall accounting?

Updates and Improvements

API
- Binance ('Convert' transactions now supported)
- MEXC (withdrawal fee improved)
- Coinbase (Airdrops and bonus/gift supported)
- Binance US (Staking and withdrawals improved)
- Bitfinex (Slider 'convert settlements in Trade' added, Margin profit/loss improved)

CSV
- Bitcoin Suisse (Market order now supported)
- NEXO (new transaction types now supported)
- Binance (larger file size now supported, fees improved, new transaction types supported)
- Phemex (positive funding fee imported)
- KuCoin (new CSV files supported)
- OKX (new transaction types supported, new file format supported)
- GEMINI (Withdrawal Amount improved)
- MEXC ('Futures Fund Flow' file supported, fee improved)
- Bitstamp (new file format supported)
- BSDEX (deposits imported)
- crypto.com (NFT transactions, Filled limit order and expenses supported)
- Coinmate (new file format supported)
- eToro (new transaction types supported)
- Bittrex (new file format supported)

Blockchain
- new BETA importers: BASE, LINEA
- improvements: PULSE, METIS, DFI, ATOM, LUNA, XRP - improved imports, TRON - transfer history supported (see FAQ "My blockchain transactions are not imported correctly. Why?")

Other
- Several Ticker updates for correct assignments, price histories and logos
- improvements of tax reports (US: remove incoming gift/tip from 'schedule 1 and 1040' form, non-taxable transactions added to export, Italy: crypto to crypto option added)
- Balance by Exchange - time filter and export added, Daily Balance - PDF export improved, Coins by Exchange - export added
- iOS and Android App Fixes and Updates (list commodities and their values on balance page)

We appreciate all the feedback we've received and we have already sent individual notifications to those who provided it. Thank you for your valuable input!

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

Updates and Improvements

API
- MEXC (error messages fixed due to new permissions)
- Coinspot (all trades with same timestamp imported)
- Bitget (trade pairs correctly imported now)
- Kraken (latest timestamp for deposits and earliest timestamp for withdrawals used)
- MEXC (withdrawal fee corrected)
- Bitpanda ('Crypto Index' transactions supported - not provided via Bitpanda CSV)
- Poloniex (Trades imported, live view improved)
- Bitfinex (claiming, settlement fee correctly imported now)
- Coinbase ('partial filled trades' and 'more advanced trades' imported now)

CSV
- NEXO (new file format supported, transaction description in comment)
- eToro (improvements for USD transactions)
- Bitget (fees improved)
- BingX (fees improved)
- bake (referal signup Bonus correctly imported, added voting rewards)
- Bison (stock fees imported now)
- Kraken (latest timestamp for deposits and earliest timestamp for withdrawals used)
- Haru Invest (Trades correctly imported now)
- crypto.com App ('precredit' & 'repayment' supported, unlock/lock/unfilled limit order not imported)
- BingX (all trades imported now)
- BSDEX (added support for new file format)
- GEMINI ('redeem' imported as withdrawal)
- NFTBank (new file format supported now)
- crypto.com exchange (new 'deposit_withdrawal' format supported now)

Blockchain
- New importer: Terra 2.0 BETA
- Improvements: ALGO - some withdrawals added, CRO - 'failed transactions' skipped, Solana - NFTs with N- Ticker imported now(see FAQ "My blockchain transactions are not imported correctly. Why?")

Other
- Several Ticker updates for correct assignments, price histories and logos
- Improvements of tax reports (General report: non-taxable income added, Germany - loss carried forward removed)
- New loan transaction types added (described in FAQ "Transaction Types")
- All CSV exports are in account timezone and CSV import options are using account timezone as well
- Balance by exchange and Coin by Exchange reports - option to hide exchanges that are no longer in use
- iOS and Android App Fixes and Updates (Exchange auto complete, show account name, notifications, added new transaction type support, price alert improvements, Auto Refresh and Reload)

We appreciate all the feedback we've received and we have already sent individual notifications to those who provided it. Thank you for your valuable input!

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

We support almost every date format (EU/US). If you have still issues please send a ticket/E-Mail with examples.

ok - thanks. I've ended up using most of the different approaches on https://cointracking.freshdesk.com/en/support/solutions/articles/29000007211-delete-some-or-all-transactions

---

What is the date format for Start Date on the Binance API import? I entered a date and it was ignored

---

...it's ok - I've edited it and it has accepted the Start Date.
If there are specific formats CT does / doesn't accept, it would be worth updating the API import page with brief instructions, next to the Start Date.

Yes correct. Or use manual deletion with search/sort option on enter coins page: "Delete and edit some or all transactions" https://cointracking.freshdesk.com/en/support/solutions/articles/29000007211-delete-some-or-all-transactions

I'm trying to work out if I can use Bulk Edit/Delete to:
Delete all Binance Trades where Type = "Interest Income" or "Other income" and date is before 2023.01.01

It doesn't seem I can do this directly with Bulk Delete
I think the only way I can do this in CT is to use Bulk Edit and create a brand new exchange based on the above criteria (e.g. "TempExchange"), and then go to Bulk Delete and delete all trades in TempExchange.
I'd need to do this twice, once for Type = "Interest Income" or and once for Type = "Other income"

Is that correct?

You need to summarize/aggregate them manually.

I'm aggregating about 20,000 daily interest payments into about 700 monthly payments.
I don't need 20,000 daily interest payments in CT.
I don't believe CT has implemented the ability to aggregate interest payments, so I've written my own code to make the changes outside of CT - please correct me if this functionality does exist.

I think my only option is to follow the instructions you gave for "Start from scratch"

We do not recommend doing this at all, but if you want to do it you need to delete all data first as shown here: "Start from scratch - delete all data and import again" https://cointracking.freshdesk.com/a/solutions/articles/29000031892?lang=en
We rather recommend creating a second account restore there your backup, make the adjustments, create a backup in the 2nd account and restore it then to the first account: "Create backup, restore or export your account data" (https://cointracking.freshdesk.com/a/solutions/articles/29000031008-create-backup-restore-or-export-your-account-data/en)

I've done a full CSV Export and have been making changes to the data.
When I do a CSV import, at https://cointracking.info/import/import_csv/ does it:
1. append the upload to the existing data in CT?
or 2. remove all existing data from CT and replace it with the CSV import?

If it is number 2, how do I delete everything in CT before I do the CSV import?
I have made a backup.

regards,
dr1ver

You are the first one asking for this chain. We add it to our long list. Thank you for your patience.
For now please use the manual options to add your transactions.

Any plans for imports from Kaspa blockchain?

Thanks very much @Andreas_CoinTracking for the super quick reply (only realised now you'd already replied lol).

Eth address was listed under "Import all transactions of a Ethereum address (legacy v2)" on https://cointracking.info/import/eth_address/

Deleted the old job as well as all the relating txns.
 
Created a new job at the top of the page as suggested but unfortunately, I can still only see Deposits and Withdrawals, but no rewards whereas I can see them on the Kiln dashboard.

Have sent a ticket with my email as recommended.

Thanks again  

Updates and Improvements

API
- Bitpanda (Live balance added, 'Crypto Index' transactions now supported)
- KuCoin (sub account instructions added, grid bot transactions improved)
- Bitfinex ('settlement fee' and 'claiming' correctly imported now)
- MEXC (adjustment to new API version)
- Binance ('Referral commission' same as CSV import)

CSV
- crypto.com exchange (new file formats supported, update of instructions)
- Bitstamp ("skip FIAT" - slider added)
- eToro (new file format for 'English' now supported, additional transaction types now supported)
- Bitget (Spot Trades with same timestamp now supported)
- BingX ('Standard Futures PnL' transactions now supported)
- Gate.io (new file format now supported)
- crypto.com App ('VIBAN' trades now supported)
- Bitpanda (Crypto Index transactions now supported)
- TradeOgre ('currency pairs trades' correctly imported now)
- MEXC (German futures PnL file format now supported)

Blockchain
- Improvements: Cardano - Indigo Defi protocol now supported, GoChain - LP support added (see FAQ "My blockchain transactions are not imported correctly. Why?")

Other
- Several Ticker updates for correct assignments, price histories and logos
- Improvements of tax reports (new: Italy, translation: Finland, Adjustments: US - 'Swap Trades' removed from form '8949', Austria - 'Sum amount' and PDF improved)
- Balance by Exchange page - added Excel, CSV, PDF export option
- Adjusted of Timestamp for 'CSV export' in 'Enter Coins' page
- New transaction type "Swap" added
- Excel Import Template - new columns added

We appreciate all the feedback we've received and we have already sent individual notifications to those who provided it. Thank you for your valuable input!

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

It is part of the latest ETH blockchain importer here: https://cointracking.info/import/eth_address/
May be you are still using an old ETH importer. So if you create a new API job on top of the page with your wallet address those transactions should be imported.
Otherwise please send us a ticket/eMail with your account name. @Pelaio

Hi,
I can see "ETH - Validator transactions" listed in the "Updates and Improvements" released on 05/07/23 and being mentioned again on 31/07/23.

Can you please let us know where the function to import Eth validator transactions is in Cointracking?

Have tried to delete all transactions for the eth account I used to transfer eth to a validator but only the eth transactions listed on etherscan relating to that Eth address were re-imported. None of the Beacon chain/validators transactions (deposit/activation or rewards) were imported.

Thanks very much

Updates and Improvements

API
- Bitget (new API version supported, 'cancelled orders' not imported any more)
- Bybit (new 'Unified Account' importer, error messages fixed)
- Coinbase ('not found' error fixed)
- Binance ('cancelled orders' not imported any more)

CSV
- eToro (english files now supported)
- MEXC (new Spot Trade file format supported, 'Future PnL' File support added)
- Bitpanda (added 'FIAT deposit/withdrawals' slider, 'Unstake' imported correctly)
- Bitpanda PRO (fee import improved)
- crypto.com ('Unfilled Limit Order' not imported any more, new format supported)
- Binance (support for the following transaction types: Card Cashback, Stablecoins Auto-Conversion, Simple Earn Flexible Airdrop, Leverage Token Redemption, transaction fee)
- Bitget (new transaction types supported)
- Poloniex (completely revised including instructions, new format supported)
- Bitcoin Suisse (new format supported including staking)
- Bake (LP token support improved)
- Coinbase ('Card Buy Back' and 'Card Spend' now supported)

Blockchain
- improvements: ETH - Validator transactions improved, DeFiChain - Vault and Loan supported (see FAQ "My blockchain transactions are not imported correctly. Why?")

Other
- Several Ticker updates for correct assignments, price histories and logos
- improvements of tax reports (update of explanations: Germany, Spain & UK, new: India)
- improved E-Mail verification process

We appreciate all the feedback we've received and we have already sent individual notifications to those who provided it. Thank you for your valuable input!

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

Updates and Improvements

- New API import: Bitrue
- Deribit (Swap Trades supported)

CSV
- New CSV import: Coindex
- crypto.com Exchange (support for new file format, new date format and Trade Volume of Business)
- 21bitcoin (date format fix)
- KuCoin Futures (support for new file formats)
- Bitrue (support for new file formats)
- Kraken (support for Credit card purchase and airdrop)
- BingX (support for new file formats)
- Ledger Live (support for NFT purchases)
- Binance (Instructions adjustment and adjustment of transaction types swap farming and FIAT buy)
- Coinmerce (support for new file formats)
- BSDEX (FIAT deposit/withdrawals now supported and slider implemented)
- Bitget (Short Trades now supported, fees improved)
- Bake (Rebranding from Cake DeFi, Elite bonus types adjusted)

Blockchain
- Improvements: Solana - support for new transactions types, Cardano - WingRider improved & 'Controlled Stake' now supported & UTXO transactions improved, support for ETH - Validator Staking Rewards (see FAQ "My blockchain transactions are not imported correctly. Why?")

Other
- Several Ticker updates for correct assignments, price history and logos
- Update of tax reports (new: Denmark & Belgium & New Zealand, Update: Austria, Canada - default slider settings, Spain - new sum groups)
- New partner benefits (CryptoTaxAudit)

We appreciate all the feedback we've received and have already sent individual notifications to those who provided it. Thank you for your valuable input!

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

Updates and Improvements

API
- Binance US ('Dust Converts' supported)
- BitMEX (PnL data imported)

CSV
- New CSV import: 21bitcoin, SorareTools, eToro, BingX
- Cake DeFi (all CakeELITE transaction types are now supported)
- Bybit (support for new formats, PnL - adjusted currency)
- Bitpanda (further improvements in 'Staking' and adjusted note for Airdrops)
- OKX (new file formats supported, sub-account import support using individual exchange names)
- crypto.com Exchange (new file formats supported)

Blockchain
- Improvements: DeFiChain - support for more transaction types, leading to better balance results; all chains - adjusted Liquidity Token Live Balance ticker (see FAQ "My blockchain transactions were not imported correctly. Why?")
- BETA importers now available for all users

Other
- Several adjustments of Coin Tickers, Price History, and Logos
- Improvements of tax reports (Spain - sums for the four categories, translation complete, added Finland)

We appreciate all the feedback we've received and have already sent individual notifications to those who provided it. Thank you for your valuable input!

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