Kotak Securities Tax P&L: How to Download and Read Every Column

If you trade through Kotak Securities and want to file your own ITR, the Tax P&L Statement is the single file you need. Kotak gives you something most brokers don't: every row in the Tax P&L sheet is already split into three separate columns — Intraday, STCG (<1yr) and LTCG (>1yr). You don't have to compute holding periods or run pivot tables. Each row contributes to exactly one of the three.

This guide walks through how to download the file, explains every column across all four sheets, and highlights the five Kotak-specific quirks worth knowing before you copy numbers into your ITR.

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

Open the file and look at rows 2–5 of the Tax P&L sheet. Kotak pre-computes the headline numbers in the top-right block:

For most equity-only investors, the three taxable columns inside each detail row — Intraday, <1yr, >1yr — are sufficient. Sum each column across all delivery rows and you have your STCG and LTCG figures ready for Schedule CG.

Caveat before you rely on the totals: if you have Bonds, SGBs or REITs in your demat, they may sit alongside equity in the same sheet under different Security Type values. The header summary aggregates them with equity, so verify the Security Type column before treating Realised P&L as pure equity capital gains — see Gotcha #5.

How to download your Kotak tax P&L

1. Log in to Kotak Neo at neo.kotaksecurities.com (or the legacy Kotak Securities desktop site).
2. Navigate to Reports → Tax P&L Statement.
3. Select the financial year (for FY 2025-26 returns, choose 2025-26).
4. Click Download — you receive a single .xlsx file.

Unlike Zerodha (which requires a separate download for Equity, F&O, Currency and Commodity), Kotak gives you one file covering every segment plus holdings and dividends.

What's in the file

The downloaded Excel has four sheets:

For ITR you will primarily use Tax P&L (for equity capital gains and intraday) and Derv_Tradewise (for F&O business income). The Portfolio Tracker is useful at year-end for verifying that your open positions match the broker's record.

Column-by-column reference

Tax P&L — Equity section

Row 6 is the column header. Row 7 is a sub-header that splits column 14 into three Tax P&L columns. Below row 8 (labelled "Equity") sit the equity rows; below "Derivatives" sit the futures and options summary rows. The headers are:

Exactly one of the three Tax P&L columns will have a non-zero value per row — Intraday for same-day trades, <1yr for STCG, >1yr for LTCG. The other two will be 0. This is the key advantage of Kotak's format over brokers that give you a single P&L value and force you to split it yourself.

Tax P&L — Derivatives section

Below the equity section, the same column structure repeats under a "Derivatives" label. Important: derivatives rows in the Tax P&L sheet are aggregated summaries, not per-trade detail. Per-trade F&O data lives in the Derv_Tradewise sheet.

The Buy Date and Sell Date columns in the derivatives section are typically blank — Kotak does not retain dates at this aggregation level. For Schedule BP filing you don't strictly need dates, but if your CA asks for contract-level dates, use the contract notes.

Derv_Tradewise — per-trade F&O

This sheet has 13 columns covering each matched futures/options trade pair:

No dates in this sheet. If you need to reconstruct buy/sell dates per contract (for audit detail), pull them from the contract notes — the Tradewise sheet only retains prices and quantities.

Turnover note: for the Sec 44AB threshold (₹10 crore for FY 2025-26 under presumptive scheme):

• Futures turnover = abs(Sell Amt − Buy Amt) per contract — use the Tax P&L header field
• Options turnover = premium received on options sold — use the Tax P&L header field

Don't sum Buy Amt + Sell Amt as turnover; that double-counts.

Dividend Statement

Three columns per row: Scrip Name, ISIN, Ex-date, Qty, Dividend Type ("Final" / "Interim" / "Special"), Dividend per share, Total Dividend Amount. The header shows Total Dividend across the year.

Dividends are taxed at slab rates as "Income from Other Sources" — not capital gains. Cross-check this sheet against your Form 26AS / AIS for any TDS already deducted (10% TDS if dividend per company > ₹5,000 per FY).

Portfolio Tracker

Open holdings as of the year-end date shown in the header. Columns:

The sheet is divided into sub-sections by Security Type (Equity, Mutual Funds, Derivatives Open Positions). Unrealized P&L is informational — only realised gains appear in the Tax P&L sheet.

Five Kotak-specific gotchas

1. Tax P&L is pre-split into Intraday / STCG / LTCG — verify each row contributes to one

This is Kotak's headline feature, but it can mislead if you don't notice the layout. Row 7 shows three sub-headers under column 14: Intraday, <1yr., >1Yr. Each equity delivery row will have a value in exactly one of these three columns; the others will be 0.

Why it matters: if you SUM the entire "Tax P&L" column across all rows, you'll get the right total only because two of the three sub-columns are zero per row. But if you copy values into ITR Schedule CG using a quick column sum, make sure your spreadsheet is summing the correct sub-column — <1yr. for STCG and >1Yr. for LTCG. Don't confuse the column orders.

Charges (GST, Brokerage, Misc., STT) are already deducted from these taxable values per row — you don't add or subtract them separately.

