Zerodha allows you to download your Tradebook/Ledger from their trading portal. A Ledger/Tradebook contains all the transactions made in the stock market from a trading account. Therefore, this applies to all the segments i.e Equity, Futures, Options, etc. Trading ledger is the same as a Tradebook. One also uses Ledgers to prepare a Profit & Loss statement for a particular Financial Year while filing Income Tax from Trading.
Zerodha
Trader
Zerodha
Steps to download the Ledger/Tradebook from Zerodha
- Visit Zerodha Console
You can do it from here
- Log in with your Kite credentials.
Enter the user name and password
- Go to Reports
Select Tradebook
- Select the necessary filters
Click on View
- Your transaction details will be shown
On the screen
- Click on Download XLSX | CSV
To download your trade book
- An excel sheet will be downloaded in your PC
This is how your trade book will look
FAQs
Tax Audit is applicable if the turnover of a taxpayer exceeds Rs. 1 cr in a particular Financial year. It is also applicable if the net profit is less than 6%/8% of the turnover. Filing Tax Audit report is compulsory in order to file ITR. The tax Audit report can only be filed by a CA.
When an order is placed in the stock market, the details of the order, quantity of the order, price of the order and its unique order number is recorded in the order book. While when an order is executed in the stock market, its execution status and trade number get recorded in the trade book.
Most of the time, orders get executed immediately, therefore, order book and trade book reflects the same.
In order to download your Tax P&L report from Zerodha, you have to log into your Zerodha console account. Click on “Reports” > “Tax P&L”. Thereafter, when the Tax P&L reports open you can download it.
To download a Contract note from Zerodha, you have to log into your Zerodha console account. Click on “Reports” > “Downloads”. Finally, select contract notes and download them.
Hey @TeamQuicko
Thanks for the blog! Just one quick question - Why do we have to report a quarterly breakdown of Dividend Income under IFOS?
Thank you!
Hey @TanyaChopra
This quarterly breakdown of Dividend Income under IFOS will help to calculate and determine penalty u/s 234C for the delay in payment of Advance Tax.
Hope this helps!
I had received dividend recently but I had noticed that TDS had been deducted. any idea as to why has it happened and is there a way I can claim this TDS?
Hey @HarshitShah
After the introduction of Budget 2020, dividend income is now taxable in the hands of the shareholder; and is also subject to TDS at 10% in excess of INR 5000 u/s 194 & 194K. Foreign Dividend is taxable at slab rates. TDS is not applicable to such dividends. The taxpayer should report such income under the head IFOS in the ITR filed on the Income Tax Website.
Hope this helps!
Hey @HarishMehta
Yes, dividend income is now taxable from FY 2021-22 onwards and it has to be reported under the head of IFOS.
You can read more about it here:
Hi @Maulik_Padh,
You need to pay Income tax on the net taxable income, i.e. after subtracting deductions, expenses, etc.
If the net taxable income is negative i.e. if there is loss, you can carry it forward when filing the ITR
Here are some of the articles which might help
Hi @ameyj
The amount of TDS deducted shall reflect in your Form 26AS only and it will also reflect the name of the deductor.
Using the name of the deductor you can find out on which share you have received the dividend and you can also cross-check the same in your bank statement.
Yes, you are right, TDS is to be deducted when the dividend paid exceeds 5000 INR in a financial year. However, the 5,000 INR limit pertains to all the dividends an individual gets in a year, or the total dividend per shareholder that a company pays out in a year, is left to interpretation, and hence registrars and share transfer agents (RTA) are not taking any chances and are deducting TDS even on small amounts.
Hope this helps
Hi @ameyj
You can submit a grievance on Income Tax Portal mentioning the issue and also attach the 26AS.
The other option is to leave it as it is and clarify it when the tax department sends the notice.
Hi @TeamQuicko
Consider that I have 10 shares each of 10 different Indian companies. Each of the 10 companies are declaring a dividend of INR 100 before the FY ends. Now I will be recieving 1000 as dividend from each company, thereby a total of 10,000.
The 5,000 dividend limit, is it applicable to each company / total dividend recieved by me in a year. If it is applicable to each company, then I would not attract TDS of 10% for dividend.
Also pl clarify, how would the company B know that I have got shares of Company A,C,D,E so on…
@Saad_C @Laxmi_Navlani @Divya_Singhvi @Kaushal_Soni @AkashJhaveri can you help with this?