I’m trying to get my own spreadsheet that’s very simple. Columns with ‘exchange’ ‘BTC buy/sell’ ‘BTC withdrawal’ ‘date time’ ‘price of bitcoin’. The transaction sheets provided by the exchanges is a lot more complicated than necessary. Going forward I’ll update the sheet every week as I get paid or need to pay for a bill.
Discussion
Also use FIFO cost basis for simplicity. Sell oldest coin first.
I use HIFO, ChatGPT helped figure out the formula. As long as the IRS gets their cut, I’m not worried. I would be interested in seeing your spreadsheet (blank obviously) and compare it to mine. I go too much in depth.