CA firm compliance tracker in Excel
A client master and a work list: every filing of the month with its data status, work status and who it is pending with.
What the file looks like
The heading row and the five example rows, as they open in Excel. Under them the file has empty rows that are ready: the lists, the formulas and the colours are already set.
| Client | Entity | Group | Registrations | GST returns | TDS | Income tax | ROC filings | Payroll | Data from | Handled by | Reviewer | Fee |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Mittal Hardware | Proprietor | Mittal family | PAN and GSTIN on file | Monthly | No | Return | No | Mr Mittal, Tally backup, by the 5th | Aman | Neha | Monthly retainer | |
| Kapoor Builders Pvt Ltd | Private limited | Kapoor group | PAN, GSTIN, TAN and CIN on file | Monthly | Yes | Advance tax, return, audit | Yes | PF and ESI | Accountant, Excel and bank statement, by the 7th | Ritika | Neha | Monthly retainer, audit billed yearly |
| Sunrise Auto Components LLP | LLP | PAN, GSTIN, TAN and LLPIN on file | Monthly | Yes | Advance tax, return, audit | Yes | Accounts head, Tally backup, by the 6th | Ritika | Neha | Quarterly retainer | ||
| Dr Meera Sethi | Individual | PAN on file | Not registered | No | Advance tax, return | No | Self, bank statement and fee register, quarterly | Aman | Neha | Per filing | ||
| Goyal Polymers | Partnership | Goyal family | PAN, GSTIN and TAN on file | Quarterly | Yes | Return, audit | No | Partner, Busy backup, by the 8th | Aman | Neha | Monthly retainer |
| Client | Filing and period | Due date | Internal date | Data status | Work status | Pending with | Filed on | Acknowledgement no. | Remarks | Days to internal date |
|---|---|---|---|---|---|---|---|---|---|---|
| Mittal Hardware | GST return, last month | 18 Oct 2026 | 15 Oct 2026 | Complete | In review | Neha | fills itself | |||
| Kapoor Builders Pvt Ltd | TDS challan, last month | 11 Oct 2026 | 9 Oct 2026 | Part received | In progress | Client | Two party ledgers still to come. | fills itself | ||
| Sunrise Auto Components LLP | GST return, last month | 18 Oct 2026 | 15 Oct 2026 | Asked | Not started | Client | Reminder sent on WhatsApp. | fills itself | ||
| Goyal Polymers | GST return, last quarter | 22 Oct 2026 | 19 Oct 2026 | Not asked | Not started | Aman | fills itself | |||
| Dr Meera Sethi | Advance tax, this quarter | 8 Oct 2026 | 5 Oct 2026 | Complete | Filed | 4 Oct 2026 | Sample no. 0001 | Client informed. | fills itself |
- Red row: Your internal date has passed and the work is not filed.
- Amber row: The internal date is within three days.
- Green row: Filed.
The columns, and what to write in each
- Client
Name of the client.
- Entity
Type of entity.
IndividualProprietorHUFPartnershipLLPPrivate limitedTrust - Group
The family or group it belongs to.
- Registrations
PAN, GSTIN, TAN, CIN or LLPIN, as they apply.
- GST returns
Which returns apply, and how often.
- TDS
Challans and returns.
YesNo - Income tax
Advance tax, return, audit.
- ROC filings
For companies and LLPs.
YesNo - Payroll
PF, ESI and other payroll challans, if you handle them.
- Data from
Who sends the data, in what form, and by which day.
- Handled by
The staff member.
- Reviewer
The person who checks before filing.
- Fee
Retainer or per filing, and when it is billed.
Second sheet, "Work list": Client, Filing and period, Due date, Internal date, Data status, Work status, Pending with, Filed on, Acknowledgement no., Remarks, Days to internal date.
How to keep it
- Fill the sheet "Client master" once: which filings apply to each client, who sends the data and who handles it.
- On the 1st, add the rows of the month in the sheet "Work list" from the client master. Take every due date from the current official calendar.
- Set your own internal date a few days earlier, to leave room for review.
- Twice a week, sort by internal date and read out what is pending, and with whom.
- On filing, write the date and the acknowledgement number in the row and tell the client.
Free to use and to change. No macros, nothing to install.
CA firm compliance tracker: what to track for every client
A client master, a monthly work list and a six-step routine that show a CA firm what is filed, what waits for client data and what is pending with staff.
People also look for this as: compliance tracker in Excel for a CA firm · client due date tracker · CA office work register
