AngelOne Tax P&L: How to Download and Read Every Column
If you invest through Angel One and want to file your own ITR, the tax P&L report is the one file you need. Unlike some brokers that require separate downloads per segment, Angel One delivers everything — equity, intraday, F&O, bonds, dividends — in a single Excel file.
Even better: the first sheet, Summary, pre-computes the six numbers you need for your ITR before you even open the detail sections. This guide walks through how to use that shortcut, explains every column in the detail sheets, and highlights the five AngelOne-specific gotchas that trip up first-time filers.
Reading time: ~9 minutes. Skip to the column reference or the gotchas if you already have the file open.
Your ITR numbers in 60 seconds
Before diving into the column details, open the Summary sheet. Angel One pre-computes the key ITR numbers for you:
| Summary field | Where it goes in ITR |
|---|---|
| Taxable Delivery P&L (LTCG) Excluding Buyback | Schedule 112A |
| Taxable Delivery P&L (STCG) Excluding Buyback | Schedule CG Sec 111A |
| Taxable Intraday P&L (Speculative) | Schedule BP — Speculative Business |
| Futures Turnover | Sec 44AB threshold check |
| Options Turnover | Sec 44AB threshold check |
| Total Charges and Statutory Levies | Business expense deduction (F&O/Intraday) |
For most equity-only investors, the two delivery P&L lines are sufficient. If you have F&O or intraday trades, add the Futures and Options Turnover to get your total F&O turnover for the Sec 44AB audit threshold (₹10 crore for FY 2025-26 under the presumptive scheme).
Two caveats before you rely on the Summary:
- The sheet also shows separate Buyback LTCG/STCG lines — treat these as capital gains, not as dividend income.
- If you held Bonds or SGBs during the year, the Summary totals may include them without distinguishing their different tax treatment. Check the detail sheet first — see Gotcha #1.
How to download your AngelOne tax P&L
- Log in at trade.angelone.in or open the Angel One mobile app.
- Navigate to Reports → P&L Report (the exact path may vary slightly between app and web).
- Select the financial year (for FY 2025-26 returns, choose
2025-26). - Click Download — you receive a single
.xlsxfile covering all segments.
Unlike some brokers that require a separate download per segment (equity, F&O, currency, commodity), Angel One gives you everything in one file.
What's in the file
The downloaded Excel has five sheets:
| Sheet | Contents | ITR relevance |
|---|---|---|
| Summary | Pre-computed LTCG, STCG, Intraday P&L, Turnover totals | Quick cross-check before filing |
| Equity+Bonds+SGB Trade Details | Intraday (speculation) + Delivery trade-wise P&L | Primary source for capital gains |
| Derivatives Trade Details | Futures + Options trade-wise P&L | Primary source for business income |
| Non Trade Charges | DP charges, AMC, other fees | Rarely needed for ITR |
| Dividend Report | Dividend income per scrip | Cross-check with Form 26AS for TDS |
For ITR, you will work with Summary (for totals), Equity+Bonds+SGB Trade Details (for delivery and intraday detail), and Derivatives Trade Details (for F&O).
The Equity sheet is divided into two sub-sections: Intraday (Speculation) at the top, followed by Delivery P&L below it. The Derivatives sheet is divided into Futures and Options sub-sections.
Import your AngelOne P&L into VriddhiQ
VriddhiQ reads the AngelOne file directly — FIFO lot matching, LTCG/STCG split, grandfathering for pre-2018 shares, and ITR-ready Schedule 112A already applied.
Import your AngelOne P&L freeColumn-by-column reference
Equity Delivery P&L
This sub-section (found below the Intraday section in the Equity sheet) has 17 columns. It is the most important section for equity investors.
| Column | What it is | ITR usage |
|---|---|---|
| ISIN | International Securities ID | Required for Schedule 112A |
| Scrip Name | NSE/BSE trading symbol | Identification |
| Qty | Shares sold in this lot | Quantity |
| Buy Date | FIFO-matched purchase date | Date of acquisition |
| Sell Date | Date of this sale | Date of transfer |
| Avg Buy Price | Purchase price per share | Cost of acquisition per unit |
| Buy Value | Qty × Avg Buy Price | Raw cost basis |
| Avg Sell Price | Sale price per share | Sale consideration per unit |
| Sell Value | Qty × Avg Sell Price | Full value of consideration |
| Cost Of Acquisition | Adjusted cost — may include grandfathering for pre-2018 shares | Use this for Schedule 112A, not Buy Value |
| Charges and Statutory Levies | Brokerage + exchange charges (STT excluded) | Already netted into P&L |
| STT | Securities Transaction Tax | Not deductible for delivery (Sec 48) — already excluded |
| Net Profit/Loss | Sell Value − Buy Value − Charges | Pre-LTCG/STCG split gain |
| Long term taxable income | LTCG portion (holding > 365 days) | Schedule 112A / Schedule CG |
| Short term taxable income | STCG portion (holding ≤ 365 days) | Schedule CG Sec 111A |
| Purchase Type | Normal / IPO / Rights / Bonus | IPO allotments use issue price as cost |
| Type of instrument | Equity/Corporate Bonds / SGB / Bond | Filter this — see Gotcha #1 |
Key advantage: Angel One already splits each row into Long term taxable income and Short term taxable income. You do not need to separately determine the holding period — the column does it for you.
Equity Intraday (Speculation)
This sub-section appears first in the Equity sheet, above the Delivery section. It has 11 columns.
| Column | What it is | Notes |
|---|---|---|
| ISIN | International Securities ID | |
| Scrip Name | Symbol | |
| Qty | Shares bought and sold same day | |
| Transaction Date | Single date (buy = sell = same day) | No separate Buy Date / Sell Date |
| Avg Buy Price | Average intraday buy price | |
| Buy Value | Total intraday buy value | |
| Avg Sell Price | Average intraday sell price | |
| Sell Value | Total intraday sell value | |
| Charges and Statutory Levies | Brokerage + exchange charges | Fully deductible speculative business expense |
| STT | STT on intraday trades | Deductible for intraday (unlike delivery) |
| Taxable P&L | Net speculative profit/loss | Schedule BP — Speculative Business Income |
Intraday P&L is speculative business income. It can only offset other intraday (speculative) income in the same FY — it cannot be set off against delivery capital gains or F&O profits.
Derivatives — Futures
| Column | What it is | Notes |
|---|---|---|
| Segment | NSE / BSE / MCX | Commodity futures (MCX) are included here |
| Symbol Name | Contract name (e.g. NIFTY, SILVER) | |
| Expiry date | Contract expiry | |
| Qty | Number of lots | |
| Buy Date | Contract open date | |
| Sell date | Contract close date | |
| Avg Buy Price | Average entry price | |
| Buy Value | Total entry value | |
| Avg Sell Price | Average exit price | |
| Sell Value | Total exit value | |
| Total Charges and Statutory Levies | All charges excl. STT | Deductible business expense |
| STT | STT on futures | Deductible business expense |
| Closing Price (31/03/YYYY-1) | Prior FY year-end closing price | Cross-year position MTM — see Gotcha #3 |
| Closing Price (31/03/YYYY) | Current FY year-end closing price | Open position MTM at year-end |
| Taxable P&L | Net non-speculative profit/loss | Schedule BP — Non-Speculative Business Income |
| Turnover | abs(Sell Value − Buy Value) | Sec 44AB audit threshold |
Derivatives — Options
The Options sub-section adds Strike Price and Option Type compared to Futures:
| Column | What it is | Notes |
|---|---|---|
| Segment | NSE / BSE / MCX | |
| Symbol Name | Contract name | |
| Expiry date | ||
| Strike Price | Option strike price | |
| Option Type | CE (Call) or PE (Put) | |
| Qty | Lots | |
| Buy Date / Sell date | Open / close dates | |
| Avg Buy Price / Buy Value | Entry price / value | |
| Avg Sell Price / Sell Value | Exit price / value | |
| Total Charges and Statutory Levies | Deductible | |
| STT | Deductible | |
| Taxable P&L | Net non-speculative P&L | Schedule BP |
| Turnover | Premium received on options sold | Different formula from futures — see Gotcha #4 |
Five AngelOne-specific gotchas
1. Bonds and SGBs sit in the Equity sheet — and have different tax treatment
The sheet is named "Equity+Bonds+SGB Trade Details" for a reason. Normal equity rows show Type of instrument = "Equity/Corporate Bonds" (Angel One's label for regular shares). SGB and Bond rows show different values.
Why it matters:
- Sovereign Gold Bonds (SGBs) redeemed at maturity via RBI are fully exempt from capital gains tax. SGBs sold in the secondary market before maturity are taxed as capital gains normally.
- Bonds (NCDs, government securities) require a 36-month holding period for LTCG for unlisted bonds — listed bonds reduced to 24 months after Budget 2024. Both are longer than equity's 12 months.
Before using the Summary tab LTCG/STCG figures, scan the Type of instrument column in the Delivery section for any rows that are not regular equity. Adjust the totals if needed.
2. "Cost Of Acquisition" may differ from Buy Value — use it for Schedule 112A
For shares acquired before 1-Feb-2018, LTCG is calculated on the higher of actual purchase cost or the Fair Market Value (highest traded price) on 31-Jan-2018 — capped at the sale consideration. This is the grandfathering rule under Section 112A.
Angel One populates the Cost Of Acquisition column with this adjusted value. For old holdings, Cost Of Acquisition may be higher than Avg Buy Price × Qty. Always use Cost Of Acquisition — not Buy Value — when filling ITR Schedule 112A.
To verify: find one pre-2018 holding in the Delivery section and check whether Cost Of Acquisition differs from Avg Buy Price × Qty. If it does, grandfathering has been applied.
3. Cross-year futures: open positions are MTM'd at 31-Mar closing price
If you held a futures contract open across the financial year boundary — bought in March 2025, closed in April 2025 — Angel One splits the P&L across two FYs using the 31-Mar closing price.
The Closing Price (31/03/YYYY-1) and Closing Price (31/03/YYYY) columns show the prices used for this mark-to-market. This is correct per ICAI guidance, but it means:
- Your FY 2025-26 report will show partial P&L for that contract (MTM to 31-Mar close, not actual close).
- The remaining P&L appears in your FY 2026-27 report when you actually close the position.
This is not an error in the report — it is the correct tax treatment for cross-year open positions.
4. Options turnover uses a different formula than futures turnover
Per ICAI guidance:
- Futures turnover = abs(Sell Value − Buy Value) per contract
- Options turnover = premium received on options sold
Angel One applies the correct formula in each sub-section's Turnover column. Don't assume both use abs(P&L) when cross-checking.
For the Sec 44AB threshold: add Futures Turnover + Options Turnover from the Summary sheet. The threshold for FY 2025-26 under the presumptive scheme is ₹10 crore.
5. Off-market transfers and gift shares show zero cost
If shares were transferred into your Angel One demat via off-market transfer (CDSL Easiest), received as a gift, or inherited, Buy Value and Cost Of Acquisition will show zero (or be absent entirely). Filing with a zero cost basis dramatically inflates your reported capital gains.
You must manually enter the correct acquisition cost — from the previous broker's contract notes, gift deed, or probate records. This is the most common source of inflated capital gains in DIY ITR filings.
Frequently asked questions
Q: Where do I download my AngelOne tax P&L? A: Log in at trade.angelone.in or the Angel One app, go to Reports → P&L Report, select the financial year, and click Download. You get a single Excel file — no separate downloads per segment.
Q: Does AngelOne already split LTCG and STCG for me?
A: Yes. The Delivery P&L section has separate Long term taxable income and Short term taxable income columns per row. The Summary sheet aggregates them. These transfer directly to Schedule 112A (LTCG) and Schedule CG Sec 111A (STCG).
Q: Why are Bonds and SGBs in the Equity sheet?
A: Angel One groups all non-derivative instruments together. Check the Type of instrument column — SGBs redeemed at maturity via RBI are tax-exempt, and Bonds need a 36-month (not 12-month) holding for LTCG. Confirm treatment for any non-equity rows before using the Summary totals.
Q: How does AngelOne calculate F&O turnover? A: Futures turnover = abs(Sell Value − Buy Value). Options turnover = premium received on options sold. Angel One applies the correct formula in each sub-section. Add both for your total F&O turnover for the Sec 44AB threshold.
Q: What is "Cost Of Acquisition" in AngelOne — is it the same as Avg Buy Price × Qty?
A: Not always. For shares acquired before 1-Feb-2018, Angel One adjusts the cost to the FMV on 31-Jan-2018 under the Sec 112A grandfathering rule. Always use Cost Of Acquisition — not Buy Value — when filling Schedule 112A.
Further reading
- Consolidating tax P&L across multiple brokers — the hub article if you trade on more than one demat
- F&O turnover calculation FY 2025-26
- Section 64(1A) minor income clubbing
- LTCG ₹1.25L exemption FY 2025-26 — coming soon
Stop calculating. Start filing.
VriddhiQ imports your broker statements, applies FIFO matching, clubs minor income under Sec 64(1A), and exports ITR-ready summaries — automatically.
Try VriddhiQ freeThis article reflects rules as of FY 2025-26 (Budget 2024 amendments). Tax laws change yearly — always confirm with your CA or the income-tax portal before filing.