Trading Turnover Calculator for Tax Audit

For closed futures trades, tax-audit turnover adds profits and losses as positive amounts. It differs from net profit and total contract value. This calculator adds manually entered totals, but can double-count option amounts and cannot confirm whether an audit is required. Its intraday help text also gives an unsuitable turnover instruction. Use the worked examples to check how the totals add up, then ask a chartered accountant to check your reporting period and full records.

Start with the reporting period

The Income Tax Department’s transition FAQ distinguishes FY 2025-26, assessed in AY 2026-27, from Tax Year 2026-27. The earlier period remains under the Income-tax Act, 1961; the later framework uses the Income-tax Act, 2025. Section 63 corresponds to the former Section 44AB.

The calculator has no year selector. Its heading and audit card therefore cannot decide which legal framework applies to your return. Keep the dates attached to the broker reports and business records you are adding.

Due dates for AY 2026-27 audit cases

The Central Board of Direct Taxes (CBDT) issued Circular No. 07/2026 dated 28 September 2026. It moves the due date for filing the return of income for Assessment Year 2026-27 (Previous Year 2025-26) from 31 October 2026 to 21 November 2026 for the persons listed at serial number 2 in the table below Explanation 2 to section 139(1). It says that, as a result, the specified date for furnishing the audit report moves to 21 October 2026.

The circular names a category of taxpayers by reference to the table in section 139(1). Dates can change again, so check the Income Tax portal for the latest notice. Whether you fall in that category depends on your facts, so ask a chartered accountant (CA) rather than assuming. If you are unsure whether your records need an audit report at all, do not wait for a calculator result. Contact a CA now, because the specified date for the audit report, 21 October 2026, had passed by 28 October 2026.

Difference-based turnover and the options exception

ICAI’s Revised 2025 tax-audit guidance adds favourable and unfavourable differences for closed derivatives trades and intraday trades without delivery. It also discusses reverse trades, open positions and delivery settlement. A broker’s traded contract value is a different measure. ICAI now lists a Revised 2026 edition, but its full text was not available without signing in when checked on 16 October 2026. The discussion here describes the accessible earlier edition; ask your accountant to check the newer guidance before applying it.

The options clause includes sale premium and says: “However, where the premium received is included for determining net profit for transactions, then such net profit should not be separately included.” This qualification matters. The calculator always adds its Options Profit, Options Loss and Options Premium fields; it cannot determine whether those amounts overlap.

Ask your accountant to reconcile the options report with that clause. Do not assume that every report needs a premium addition, or that premium is universally excluded. The tool offers no way to mark which amounts already contain a premium.

How the actual fields are added

• Futures Total Profit: add the positive trade differences; avoid using the single annual net result.
• Futures Total Loss: enter the total losing differences as a positive magnitude.
• Options Profit, Options Loss and Options Premium Received (Selling): these are unconditionally added by the tool. Resolve the reporting basis before treating that sum as tax turnover.
• Intraday Equity Turnover: enter a separately checked turnover subtotal. The help text’s buy-value-plus-sell-value instruction does not follow the guidance’s difference-based approach for non-delivery speculative transactions.
• Net Trading Profit/Loss: a separate result, which affects Profit % and the audit card. It does not replace the turnover calculation.
• Other Business Turnover: a manually prepared business subtotal; the form does not classify individual receipts.

This is a totals form, without transaction dates, individual trade rows, charge inputs or a report-reading function. For terminology, see F&O turnover and intraday trading taxation.

Second worked example: options with sale premium

This example shows why the options fields need care. These figures are made up and only show how premium received and the differences are handled in the fields. A trader closes options trades with ₹2,50,000 of positive differences and ₹1,80,000 of negative differences, and also sold options for a total premium of ₹4,00,000. The calculator adds all three option fields, so it shows options turnover as:

The two readings differ by ₹4,00,000. Which one is right depends on how your broker report was built and on the guidance quoted above, which says that where the premium received is included for determining net profit, that net profit should not be separately included. Your CA decides this, not the tool. If the premium is already inside the profit and loss figures, entering it again overstates the turnover.

Where turnover meets the audit threshold

