ExcelFree · no sign-upTax and reference

Advance Tax Quarterly Planner for Traders

An 8-column Excel planner with one row per advance tax instalment: due date, estimated annual income, tax rate, instalment due, paid and balance.

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
QuarterDue DateEst. Annual Income ₹Tax Rate %Instalment Due ₹Paid ₹Balance
Q115 Jun20,00,0001030,00030,0000
Q215 Sep20,00,0001060,000060,000
Q315 Dec20,00,0001060,000060,000
Q415 Mar20,00,0001050,000050,000
Illustrative plan, new regime, before cess. Tax Rate % is the effective rate.
FormatExcel (.xlsx)
Trade Log sheet8 columns
Best forProfitable F&O traders
Fill itQuarterly

What is inside

Trading income has no TDS, so advance tax is due in four instalments: 15% of the year’s tax by 15 June, 45% by 15 September, 75% by 15 December and 100% by 15 March. Missing them adds interest.

Use the effective rate, total tax divided by income, in the Tax Rate % column. Re-estimate income after each strong or weak month and adjust the next instalment.

Trade Log · 8 columns

One row per instalment.

  • Quarter
  • Due Date
  • Est. Annual Income ₹
  • Tax Rate %
  • Instalment Due ₹
  • Paid ₹
  • Balance
  • Notes

Worked example

₹20 lakh of F&O income

Estimated F&O business income of ₹20,00,000 for FY 2026-27 under the new regime, with no other income (illustrative).

Tax for the year
₹2,00,000
Effective rate
10%
Due by 15 Jun
₹30,000

Instalments are cumulative. The 15 September payment is ₹60,000, bringing the total to ₹90,000. Cess is extra; your CA will confirm the final figure.

The numbers

New-regime slabs up to ₹20 lakh0 + 20,000 + 40,000 + 60,000 + 80,000 = ₹2,00,000
15 Jun instalment = 15%₹30,000
By 15 Sep (45%), 15 Dec (75%)₹90,000, ₹1,50,000 cumulative

Formulas to paste in

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

Annual tax at effective rate
=C2*D2/100
Q2 instalment (cumulative 45% less paid)
=C3*D3/100*45%-SUM($F$2:F2)
Balance (G2)
=E2-F2

How to fill it

  1. Estimate the year’s incomeStart from your journal’s year-to-date net and a cautious projection.
  2. Work out the taxUse the slab rates, then the effective rate for the Tax Rate % column.
  3. Pay each instalment by its date15 June, 15 September, 15 December and 15 March.
  4. Re-estimate each quarterUpdate Est. Annual Income before the next due date.

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

Questions traders ask

When is advance tax due for traders?

15 June (15% of the year’s tax), 15 September (45%), 15 December (75%) and 15 March (100%). The percentages are cumulative.

Does the ₹12 lakh rebate apply to F&O income?

Under the new regime, total taxable income up to ₹12 lakh pays no tax because of the rebate. Above that, the full slab tax applies. Ask your CA how it works with your other income.

Is the Advance Tax Quarterly Planner for Traders 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.