Free Downloadable Excel Compliance Calendar (Auto-FY)

⬇  Download the free compliance calendar 2026-27 (Excel) — no sign-up

Last updated: 27 June 2026 · Built for Indian SMBs. Dates falling on holidays may shift; confirm on the relevant government portal.

A compliance calendar in Excel lists every recurring statutory deadline — GST, TDS, EPF, ESI, income tax and ROC — against its due date, and an "auto-FY" version recalculates those dates for whichever financial year you type in one cell. You can build it yourself with a few formulas, or download our free version (free to download, no sign-up) and adapt it to your business.

Key takeaways

• An auto-FY calendar uses one input cell (the FY start year) so every date shifts automatically — no rebuilding each April.
• The core monthly dates to track: TDS deposit (7th), GSTR-1 (11th), EPF & ESI (15th), GSTR-3B (20th).
• Annual anchors: ITR (31 July non-audit), tax audit (30 September), audit-case ITR (31 October), GSTR-9/9C (31 December).
• Use Excel's DATE, EOMONTH and WORKDAY functions so a deadline on a Sunday rolls to the next working day.
• Our template is free to download, no sign-up — keep it offline, edit it freely.
• Always verify each date on the official portal; some shift on weekends or by government extension.

Fact box. An "auto-FY" Excel calendar needs only one input cell — the financial-year start year (e.g. 2026) — and every GST, TDS, EPF, ESI, ITR and ROC due date recalculates from it using DATE() formulas.

What is an auto-FY compliance calendar?

It is a single spreadsheet where you type the financial year once and all deadlines update. Instead of hard-coding "15 July 2026", you store the rule ("15th of each month") and let Excel compute the actual date for the year you chose.

This matters because Indian compliance runs on the April–March financial year. A calendar that auto-adjusts saves you from rebuilding the whole sheet every 1 April and from copy-paste date errors.

How do I build it in Excel? (step by step)

You can assemble a working auto-FY calendar in a few minutes.

1. Add an input cell. In cell B1, type the FY start year, e.g. 2026 (this means FY 2026-27).
2. Build monthly dates with DATE. For a deadline on the 20th of a month, use =DATE($B$1, 5, 20) for May, =DATE($B$1, 6, 20) for June, and so on. Months 1–3 (Jan–Mar) belong to the next calendar year, so use $B$1+1 for those.
3. Use EOMONTH for month-end dates like the 31 May TDS return: =EOMONTH(DATE($B$1+1,5,1),0).
4. Roll weekends forward with WORKDAY. Wrap a date so it never lands on a Saturday/Sunday: =WORKDAY(DATE($B$1,5,20)-1, 1). Add a holiday list as the third argument for public holidays.
5. Flag what's near. In a status column use =IF(due_date-TODAY()<=7, "Due soon", "") to highlight deadlines within 7 days.
6. Filter to your business. Add a column for applicability (e.g. "only if EPF-registered") so each user hides rows that don't apply.

Fact box. Use =WORKDAY(due_date-1, 1, holidays) in Excel so any statutory date that falls on a weekend or listed holiday automatically rolls to the next working day — mirroring how government portals treat holiday deadlines.

Which due dates should the calendar include?

Include the recurring monthly, quarterly and annual obligations relevant to your registrations.

Why keep the calendar in Excel (and offline)?

Excel is already on the accountant's machine, works without internet, and lets you adapt rows to your exact registrations. There is no login, no subscription and no data leaving your laptop — which suits a small business wary of cloud tools.

How Ankeshan helps: Ankeshan turns this static sheet into a live one — it reads your business profile (GST type, employee count, state, entity) and reminds you 7 days, 3 days and on the day before each deadline, inside Excel. New government dates appear automatically. (Launching soon — join the waitlist for the free Excel calendar.)

Frequently asked questions

Is the Excel compliance calendar free? Yes — it is free to download, no sign-up. You can edit it, keep it offline and adapt the rows to your own registrations.

How does the "auto-FY" feature work? You type the financial-year start year in one cell, and every due date recalculates from it using Excel's DATE and EOMONTH formulas. No need to rebuild the sheet each April.

Does it handle weekends and holidays? If you use the WORKDAY function with a holiday list, a deadline that falls on a weekend or listed holiday rolls forward to the next working day.

Which deadlines does it cover? GST (GSTR-1, 3B, 9), TDS deposits and returns, EPF/ESI, advance tax, ITR, and ROC forms for companies and LLPs — you keep only the rows that apply to you.

Do I still need to check the official portals? Yes. The calendar is a planning aid. Always confirm the exact date on the relevant government portal, since dates shift on holidays and by occasional government extension.

Sources

• GST due dates — cbic-gst.gov.in, gst.gov.in.
• Income tax, TDS and advance tax — incometax.gov.in.
• EPF — epfindia.gov.in · ESI — esic.gov.in.
• MCA / ROC forms — mca.gov.in.

General information, not professional advice. Verify each date on the official portal for your specific case. Reviewed by a Chartered Accountant; last updated 27 June 2026.

Related: Full compliance calendar 2026-27 » · GST return due dates » · ITR due dates by taxpayer type » · Compliance hub »