How Indian Startups Track ESOP Vesting for Employees: The Manual Approach vs Automated Software

Every ESOP grant a startup makes creates an ongoing obligation: tracking how many options have vested for each employee, as of any given date, across different vesting schedules, for employees at different stages of their employment. For a company with five option holders, this is manageable. For a company with twenty-five holders across three grant batches with different cliff dates, different monthly vesting amounts, and several leavers whose unvested options were cancelled it becomes a full-time administrative task that most founders are handling in a spreadsheet that was not designed for the job.

The way Indian startups track ESOP vesting has changed significantly over the past three years, as ESOP management software designed specifically for the Indian context has become available. This guide maps the traditional approach manual tracking in Excel with CS support against the software approach, shows exactly where the traditional approach breaks down, and explains what automated vesting tracking actually looks like in practice for an Indian startup at Seed or Series A stage.

KEY TAKEAWAYS

• Manual ESOP vesting tracking fails at three predictable points: when the first employee leaves, when the second grant batch is issued with different terms, and when an employee asks for their current vesting statement.
• The traditional approach Excel + CS + CA creates four different records of the same information that are rarely in sync and none of which is definitively authoritative.
• Automated vesting tracking calculates vested and unvested balances to the day, for any employee, across any vesting schedule combination, without manual calculation.
• The most operationally valuable features of ESOP software are not the cap table they are the employee-facing vesting dashboard and the automated leaver processing.
• Tabulate handles the full ESOP lifecycle for Indian startups grant, vest, exercise, leaver processing with DPIIT compliance built in and a 1-month free trial.

The Traditional Approach: How Manual Vesting Tracking Actually Works

Before software, Indian startups tracked ESOP vesting through a combination of four partially overlapping systems, none of which was designed to be the authoritative record and all of which were maintained separately by different people.

System 1: The Founder's Cap Table Spreadsheet

The primary cap table spreadsheet maintained by the founder or CFO. Typically shows the ESOP pool size, the number of options granted, the exercise price, and a rough breakdown of vested vs unvested. Updated sporadically often only when someone asks for it. The vesting calculations are manual formulas that assume grants were made at the start of a month (even when they were not) and that nobody has left (even when they have).

System 2: The Company Secretary's Grant Register

The CS maintains a register of option grants as a statutory requirement. This register shows the grant date, grantee name, number of options, and exercise price for each grant. It does not typically include ongoing vesting calculations it is a record of what was granted, not of what has vested. The CS updates it when new grants are approved by the board and when exercises or cancellations are formally processed, but not in between.

System 3: The HR System's Employment Records

HR tracks employment start dates, end dates, and job grades all of which are inputs to ESOP vesting calculations. But HR's system is not connected to the cap table spreadsheet or the CS's grant register. When an employee leaves, HR marks the departure date in their system. Whether that departure date is correctly reflected in the vesting calculation for that employee's options depends on someone manually connecting the HR event to the cap table update and that connection is made inconsistently, often weeks or months after the departure.

System 4: Individual Employee Grant Letters

Each employee has a copy of their grant letter, which states the number of options, exercise price, and vesting schedule. This is the document the employee refers to when they want to understand their equity. It is accurate as of the grant date. It does not update as vesting progresses. Employees who want to know their current vesting status have to either do the calculation themselves (using the grant letter) or ask HR or the founder neither of whom can give an instant, reliable answer without checking the spreadsheet.

Where the Traditional Approach Breaks Down

Failure Point 1: The First Employee Departure

When an employee leaves, their vesting stops on the departure date. Unvested options are cancelled and returned to the ESOP pool. The exercisable period for vested options begins typically 30 to 90 days. The cap table must be updated to show: (a) how many options vested up to the departure date, (b) how many options were cancelled, (c) the updated pool balance, and (d) the exercise window closing date.

In the manual approach, this update requires the founder or CFO to identify the exact departure date, calculate options vested to that exact date (not the nearest month-end, which is what most formula-based spreadsheets assume), remove the unvested portion from the employee's row, add it back to the pool balance, and note the exercise window deadline. For a standard 4-year, 1-year cliff schedule, this calculation is: vested = (months employed / 48) x total grant, subject to cliff. Getting this right for a departure that happened on the 17th of a month, with a grant date that was the 3rd of a different month, requires careful arithmetic that spreadsheet formulas rarely handle correctly.

WORKED EXAMPLE Leaver Calculation in a Manual Spreadsheet vs Software

Employee: Senior Engineer, grant date 1 March 2022, 4,800 options, 4-year vest / 1-year cliff

Departure date: 17 October 2023

Manual calculation:

Employment duration: 1 March 2022 to 17 October 2023 = 1 year, 7 months, 17 days

Months completed: 19 full months (March 2022 to September 2023) + 17 days of October

Most spreadsheets round to 19 months or 20 months depending on formula logic

Vested at 19 months: 19/48 x 4,800 = 1,900 options (below cliff: 1,200 vested at cliff + 700 monthly)

Vested at 20 months: 20/48 x 4,800 = 2,000 options

The difference of 100 options approximately Rs 7,000–Rs 15,000 at current FMV depends entirely on whether the formula rounds correctly.

