TogglIcon
ToolsLearnBytesTax Q&AGet Started

Understanding Zerodha Tax P&L Report

You can download the Tax P&L Report from Zerodha Console.

The report includes details of segment-wise trading – scrip name, buy value, sell value, buy price, sell price, realized profit, and trading expenses.
This Tax P&L Report can be used to prepare P&L A/C to report it in the Income Tax Return.

However, the trader must take care of the following things where the treatment as per Income Tax may differ.

  • Expenses

    The Tax P&L Report covers transfer expenses that are directly related to trading transactions.

    In the case of Capital Gains from Equity Delivery and Equity MF/ETF, you can only deduct transfer expenses such as brokerage, turnover fees, transaction charges, GST, stamp duty, etc.

    In the case of Intraday and F&O, you can also claim other expenses – such as internet expense, legal fee, subscription expenses, depreciation, etc which are not covered in Tax P&L Report.
  • Buy Back Gains

    When a company buys back shares issued by it from an existing shareholder, it results in capital gains for the shareholder. Such buyback gains would be included in the Tax P&L Report.
    As per a recent amendment in Budget 2019, the gains from buy-back are exempt in the hands of the individual since the company is now liable to pay the buyback tax under Section 115QA. This amendment is applicable to all the buybacks after 5th July 2019. Therefore, buyback gains before 5th July 2019 are taxable for the trader and the ones after 5th July 2019 are exempt.

    If such buyback gains have been included under Capital Gains in Zerodha, you can omit the buyback gains and report them under Exempt Income in the ITR.
  • Calculation of Long Term Capital Gains under Section 112A

    LTCG on the sale of securities (on which STT is paid), bought on or before 31st Jan 2018 should be calculated using the Grandfathering Rule. As per this rule, the Cost of Acquisition is computed after considering the FMV as on 31st Jan 2018 as per Section 112A.
    Zerodha provides the FMV as on 31st Jan 2018 and the taxable Long Term Capital Gains in the ‘Tradewise Exit-Entry’ tab of the Tradewise Tax P&L Report. Thus, the LTCG should be calculated as per the grandfathering rule using the FMV of each trade in the Tradewise Tax P&L Report.
  • Transfer In/Out

    If you moved your portfolio from another broker to Zerodha or vice versa, your brokers will have partial data (either buy-side or sell-side depending on transfer in or out). Most brokers including Zerodha let traders enter such missing data. However, there are high chances of missing out Capital Gains arising out of such transfers.
  • Devolvement

    Devolvement means that the option contract will get converted into a futures contract of the same underlying. As per the Zerodha Support thread, the RMS team (at their discretion) can square-off of open positions upon Failure to produce the margin. Any gains/losses arising from such trades will be included in the Tax PnL report – marked as “DEVOLVED”
  • Reversals

    As per the Zerodha thread, Reversal trades are alleged to be non-genuine trades. All reversals will be included in Tax PnL report – marked as “REVERSALS”. In most cases, reversals are punched in on a cost basis & hence do not carry any tax consequences. However, sometimes the reversals for short deliveries are not entered on a cost basis, the gain or loss in such cases must be included under Capital Gains in the Income Tax Return.

All of the above conditions are considered when you file your Tax Return using Quicko. However, reporting may vary depending on your specific situation, hence it’s always advisable to consult a tax professional when in doubt.

Tweet Us--Like Us--Join Us

7 Likes

Share
facebook twitter

Got Questions? Ask Away!

  1. Hi,
    Since yesterday, I was able to import my trading or mutual fund data from zerodha, but now I am not seeing that option and all the imported data has also been deleted from capital gains window in quicko website.

  2. Avatar for Abhi Abhi says:

    I have hard time understanding how the “Transfer Expense” was populated by Quicko from my Zerodha account data. I tried to calculate it manually by considering charges except STT in contract note and DP charges. The DP charge itself is ₹15.93 (no other sell order for that scrip on that day). (I am showing sample contract note here only for reference. But I tried to compare it with real contract note too.)

    Does Quicko consider DP charges during import? Also, I’m not able to tally the value shown by Quicko with Zerodha’s Tax P&L statement because in that statement, per trade charges are not mentioned.

    Even if I consider the total transfer expense across all short-term trades, it’s not exactly matching with the sample contract note attached above (after excluding STT).

    I believe Quicko somehow is getting the total transfer expense and dividing it proportionately for each trade according to the “Traded Value” of the trade but even here it’s only matching approximately. For example, as per Quicko, the total transfer expense across all STCG trades is ₹33.2105. And for the above trade for which I attached the screenshot, the Traded value is ₹1561 and total traded value across all trades (from above sample contract note which represents my scenario) is ₹3581.7. Considering (1561/3581.7)*33.2105 gives ₹14.474 which of course does not match exactly (but matches approximately) with ₹14.4279 populated by Quicko.

    Also, for business income from trading case, for the Zerodha Trading Account that Quicko creates in the ITR filing, under “Rates and Taxes”, the values are matching with Zerodha’s Tax P&L statement under “Charges” heading in the Equity sheet. Do these “Charges” (like STT, Stamp Duty, Turnover fees, etc) shown in the statement and imported by Quicko correspond only to intraday trades? Or are values from short term and long term trades also summed up there?

