ESOP Accounting
Cadel extracts and validates ESOP grant letters — employee details, option grants, vesting schedules, and exercise prices — reducing manual data entry and ensuring compliance with Ind AS 102 and ASC 718.
The Problem
Accounting for employee stock option plans (ESOPs) begins with a document that is surprisingly hard to process at scale: the individual grant letter. A mid-market company issuing options to 80–300 employees across two or three grant cycles per year may generate hundreds of grant letters, each containing employee identifiers, grant dates, exercise prices, vesting schedules, and plan references that must be extracted, cross-checked against the plan document, and translated into periodic compensation expense entries. Done manually, a controller or stock-plan administrator typically spends two to four days per grant cycle keying data into a spreadsheet before any accounting can begin.
The regulatory obligation is firm. Under Ind AS 102 (Share-based Payment), the fair value of options must be determined at grant date and recognised over the vesting period on a systematic basis. The equivalent US standard, ASC 718 (Compensation — Stock Compensation), imposes the same measurement and recognition discipline. Both standards require that every grant record carry a defensible fair-value measurement, a correctly parsed vesting schedule, and an auditable forfeiture-rate assumption — none of which can be defaulted or estimated without the source document.
At scale the manual process breaks in predictable ways. Vesting schedules described in natural language — '25% after year one, remainder monthly' — are parsed inconsistently across grant cohorts, producing mismatched amortisation tables. Exercise prices denominated in USD for options issued by a foreign parent are sometimes carried at the wrong exchange rate. Repriced grants referencing an earlier grant ID are booked as new grants rather than modifications, understating or double-counting incremental fair value under Ind AS 102.26 or ASC 718-20-35-3. Each of these errors accumulates silently until the external auditor or internal audit function opens the equity footnote workpaper.
Why It Matters: Context
Ind AS 102 and ASC 718 are not optional disclosures — they determine the income-statement charge for every period in which unvested options exist. Ind AS 102.12 requires that, for equity-settled awards, the entity measure fair value at grant date using an option-pricing model (typically Black-Scholes-Merton or a binomial lattice) and recognise that amount as an expense over the vesting period, adjusted for estimated forfeitures under Ind AS 102.19. ASC 718 mirrors this structure, with the ASU 2016-09 practical expedient allowing US entities to recognise forfeitures as incurred rather than estimating them upfront. In either regime, the accounting engine can only be as accurate as the structured data extracted from the source grant letter.
For mid-market companies — those with 50 to 500 active option holders and no dedicated equity-compensation system — the grant letter is almost always a PDF or Word document produced by HR or legal counsel. There is no single-source-of-truth register automatically fed into the GL. Controllers must manually reconcile grant letters against plan documents approved by the board, verify that the cited plan name and board-approval date precede the grant date (a governance requirement), and maintain a live table of unexercised, forfeited, and expired options for each reporting period. This is tractable for a single cohort; it becomes error-prone across five or six cohorts with different exercise prices and vesting ladders.
Failure takes concrete forms. An incorrectly parsed cliff-versus-graded vesting schedule produces a front-loaded or back-loaded expense that misstates employee benefits cost in interim filings. A repriced grant booked as a new grant overstates the option pool on the cap table and inflates stock-based compensation expense, both of which draw audit findings. Under ICAI SA 505 (External Confirmations) and standard equity-footnote audit procedures, auditors routinely confirm grant terms directly with the plan administrator — discrepancies between the confirmed terms and the ledger entries can result in an adjusting journal entry requirement or, in material cases, a qualified audit opinion on the financial statements.
What This Workflow Automates
- Cadel ingests each ESOP grant letter (PDF or Word) and extracts structured fields: employee name, employee ID, grant date, number of options, exercise price, currency, vesting schedule, cliff date, plan name, and plan version identifier.
- The extracted vesting schedule is parsed against a controlled vocabulary of schedule types — cliff, graded, cliff-plus-graded hybrid — and any ambiguous natural-language description is flagged as requiring controller sign-off before the amortisation table is generated, preventing silent misclassification under Ind AS 102.12 or ASC 718-10-55-68.
- Where an exercise price is denominated in a currency other than the entity's functional currency, the workflow identifies the mismatch, attaches the applicable RBI reference rate (or FRED mid-market rate for USD-functional entities) for the grant date, computes the converted amount, and marks the field for treasury review under Ind AS 21.
- For any grant letter that references an earlier grant ID — indicating a repricing or modification — the workflow links the amendment to the original grant record, computes the incremental fair-value delta, and generates a separate accounting line dated to the modification date, satisfying the incremental-charge requirement under Ind AS 102.26 or ASC 718-20-35-3.
- The cited plan identifier is cross-checked against the registered plan document library; grants referencing a plan not present in the library, or whose board-approval date post-dates the grant date, are blocked from posting and marked as 'unresolvable' pending attachment of a valid plan document.
- Where no forfeiture rate has been configured at the plan level, the workflow raises a validation warning, prompts the preparer to enter a historically or actuarially supported rate, and records the assumption in the audit workpaper export — preventing the silent default to zero forfeiture that would overstate compensation cost.
- In multi-entity groups, the workflow enforces a compound key of entity-code plus grant-ID at ingestion, surfaces all collisions with entity attribution, and blocks posting until duplicate IDs are disambiguated, preventing double-counting at the consolidation layer.
All seven steps execute within seconds of document upload, producing a deterministic, field-level output record for every grant letter that any controller can inspect, annotate, and attach to the period-close equity workpaper without further manual transcription.
Edge Cases We Simulate
The workflow ships with a battery of synthetic test scenarios that exercise every failure mode we have seen in real-world data. Each scenario produces a deterministic outcome that an auditor or controller can verify in seconds.
| Scenario | What's wrong | Expected outcome |
|---|---|---|
| Cliff vs. Graded Vesting Mismatch | Grant letters sometimes describe a schedule using ambiguous language — e.g., '25% after year one, remainder monthly' — which can be parsed as either a cliff-plus-graded hybrid or a pure graded schedule, producing incorrect periodic expense amortisation under Ind AS 102.12 or ASC 718-10-55-68. | Workflow flags the vesting type as 'ambiguous' and surfaces both possible interpretations with the corresponding charge schedules, requiring explicit controller sign-off before the entry is accepted. |
| Exercise Price Denominated in Foreign Currency | For employees granted options by a foreign parent entity, exercise prices may be stated in USD or another currency while the entity's functional currency is INR. Direct use of the grant-date exchange rate is required under Ind AS 21 for measurement, but letters often omit the applicable rate. | Workflow identifies the currency mismatch, attaches the RBI reference rate for the grant date, recalculates the INR equivalent, and marks the field for treasury review. |
| Repriced or Amended Grants | When exercise prices are reduced or vesting terms modified after the original grant date, the amendment creates an incremental fair value that must be recognised as an additional charge under Ind AS 102.26 or ASC 718-20-35-3. A repriced letter referencing an earlier grant ID without a clear delta calculation causes duplicate or understated expense. | Workflow detects the amendment reference, links it to the original grant record, computes the incremental fair-value delta, and generates a separate accounting line for the modification date onwards. |
| Missing or Expired ESOP Plan Reference | Grant letters that cite a plan name (e.g., 'ESOP Plan 2019') not present in the uploaded plan document register, or that reference a plan whose board-approval date post-dates the grant date, indicate a governance gap that invalidates the grant for accounting purposes. | Workflow cross-checks the cited plan identifier against the registered plan library, flags unmatched or post-dated references as 'unresolvable', and blocks the grant from posting until a valid plan document is attached. |
| Forfeiture Rate Assumption Absent | Ind AS 102.19 and ASC 718-10-30-11 require an entity to estimate forfeitures at grant date (or, under the ASU 2016-09 practical expedient, recognise them as incurred). Grant letters that contain no historical forfeiture data and where no plan-level assumption has been configured cause the expense calculation to default to zero forfeiture, overstating compensation cost. | Workflow raises a validation warning when no forfeiture rate is associated with the plan, prompts the preparer to input an actuarially or historically supported rate, and documents the assumption in the audit workpaper export. |
| Duplicate Grant ID Across Entities in a Group | In multi-entity groups, subsidiaries sometimes issue grants using the same sequential numbering scheme as the parent, creating colliding grant IDs that result in double-counting stock-based compensation expense at the consolidation layer. | Workflow enforces a compound key of entity-code plus grant-ID at ingestion, surfaces all collisions with entity attribution, and prevents posting until IDs are disambiguated. |
Sample Documents
Download or inspect the seeded sample files used to demonstrate this workflow:
| File | Document type | Notes |
|---|---|---|
esop_grant_letter_sample.pdf |
ESOP Grant Letter | Standard individual grant letter containing employee name, employee ID, grant date, number of options, exercise price, and a four-year graded vesting schedule with a one-year cliff; used to demonstrate field extraction and vesting-schedule parsing. |
esop_plan_document_2022.pdf |
ESOP Plan Document | Board-approved ESOP plan document specifying total option pool size, eligible participants, exercise window, and forfeiture conditions; used to validate grant letters against authorised plan parameters. |
black_scholes_inputs.xlsx |
Fair Value Workbook | Spreadsheet containing risk-free rate, expected volatility, dividend yield, and expected term inputs used to compute grant-date fair value per option under the Black-Scholes model as required by Ind AS 102 / ASC 718. |
esop_amendment_letter.pdf |
Grant Amendment Letter | Amendment notice reducing the exercise price on an earlier grant; demonstrates the workflow's ability to detect repricing events, link to the original grant, and calculate incremental fair value under Ind AS 102.26. |
Sample Results
In a representative processing run across a cohort of grant letters spanning three ESOP plan vintages, Cadel extracts all required structured fields — employee ID, grant date, exercise price, vesting schedule type, plan reference — with field-level extraction validated against the source document. Validation checks covering plan-reference integrity, currency denomination, vesting-type classification, and forfeiture-rate configuration produce pass or actionable-warning outcomes for each grant record, with no grant advancing to the amortisation-table stage until all hard-stop validations are cleared. Across a typical 100-grant cohort, controllers report that data entry time falls from approximately two working days to under 20 minutes, with zero manual re-keying of exercise prices or vesting terms into the compensation-expense model.
A specific exception class that the workflow catches with high consistency is the cliff-plus-graded hybrid vesting schedule described in ambiguous language: for example, a letter stating 'vests as to 25% on the first anniversary of the grant date and as to 1/48th per month thereafter' is correctly identified as a hybrid — not a pure graded schedule — which changes the shape of the Ind AS 102 amortisation curve and, over a four-year vesting period on a ₹50 lakh grant, produces a materially different front-year expense charge than the pure-graded misclassification would generate. Without automated parsing, this class of error typically goes undetected until the auditor reconstructs the vesting table from the original letter.
Why Automation Wins Here
For a mid-market company running two to four ESOP grant cycles annually across 100–300 option holders, the workflow reduces grant-data preparation time from two to three working days per cycle to under 30 minutes, while eliminating the six deterministic error classes — vesting misclassification, FX omission, modification misposting, invalid plan references, missing forfeiture assumptions, and duplicate grant IDs — that most commonly generate audit findings or income-statement restatements in equity-compensation accounting. The reduction is structural, not dependent on preparer experience: every extraction and validation rule runs identically across every grant letter, every cycle.
The output artifact is a structured grant register in CSV and PDF formats, with field-level source citations back to the original grant letter, a validation-result column for each check, and the forfeiture-rate assumption documented inline. This register drops directly into the controller's period-close audit file as the supporting schedule for the stock-based compensation footnote, satisfying the documentation expectations of external auditors performing procedures under ICAI SA 230 (Audit Documentation) or PCAOB AS 1215 without any reformatting or supplemental annotation.
Frequently Asked Questions
The workflow is designed for Ind AS 102 Share-based Payment (mandatory for Indian companies preparing financial statements under the Companies (Indian Accounting Standards) Rules, 2015) and ASC 718 Compensation — Stock Compensation (US GAAP). For entities still on Indian GAAP, the ICAI Guidance Note on Accounting for Employee Share-based Payments is also referenced. The audit workpaper export maps each field to the applicable paragraph of the relevant standard.
The workflow applies the Black-Scholes-Merton model, the most commonly used closed-form option-pricing approach accepted under both Ind AS 102.B4 and ASC 718-10-55-17. Inputs — risk-free rate (typically the yield on Government of India dated securities or US Treasury notes for the relevant expected term), expected volatility (computed from historical share price data or implied volatility where available), dividend yield, and expected term — are captured at grant ingestion and stored alongside the calculated fair value for auditability. Where a lattice model is required (e.g., for options with market conditions under Ind AS 102.21), the workflow flags the grant for external actuary input.
Yes. The workflow maintains a compound key of entity code + grant ID to prevent collision across subsidiaries sharing sequential grant numbering. For group schemes where a parent grants options over its own shares to employees of a subsidiary, the workflow supports recharge accounting between entities — debit to subsidiary P&L and credit to inter-company payable — consistent with the treatment described in Ind AS 102.43A and IFRS 2.43A.
Each grant record retains a timestamped extraction log showing the source document, the page and bounding-box coordinates of every extracted field, the user who reviewed and approved the record, and any override notes. Validation exceptions — forfeiture rate assumptions, currency conversions, amendment linkages — are stored as structured comments against the grant line. This package is exportable as a PDF audit workpaper and is designed to satisfy the documentation requirements of ICAI SA 230 Audit Documentation and PCAOB AS 1215.
Validated grant data and the resulting periodic amortisation schedule are exportable as a journal entry CSV formatted for direct import into Tally Prime (using the standard XML/CSV voucher format), Oracle NetSuite (journal entry import template), and SAP FI (IDOC-compatible flat file). The export includes the debit to employee benefits expense and credit to equity — securities premium or share options outstanding reserve — along with the cost centre and profit centre coding captured from the grant letter.
When an employee departs before full vesting, the workflow records a forfeiture event against the open grant, reverses the unrecognised portion of the cumulative expense, and updates the outstanding option count. This treatment follows Ind AS 102.19 (estimate-based approach) or the ASU 2016-09 actual-forfeiture election under ASC 718. A reconciliation of opening options outstanding, granted, forfeited, exercised, and lapsed is produced each period and ties to the disclosures required under Ind AS 102.45(b) and ASC 718-10-50-2(c).
This workflow is deployed and live in our demo environment. Upload your own documents to see it in action.
Open the live workflow