Registration Tracker (Main Sheet) Tracks up to 50 registrations with these key fields:
- GSTIN, Legal/Trade Name, State, Business Type
- Registration Type, ARN, Application Date
- Registration Status (dropdown with 9 options — auto colour-coded)
- GSTIN Allotment Date, Effective Date, Last Return Filed
- Return Compliance (dropdown), Amendment Type & Date
- Cancellation Date, Revocation Date, Officer Assigned, Remarks
📊 Dashboard
- 9 live KPI cards: Total, Active, Pending, Cancelled, Rejected, Amendments Pending, Revocations, Non-Compliant, Compliant
- Status-wise summary with count & % of total
- Compliance breakdown table
- State-wise registration count (Active vs Cancelled/Rejected)
🚫 Cancellation Log
- Dedicated sheet to record all cancelled, suspended & revoked registrations
- Fields for Cancellation Type, Application Date, Cancellation Date, Revocation details & Reason
📖 Instructions
- Field-by-field guide, colour code legend, and sheet navigation tips
Colour legend for Status column: 🟢 Green = Active / Revocation Granted | 🟠 Orange = Pending / Under Process | 🟣 Purple = Amendment Pending | 🔴 Red = Cancelled / Rejected | 🍑 Peach = Suspended
