ExcelFree · no sign-upTax and reference

F&O Turnover Worksheet (ITR-3 Filing)

A 5-column Excel worksheet with one row per month: absolute profit, absolute loss and F&O turnover as their sum, ready to hand to your CA for ITR-3.

The .xlsx opens in Excel, LibreOffice or Google Sheets (upload it to Drive, then open with Sheets). Delete the sample row before you log real trades.

See a worked example →
Trade Log
MonthAbsolute ProfitAbsolute LossTurnover (abs method)Notes
Apr 20261,80,0001,20,0003,00,000
May 202695,0001,40,0002,35,000
Illustrative months. Profits and losses are summed trade by trade, ignoring sign.
FormatExcel (.xlsx)
Trade Log sheet5 columns
Best forF&O tax filing
Fill itMonthly, filed yearly

What is inside

F&O income is non-speculative business income, so you file ITR-3 and need a turnover figure. For F&O, turnover is commonly worked out as the sum of absolute profits and absolute losses on each trade, not the contract value.

Filling this monthly saves a scramble in July. Your broker’s tax P&L report usually lists trade-level profit and loss to add up. Confirm the method and any audit requirement with your CA.

Trade Log · 5 columns

One row per month.

  • Month
  • Absolute Profit
  • Absolute Loss
  • Turnover (abs method)
  • Notes

Worked example

April 2026

Trades that made money added up to ₹1,80,000; trades that lost added up to ₹1,20,000 (illustrative).

Turnover
₹3,00,000
Net F&O income
+₹60,000

Turnover can be much larger than net income. Both numbers go to your CA.

The numbers

Turnover = Σ|profit| + Σ|loss|1,80,000 + 1,20,000 = ₹3,00,000
Net = profits − losses1,80,000 − 1,20,000 = ₹60,000

Formulas to paste in

The download has headers and a sample row, not formulas. These match its column letters.

Turnover (D2)
=B2+C2
Year turnover
=SUM(D:D)
Year net
=SUM(B:B)-SUM(C:C)

How to fill it

  1. Download the tax P&L reportGet the month’s F&O trade-wise P&L from your broker.
  2. Add winners and losers separatelyTotal profitable trades and losing trades, both as positive numbers.
  3. Fill one row per monthTurnover is the sum of the two.
  4. Share with your CAHand over the year’s sheet with the broker report before filing.

Same review, without the typing

TradeLyser imports trades from supported Indian brokers by sync or CSV, with charges, and shows win rate, profit factor and drawdown for each strategy.

Try TradeLyser free

Read next

Free calculators

Questions traders ask

Which ITR form is used for F&O income?

F&O income is non-speculative business income, which is reported in ITR-3. Confirm with your CA if you have other income types.

Is F&O turnover the same as contract value?

No. The commonly used method adds up the absolute profit or loss on each trade. Contract value is far larger and is not used for this.

Is the F&O Turnover Worksheet (ITR-3 Filing) free?

Yes. The download link on this page needs no sign-up or email. The workbook ships with column headers and one sample row; add your own formulas or use the ones listed on this page.