2. FMV per Unit as on 31st Jan. 2018 — grandfathering shown explicitly

For shares acquired before 1-Feb-2018, LTCG under Sec 112A is calculated on the higher of the actual purchase cost or the FMV on 31-Jan-2018, capped at the sale consideration. This is the grandfathering rule introduced by the Finance Act 2018.

Kotak shows the FMV in its own column (column 11), and the total FMV (per-unit × qty) in column 12. For shares bought after 1-Feb-2018, both columns will be 0. For pre-2018 holdings, you can verify the grandfathering is being applied by comparing:

• Buy Amt. (A) vs. FMV as on 31st Jan. 2018

The Tax P&L >1Yr. column already uses the higher of the two as the cost basis for the LTCG calculation. If Buy Amt is ₹1,00,000 but FMV is ₹1,50,000, your effective cost for LTCG is ₹1,50,000 — meaning your taxable LTCG is smaller. For Schedule 112A in the ITR utility, you'll enter both: actual cost in one field and FMV in another, plus the date of acquisition. Kotak gives you all three.

3. F&O has no trade dates — anywhere in the file

The Tax P&L derivatives section is an aggregated summary (no dates). The Derv_Tradewise sheet has prices and charges per contract, but also no buy/sell dates.

This is harmless for ITR — Schedule BP for non-speculative business income doesn't require per-trade dates. But if you need contract-level dates for audit purposes or for a CA's working file, pull them from your contract notes. Tools that import the Derv_Tradewise sheet (including VriddhiQ) default the F&O dates to the FY period and flag them so you can edit per-contract if needed.

4. Acquisition type and Sell type — watch off-market transfers

Columns 3 and 4 in the Tax P&L sheet show how the shares entered and left your demat:

• "On-market" = regular exchange trade — Buy Amt. and Sell Amt. are reliable.
• "Off-market" = the position bypassed the exchange. Common reasons: gift from family, inheritance, transfer from another broker's demat, ESOP allocation, buyback through tender.

For off-market acquisitions, the Buy Amt. may be ₹0 (if the cost basis wasn't carried over during the transfer), or it may reflect the new demat's record — which may differ from the original cost. Always cross-check off-market acquisition rows against the source documents (gift deed, ESOP grant letter, contract note from the previous broker).

Filing ITR with a ₹0 buy amount on a transferred holding overstates capital gains and overpays tax. This is the single most common DIY filing error on Kotak P&Ls.

5. Bonds, SGBs and REITs sit alongside equity — different tax treatment

The Security Type column distinguishes EQUITY STOCK from SGB, Bond, REIT, etc. The header-summary Realised P&L and Taxable P&L aggregate everything in the sheet, so before relying on the headline figure:

• Scan the Security Type column for non-EQUITY rows.
• 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 normally.
• Bonds (NCDs, government securities): listed bonds have a 24-month LTCG holding period after Budget 2024 (was 36 months); unlisted bonds are still 36 months.
• REITs / InvITs have their own holding-period rules and a portion may be distributed as exempt income.

If you find non-equity rows mixed in, recompute the equity-only LTCG and STCG totals by filtering. Don't copy the header summary blindly into Schedule 112A.

Frequently asked questions

Q: Where do I download my Kotak Securities tax P&L? A: Log in to Kotak Neo (neo.kotaksecurities.com), go to Reports → Tax P&L Statement, select the financial year, and download. You get one Excel file with four sheets: Tax P&L, Derv_Tradewise, Dividend Statement, Portfolio Tracker.

Q: Does Kotak already split LTCG, STCG and Intraday for me? A: Yes. The Tax P&L sheet has three separate columns per row — Intraday, <1yr (STCG) and >1yr (LTCG). Each row contributes to exactly one. The header block also aggregates the totals.

Q: Why does the Tax P&L sheet show no dates for F&O trades? A: Kotak rolls F&O up into segment summaries in the Tax P&L sheet. Per-trade F&O detail is in the Derv_Tradewise sheet — but dates aren't shown there either. If you need contract-level dates, pull them from your contract notes.

Q: What is the FMV per Unit as on 31st Jan. 2018 column for? A: Section 112A grandfathering. For shares acquired before 1-Feb-2018, the cost of acquisition is the higher of the actual purchase cost or the FMV on 31-Jan-2018 (capped at sale value). Kotak shows this per-unit FMV explicitly so you can verify grandfathering was applied. For post-2018 acquisitions it's 0.

Q: How do I treat the "Acquisition type" and "Sell type" columns? A: "On-market" = a normal exchange trade with reliable cost and sale values. "Off-market" = the position was transferred outside the exchange (gift, inheritance, demat transfer, ESOP, buyback). Off-market acquisition rows may show ₹0 or an incorrect Buy Amt. Verify against the source documents before filing.

Further reading

• Consolidating tax P&L across multiple brokers — the hub article if you trade on more than one demat
• Zerodha Tax P&L Guide
• AngelOne Tax P&L Guide
• F&O turnover calculation FY 2025-26
• Section 64(1A) minor income clubbing
• LTCG ₹1.25L exemption FY 2025-26 — coming soon

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