Continue the conversation on TaxQ&A

8 more replies

Participants

Comments

Steven Smith says: (Awaiting Approval)

2024-09-25 04:13:06

In the ever-expanding world of online gaming, 101 games stands out as a vibrant platform that offers a diverse array of fun and interesting games for players of all ages.

Reply

e says: (Awaiting Approval)

2024-03-18 13:23:48

e

Reply

profinserv says: (Awaiting Approval)

2023-10-20 06:54:44

We have literally tried almost everything that has some value and finally concluded the best trading phenomena that exactly works in the market. we are the only institute in India that provides courses on demand and supply concepts, and we are already helping 5k students to make money in the stock market on a daily basis. aded currencies Forex Trading Gold Trading Forex Trading Forex Trading Vs Option Trading Trading psychology Options trading Bank Nifty Stocks swing trading vs day trading Bank Nifty Trading call option Option Selling vs. Buying

Reply

Shubham More says: (Awaiting Approval)

2023-10-12 11:17:56

Can i file ITR now days to carry forward losses of year 2022-2023

Reply

finalert llc says: (Awaiting Approval)

2023-09-16 17:56:26

"Your writing style is engaging and conversational. It feels like we're having a discussion rather than reading a blog post."

Reply

Sandip Kumar says: (Awaiting Approval)

2023-09-06 19:11:31

Reply

e says: (Awaiting Approval)

2023-08-23 17:09:51

Reply

e says: (Awaiting Approval)

2023-08-23 17:08:12

e

Reply

finalert says: (Awaiting Approval)

2023-08-18 05:35:52

Interpreting the Zerodha Tax P&L Report may require some familiarity with trading terminology and tax regulations. If you're unsure about any aspect of the report or how to use it for tax purposes, seeking assistance from a tax expert or financial advisor is a prudent step.

Reply

Abhiram says: (Awaiting Approval)

2023-07-26 05:52:43

How does Quicko compute "Transfer Expense" per trade in capital gains? Does it include DP charges? I'm not able to tally the value shown by Quicko with Zerodha's Tax P&L statement because in that statement, per trade charges are not mentioned. Also, for business income from trading case, for the Zerodha Trading Account that Quicko creates in the ITR filing, under "Rates and Taxes", the values are matching with Zerodha's Tax P&L statement under "Charges" heading in the Equity sheet. Does these "Charges" (like STT, Stamp Duty, Turnover fees, etc) shown in the statement correspond only to intraday trades? Or are values from short term and long term trades also summed up there? Ideally this question should be asked in Zerodha's forum but asking here because I see Quicko's values in business expenses matching with the statement. Or should I separately compute these myself for intraday and stcg manually?

Reply

Ravi says: (Awaiting Approval)

2023-07-17 09:22:32

The Tax P&L (for zerodha imported data): The download report option / link to download the Tax P&L Tradewise report is available. Is there any option to download / email it.

Reply

YASH PAUL SACHDEVA says: (Awaiting Approval)

2023-06-18 17:43:54

I have downloaded Zerodha Tax PnL Report. It gives details of total expenses but does not bifurcate them between STCG and Intraday Business Income. What is the solution? Second, Can I claim interest paid to the Bank on Loan taken for earning intraday trading profits?

Reply

Anant says: (Awaiting Approval)

2023-07-08 12:08:33

yes it should bifurcate yes, there will excess profit or less loss gets reported

Reply

says: (Awaiting Approval)

2022-07-28 12:47:39

Reply

Rahul says: (Awaiting Approval)

2022-07-20 16:25:57

