Jul 17, 2025 at 12:58 AM#6
you are a gift to this community. I actually made a simple Google Sheet template for tracking this if anyone wants it. Columns are:
| Date | Coin | Amount | Cost Basis | Value at Spend | Gain/Loss | Purpose |
I just fill it in after each purchase. Takes literally 30 seconds and my accountant loves me for it at tax time.
Also worth noting: if you're buying crypto specifically to spend (not holding long term), the gains are usually tiny because there's minimal time for the price to change. The people who get in trouble are the ones who bought BTC in 2020 at $10k and are spending it now at $95k. THOSE are significant gains 💰
Last edited: Jul 17, 2025 at 5:58 AM
45 22nick_newbie, DadBodDave, AmyNC_wife and 42 others
Reply Quote Save Share Report