Sheet 1 — E-Way Bill Log (Main Tracker)
- Live KPI banner: Total Active Bills, Total Distance, Bills Expiring ≤24 hrs, Extended Bills, Total Invoice Value
- 10 pre-filled sample entries + 32 blank input rows
- Auto-calculated Expiry Date from generation date + validity days
- Auto Status formula:
Active/Expiring Soon/Expired - Dropdown validation for Vehicle Type (Truck/LCV/Tanker/Trailer etc.) and Extended (Yes/No)
Sheet 2 — Distance & Validity Rules
- Full reference table per CGST Rule 138(10) (100 km → 1 day … 2000+ km → 15 days, ODC → 20 days)
- Quick Validity Calculator — enter any distance to instantly see validity in days, hours, and haul category
Sheet 3 — Vehicle Master
- Fleet directory with 10 sample vehicles: Vehicle No., Type, Owner/Transporter, GSTIN, Driver, Mobile, Capacity, Insurance & FC Expiry dates
Sheet 4 — Dashboard
- KPI cards linked live from the Log (Active, Expiring Soon, Expired, Total)
- Status breakdown table with counts and % of total
- How-to-use guide
Colour coding: 🔵 Blue = your input cells | ⚫ Black = auto-calculated formulas | 🟡 Gold = validity day inputs
