Download tradebook from Zerodha

author portrait

Aakash (Quicko Customer Success Representative)

F&O Trading
ITR-3
Trading Income
Last updated on February 9th, 2023

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.

Promo Code
Zerodha
Tax Compliance for Zerodha
Trader
Are you an Equity, Intraday, F&O or Commodities Trader? Upload your Tax P&L and file Tax Return online
[Rated 4.8 stars by customers like you]
Tax Compliance for Zerodha Trader
Are you an Equity, Intraday, F&O or Commodities Trader? Upload your Tax P&L and file Tax Return online.
[Rated 4.8 stars by customers like you]
Promo Code
Zerodha
Explore Now

Steps to download the Ledger/Tradebook from Zerodha

  1. Visit Zerodha Console

    You can do it from here

  2. Log in with your Kite credentials.

    Enter the user name and passwordZerodha console login

  3. Go to Reports

    Select Tradebookzerodha reports

  4. Select the necessary filters

    Click on View

  5. Your transaction details will be shown

    On the screen

  6. Click on Download XLSX | CSV

    To download your trade bookZerodha tradebook

  7. An excel sheet will be downloaded in your PC

    This is how your trade book will lookZerodha Tradebook excel

Find the best plan
Find the best plan
GET EXPERT HELP
Find the best plan
Find the best plan

FAQs

Is tax audit compulsory for F&O loss?

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.

What is the difference between the order book and trade book?

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.

How can I download my Tax P&L reports from Zerodha account?

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.

How can I download Contract note from Zerodha?

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.

Got Questions? Ask Away!

  1. 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!

  2. 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?

  3. 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!

  4. 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

  5. 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 :slightly_smiling_face:

  6. 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.

  7. 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…

Continue the conversation on TaxQ&A

18 more replies

Participants

Avatar for TeamQuicko Avatar for Nireka Avatar for Yesha Avatar for TanyaChopra Avatar for Sakshi_Shah1 Avatar for HarshitShah Avatar for Divya_Singhvi Avatar for HarishMehta Avatar for Robin_Dhankhar Avatar for Kaushal_Soni Avatar for Maulik_Padh Avatar for ameyj Avatar for Abdul_Kaleem_shah Avatar for ChinmayB Avatar for Yash_Kaviya Avatar for PALLAV_MITTAL Avatar for Amulya_Garg Avatar for HIREiN