CA Office Compliance Management System in Excel: GST and TDS Due Dates, Filing Status, Fees and Staff Report

By Ravindra Bagale · Last updated: 17 October 2026

Download the template: ca-office-compliance-management-system-template.xlsx: a 8-sheet system with example data and real formulas (Read me, Setup, Clients, Compliance, Fees, Fee invoice, Staff report, Dashboard). Yellow cells are inputs you can type over; green cells hold formulas; blue rows are headers and totals. Replace the example data with your own and every report and the dashboard recalculate.

Made-up data: every name, amount, business and date on this page is made up for practice. Cities are used only to make the examples feel real.

1. The business story

Bagale & Associates, Pune, as of 17 October 2026 (made-up clients and filing dates). The due dates are the regular ones for the September 2026 period: GSTR-1 on the 11th (13th for the quarterly GSTR-1 under QRMP), GSTR-3B on the 20th (22nd under QRMP for Maharashtra), TDS deposit for September by 7 October and the quarterly TDS return for July to September by 31 October. When the government extends a date, change it once in Setup.

For personal bills and reminders, see the bill payment reminder; for a GST invoice register see 21.5 GST invoice register.

2. Build it sheet by sheet

Step 1. Setup: the due-date table

1. B3 as-of date, B4 due soon window (7 days), B5 GST on professional fees (an input).
2. In A9:D14 type Compliance, For filing type, Due date, Basis: GSTR-1 (Monthly, 11 Oct), GSTR-3B (Monthly, 20 Oct), GSTR-1 (quarter) (QRMP, 13 Oct), GSTR-3B (quarter) (QRMP, 22 Oct), TDS deposit (TDS, 7 Oct), TDS return Q2 (TDS, 31 Oct).
3. Staff in D3:D5 and filing types in E3:E5 feed the drop-downs.

Step 2. Clients

1. Row 4: Client ID, Client, GST filing, TDS, Monthly fee, Staff, Tasks, Pending, Overdue.
2. GST filing is Monthly, QRMP or None; TDS is Yes or No. That decides which tasks the client gets each month.
3. G5 =COUNTIF(Compliance!$A$5:$A$500,A5), H5 pending with COUNTIFS on a blank filed date, I5 overdue.

Step 3. Compliance calendar

1. One row per client per task. Row 4: Client ID, Client, Compliance, Due date, Filed on, Status, Days late, Staff.
2. D5 =XLOOKUP(C5,Setup!$A$9:$A$14,Setup!$C$9:$C$14) picks the due date from Setup (XLOOKUP).
3. F5: =IF(E5<>"",IF(E5<=D5,"On time","Late"),IF(D5<Setup!$B$3,"Overdue",IF(D5-Setup!$B$3<=Setup!$B$4,"Due soon","Upcoming"))) (nested IF).
4. G5 days late: filed − due when filed late, today − due when still pending past the date. Overdue rows go red; Late and Due soon amber.

Step 4. Fees and fee invoice

1. Fees row 4: Invoice no, Client ID, Client, Fee, GST, Invoice total, Received, Outstanding. E5 =ROUND(D5*Setup!$B$5,0), F5 =D5+E5, H5 =F5-G5.
2. On Fee invoice type a client ID in B4; rows 6 to 12 pull invoice number, client, fee, GST, total, received and balance. Print A1:C16 (print area).

Step 5. Staff report

1. Rows 5 to 7, one per staff member: tasks =COUNTIF(Compliance!$H$5:$H$500,A5), filed (COUNTIFS with "<>"), pending, overdue, late.
2. G5 on-time rate = On time ÷ filed. Rows 11 to 16 count tasks and pending per compliance (COUNTIFS).

Step 6. Dashboard

1. Cards: tasks this month, overdue, due within 7 days, on-time rate, fees billed and fees outstanding.
2. Chart 1 at A8: tasks, filed and pending by staff. Chart 2 at A25: pending by compliance.

3. Formulas used

Every formula above is written in the template, so you can click a cell and see it in the formula bar. All values on this page were recalculated in LibreOffice with zero errors.

4. Common mistakes

1. Typing due dates on every row. When a date is extended you must fix 20 rows. Keep the table in Setup and look it up.
2. Marking a return filed before the acknowledgement. Type the filed date only after the return is actually filed and the acknowledgement is saved.
3. One due date for all GSTR-3B. Monthly filers and QRMP filers have different dates. Keep separate rows for each.
4. Leaving the as-of date old. Nothing turns Overdue if B3 never moves. Use =TODAY() in daily use.
5. Not counting days late. Late fees and interest depend on days. Keep the column even when the return is filed.

5. More real examples

Example 1: Income tax return season. Add ITR rows with the due date for each client category in Setup and the same status formula.

Example 2: Payroll compliance for clients. Add PF and ESI monthly payment rows, using the due dates from the payroll calculator.

Example 3: Assurance practice with engagements. Replace returns with review milestones (planning, fieldwork, report) and use the same Due soon and Overdue flags.

Quick revision cards

Englishमराठीहिंदी

Quick revision

Each card shows formulas from this page, each with an example and its answer from the template. Scan the QR code on a card to open this lesson. All names and numbers are made up for practice.

More cards: Ravi Sir's Cards.

6. Frequently asked questions

What are the GSTR-1 and GSTR-3B due dates?

For monthly filers GSTR-1 is due on the 11th and GSTR-3B on the 20th of the next month. Under QRMP, GSTR-1 is due on the 13th after the quarter and GSTR-3B on the 22nd or 24th depending on the state (22nd for Maharashtra). Check the portal for extensions.

When is TDS deposited and when is the return due?

TDS deducted in a month is deposited by the 7th of the next month (other than March). Quarterly TDS returns are due on 31 July, 31 October, 31 January and 31 May.

How do I flag overdue compliance in Excel?

If the filed date is blank and the due date is before today, show Overdue: the nested IF in Compliance F5 does this.

How do I handle a government extension?

Change the due date once in Setup C9:C14; every task row looks it up and the status updates.

Can I add late fees?

Days late is already worked out. Add a late fee column using the rates that apply to that return; keep it separate from your fee.

7. Quick quiz

Ten questions on this page. Sign in to save your score.