Stock-based compensation case study

Stock-Based Compensation (ASC 718) Automation Case Study

A pre-IPO SaaS company moved equity comp accounting from a Carta export plus four spreadsheets into an automated ASC 718 engine — handling options, RSUs, ESPP, modifications, repurchases, and disclosure-ready expense rollforwards across 480 active grant holders.

Client profile: Composite case study based on a $90M ARR vertical SaaS company on a 12–18 month IPO horizon, NetSuite OneWorld, 480 active equity holders, mix of ISOs, NSOs, RSUs, and ESPP. 8-person finance team with a designated equity accountant.

Company context — and why ASC 718 is hard to get right

The client is a $90M ARR vertical SaaS company on a 12–18 month IPO horizon. The cap table runs through Carta with 480 active equity participants — a mix of incentive stock options (ISOs) for early hires, non-qualified stock options (NSOs) for advisors and recent grants, restricted stock units (RSUs) introduced after the most recent priced round, and an Employee Stock Purchase Plan (ESPP) launched 18 months ago. Annual stock-based compensation expense is approximately $11M, with cliff and graded vesting schedules, performance conditions on a small subset of executive grants, and frequent modifications driven by promotion-based refresh grants.

ASC 718 looks straightforward on paper: estimate fair value at grant, recognize expense over the requisite service period, account for modifications when terms change. In practice, the accounting breaks under the cumulative weight of: refresh grants that overlap with prior grants, forfeitures that need to be re-trued, modifications that require incremental fair value calculations, ESPP look-back provisions, deferred tax asset (DTA) tracking by grant, and disclosure schedules (rollforward by award type, weighted-average grant-date fair value, weighted-average remaining contractual term) that have to tie to the underlying cap table down to the share. Auditors test stock comp at material-weakness sensitivity — a small error in volatility input or vesting period applied to thousands of grants compounds into a meaningful misstatement.

  • $90M ARR, 12–18 month IPO horizon
  • 480 active equity participants
  • Award mix: ISOs (~22%), NSOs (~36%), RSUs (~38%), ESPP (~4%)
  • ~$11M annual SBC expense
  • Carta as cap-table system of record; NetSuite as GL
  • ~80 grants per year; ~25 modifications per year
  • SOX 404 readiness in flight; auditor reviewing equity area as material

Before automation — Carta export plus four workbooks

The equity accountant maintained four interlocking spreadsheets. Workbook 1: Carta export refreshed monthly, manually reconciled to the prior month for new grants, vested tranches, and forfeitures. Workbook 2: per-grant Black-Scholes calculation with hardcoded inputs (volatility, risk-free rate, dividend yield, expected term). Workbook 3: monthly expense calculation by grant with vesting tranche schedule. Workbook 4: ESPP look-back fair value calculation. The four workbooks reconciled at quarter-end with two days of manual cleanup.

Audit findings in the prior cycle: three grants had volatility input from the prior year (not refreshed), two modifications were calculated without incremental fair value, and the ESPP look-back was using the wrong reference period. None were material in isolation but the combination raised a control-design question that audit committee couldn't ignore on the IPO horizon.

  • Manual Carta-to-spreadsheet reconciliation each month (~6 hours)
  • Per-grant Black-Scholes in spreadsheet — volatility refreshed annually, sometimes
  • Modifications calculated by hand with inconsistent methodology
  • ESPP look-back complexity not fully reflected
  • DTA tracking by grant absent — done at aggregate
  • Forfeiture rate estimated annually, not re-trued continuously
  • Disclosure rollforward built quarter-end from spreadsheet snapshots
  • Three audit findings on equity in prior year

What Ledger Summit implemented

An ASC 718 expense engine that pulls live from Carta, calculates fair value per grant with documented methodology, applies vesting tranche schedules, handles modifications and ESPP look-back, posts monthly journal entries to NetSuite, and produces a per-grant evidence pack. Every disclosure number ties to underlying grant-level detail.

  • Carta API integration — daily cap-table sync; new grants flagged for measurement
  • Black-Scholes engine with documented inputs — volatility (peer-group + historical), risk-free rate (Treasury curve), dividend yield, expected term (SAB 107 simplified or actual exercise data)
  • Vesting tranche schedule per grant with ratable expense recognition over the requisite service period
  • Forfeiture handling — actual basis (preferred under ASU 2016-09) or estimated rate with annual true-up
  • Modification engine with three branches: type I (probable-to-probable), type II (improbable-to-probable), type III (probable-to-improbable); incremental fair value calculation
  • ESPP fair value with look-back provision (fair value of look-back option + 15% discount where applicable)
  • Performance condition tracking with probability assessment
  • Repurchase accounting (treasury stock, retirement)
  • DTA tracking per grant with windfall/shortfall handling on exercise/vest
  • Quarterly disclosure rollforward auto-generated
  • SOX-ready evidence pack per grant: methodology, inputs, calculation, JE trace

ASC 718 mechanics — what the engine handles

Stock comp accounting has many edges. Each is a documented branch in the engine.

