📋 GST Refund Tracker (Main Sheet)
- Tracks up to 50 refund claims with all key fields: GSTIN, ARN, refund type, amounts, dates, and status
- Dropdown menus for Refund Type (ITC Accumulated, Export, Inverted Duty, Excess Payment) and Status
- Auto-calculated columns: Pending Amount and Days Taken
- Colour-coded status rows: Green = Sanctioned/Credited, Orange = Under Process, Red = Rejected/Appeal, Blue = Acknowledged
- Live KPI banner showing Total Claims, Claimed, Sanctioned, and Pending amounts
📊 Dashboard Sheet
- 6 KPI cards auto-updating from the main sheet
- Status-wise summary table with claim counts and amounts (Claimed, Sanctioned, Pending) for all 9 status types
- Grand Total row
📖 Instructions Sheet
- Field-by-field guide explaining every column and colour code