Incorrect rounding in one spreadsheet cell means the employee's entitlement is wrong.

When the employee's CA later asks for the exact vested count, the company has a number that may be inconsistent with what the formula produces on a different day.

Software approach:

The departure date is entered: 17 October 2023.

The system calculates: 596 days employed (1 March 2022 to 17 October 2023).

Vesting schedule: 1/48 per month after cliff. Cliff date: 1 March 2023 (12 months).

Months completed post-cliff: 7 full months (March to September 2023) + 17/31 of October

Vested post-cliff: 7.548 months x 100 options per month = 755 options (rounded to 755 completed units per scheme rules)

Cliff vest: 1,200 options

Total vested: 1,955 options. Unvested cancelled: 2,845 options. Pool restored: 2,845.

System logs the transaction with the departure date, vested count, cancelled count, and pool update timestamped and auditable.

Failure Point 2: Multiple Grant Batches With Different Terms

By the second or third grant batch, the vesting tracking problem multiplies. Each batch has its own grant date, cliff date, monthly vesting amount, and exercise price. Some employees may have received grants in multiple batches a top-up grant at promotion, for example. Their total vested position is the sum of all vested amounts across all their grants as of any given date.

A spreadsheet that tracks multiple grant batches for the same employee typically has a separate row per grant, with each row calculating vesting independently. The total vested for that employee is a SUM across the rows. This works when the rows are correct. It breaks when the grant dates are wrong, when the cliff calculations use different rounding in different rows, or when a leaver adjustment is applied to one row but not updated in the other. By the time a company has three grant batches and twelve leavers, the chance that every cell in every row is correct is low.

Failure Point 3: An Employee Asks for Their Current Vesting Statement

This is the moment the manual approach becomes most visibly inadequate. An employee walks up to the founder or HR and asks: 'How many of my options have vested as of today?' In a well-run ESOP programme, this question should have an immediate, confident, accurate answer ideally available to the employee themselves without needing to ask.

In the manual approach, the honest answer is: 'Let me check the spreadsheet.' And then: 'Actually, let me check with the CS.' And sometimes: 'The number I have is from last quarter let me recalculate.' This is the answer that tells an employee their equity programme is not being managed seriously. It undermines the entire purpose of the ESOP grant which was to create a sense of ownership and alignment, not uncertainty and administrative friction.

What Automated Vesting Tracking Actually Does

How the Software Approach Works

In an ESOP management system like Tabulate, vesting tracking works as follows: when a grant is created, the grant date, employee name, number of options, exercise price, cliff period, and vesting schedule are entered into the system. From that point, the system calculates the vested balance for that employee as of any date including today automatically. There are no manual formulas to maintain. The calculation is done by the system using the grant parameters and the current date.

When an employee leaves, the departure date is entered. The system recalculates the final vested balance as of the exact departure date, cancels the unvested options, restores the pool balance, and logs the exercise window deadline. The CS receives an automated notification with the exercise window closing date for the leaver. The employee (if they have access to the employee portal) can see their vesting status and understand their options.

The Employee-Facing Dashboard

The most retention-impactful feature of ESOP management software is often the employee-facing vesting dashboard a view that each option holder can access to see their grant details, current vesting status, estimated value at current FMV, and exercise window information. When employees can see their own vesting progress 'as of today, 2,100 of my 4,800 options have vested, worth approximately Rs 1,89,000 at current share price' the ESOP becomes a tangible, visible part of their compensation rather than a number on a grant letter they filed away two years ago.

This employee visibility transforms the retention value of the ESOP programme. An employee who can see their options vesting in real time who can calculate what another year at the company is worth is making a continuous informed decision to stay. An employee who received a grant letter and has no idea of its current value is not making an informed decision at all.

The Compliance Dimension: What Manual Tracking Misses

DPIIT Tax Deferral Record-Keeping

For DPIIT-recognised startups, the five-year perquisite tax deferral benefit requires meticulous record-keeping: the grant date, the exercise date, the FMV at grant, the FMV at exercise, and the applicable deferral period for each exercising employee. If an employee exercises options at different points in time across multiple vesting milestones, each exercise event must be individually tracked. A manual spreadsheet that does not automatically log exercise dates, FMV at exercise, and deferral status creates a compliance gap that surfaces when the employee files their income tax return and discovers the numbers do not reconcile.

ESOP Scheme Document Compliance

The ESOP scheme document defines the specific vesting mechanics cliff period, monthly vesting unit, treatment of part-months, acceleration clauses, good leaver vs bad leaver distinctions. Manual vesting tracking that applies a simplified formula (total months / 48) may not correctly implement the scheme document's specific provisions. A software system that implements the scheme document's exact terms including part-month treatment and leaver categorisation produces calculations that are consistent with the scheme, not approximate.

PAS-3 Filing Accuracy for Exercise Allotments

When an employee exercises their options and shares are allotted, the company must file a PAS-3 with the ROC within 30 days. The PAS-3 must correctly state the number of shares allotted, the allotment date, the issue price (exercise price), and the distinctive numbers. A manual process that tracks exercises in a spreadsheet and then prepares PAS-3 filings from that data is dependent on the spreadsheet being correct and as established, spreadsheet accuracy degrades with complexity.

