| Sheet | Contents |
|---|---|
| Cover | Organisation details, GSTIN, contact info, and full workbook guide |
| Demand Register | Master log — Demand ID, GSTIN, nature, tax period, IGST/CGST/SGST split, interest, penalty, auto-totals, balance outstanding, status dropdown |
| SCN Tracker | SCN-wise monitoring — issuance date, reply due date, PH attendance, order outcome, status dropdown |
| Payment & Recovery | DRC-03 challans, mandatory pre-deposit, bank/property attachment, ITC adjustment, auto-calculated total settled & balance |
| Interest Calculator | Section 50 interest computation — days delayed formula, 18%/24% rate reference table, department figure vs computed difference |
| Penalty Tracker | Penalty under Sec 73/74/122/125 — imposed, waived, reduced, net payable, paid, balance, auto-totals |
| Appeal & Stay Tracker | Forum-wise appeal log (GSTAA/CESTAT/HC/SC), pre-deposit %, stay status, hearing dates, outcome dropdown |
| Summary Dashboard | 6 KPI cards (total demand, interest, penalty, paid, balance) + status-wise case count breakdown — all auto-calculated |
Key features: Colour-coded column groups per category, dropdown validations for Status/Forum/Section/Recovery Mode, frozen header rows, INR formatting throughout, and auto-sum formula rows at the bottom of each tracker.
