re: Hmm, you can always call up where you made the trades in your exchange, can't you?
The exchanges I use, Coinbase, Gemini, Kraken, provide the numbers. But each one has its own format. Some do not provide the fiat price at the time of exchange and that must be calculated.
There are two basic problems. First: getting the numbers into a spread sheet such that the format is the same for all exchanges. This is expected to require significant effort. Second: organizing and calculating the profit/losses such that my numbers will agree with the IRS numbers. I think I can do that, but, have no confidence that the IRS will be happy with my results.
At least one site notes that crypto is treated like stocks and real estate. But it does not state exactly the same. I am looking for Excel or other utilities to do this.
Edit:
Key Point: How should transfers between exchanges be treated?
First: Gemini and Coinbase trade reports are different. The thought is to keep track of Gemini trades in a sheet just for Gemini, and Coinbase in another sheet. And to go further, each coin should have a separate sheet.
Second: Coinbase does not trade in Dogecoin, Kraken does. But I was not able get Kraken configured to accept a bank transfer in US Dollars. So I buy Ethereum using bank funds on Coinbase, then transfer Ethereum to Kraken. On Kraken, sell Ethereum and buy Dogecoin.
But: I really don’t want the complexity of the Kraken worksheet depending upon the Coinbase worksheet and the reverse. So what is the best way to handle those transactions?
I am Googling and looking for rules, hints, and maybe spread sheets or utilities to buy.
Or maybe create some Excel VBA to do the imports and formats.