Use Cases Where Automated Tracking Delivers the Most Value

Use Case 1: The Growing Company with 15+ Option Holders

Once a company has more than fifteen active option holders, the manual tracking burden becomes a genuine operational problem. Monthly vesting events need to be calculated. Leavers need to be processed. New grants need to be recorded. Exercise windows need to be monitored. A founder or CFO spending three to four hours per month on ESOP administration is a founder spending three to four hours not building the business. Software reduces this to a few minutes per event.

Use Case 2: The Company Approaching a Funding Round

The three to six months before a Series A is when the ESOP register needs to be most accurate because it will be reviewed in detail by the investor's legal team. A company that moves to ESOP management software six months before fundraising has time to migrate its historical data, verify the migration against grant letters and statutory filings, and arrive at due diligence with a system that produces audit-ready reports on demand. A company that moves to software during due diligence is doing the migration and the audit simultaneously the worst possible combination.

Use Case 3: The ESOP Buyback

Running an ESOP buyback requires knowing the exact vested count for every participating employee as of the buyback record date. For a company with twenty employees who joined at different times, have different grant dates, and have different vesting schedules, calculating the buyback-eligible amount for each person manually is a multi-day project. A software system produces this report in minutes exact vested counts, exercise prices, and FMV calculations for each eligible participant.

Limitations: What Software Cannot Replace

The Human Judgment on Leaver Classification

The software processes departures according to the scheme document's good leaver / bad leaver definitions. But classifying a departure as good or bad requires human judgment understanding the circumstances of the exit, the terms of any settlement agreement, and the provisions of the employment contract. Software can enforce the rule once the classification is made; it cannot make the classification for you.

The Valuation Input for FMV Calculations

Software calculates the perquisite spread at exercise using the FMV entered into the system. But the FMV itself comes from a Rule 11UA valuation report an external document that the software references but cannot generate. The compliance quality of the exercise tracking depends on the valuation report being correct and contemporary. Software amplifies the accuracy of good inputs; it does not correct bad ones.

The Bottom Line

The traditional approach to ESOP vesting tracking Excel, CS records, HR system, grant letters produces four partially overlapping records that are rarely in sync, cannot be self-served by employees, and break down predictably at the exact moments they are most needed: when an employee leaves, when due diligence starts, and when an employee asks how much of their equity has vested.

Automated vesting tracking eliminates these failure points by making the calculation continuous, automatic, and accessible to everyone who needs it employees, founders, investors, and compliance teams. The operational benefit is real and immediate. The compliance benefit is visible at due diligence and at tax time. And the retention benefit employees who can see their vesting progress in real time is the hardest to quantify but often the most valuable of the three.

Also Read: Why Excel Breaks Your Cap Table Before Series A

Also Read: Cap Table Management for Indian Startups: Why Excel Is Not Enough

Frequently Asked Questions

How does software handle employees who received multiple ESOP grants at different points in time?

Each grant is entered as a separate record with its own grant date, cliff date, vesting schedule, and exercise price. The system tracks vesting for each grant independently and provides a combined total vested position for the employee the sum of all vested amounts across all their grants as of any given date. When an employee exercises, they can specify which grant they are exercising from, or the system can apply a first-in-first-out rule depending on the scheme document's terms.

Does ESOP management software handle the leaver classification (good leaver vs bad leaver) automatically?

Software implements the scheme document's definitions for good and bad leavers which typically specify treatment based on departure reason (resignation, termination for cause, termination without cause, death, disability). The HR team or founder inputs the departure reason, and the software applies the corresponding treatment: vested options expire within the specified window, unvested options are cancelled immediately for bad leavers, or some unvested options may be accelerated for good leavers depending on the scheme terms. The software enforces the rule; the human makes the classification.

Can employees see their own vesting status in Tabulate?

Yes. Tabulate provides an employee-facing dashboard where each option holder can log in to see their grant details, current vesting status, exercise price, estimated current value at the latest FMV, and upcoming vesting milestones. Employees do not see other employees' grant details each person sees only their own information. This employee self-service view is one of the most retention-impactful features of the platform, transforming the ESOP from a paper promise into a visible, real-time component of compensation.

How long does it take to set up Tabulate for an existing ESOP programme?

For a startup with up to 30 option holders and two to three grant batches, setup typically takes one to two weeks including migrating historical grant data, verifying it against grant letters and the CS's records, and confirming that the software's vesting calculations match the expected outputs for a sample of employees. Tabulate's onboarding team supports Indian startups through this process. After setup, the ongoing administration new grants, departure processing, exercise requests takes minutes per event rather than hours.

Does Tabulate generate the grant letters and exercise notices, or just track the data?

Tabulate generates grant letters using customisable templates that can be tailored to the company's ESOP scheme terms and branding. When a grant is created in the system, the grant letter is produced automatically with the correct employee details, grant date, exercise price, cliff date, and vesting schedule. Exercise notices and exercise confirmations are similarly generated. This document generation eliminates the manual drafting step and ensures that the documents issued to employees exactly match the data in the system.