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 →| Month | Absolute Profit | Absolute Loss | Turnover (abs method) | Notes |
|---|---|---|---|---|
| Apr 2026 | 1,80,000 | 1,20,000 | 3,00,000 | |
| May 2026 | 95,000 | 1,40,000 | 2,35,000 |
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 can be much larger than net income. Both numbers go to your CA.
The numbers
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
- Download the tax P&L reportGet the month’s F&O trade-wise P&L from your broker.
- Add winners and losers separatelyTotal profitable trades and losing trades, both as positive numbers.
- Fill one row per monthTurnover is the sum of the two.
- 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.
Related templates
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.