Hey, I am analysing the computation that I got from uploading taxpnl from zerodha on Clear tax. And this is my first time filing it and I found that the computation did not counted/considered any expense whatsoever - Expenses being all transaction charges & Brokerage,STT, etc. It just gave the gross profit/loss as the total P & L. Hence, I am confused whether the platform is wrong or it is that expenses are not counted in my case. NOTE : I am trading under Retail account(not under corporate) and a salaried employee. QUICKO can u kindly clear the fact that if a salaried employee while filing ITR 3 can claim expenses such as brokerage , STT, transaction charges etc. (Specify the expenses if u want)! I know its written everywhere that WE can claim expenses but its not clear who is ‘WE’ here. Are everyone included in 'WE" or its just the business account(who have incorporated business entity). Appreciate that you took time out from your busy schedule to reply! Thank You

Reply

Raj says: (Awaiting Approval)

2022-05-12 10:23:24

You are so interesting! I don’t believe I’ve truly read through anything like that before. So wonderful to discover another person with a few unique thoughts on this issue. Seriously.. many thanks for starting this up. This website is something that is required on the internet, someone with a bit of originality! SBI share price Tata Steel Share Price ITC Share Price DLF share price HDFC bank share price

Reply

syed sanib says: (Awaiting Approval)

2022-04-01 03:23:39

I do not know anything much about income tax and all. I started my trading journey from end 2020 and till now i am in approx 10k loss over all. Do not have job or salary. Do i also have to give income tax. Or can just continue what i am doing. I dont know what to do Please let me know Thanks

Reply

Santhosh says: (Awaiting Approval)

2022-10-13 07:04:44

Yes , you can Still File the ITR and Declare your Losses .

Reply

ajay sharma says: (Awaiting Approval)

2022-02-18 16:37:05

i am doing trading in fno since last march(2021). my net pnl is 1.46L loss and turnover rose to 64lac in fno. i am a salaried person . do i have file ITR? , anyone please guide me what do i have to do?

Reply

Bharat Jain says: (Awaiting Approval)

2022-02-08 18:16:49

My queries to Zerodha and Quicko Team : 1. How Options turnover in my case is calculated. As per your site you take turnover (for options) as total of sell side which is 1193543 in my case. But you have taken turnover as 1285508. Please explain. 2. Also as per income tax turnover in case of options should be absolute amount of positive and negative differences of option transactions. In that way as per income tax my turnover should come as 91966. 3. Your site mentioned tax audit limit as 5 Crore for F Y 20-21. It is 10 Crore I think. Please clarify. 4. Your site mentions that If I have turnover less than 5 crore and less than 6% profit I show then I will have to get audit done. Which is incorrect I think as 44AD section is applicable up to 2 Crore turnover only. So if turnover is more than 2Crore but less than 5 Crore then the statement on site does not hold true. Kindly clarify.

Reply

Gourab says: (Awaiting Approval)

2021-12-29 14:23:28

Transfer expenses(Brokerage,STT,Stamp Duty) is not pre-deducted . Can we deduct expenses from Gross profit of STCG?

Reply

Gowthaman says: (Awaiting Approval)

2021-11-03 06:49:42

Hi, I'm a salaried person and doing banknifty F&O trading. In my zerodha account -> P&L section, I can see options turnover as 27L and options profit/Total gross profit as 12.38k. So I have to pay income tax for 12.38K from my respective slab, am I right?

Reply

kishan says: (Awaiting Approval)

2021-04-01 06:49:19

I have booked profit 22000 approx by ipo and Short term Trading. Am I eligible To pay tax also I want to know Feed and charges if I do through Quicko

Reply

kishan says: (Awaiting Approval)

2021-04-01 06:49:18

I have booked profit 22000 approx by ipo and Short term Trading. Am I eligible To pay tax also I want to know Feed and charges if I do thriugh Quicko

Reply

Samar says:

2021-01-10 03:58:53

You have specified "In the case of Capital Gains from Equity Delivery and Equity MF/ETF, you can only deduct transfer expenses such as brokerage, turnover fees, transaction charges, GST, stamp duty, etc. " Can we deduct DP charges too? Zerodha levies ₹13.5 + GST per scrip (irrespective of quantity) as DP charge.

Reply

Sumeeth says: (Awaiting Approval)

2020-12-26 12:03:08

I have done multiple trades in F&O as well as intraday in both Zerodha and Astha Trade. The turnover in F&O has crossed 1 crore as well. I have also incurred losses which need to be carried forward. My CA says that each transaction has to be entered while filing ITR for FY 2020-21 and so its a cumbersome process as there will be more than 3000 transactions to enter. Since tax audit is to be done, the charges are informed as around Rs 15000/-. Please guide.

