Download ledger from 5Paisa

author portrait

Aakash (Quicko Customer Success Representative)

F&O Trading
Speculative Income
Trading Income
Last updated on February 9th, 2023

5Paisa allows you to download your Tradebook or Ledger. When a trader makes a transaction in the stock market, all the transaction details are actively recorded in the Tradebook or Ledger. This applies to all the segments i.e Equity, Futures, Options, etc. Trading ledger is also known as a trade book. Ledgers are used to prepare your Profit & Loss statement for income tax on trading of a particular Financial Year.

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

Steps to download the Ledger/Tradebook from 5Paisa

  1. Log in to your 5 Paisa account

    Add your user name and password here.

  2. Click on your Profile logo

    From the dasboard5 paisa my profile

  3. Go to My reports

    From the List5 paisa my reports

  4. Select Ledger

    From the optionsdownload tax p&l step 1

  5. Select the necessary filters

    Then click on Go5 paisa ledger details

  6. Once you have been redirected

    You can now view your Ledger entries in detail

Import Your Trades
File ITR Online

India’s fastest growing Tax Filing Platform

[Rated 4.8 stars by customers like you]

Import Your Trades

File ITR Online

India’s fastest growing Tax Filing Platform

[Rated 4.8 stars by customers like you]

FAQs

Is tax audit compulsory for F&O loss?

Tax Audit is required when the turnover of a taxpayer exceeds Rs. 1 cr in a particular Financial year or if the net profit from such transactions is less than 6% / 8% of the turnover. A 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 to download Tax P&L from 5Paisa?

In order to download Tax P&L from 5Paisa, Log in to the portal. Go to My reports > Portfolio > My portfolio reports > Profit and loss. Once the report is visible download it by clicking on the Excel button.

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