Topic: CoinTracking - Profit/Loss Portfolio and Tax Reporting for Digital Currencies (Read 121677 times)

Updates and Improvements

API
- KuCoin (instructions updated)
- Coinbase ('Partial Limit Orders' imported, staking transactions improved)
- Bitget (instructions updated)
- Kraken (Staking improved)

CSV
- Binance (new P2P file format supported)
- crypto.com App (Trades, Recurring Trades, Expense and conversion transactions improved)
- OKX (trades, staking, PnL & fees improved)
- Bybit (instructions updated, new file formats supported)
- KuCoin (new file formats supported)
- KuCoin Futures (new file format supported)
- MEXC (new file formats supported, fees improved)
- Bitget (new transaction types supported)
- Bitvavo (fees improved)
- BlockFi (new file format supported)
- Bittrex (new file format supported, fees improved)
- Coinbase (staking transactions improved)
- Criptan (new file format supported)
- Bitrue (transaction types improved)
- Voyager (new transaction types supported)
- Poloniex (Trades and fees improved)

Blockchain
- Improvements: Solana - NFT purchases & trades improved, Elrond renamed to MultiversX & improved, DeFiChain - LP transactions improved, BTC - taproot 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 (capital gains report - search by multiple keywords, search separated by semicolon added, Austria - further improvements like depot separation & Staking, Spain - Modello 721 report added, Sweden - ACB method added)
- All contract IDs shown and searchable on coin trends pages

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
- ByBit Unified (PnL data improved)
- Binance US (FIAT withdrawals improved)
- Coinbase (fees, partial limit order, timestamp, FIAT transactions improved)
- Bitfinex (Trades improved)
- Bitget (trade fees improved)

CSV
- New CSV importer: Bitvavo, Wallet of Satoshi
- Bitstamp (RFC 4180 format supported)
- Ledger Live (deposit fee improved)
- Binance (transfers between Main/Funding/Futures/Spot supported)
- Exodus (fees improved)
- Bake (Liquidity Pool name added)
- OKX (new trade history format & new transaction types supported)
- NEXO (new transaction type supported)
- Bitget (new transaction types supported, fees & FIAT trades improved
- KuCoin (new file formats supported)
- Coinmetro (new file format supported)
- MEXC (new file formats supported)
- Coinbase (Rewards and deposits improved)
- Bison ('shares' and 'ETF' transactions will be skipped now)
- Deribit (trade 'open sell' improved)

Blockchain
- Improvements: Solana - liquidity pool transactions improved, Bitcoin - fee & xpub & zpub improved, Cosmos - staking & DEX supported, Osmosis - DEX, staking rewards & 'GAMM' LPs 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 ('LP rewards income' setting Slider added, Austria - further improvements)
- Coins by Exchange (diagram and balances aligned)
- Dark mode view improved
- iOS App Fixes and Updates (trade view, Currency ticker with dash useable)

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
- New API import: Atani
- Binance (additional Futures PnL data supported)
- Bitvavo ('Repaid fees' supported)
- Coinbase (fee, FIAT, 'partial filled' trades improvement)
- Kraken Futures (Deposit & 'Multicollateral Conversions' improved, 'Unwind Counterparty' supported)
- MEXC ('Bonus Future Trading' and 'Funding rate' supported)
- OKX (withdrawal fee optimized)
- crypto.com Exchange (Withdrawal transactions optimized)
- Bybit (Margin Trades optimized)

CSV
- bitcoin.de ('corrective position' and 'welcome bonus' supported)
- Binance (additional Futures PnL data supported, trades & credit card transactions improved, Autoinvest supported)
- BTCPay (new format supported)
- NEXO (additional transaction types supported)
- OKX (PnL import & Convert improvement, new Trading History format and 'Untradeable Asset' withdrawal supported)
- Kraken Futures (Deposit & 'Multicollateral Conversions' optimized)
- Bitpanda (FIAT deposit/withdrawal slider optimized)
- crypto.com App (Defi purchases supported)
- Bittrex (new format supported)
- MEXC (Bonus Future Trading and Funding rate supported)
- gate.io (Dust swap supported)
- crypto.com exchange (Trade import & Withdrawal transactions optimized)

Blockchain
- Improvements: Cosmos, Solana, Ripple & Pulsechain - 'no imports' fixed, SOLANA - Token Blacklist option added, DeFiChain - more transaction types 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 (Germany - depot separation active by default, Austria - several improvements)
- Custom Exchange Importer (Export function for settings added)
- Backup ('Umlauts' in comments field supported)
- Excel Importer (Duplicate check improved)
- Enter Coins page (page number added above the transactions)

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

Not sure what you mean here. We are using block explorer APIs for blockchain importers.

Another agregator has been born!

So part of the reason why  I am not sure of getting everything I want tracked from one site is because the on-chain scanner analysis that provides all the projects that has been created from that chain has not been developed.


From the above mentioned, is there a way this can be integrated into the cointracking platform for a more comprehensive data agregation?

Updates and Improvements

API
- Bitmart (withdrawal amounts adjusted)
- One Trading (Rebranding from Bitpanda PRO)

CSV
- new CSV import: TAXBit
- Wirex (info comments updated)
- Bake (new transaction types and currencies supported)
- crypto.com (new transaction types including 'spend' supported)
- Bitget ('Ordinary Withdrawal', trades and internal transfers improved, 'Exchange Income' and 'Exchange Spending' supported)
- Binance ('small assets exchange', 'Airdrop assets' and 'sell to card' supported)
- Bitstamp ('Conversion' and 'Staking Rewards' supported)
- eToro (Withdrawal, fees and other transaction types improved)
- Kraken Futures (Funding fee import improved)
- Coinmetro (fee import improved)
- CoinEx (new file format supported)
- OKX ('Funding Account history convert' supported)
- One Trading (Rebranding from Bitpanda PRO)

Blockchain
- new importer zkSync
- improvements: DeFiChain - LP supported; PulseChain, Ronin and Tezos import issues fixed (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 (UK: added tax forms for 2022/2023, Germany: 'Year end balance' option and additional options added, Canada: airdrop and staking included in taxable income)
- Added loan transaction types to Excel Template, Balance by Exchange - Summary improved, Coin/token contract address on Coin Trends page and search added
- iOS and Android App Fixes and Updates (listing of 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

1. I am no tax advisor but yes you can add this as fee. When in the same currency then the transaction add it there or if in another currency add it as "other fee" separately.
2. If you add fees correctly as shown here then your balances are correct: https://cointracking.freshdesk.com/en/support/solutions/articles/29000007202-entering-fees
This is helpful as well: https://cointracking.freshdesk.com/a/solutions/articles/29000039588?lang=en

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.

...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.

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

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

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