I have been reading more lately about all the US tax liabilities that can come into play in the crypto world and have started worrying about how much I would owe for 2017. I was starting to lose some sleep on the matter and finally decided to organize all of my activity once and for all. I figured I'd write this post for other people who might want to find out what I have learned in this process. I am filing in the US, but some of this might apply to people in other countries as well.
If you have just bought and HODL'd then it will probably be much simpler for you. But if you have done ICOs and any trading and are worried about this stuff, don't worry too much. Its totally possible to get yourself organized with a little bit of work. Background
Bought my first ETH in Feb '17 from Coinbase and since then:
- Have traded probably 50 different tokens on 10 different exchanges
- Have participated in 21 ICOs
- Have received Airdropped tokens
- Have sold some and withdrawn profits to my bank account
The best place to get started is bitcoin.tax Referral Link Normal Link
I signed up for the 1 year plan for $19.95 (they also accept crypto) and believe me its worth every penny. You can use it for free, but are limited to 100 items (I ended up having > 1500). It really does almost everything for you, so you don't have to worry about figuring out the cost basis yourself. The only time USD was involved was buying via coinbase, everything else was handled as a token to token trade.
Microsoft Excel or Google Sheets is a must if you are doing any trading on the non-supported exchanges because you might have to massage the data into the correct format. Etherscan
Unfortunately, for some trades and the ICOs, I had to go directly to Etherscan to track down the data. DeltaBalances
This is a lifesaver for tracking trades made on ED. I wasn't able to get the export feature working, but copy/pasting the table into Excel was fine. Html Table to CSV
If you are having trouble copy/pasting table data this comes in handy. You can just copy the raw table HTML from Chrome Dev Tools and get a nice CSV. Exchanges
I am only going to list the exchanges I use and how I was able to get the data into bitcoin.tax. But regardless of the method, make sure you verify all the data that was imported. The system did a bad import on my Bitfinex data and I had to wipe it and reimport because it was missing a bunch of rows.
All the importing is done on the trading tab of bitcoin.tax. Some exchanges require you to download a .csv file from the exchange website, and some have direct API access. Just follow the tutorials on bitcoin.tax for each exchange. The Easy Ones
Bitcoin.tax supports API data pulls for these exchanges: Bitfinex, Coinbase, GDAX, Kraken
. For these, I still recommend going to the exchanges and downloading a copy of your history for your personal records.
You need to login to the exchange and download trade history and then use bitcoin.tax's import tool for these: Binance, Bittrex, Poloniex The Tough Ones
Trades made on Etherdelta
present a bit of a challenge. There is no direct import into bitcoin.tax so you will have to manually compile a CSV and import it to their system. They give you a template to follow with the required data and it will require a bit of "massaging" to get the ED data to the correct format. For this is it extremely helpful to use DeltaBalances. For each wallet you use you will need to check the trade history and go back a sufficient number of days to cover your trading history. Warning, it might take a long time for this process to finish and it isn't 100% reliable. When I ran it, it needed to download > 200MB worth of data for the 260 days I went back. My suggestion is to run it a few times to validate the results. You will need to run it for each wallet you use to trade on ED. Once you get the results, you can try copy/paste the table into Excel and then format the columns to match. Liqui
was the biggest pain in the ass of them all. If you traded a lot on Liqui, be prepared for some pain because they have no export and only show you the history of 1 pair at a time (and only the last 30 trades!). Liqui has over 250 trading pairs so if you forgot what you traded, you will tediously have to go through each pair to check. I couldn't bear this, so I ended up coding a custom script to query all 250 trading pairs and dump out the data for me, then I had to import that into Excel and format it to match the bitcoin.tax template. Kucoin
wasn't too bad. They don't have an export function, but you can copy paste the tables into Excel and massage the data there.
I did a few trades with OasisDEX
but when I went there it didn't have any of my history, so I had to manually cobble that together from looking at Etherscan. Luckily it was only a few trades or else this would have been very tedious. ICOs
Like I mentioned, I participated in something like 20 ICOs this last year. Unfortunately I have no records of any of them. In bitcoin.tax I handled these as just another trade. In order to track down the ICOs I participated in, I was forced to use Etherscan and go through my whole transaction history looking for them. In order to add the trades manually in bitcoin.tax you need the Date, the # of ETH you spent and the # of tokens you received. It's not super difficult, but just very tedious. One that threw me for a curve ball was RedPulse. This was a NEO ICO, but adding a trade manually doesn't yet support NEO as a currency. The workaround for this is putting it into a CSV and importing it that way. In fact, if I was to do this again, I would have built a CSV for all the ICOs and just imported it that way rather than inputting them one-by-one. Airdrops
I treated airdrops as "Gifts/Tips" under the income tab. I had to find these through Etherscan. Verifying the data
In order to verify that all seemed right and there are no problems, there are two things that I was working toward:
- No unmatched trades -- On the reports tab, you can filter by "unmatched trades". Ideally you won't have any of these. If there are some, you may need to do some more digging to see why
- Closing position report -- On the reports tab, your closing position report should match as closely as possible to your current holdings in Blockfolio.
Overall, although there was some tedious parts, this was a really good exercise. Going through my entire history gave me some great insight on how my strategies played out (ICOs were great / I suck at trading). As far as the taxes themselves, it turned out to be a lot more than I was expecting, but considering the gains I am not too sad. Going into this next year I am going to make some changes. First of all, I will probably stop trading as much. It just wasn't that successful for me and created a lot of work and taxes on top of that. Secondly, I really want to try and stay away from exchanges that don't (or don't plan to) offer history exports. Third, I will probably hold most of my unsold ICOs for at least a year so as not to be liable for short term gains. Lastly, I will keep better records as I go along so I don't have to do so much digging for next tax season.
I hope this can help some of you guys figure this out and I would love to hear any additional tips from those of you who have gone through this.
Edit: A couple other hiccups that I just remembered. Some tokens change their symbol, this can cause some havoc, I had done some trades in MyriadCoin as MYR then it changed to something else and it got all wacky. Updating the old token symbol to the new one seemed to do the trick. Also, to add to the Liqui woes, I had bought some BCAP way back in the day, but it got delisted so there is no way I found through the UI to get that information. The only way I found out I had actually done that trade was that the script I coded iterated through every possible trading pair and only then it was uncovered.
Edit #2: I got a request for the liqui ruby script
An Investigator’s Guide to Blockchain, Bitcoin and Wallet Transactions Complete the form below to watch the webinar . As Bitcoin and blockchains are coming into the mainstream, investigators, auditors and forensics and security professionals need to become familiar with how blockchain works and why it is so important to tomorrow’s digital security. It is important for anyone involved in ... Best bitcoin stocks. Latest news on bitcoin halving cointelegraph. Bitcoin wallet balance ranking. How to use bitcoin qt import wallet. Highest paying bitcoin games bot uninstall. New - freebitcoin.io reviews: scam or legit. Guide to investing in bitcoin, blockchain, and cryptocurrency. How to cash out my bitcoin in euros - quora.. Vectorvest groups meetup. Breaking interview w roger ver ... ***Bitcoin Asic Ebay What Is A Bitcoin Wallet Seed Petahash Bitcoin Definition Bitcoin Asic Ebay How To Send Bitcoin With Bither How Do I Get Bitcoin Currency Bitcoin 2010 Value Bitcoin Asic Ebay Bitcoin In China Best Place To Buy Bitcoins With A Debit Card I have been looking for a way to see the address's balance that doesn't belong to my own Bitcoin core wallet. I don't like to use an external API, I have this full node and I really wonder if this is ... bitcoin-core. asked Oct 2 at 2:31. Luca Blight. 82 1 1 silver badge 6 6 bronze badges. 1. vote. 0answers 34 views Bitcoin “scantxoutset” rpc command return response too slow. For one of ... In March, Adrian Xinli Zhang became a director at Deutsche Bank in New York aged just 29, but was gone in a month after trading Bitcoin in his spare time, sources told Bloomberg. BlackRock staff member Asim Ahmad put everything into Ether when he had the chance, using all of his life savings to invest in the digital currency, but has now left his London office to start anew on the back of his ... Binance said last month that the limited edition phone will be launched “very soon.” The device supports Binance’s native blockchain, Binance Chain, and has a built-in cryptocurrency wallet ... But I don't want to spend all of the Bitcoins on my Paper Wallet to get the bitcoins from your paper wallet to your software wallet; scan the QR code or Nov 24, 2017 - Scans for Bitcoin wallet archives Bot trying to steal Ethers from my honeypot, after enumerating "my" accounts, getting the balance and The best part of QR codes is that when a potential customer decides to scan the Which BitGo ... Both blockchain.info and bitcoinpaperwallet.com are for Bitcoin, you need a Litecoin wallet and then import your private key to that. The most reliable way to have a Litecoin wallet is to download and run the official Litecoin Core client, although you can use web based wallets as well but as I have no experience using them I can only give you a search link. Trust Wallet is the official cryptocurrency wallet of Binance. Your private key is only stored locally and protected with several layers of security. Join 5 million+ people using Trust Wallet to buy, store, exchange and earn crypto. Trust Wallet supports the leading blockchains and cryptocurrencies (ETH, BTC, BNB among others). Trust Wallet works seamlessly with Binance DEX, DeFi platforms ... Bitcoin paper wallets offer a flexible and useful way to store surplus funds Transfer bitcoin held at an exchange such as LocalbitcoinsPar contre 2 Une fois mes crypos sur binance je souhaiterai les mettre sur Paper wallet, mais je Transfert de Bitcoin depuis un wallet paper. Best Bitcoin Wallet Reviews for 2018. Gox's wallet A paper wallet is ...
HOW TO SEND STELLAR LUMENS XLM TO AN EXCHANGE 2018 BITCOIN BINANCE Hey everyone! In this video you will be learning how send your Stellar Lumens (XLM) from your wallet to an exchange! Its ... BITCOIN DEATH CROSS - BE READY FOR THIS (btc crypto live news price today analysis prediction ta - Duration: 34:28. Crypto Crew University 25,077 views. New #earnfreebitcoin #hackblockchainwallet #hackbitcoin #freebitcoinearn #bitcoinprivatekeyimport private key database With Balance 2018 100% working.. https://k... This video will show you how to check if your ripple purchase was successful and how much Ripple you currently own. Link to create a Coinbase account: https:... Electroneum - How to Check The Balance Of Your Paper Wallet Mytham Tutorials. Loading... Unsubscribe from Mytham Tutorials? ... You are being LIED TO about BITCOIN 🚨DON'T BE FOOLED! Cuban Gates ... Online Wallet: https://goo.gl/s6wMpq Offline Wallet: https://goo.gl/f3JwmP Hast du dir auch schon immer gewünscht, von Zuhause aus Geld zu verdienen, ohne etwas dafür zu tun? Ich habe nun damit ... Subscribe: http://www.youtube.com/channel/UCc4mfwJYpf29LTsbZyF1b6w?sub_confirmation=1 Trade on Binance https://www.binance.com/?ref=12885608 ++++Find Me on S... Bitcoin Maximalist Giacomo Zucco and Richard Heart on , Ethereum, HEX, security, scams, etc. Richard Heart 1,572 watching Live now Cardano Incentivized Testnet Explanation & Yoroi Staking AMA ... See reply to Juan Lopez's comment for a slightly more advanced version, where you can also show the number of transactions performed from a certain Bitcoin address. Also check my open-source web ... How to Buy Bitcoin on Binance US & Store in a Ledger Nano X - Duration: 8:36. Rex Kneisley 1,392 views. 8:36 . Stock Market Order Types (Market Order, Limit Order, Stop Loss, Stop Limit ...