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 →| Quarter | Due Date | Est. Annual Income ₹ | Tax Rate % | Instalment Due ₹ | Paid ₹ | Balance |
|---|---|---|---|---|---|---|
| Q1 | 15 Jun | 20,00,000 | 10 | 30,000 | 30,000 | 0 |
| Q2 | 15 Sep | 20,00,000 | 10 | 60,000 | 0 | 60,000 |
| Q3 | 15 Dec | 20,00,000 | 10 | 60,000 | 0 | 60,000 |
| Q4 | 15 Mar | 20,00,000 | 10 | 50,000 | 0 | 50,000 |
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).
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
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
- Estimate the year’s incomeStart from your journal’s year-to-date net and a cautious projection.
- Work out the taxUse the slab rates, then the effective rate for the Tax Rate % column.
- Pay each instalment by its date15 June, 15 September, 15 December and 15 March.
- 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.
Related templates
Read next
Free calculators
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.