ESOP administration: the operational mess of grant tracking that's costing you

Every founder we work with treats their ESOP scheme as a strategic asset. The hiring narrative is built around it, the cap table reflects it, the board approvals authorise it. What almost none of them treat with the same seriousness is the operational administration of the scheme — the grant-by-grant tracking that turns those board approvals into compliant, accurately accounted, correctly taxed events.

At 20 grants outstanding, an Excel sheet works. At 100 grants, the Excel sheet has bugs nobody has noticed. At 200 grants across two schemes and two grant types, the Excel sheet is wrong in three places and there is no audit trail. We have seen this story play out at half a dozen companies, and the pattern is consistent enough to write down.

The grant tracking matrix

A clean ESOP administration system tracks, for every single grant, the following data points:

Grant date. The date the board approved the grant under the scheme.

Vesting schedule. The vesting cliff (typically 1 year), the vesting frequency thereafter (monthly, quarterly), the total vesting period (typically 4 years), and any acceleration clauses.

Exercise window. The period within which vested options can be exercised, both during employment and after termination. Indian schemes typically allow exercise during employment without restriction and within 30 to 180 days post-termination depending on the scheme rules and reason for termination.

Exercise price. The price at which the option-holder buys the share when they exercise.

Fair Market Value (FMV) at the time of grant for accounting under Ind-AS 102, and FMV at the time of exercise for the perquisite tax computation under Section 17(2)(vi) of the Income-tax Act.

Exercise date and quantity. When each option-holder exercised which options, in what quantity.

Tax withholding. TDS under Section 192 on the perquisite value at exercise (or deferred under the eligible startup provisions of Section 191(2A) if applicable), reported in Form 24Q and Form 16.

Share certificate or DEMAT issuance. The actual shares getting issued and reflected in the cap table after exercise.

Plus: leaver tracking. Date of termination, reason (resignation, termination with cause, termination without cause, death, retirement), how the vesting and exercise clauses apply to that leaver, what got accelerated, what got lapsed.

Why Excel breaks at 200 grants

An Excel sheet with 200 rows is not, in itself, complicated. What breaks is the cross-checking.

Every month, the finance team needs to compute the ESOP expense under Ind-AS 102 for the period. The computation requires knowing, for every grant: how much of the grant has vested in the period, the fair value of the option at the grant date (Black-Scholes or binomial-tree valuation), the prorated expense for the period. With 200 grants and rolling monthly vesting, this is a non-trivial monthly calculation.

Every quarter, the company secretary or finance team needs to file the ESOP-related disclosures under the Companies Act. The Form MGT-9 (or, for unlisted companies, the disclosures in the board report) require quantitative summaries of grants made, exercised, lapsed, and outstanding.

Every year, the finance team needs to reconcile the cap table against the exercised options, file the Form ESOP-1 with the income tax authorities if eligible, and ensure the Form 16 issued to every option-holder accurately reflects the perquisite tax on exercise.

Every termination event triggers a re-check: did the leaver have unvested options that were forfeited, did they have vested options that were exercised within the post-employment exercise window, did the company withhold and deposit the right TDS amount.

Each of these workflows breaks an Excel sheet when 200 grants are involved. Not because Excel cannot do it, but because the workflow is now too complex for a single sheet maintained by a single person to handle without errors.

The tools that actually work

Three tool categories are in use across Indian growth-stage companies.

Dedicated ESOP platforms. Carta is the global standard and has Indian-entity support. Vega Equity is the local alternative with cleaner Indian tax workflows and INR-native pricing. Both handle grant tracking, vesting calculations, exercise workflows, cap-table integration, and basic accounting outputs. Pricing is per-stakeholder per-year, roughly Rs. 600 to Rs. 1,800 per stakeholder per year depending on scale and module selection.

In-house Postgres or Airtable plus scripts. A small number of companies build their own tracking on top of Airtable or a Postgres table, with scripts in Python or Google Apps Script for vesting and accounting computations. This works at the lower end of complexity and gets fragile fast. We do not recommend it past 100 grants unless the company has a finance-engineer hybrid running it.

Cap-table-plus-spreadsheet hybrid. Use a cap-table tool (Eqvista, EquityList, Carta Lite) for the share-ledger side, and maintain a parallel grant-tracking spreadsheet for the operational data the cap-table tool does not capture. This is the most common setup at Indian companies in the 50-to-300-employee range. It works if and only if there is a clear owner of the spreadsheet and a monthly reconciliation discipline between the two systems.

The five ESOP errors that bite at audit

Across the ESOP audits we have supported, five errors recur.

1. Missed vesting accelerations on terminations

Some schemes include acceleration on termination without cause, or on change of control. When a senior employee is terminated without cause, the relevant clauses can accelerate up to 12 months of unvested options. Companies miss this because the termination is handled by HR, the option records are with finance, and nobody crosses the two systems. The audit finds the unaccelerated options and the company has to backdate the acceleration, redo the tax computation, and amend the Form 24Q.

2. Missed re-pricing or modification accounting

If the company re-prices vested options (because the strike price is now above FMV and the scheme allows re-pricing), Ind-AS 102 requires the incremental fair value to be recognised over the remaining vesting period. Companies frequently treat the re-pricing as a non-event from an accounting standpoint and the auditor catches it.

3. Missed tax withholding on cashless exercises

When an option-holder does a cashless exercise (sells a portion of the exercised shares to fund the exercise price and the tax liability), the company is still required to deduct TDS on the perquisite value under Section 192. The mechanics get muddled because the company never actually receives the exercise consideration in cash, but the TDS obligation remains. Missed deductions show up at the time of the Form 16 issuance and at TDS assessment.

4. Missed grant accounting under Ind-AS 102

Smaller companies sometimes skip Ind-AS 102 accounting entirely on the theory that the scheme is administered through a Trust route and the company has no expense. This is wrong. The expense is on the company books regardless of the route. The auditor will require restatement of the prior-period financials if the accounting was missed.

5. Missed ESOP Trust audit

If the scheme uses an ESOP Trust route (common at companies that have been around long enough to have established Trusts), the Trust itself is an entity that requires its own books, its own audit, and its own tax return. Companies frequently maintain the Trust as a passthrough and discover at the time of an external diligence that the Trust audit has been pending for two years.

What good administration looks like

We help a number of clients run their ESOP administration. The pattern that works:

A single owner for the function. Usually a finance manager or company secretary with explicit responsibility, not 'whoever is least busy this month'.

A monthly reconciliation between the ESOP system, the cap table, and the trial balance. Outstanding options times remaining fair value should reconcile to the deferred expense balance on the books. Exercised options times shares issued should reconcile to the cap-table movement.

A quarterly review with the controller and the CFO (or vCFO) covering: new grants approved, vesting movements in the quarter, exercises and tax withholding, leavers and their option treatment, accounting expense for the quarter.

An annual deep review with the company secretary, the auditor, and the tax adviser covering: scheme amendments needed, Form 24Q and Form 16 reconciliation, Trust audit if applicable, ESOP-1 filing if applicable, and disclosure adequacy in the board report.

This costs Rs. 3 to 6 lakh per year in external support for a company with 150 to 400 outstanding grants. It saves a multiple of that in audit findings, tax disputes, and the diligence delays that an unclean ESOP file causes when the company is approaching a fundraise or an exit.

ESOP is one of the most powerful instruments an Indian startup has. It is also one of the easiest to administer badly. The administration discipline is not glamorous, but it is what separates an ESOP scheme that delivers on its hiring promise from one that becomes a liability at audit and a problem at exit.