Reply

Gowthaman says: (Awaiting Approval)

2021-11-03 06:48:15

Hi, I'm a salaried person and doing banknifty F&O trading. In my zerodha account -> P&L section, I can see options turnover as 27L and options profit/Total gross profit as 12.38k. So I have to pay income tax for 12.38K from my respective slab, am I right?

Reply

Krishnanunny Mangalasseri says:

2020-11-20 12:09:34

I am a salaried person and a trader (started last year only) as well. Two CAs I consulted said they need dates of the trades (both intraday and short term). Tax P&L report from Zerodha don't provide the dates. What is the alternative to this?

Reply

Nireka Dalwadi says:

2020-12-02 18:56:30

Hi, Since you will be filing ITR 3 with your Trading income, there is no requirement of dates since Zerodha's Tax P&L has already calculated the short-term/longterm gains based on the dates. However, you can download the tradebook from zerodha console.

Reply

Naveen Kumar Ch. says: (Awaiting Approval)

2020-11-20 10:21:25

How to download script wise trading data for a complete financial year for the purpose of filing income tax returns.

Reply

Joel says:

2020-11-20 08:43:38

I am a student, started trading since September 2020, with capital of 1lakh which i took from my father, my question is do i need to fill for ITR, if yes specify in details please.

Reply

Nireka Dalwadi says:

2020-12-02 17:24:49

Hi Joel, It is always a good practice to file your Income Tax Return and report all your incomes. It reduces the chances of getting a notice from the ITD, especially, with the recent MoU between SEBI and CBDT for the exchange of data, ITD can catch you for not reporting your Trading transactions. In case your income is below the basic exemption limit you can file a Nil return. Read more about Income tax on trading.

Reply

Kunal says:

2020-10-29 07:32:06

I know that we can show brokerage and STT charges as business expenses if we show trading as business, but I want to know if I can show GST, Exchange Transaction Charges, Sebi Turnover fees, Stamp Duty charges and Exchange penalty charges for margin shortfall as Business expenses?

Reply

Aakash Lalchandani says:

2020-10-29 13:04:46

Hey Kunal, Any expense incurred for trading can be claimed as a valid business expense in P&L Account if trading is considered as a Business Income. However, the Income Tax Act does not allow claiming an expense paid in the form of a penalty. Any expense charged by the broker in the form of a penalty cannot be claimed as a business expense. You can read about what expenses can a trader claim.

Reply

Nihal says:

2020-10-29 05:44:41

How does Quicko report the data to the ITD? As per my understanding, apart from reporting transactions with regards to Capital Gains involving grandfathering, there is no requirement to report scripwise or tradewise data.

Reply

Nireka Dalwadi says:

2020-10-29 11:28:51

Hey Nihal, Quicko reports trade-wise data to Income Tax Department when grandfathering is involved in Capital Gains. All the other data which consist of gains/losses, turnover, and profits are aggregated and reported to the ITD as per the Income Tax utilities. Every year during the Income Tax filing season, the ITD continuously updates these utilities to ease and improve the compliances. In AY 2020-21 the ITD made it not mandatory to report scrip-wise for shares/units which are NOT eligible for Grandfathering.

Reply

Shashwat says:

2020-10-29 05:24:27

So is schedule 112A applicable only for LTCG? and when reporting STCG only total net share values can be entered?

Reply

Nireka Dalwadi says:

2020-10-29 11:09:49

Hi Shashwat, u/s 112A, the taxpayer needs to report the sale of equity share or unit of equity oriented fund or unit of a business trust on which STT is paid under section 112A. Sec 112A is applicable FY 2018-19 (AY 2019-20) onwards to levy 10% income tax on only Long Term Capital Gains on the sale of equity shares, equity mutual funds and units of business trust in above of INR 1 lakh for the FY. When reporting LTCG on shares (where STT is paid) bought on or before 31st Jan 2018 should be calculated as per the grandfathering rule using the FMV. You can find the FMV as ‘Tradewise Exit-Entry’ tab of the Tradewise Tax P&L Report. When reporting LTCG u/s 112A, earlier it was also mandatory to report ISIN - which most brokers did not provide. So to ease the compliance of taxpayers ITD allows you to put ISIN as INNOTAVAILAB. Read more about Section 112A

Reply

e says: (Awaiting Approval)

2023-08-23 17:09:47

Reply

Post a comment

Scroll to Top Quicko