I made a Bitcoin accounting template in Excel to share

This is the spreadsheet I use to track my transactions. Of course I stripped out my personal info. The Instructions tab gives a bunch of examples on how to use it. In Column Q I also give text instructions on how each type of transaction should be entered. Please let me know if you have any questions on how it works. Make a copy to your own google drive or download it, and use it yourself. If done properly it will make adding up your capital gains much easier. (I do include promo money and interest in the Capital Gains column and that's not quite right, but it's what I do. Just make sure you report promo and interest money as income, not capital gains)

https://docs.google.com/spreadsheets/d/10qyn2bcjq7JGf5pPQmiScOSCJb0CmgzR2aYNjtJAlCU/edit?usp=sharing