ESOP TRACKER
Company: [Pvt Ltd Name] | ESOP Pool: [10,000 options] | As on [DD/MM/YYYY]
| Emp ID | Employee Name | Grant Date | Options Granted | Exercise Price (₹) | Vesting Schedule | Vested to Date | Exercised | Unvested |
|---|---|---|---|---|---|---|---|---|
| [E01] | [Employee A] | [01/04/2024] | [1,200] | [10] | [1-yr cliff, 25% p.a. over 4 yrs] | [300] | [0] | [900] |
| [E02] | [Employee B] | [01/07/2023] | [600] | [10] | [25% p.a. over 4 yrs] | [300] | [150] | [300] |
| [E03] | [Employee C] | [01/10/2024] | [400] | [25] | [Monthly over 48 months] | [50] | [0] | [350] |
| Total | [2,200] | [650] | [150] | [1,550] |
How to use: Add one row per grant, using the vesting schedule to compute vested options as of today. On exercise, the difference between fair value and exercise price is a perquisite taxable in the employee’s hands (with deferral relief for eligible DPIIT startups u/s 192(1C)). Keep this tracker reconciled with your ESOP pool and cap table.