1. I don't know if they actually providing one, but I have read that "Zerodha" is providing tradewise turnover report. If you have Zerodha account, check again.
2. I have been trying to find a solution for this for years now, but I haven't found one. Even posted a thread here. I guess it's lot tougher than I/you think. I have been doing this manually till date. It's about few hours work every year.
4. If one is an options scalper, most likely he will hit that 2cr mark easily and if in profit likely that would be less than 8% of t/o.
5. Again, it's not easy for an options scalper.
8. I am not sure about this. Just because salary is more than base limit, we should get our books audited? Doesn't that 8% rule come into play here?
Eg: Salary of 4 lakh and derivative loss of 1 lakh with t/o of 10 lakh.
- 4 lakh (salary alone) is more than 8% of t/o (10 lakh)
- if we club both the income, 3 lakh (4 lakh - 1 lakh) is still more than 8% of turnover (I know we can't set off business loss against salary income, just for the calculation).
@canikhil, Can you clarify this (point #8)? I thought I was clear about this taxation matters, Square nicely confused me here
2. I have been trying to find a solution for this for years now, but I haven't found one. Even posted a thread here. I guess it's lot tougher than I/you think. I have been doing this manually till date. It's about few hours work every year.
4. If one is an options scalper, most likely he will hit that 2cr mark easily and if in profit likely that would be less than 8% of t/o.
5. Again, it's not easy for an options scalper.
8. I am not sure about this. Just because salary is more than base limit, we should get our books audited? Doesn't that 8% rule come into play here?
Eg: Salary of 4 lakh and derivative loss of 1 lakh with t/o of 10 lakh.
- 4 lakh (salary alone) is more than 8% of t/o (10 lakh)
- if we club both the income, 3 lakh (4 lakh - 1 lakh) is still more than 8% of turnover (I know we can't set off business loss against salary income, just for the calculation).
@canikhil, Can you clarify this (point #8)? I thought I was clear about this taxation matters, Square nicely confused me here
2) Ok. Not you and me, but someone with excel experience can do it. So the downloaded tradewise details in excel file can be directly used in this excel tool to give us FIFO turnover calculation. Worse still if it has to be done manually then too few hours of work each year as you mentioned should be just fine.
4) and 5) I think, option or futures the turnover will be based on net profit and net loss of each trade so it should not matter.
8) Don't confuse salary as a percentage of turnover. It is just not related. Salary is standalone and business is stand alone.