Download Ledger from Motilal Oswal

Motilal Oswal 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 with Trading income.

Invested in Intraday?
Need to file your ITR? Let us help you out!
[Rated 4.8 stars by customers like you]
Invested in Intraday?
Need to file your ITR? Let us help you out!
[Rated 4.8 stars by customers like you]

Steps to Download the ledger from Motilal Oswal

  1. Log in to Motilal Oswal portal.

    You can do it from here.

  2. Go to Reports

    Select Ledger

  3. You can view your Financial summary

    You can do this segment wise

  4. Click on any ledger detail

    A pop will be displayed disclosing further details.

  5. Click on PDF symbol to download the ledger

    You can view it from there then.

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]


What is the difference between the order book and trade book?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 to download Tax P&L from Motilal Oswal?

In order to download Tax P&L from Motilal Oswal, Log in to the portal. Select the Talk to MO Genie bot. Search for P&L Report there and download.

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 @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

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

  6. Hey @Abdul_Kaleem_shah

    As per sec.194 of income tax act, TDS liability will arise when the amount of such dividend or the aggregate of the amounts of such dividend distributed or paid or likely to be distributed or paid during the financial year by the company to the shareholder, exceeds 5000 Rs.

    Here, the term company not includes aggregate companies and hence limit of 5000 Rs. should be applicable to each company.

    Here, you can read below article covering TDS on dividend income:

    Since, it is purely based on interpretation and ambiguous as opinion vary from experts.

  7. Hey @TeamQuicko

    I tried to file ITR-3 via Quicko’s integration with Zerodha. While filing the ITR, I got an option to switch to the New Tax regime to save additional taxes.
    Since I had some turnover from intraday and FnO (speculative/ business), am I eligible to switch to the new regime through Quicko while filing?
    How do I fill the Form 10-IE? If I haven’t filled the form, would the portal preent me from filing returns altogether?
    Also, once I get rebate (if opted for new regime) / pay dues (if opted for old regime), do I need to go through the hassles of replicating it on the new ITR portal (i.e manually answering the schedule sections)?

    Kind regards

  8. Hi @ChinmayB,

    Yes, you can opt for the new tax regime. However, keep in mind in case a taxpayer has business income and they opt for the new tax regime, they can switch to the old tax regime only once.

    If you opt for the new tax regime, you need to file Form 10-IE before filing the ITR

    Here’s how you can file the Form 10-IE

    When filing your ITR through Quicko, you do not need to enter details on the new ITR portal, since Quicko is a ERI (e-return intermediary) registered with the Income Tax Department.

    Note: ITR filing will be enabled on Quicko in the coming week. So stay tuned for more exciting features!

Continue the conversation on TaxQ&A

11 more replies