(Resolved) Tax PNL report is not satisfactory and figures do not match with other PNL report

Thanks…I have followed your steps but this approach still does not give the buy and sell dates individually…and this is what CA is asking to upload into the income tax website…

what to do to solve this issue?

Plus there are many situations where the # buy is not equal to # sell – because it is common that person does not sell within the same FY,and carry his holdings into the next FY. And for calculate capital gains, we need to consider equal number of buy and sold quantity

what to do to solve this issue?

thanks… @dhingrab @Sameet @iamshrimohan @shraddha

I see that in the ‘P&L report’ – there is table at the top called – ‘Consolidated P&L summary across all segments’ – it mentions a field called ‘realized P&L’

Is that value = capital gains?

In the Annual Global statement sent to you by Dhan for last FY we have the trades segregated date wise. Bit more difficult than the case where the useful info is aggregated on a broker report. But it has what u r CA needs.

@t7support Again just now I have checked SPAM also – but unable to locate this annual global statement with dates which you are talking about

Please can you resend email me the – annual global statement with dates – which you are talking about here

You can send to my registered email itself right now…

Without the dates I am unable to file the ITR

Prompt sending of this requested Annual Global Statement – clearly reflecting the capital gains/loss – will be highly appreciated please

Only Dhan can. Am not a Dhan employee. Besides it should be in your registered email with Dhan already. All brokers have to send this for every FY to client email.

It has trades segregated date wise. But it doesn’t have the aggregated view u want. But u can create such a report using the data in AGTS.

@t7support Again just now I have checked SPAM also – but unable to locate this annual global statement with dates which you are talking about

Please can you resend email me the – annual global statement with dates – which you are talking about here

You can send to my registered email itself right now…

Without the dates I am unable to file the ITR

Prompt sending of this requested Annual Global Statement – clearly reflecting the capital gains/loss – will be highly appreciated please

oh…ok I thought you are dhan team @t7support :slight_smile:

I have emailed to dhan care for this report now, as I am unable to locate it anywhere even in SPAM folder also

thanks for your inputs and support with this… would it be possible for you to share with me how you calculate and report the capital gains 1) short term and 2) long term

:sweat_smile: Exchange registered AP for Dhan which is like a sub broker.

I trade the market. Not into investing. But AGTS is the primary input to do it.

The issue is – in the AGTS worksheet, some transactions does not have matching buy quantity vs sell quantity.

In those cases how to find the capital gain/loss?

This is where u need some manual effort. You can give it to your CA. He will do the math for you.

without the dates of buy and sell – he is unable to comprehend what to do

Last FY AGTS has the buy and sell trades done for the last FY.

Any shares that are outstanding on the sell side (after matching the rest) is carry over shares from last FY - LTCG. You can’t short sell in Indian market. So this assumption holds.

Any buy and sell in the same FY, the extend to which you are able to match is STCG.

Any shares that are outstanding on the buy side (after matching the rest) is carry over shares to next FY. No tax botheration here.

Your CA should be able to do this.

@t7support many thanks for the guidance with the steps

a question: BY ANY CHANCE is this ‘Annual Global Statement’ – which you have mentioned ,

Is it the same as ’ Tax Profit and Loss Report Summary Statements from 01-04-2023 to 31-03-2024’ – which I can able to generate online ?
or
is it the same as
‘Profit and Loss Report from 01-04-2023 to 31-03-2024’ – which I have generated online?

no

Dhan seems to have updated this recently. It has stcg, ltcg etc sections marked. However it is blank for me as I don’t have any transactions. Please check out at your end. Also they have added AGTS to it. The format though seems bit different from what I received in email.

ok…you are right…
I see the heading ‘SHORT TERM’ in the Equity worksheet (see attached please)

Now in this kindly tell which is the CAPITAL GAINS value – is it column L (gross P&L) or column N (net P&L)?

1 Like

Have you tried importing fno data on Quicko and Clear tax for DHAN? It is total mismatch everywhere(PNL, turnover, charges) for my FNO data. If you have filed please guide what should I do.

I have used Quicko in previous years for filing ITR. At that time, I was using Zerodha. Whatever data is imported matched with TAX PNL data. For Dhan, it is failing to do so. I am not sure why it is happening. It might be some problem on Quicko side, but what is astonishing is same thing is happening on Clear Tax also. This makes me believe that Dhan reports have something wrong which all these platforms are reflecting.

1 Like

Have you checked the latest Tax Pnl report downloaded from Dhan ? Is it correct ?

  1. They are not giving out the buy and sell dates for FNO or Equity tab
  2. ATGS has missing entry for the commodities
2 Likes

Quicko removed the Dhan from the listed brokers. We can’t see Dhan icon now in quicko. Not sure if they are working on it or they have removed it.

I had highlighted issue to Quicko and seems after observing integration issue, they removed Dhan itself :slight_smile: