Download Ledger from Upstox

Upstox 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 Income Tax on trading of a particular Financial Year.

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 Upstox

  1. Visit Upstox platform

    Use this link to login

  2. Log in with your user id and your password

    Your password will be your PAN in caps lock if you are logging in for the first time.

  3. Go to Account

    Select Ledger

  4. Select the necessary filters

    Click on Go

  5. Result will appear

    Click on Export in Excel sheet

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 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 Upstox?

In order to download Tax P&L from Upstox, Log in to the portal. Go to Bill > Profit & Loss. Click on go and then download it.

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

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

  8. Thank you, @Nireka
    Will wait diligently for the new ITR updates
    All my queries have been addressed. Looking forward to using and recommending Quicko to friends and family.

Continue the conversation on TaxQ&A

12 more replies

Participants