| Sheet | What it does |
|---|---|
| Dashboard | KPI cards (Total LDCs, Active, Expiring in 30 days, Expired, Pending), section-wise summary (194C/J/A/H/I/D) with avg. certified rates, and a live Expiry Alert Panel with emoji indicators |
| LDC Register | Core tracker — one row per certificate with PAN, AO details, valid period, certified rate, amount limit, utilised amount, auto-calculated balance & days remaining, and auto-computed status (Active / Expiring Soon / Expired / Pending) |
| Application Tracker | Logs each Form 13 application from filing date → AO acknowledgement → approval/rejection → certificate issuance |
| Utilisation Tracker | Payment-level log under each LDC; cumulative utilisation auto-aggregates by LDC Ref No., balance auto-calculates |
| Expiry Alert Report | Weekly action sheet with ✅/⚠/⛔ indicators and recommended actions per certificate |
| Renewal Calendar | Plans renewals with auto-computed “file by” date (30 days before expiry), assigned owner, and renewal status |
| Instructions | Step-by-step process flow + key statutory notes on Sec 197, Form 13, Sec 206AA, limit breach rules |
Key statutory safeguards built in: expiry auto-flags at 30-day threshold, balance monitoring prevents limit overrun, and 206AA note reminds that LDC does not override PAN non-furnishing rules.