TopicWhat it requires
Grant-date fair valueBlack-Scholes (options) or grant-date stock price (RSUs); inputs documented per grant
VolatilityPeer-group implied volatility weighted with historical; refresh quarterly
Expected termSAB 107 simplified (for options without history) or actual exercise pattern
Vesting — gradedEither straight-line over total service period (with floor) or accelerated tranche-by-tranche
Vesting — cliffRecognize over total service period
Performance conditionsRecognize when probable; reverse if not achieved
Market conditionsReflected in grant-date fair value (Monte Carlo); not reversed if not achieved
Modifications — Type I (probable→probable)Recognize incremental fair value over remaining service period
Modifications — Type II (improbable→probable)New grant-date fair value; recognize over modified service
Modifications — Type III (probable→improbable)Reverse all unrecognized expense
ForfeituresAccount on actual basis (ASU 2016-09 election) or estimated with true-up
ESPP qualified plansFair value = look-back option + 15% discount; recognize over offering period
Repurchases for cashCharge to APIC up to original credit; rest to retained earnings
Repurchases for tax withholding (RSU vest)Treasury stock; reduces shares outstanding without P&L
Cashless exercisesNet share settlement; recognize compensation on full grant; treasury stock for withheld
Deferred tax asset (DTA)Recognize at expense date based on expected tax deduction
Windfall / shortfall on exerciseFlow to P&L as tax expense adjustment per ASU 2016-09
Disclosure rollforwardBy award type: outstanding, granted, exercised/vested, forfeited; weighted-avg grant-date fair value, remaining contractual term, intrinsic value

Implementation timeline — 10 weeks

  • Weeks 1–2: Discovery and methodology refresh. Inventory all 480 active grants by award type, refresh volatility methodology, refresh expected-term methodology, classify grants by vesting structure, identify modifications history.
  • Weeks 3–5: Build. Engine logic for Black-Scholes, vesting schedule application, modification handling (3 branches), ESPP look-back, repurchase accounting, DTA tracking, forfeiture handling.
  • Week 6: Calibration. Re-perform 24 months of historical expense in shadow; reconcile to prior books; identify and document differences.
  • Week 7: Parallel run. Engine ran alongside the Q3 close. Three reconciling items found — all spreadsheet errors. Engine matched.
  • Week 8: Cutover. First close on the new system for Q4. Restated cumulative-effect adjustment for 3 prior-year findings.
  • Weeks 9–10: Hypercare. Auditor walkthrough of methodology, evidence pack, SOX control narrative. Grant accountant trained for steady-state operation.

Measured results

MetricBeforeAfterDelta
Equity accountant time / month~30 hours~5 hours−83%
Quarterly disclosure prep~3 days~half day−85%
Modifications processed correctly~70%100%+30 pp
Audit findings — equity area30−3
SOX walkthrough — equityMaterial weakness flagClean walkthrough
Disclosure tie-out varianceReconciling differences$0−100%
DTA tracking granularityAggregatePer grant

Alternatives considered

OptionTime to live3-year costStrengthsWeaknesses at this scale
Shareworks (Morgan Stanley) Equity Edge Online5–7 months$420K–$680KFull equity admin platformReplaces Carta — disruptive
Carta Equity Compensation3–5 months$220K–$340KNative to existing CartaModification handling shallow
Workiva (for SOX disclosures)6 months$280K–$420KStrong disclosure depthDoesn't handle expense calc
Build on Carta + NetSuite (selected)10 weeks$140K–$220KRight-sized; SOX-readyMaintenance load on team

Frequently asked questions

Why not switch from Carta to Shareworks?

For most pre-IPO SaaS at this scale, Carta covers cap table well and the gap is in expense accounting, not equity admin. Switching equity admin platforms during IPO prep is risky; build-and-integrate delivered the expense automation without that disruption.

How do you handle volatility for a private company?

Peer-group implied volatility weighted with the company's own historical price (limited for private companies pre-IPO; supplemented by 409A valuation history). Methodology documented and refreshed quarterly with auditor concurrence.

What about ESPP look-back valuation?

Look-back option modeled per ASC 718-50; fair value = call option on stock at start of offering period + 15% discount. Engine refreshes per offering period.

How do you handle modifications correctly?

Three branches per ASC 718-20-35-3: probable-to-probable (recognize incremental fair value over remaining service), improbable-to-probable (new grant-date FV over modified service), probable-to-improbable (reverse unrecognized expense). Each modification has reviewer sign-off.

What about repurchases?

Cash repurchases reduce APIC up to original credit, then retained earnings. RSU tax-withholding repurchases create treasury stock without P&L impact. Cashless exercises net-settle with treasury stock for the withheld portion.

How do DTAs work post-ASU 2016-09?

DTA recognized as expense is recognized; on exercise/vest, actual tax deduction creates windfall (deduction exceeds expense) or shortfall (deduction less than expense). Windfalls/shortfalls flow to P&L as tax expense adjustment, not APIC. Engine tracks per grant.

What about Section 409A and 162(m)?

409A valuations drive grant pricing; the engine consumes 409A-priced grants but doesn't perform 409A. 162(m) limits on covered-employee deductibility tracked separately and impact tax provision.

Can you handle stock appreciation rights (SARs) or phantom equity?

Yes. Cash-settled SARs / phantom equity are liability-classified and remeasured each period to fair value. Engine supports both classifications.

How does this support IPO prep?

S-1 disclosures (10-Q/10-K equity tables) tie cleanly. Auditor walkthrough is part of hypercare. SOX 404 narrative drafted as the engine is built.

What about post-IPO?

The engine continues operating; SOX 404(b) auditor attestation testing slots in alongside management testing. Disclosure depth (intrinsic value, expected dividend yield) increases per public-company requirements.

Equity comp accounting holding back IPO readiness?

A 30-minute call walks your cap table and tells you whether automation is the right next step.

Book a free call