The department's published position, as reported from its FAQ (check the portal or a CA for the current limits), is that a business is covered once total sales, turnover or gross receipts exceed ₹1 crore, and that the limit rises to ₹10 crore where cash receipts and cash payments each do not exceed 5% of the totals. The calculator's Turnover (Cr) card divides your total by 1,00,00,000 so you can see where you stand.

The third row shows why the form cannot decide for you. At 1.2 crore, the turnover is above ₹1 crore, but if your receipts and payments meet the 5% cash limit the threshold is ₹10 crore. A trader who trades only through bank accounts may meet it. A CA will check both sides of the condition. The same row can also be affected by presumptive taxation and past opt-outs, which the form also does not ask.

Worked example that the futures calculation can reproduce

Made-up closed futures trades produce ₹3,00,000 of positive differences and ₹1,00,000 of negative differences. Assume no options, intraday trades or other business receipts, and no expenses in this simplified example. Enter those futures totals, leave the other turnover inputs at zero and set Net Trading Profit/Loss to ₹2,00,000.

The loss increases turnover while reducing net profit. These outputs reconcile for the example inputs. Any Audit Required message remains subject to the missing information described below; this example is not an audit-exemption opinion.

For an additional made-up intraday illustration, positive differences of ₹12,000 and negative differences of ₹7,000 produce ₹19,000 of difference-based turnover and ₹5,000 net profit. That is separate arithmetic, not a buy-plus-sell contract-value calculation or an addition to the futures example.

Why the audit answer is incomplete

As checked on 16 October 2026, the department’s business-audit FAQ states an ordinary threshold exceeding ₹1 crore, increased to ₹10 crore where cash receipts and cash payments each meet the 5% limit. It separately lists certain presumptive-taxation cases. An electronic trading account alone does not supply the form with all those business-wide facts.

This calculator collects neither cash-receipt nor cash-payment totals, past use of presumptive taxation (declaring a prescribed assumed profit), total income or business eligibility. Its fixed profit-percentage shortcut therefore cannot establish audit applicability. The trader tax-audit guide explains why turnover and audit obligations need separate consideration.

A loss does not make this incomplete form capable of deciding audit duties. Nor does its Below threshold message establish that no other audit condition applies. Ask a chartered accountant to review the relevant law, business records and prior filing history.

Reconcile before taking a number into a return

Separate futures, options and intraday schedules before combining any subtotals. Retain the transaction-level report, account statements and explanation of the options-premium basis. Keep expenses apart from a gross-difference schedule so net income and turnover remain traceable.

The form also substitutes a futures-and-options net result when Net Trading Profit/Loss is zero or blank. That can conflict with a true zero after other trading results or expenses. Check the displayed Net P&L rather than assuming the entered zero survived.

OneTradeJournal can hold trades and notes entered by hand. Keep broker records and accountant-prepared schedules for filing; journal totals and charge estimates do not certify an income-tax return.

Records to keep for your CA

• The broker's profit and loss statement for the year, with its label for each column.
• The trade-level report for futures, options and intraday trades, kept as separate schedules.
• Contract notes or the funds statement for charges. Your journal's charge estimate is not a substitute.
• Bank statements showing the settlement of profits, losses and premium.
• A note of how you treated options premium and open positions at year end.
• Any losses carried forward from earlier years.

OneTradeJournal can export your manually entered trades to CSV, JSON or TXT, which may help you list what you logged. It has no broker import, so it cannot show you a report your broker has not given you, and its totals do not certify a return.

Common mistakes when using a turnover form

• Entering the year's net profit instead of the profit and loss differences separately.
• Entering buy value plus sell value for non-delivery trades instead of the differences the guidance uses.
• Entering a loss as a negative number where the form asks for a positive total.
• Entering options premium that is already inside the profit and loss figures.
• Treating the Audit Required card as an opinion on your obligations.
• Mixing two financial years in one set of totals.

For definitions, see F&O turnover, tax audit for traders, ITR-3 for traders and the 60/40 rule for futures. Always confirm the final treatment with a chartered accountant.

Sources

• ICAI: Revised 2025 guidance, transaction-turnover discussion, checked 16 October 2026.
• Income Tax Department: audit thresholds and old/new Act transition, checked 16 October 2026.
• ICAI: Revised 2026 edition listing; full text requires sign-in, checked 16 October 2026.