I am currently working on building an excel based template to calculate gains on crypto transactions,
all you will need to do is separate buy and sale transactions and paste them in a sheet. using VBA it automatically matches sale and purchases as per
I want to ask all professionals here which software are they currently using? and does it need transactions in Excel or does it directly connect to clients exchange accounts? if it does connect do you do it for each client separately every year? also let me know pricing if possible.
also how do you treat open short positions at year end? since it shows in 26AS that sale is made, and if you don't report that sale, 100% notice will be there.