Tradebook P&L & Tax Analyzer

Upload your broker's tradebook CSV to see realised P&L split by tax head — intraday, F&O, short-term and long-term capital gains — with F&O turnover for tax audit. Your file never leaves your device.

Works with CSV tradebooks from Zerodha Console, Upstox, Angel One, Groww, Dhan, ICICI Direct and others. Download it from your broker's reports section (usually Reports → Tradebook), then choose the file below — or press “Try sample data” to see how it works first.

Drop your tradebook CSV here or

🔒 Processed in your browser. Nothing is uploaded.

How trades are taxed in India

  • Intraday equity – speculative business income, taxed at your slab rate. Speculative losses can only be set off against speculative gains.
  • Futures & options – non-speculative business income, taxed at your slab rate. Filed in ITR-3; losses can be set off against other non-salary income and carried forward 8 years.
  • Delivery equity held ≤ 12 months – short-term capital gains (STCG), taxed at 20%.
  • Delivery equity held > 12 months – long-term capital gains (LTCG), taxed at 12.5% above ₹1.25 lakh a year.

How to download your tradebook

  • Zerodha – Console → Reports → Tradebook → choose segment and dates → Download CSV.
  • Upstox – Reports → Trade / Tradebook → choose financial year → Download.
  • Angel One, Groww, Dhan – look for Reports → Tradebook or Trade history and export to CSV (convert Excel files to CSV first).

Download all segments (equity and F&O) for the full period you held positions, so delivery trades can be matched to their purchases.

F&O turnover and tax audit

Turnover is the sum of absolute profits and losses on each closed trade, not the contract value. Whether you need a tax audit depends on turnover, profit and whether you use presumptive taxation — the thresholds have changed over the years, so check the current rules with a CA if your turnover is large or you have an F&O loss.

Frequently asked questions

Is my tradebook uploaded anywhere?

No. The file is read and analysed by JavaScript inside your browser. Nothing is sent to any server, and closing the tab discards it.

Which brokers are supported?

Any broker that exports a tradebook as CSV — Zerodha Console, Upstox, Angel One, Groww, Dhan, ICICI Direct and others. Columns are detected automatically; if a column is missed, pick it manually under “Column mapping”.

How is F&O turnover calculated?

Following the ICAI Guidance Note on Tax Audit (2022), turnover for F&O and intraday trading is the total of absolute profits and losses on each squared-off trade. Option premium is not added to turnover.

How are intraday trades identified?

For equity, any quantity bought and sold in the same stock on the same day is treated as intraday (speculative business income). Remaining quantity is treated as delivery and matched first-in-first-out against earlier or later trades.

Are charges deducted?

No. Results are gross of brokerage, STT and other charges. Your broker’s tax P&L statement lists charges, which are deductible as business expenses for F&O and intraday (but STT is not deductible for capital gains).

Can I file my ITR directly from this?

Use it to understand and cross-check your numbers. Corporate actions (splits, bonuses), trades before your tradebook starts and grandfathering are not handled, so confirm figures with your broker’s tax P&L report or a CA before filing.

Results are estimates for educational purposes only and are not investment, tax or financial advice. Verify figures with your broker or advisor before acting on them.

Run a trading business? BlinkCopied also builds white-label copy trading platforms.