F&O Turnover Calculator for Tax Audit (ICAI Method)
Compute F&O turnover the ICAI way — sum of absolute P&L per trade — from your broker's trade-wise P&L, ready to discuss with your CA.
Price: ₹499 (one-time purchase)
Format: XLSX (Excel + Google Sheets) + PDF guide
Delivery: Instant download after payment is confirmed.
Category: Trading Journals
Description
Compute F&O turnover the ICAI way — sum of absolute P&L per trade — from your broker's trade-wise P&L, ready to discuss with your CA. The problem: Traders confuse turnover with contract value or net profit; brokers' reports net trades together. What's different: Trade-wise absolute P&L method, FY filter, segment split, monthly view, neutral reference-threshold flags, input checks. Features: • F&O turnover = Σ |P&L| per trade (ICAI 2022 revision) • Intraday turnover and delivery sale value kept separate • Financial-year filter and monthly table • Editable reference thresholds with neutral flags • Row checks for missing dates, segments and numbers • Up to 5,000 rows Who it's for: Indian F&O and intraday traders preparing ITR / tax-audit discussions. Works with: Microsoft Excel 2010 or later (Windows/Mac), Excel for the web, Google Sheets (upload → open → Save as Google Sheets), LibreOffice Calc 7+. No macros, no add-ins, works offline. How it was tested: every formula was recalculated in LibreOffice Calc and checked against independent Python calculations on the fictional sample data, including edge cases (blank rows, missing fees, invalid numbers, divide-by-zero). The files use only functions available in Excel 2010+ and Google Sheets; open them in your own spreadsheet app before relying on them. Reference thresholds are editable inputs, not legal conclusions. Your broker's tax P&L report is the source record. Not tax advice. Your data stays on your device or in your own Google account — no account, no broker connection. Not affiliated with, endorsed or sponsored by any exchange, broker, index provider, app or educator named on this page; names are used only to describe compatibility or subject matter. Educational record-keeping tool — not investment, tax or legal advice. Trading involves risk of loss; no results are promised.
What's included
- Blank workbook (.xlsx) for your own data
- Sample-data workbook with fictional trades to learn from
- Quick Start Guide (PDF)
- README.txt + personal-use licence (TXT)
Frequently asked questions
Is this a subscription?
No. One-time purchase, instant download after payment. Your purchased version keeps working; free updates are not guaranteed.
Does it connect to my broker?
No. It is an offline file — your data stays on your computer or Google account. You type or paste trades; nothing is sent anywhere.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive, open it with Google Sheets and choose File → Save as Google Sheets. Formulas, dropdowns and colours carry over; charts are converted by Google and can be restyled.
What's the difference between the Blank and Sample Data files?
They are identical except the Sample file is pre-filled with clearly labelled fictional trades so you can see every sheet working. Use the Blank file for your own trading.
How is F&O turnover calculated here?
As the sum of the absolute profit or loss of each F&O trade, the method described in the ICAI Guidance Note on Tax Audit (2022 revision). Intraday turnover and delivery sale value are shown separately.
Is this tax advice?
No. The calculator organises your trade-wise P&L. Your broker's tax P&L report and your CA are the authorities, and the reference thresholds are editable inputs, not legal conclusions.
What if the file doesn't open?
Contact DigiCools via digicools.com with your order email and product ID DC-TJ-38; we will help you open it or resend the file.
Tags: f&o turnover calculator excel, f&o turnover calculation, f&o turnover for tax audit, trading turnover calculator, icai turnover calculation, tax audit trading turnover, itr f&o turnover, trading turnover excel india, intraday turnover calculator