IndiaTrader Tax

ICICI Direct Tax Report Explained: Which File to Use for F&O Turnover and ITR-3

ICICI Direct is a full-service broker and its tax reports look different from the discount-broker formats. Here is which file to use for F&O, how to handle format differences, and how to turn it into a correct ICAI turnover for ITR-3.
June 25, 2026 ยท 6 min read ยท By Aktai Team

Note: This is general information, not tax advice, and tax rules change. Verify the current figures against the Income Tax Act, the relevant Finance Act and ICAI guidance, and confirm your own position with a qualified Chartered Accountant.

What ICICI Direct provides for tax

ICICI Direct offers a P&L or Gain/Loss Report that covers all segments for the financial year. For F&O traders, the relevant part is the Derivatives section. The report shows realised profit and loss per trade, the charges, and a segment-wise summary. This is the input for ICAI turnover.

Format differences from discount brokers

ICICI Direct uses column labels and file formats that differ from Zerodha, Upstox or Dhan. Where Zerodha exports a clean CSV with a standard layout, ICICI Direct may export Excel files with merged cells or different segment tabs. Aktai Tax has a parser for the common ICICI Direct formats. For unusual variants, the column-mapper lets you map your columns once and Aktai remembers the mapping.

If you get an import error on the ICICI Direct file, try the column-mapper: select your symbol, segment, side, quantity, price, date and charges columns, confirm, and Aktai will use that mapping going forward.

Computing ICAI turnover from ICICI Direct data

The ICAI absolute-sum method applies the same way regardless of broker: add the profit on winning trades to the absolute loss on losing trades, per the ICAI 8th-edition Guidance Note (August 2022). The F&O turnover calculator lets you paste your per-trade P/L figures and see the result immediately, without importing a file. For a full report from the ICICI Direct export, use Aktai Tax.

Deductible charges from ICICI Direct

Brokerage, STT, exchange transaction charges, SEBI charges and GST are all deductible trading expenses for F&O business income. The ICICI Direct P&L export typically includes these per trade. Aktai Tax captures them automatically from the export. See the full checklist in deductible trading expenses.

Frequently asked questions

Which ICICI Direct report covers F&O trades?

Use the Profit and Loss Report or Gain/Loss Report for the financial year, selecting the Derivatives or F&O segment. If ICICI Direct produces a single combined report, upload that. Aktai Tax will split trades by segment.

ICICI Direct has a different layout from Zerodha. Will Aktai read it?

Aktai Tax has a built-in parser for ICICI Direct exports. If the format version differs, the column-mapper lets you label your columns once. After that, future uploads recognise the format automatically.

Does ICICI Direct include deductible charges?

ICICI Direct P&L exports include brokerage, STT and exchange charges. Check that your export shows per-trade charges. If charges are consolidated at the account level rather than per trade, your CA can add them from your consolidated tax certificate.

Related reading

How to calculate F&O turnover (ICAI method) โ†’ICICI Direct F&O tax: export and import guide โ†’Is F&O tax audit mandatory? โ†’All supported brokers: import guide โ†’F&O turnover calculator (free tool) โ†’

Aktai Tax ยท for Indian F&O and equity traders

Know your trading tax position all year, not just in July.

Import your broker P&L, get ICAI-correct turnover across every broker, an honest audit-applicability check, an old-vs-new regime estimate, and advance-tax nudges. A clean, tax-ready report your CA can use. No bank linking, no e-filing access.

โœฆ ICAI absolute-sum turnoverโšก Advance-tax reminders๐Ÿ”’ No bank linking
Start free โ†’Explore Aktai Tax โ†’

Estimates for your reference, verify with a qualified CA. For Indian traders.

What AKTAI stands for

A

Always

K

Knowing

T

Trusted

A

Actionable

I

Instant

โš ๏ธ

Not financial advice. Aktai is software for SEBI-registered Research Analysts. It is not a financial adviser, broker, Investment Adviser, or Research Analyst, and is not registered with SEBI or any other financial regulator. It surfaces public filings and news and drafts factual notes for the registered analyst to review, edit, and sign. Aktai does not author research, make recommendations, or decide what any security is worth. The view, the recommendation, and the regulatory responsibility stay with the registered analyst who sends the note. Full disclaimer โ†’