Common Cap Table Errors and How to Fix Them

A single typo in a cap table can cost founders 3–5% equity when the error compounds across multiple funding rounds. Yet 67% of early-stage startups manage their cap tables in Excel spreadsheets where a misaligned cell, duplicate entry, or outdated vesting schedule creates discrepancies that surface only during due diligence—when investors discover your cap table shows 103% ownership allocated, or an advisor claims 2% equity you don’t remember granting. These errors don’t just embarrass founders; they delay funding rounds, trigger legal disputes, and force down-round dilution to clean up the mess.

This guide breaks down the 10 most common cap table errors that derail fundraising, exactly how to identify each mistake in your current table, step-by-step fixes to correct them, prevention systems to avoid future errors, and when to abandon Excel for dedicated cap table software.

Error #1: Outdated or inconsistent records
Error #2: Missing or incorrect vesting schedules
Error #3: Phantom equity and unpapered promises
Error #4: Mismanaged option pools
Error #5: Tracking failures on convertible instruments
Error #6: Excel formula errors and version control chaos
Error #7: Over-allocating equity early (dead equity problem)
Error #8: Failing to link options to 409A valuations
Error #9: Misunderstanding share classes and rights
Error #10: Cap table and legal document mismatches
When to switch from Excel to cap table software
Frequently asked questions about cap table errors

1. Error #1: Outdated or inconsistent records

1.1 What the error looks like

Your cap table shows co-founder Sarah owns 25%, but you vaguely remember she left 18 months ago. Or it lists an advisor with 1% equity, but you can’t find the signed agreement. Or the total shares outstanding don’t match your last 409A valuation report.

Red flags:

Cap table last updated 6+ months ago
Employee departures not reflected (unvested shares still shown as granted)
Recent option grants missing
Total ownership percentages don’t sum to 100% (or exceed 100%)

1.2 Why it happens

Founders update cap tables reactively (only when raising or during board meetings) instead of after every equity event. Someone leaves, options vest, a convertible note converts—but no one updates the spreadsheet.

Without a single source of truth, different team members create conflicting versions. The CFO has one spreadsheet, the lawyer has another, the founder has a third.

1.3 How to fix it

Step 1: Audit all equity events since the last clean version

Pull bank records for stock purchases
Review board minutes for option grants
Check employment agreements for departure dates and vesting acceleration
Cross-reference with 409A reports

Step 2: Create a timeline of every equity change

Date, event type (grant, exercise, termination, conversion), shares affected, stakeholder

Step 3: Rebuild cap table from ground truth

Start with incorporation documents (how many shares authorized, initial issuance)
Layer each equity event chronologically
Reconcile to current total shares outstanding

Step 4: Establish update cadence

Update within 48 hours of any equity event
Monthly reconciliation review
Quarterly audit against legal documents

1.4 Prevention

Use cap table software (Carta, Pulley, Capshare) that automatically timestamps changes and maintains version history. Assign one owner (CFO, finance lead, or founder) as cap table maintainer.

2. Error #2: Missing or incorrect vesting schedules

2.1 What the error looks like

Your cap table shows advisor Bob owns 50,000 shares, but it doesn’t show:

When vesting started
Cliff date (if any)
Vesting schedule (4-year monthly, annual, milestone-based)
How many shares have actually vested vs unvested

Common mistakes:

Showing fully vested shares when employee just started (assumes all shares vest immediately)
Not tracking cliff dates (1-year cliffs common for advisors, employees)
Ignoring vesting acceleration clauses (single or double-trigger on acquisition)

2.2 Why it matters

If Bob leaves after 18 months of a 4-year vest with 1-year cliff, he keeps only 37.5% of his 50,000 shares (18,750). The remaining 31,250 unvested shares return to the option pool. If your cap table shows all 50,000 as vested, you’re overstating Bob’s ownership and understating the available option pool.

During fundraising, investors will notice the discrepancy and question whether other vesting schedules are wrong too.

2.3 How to fix it

Step 1: Create vesting schedule tracker
For every stakeholder with vesting, document:

Start date
Cliff period (typically 12 months)
Vesting schedule (4-year monthly, custom milestones)
Acceleration triggers (none, single-trigger, double-trigger)

Step 2: Calculate vested vs unvested as of today
Use formula:

If current date < cliff date: 0% vested
If current date ≥ cliff date: (months since start date / total vesting months) × total shares

Step 3: Add columns to cap table

Total granted
Vested to date
Unvested (unearned)
Available to exercise (vested but not yet exercised, for options)

Step 4: Set up monthly vesting calculation
Cap table software automates this. In Excel, use formulas with TODAY() function to calculate vested amounts dynamically.

2.4 Prevention

Grant equity only with signed documents that specify vesting terms. Never grant “fully vested” equity to new employees or advisors (defeats the retention purpose). Track vesting start dates immediately in cap table.

3. Error #3: Phantom equity and unpapered promises

3.1 What the error looks like

You verbally promised your first engineer 2% equity, but never formalized it with a stock option agreement. Six months later, you can’t remember if you said 2% of current shares or 2% post-Series A dilution. The engineer remembers 2% “no matter what.”

Or you issued equity to an advisor via handshake agreement. No signed contract, no board approval, no documentation. Now the advisor claims 1.5% when you remember agreeing to 0.5%.

Red flags:

Stakeholders listed in cap table without signed grant agreements
Email promises (“We’ll give you 1% equity”) without formal documentation
Verbal agreements with early employees, advisors, contractors

3.2 Why it’s catastrophic

During due diligence, investors ask for every equity grant agreement. If you can’t produce signed docs for 5% of your cap table, you have two options:

Option 1: Exclude those stakeholders from cap table (they may sue)
Option 2: Retroactively formalize the agreements (dilutes you more than planned if stakeholders demand better terms than you remember)

Both options delay funding and damage credibility.

3.3 How to fix it

Step 1: Identify all phantom equity
Review cap table for stakeholders without executed agreements. Make a list.

Step 2: Reconstruct intent from emails, Slack messages, texts
Find written evidence of what you agreed to (even informal). This establishes baseline.

Step 3: Draft formal agreements retroactively
Work with counsel to create proper stock option agreements, advisor agreements, or restricted stock agreements matching the original intent.

Step 4: Get signatures ASAP
Approach stakeholders: “We need to formalize the equity we discussed. Here’s the agreement reflecting our original terms.” Most will sign if terms match expectations.

Step 5: Get board approval retroactively
Board must ratify all equity grants. Hold special meeting to approve the formalized agreements.

3.4 Prevention

Golden rule: Never grant equity without a signed, board-approved agreement. Use templates (available from law firms, cap table software platforms, or resources like NVCA model docs). Even if the paperwork feels slow, it prevents massive headaches later.

4. Error #4: Mismanaged option pools

4.1 What the error looks like

Your cap table shows a 10% option pool, but:

8% has already been granted to employees
You promised 3% to your next VP Sales (not yet hired)
Total: 11% committed, but only 10% exists

Or your investors negotiated a 15% option pool expansion before Series A, but you created the new shares post-money(diluting investors too) instead of pre-money (diluting only founders).

Common option pool mistakes:

Pool exhaustion: Granting options faster than you realize, leaving no room for future hires.

Overpromising: Verbally committing equity to candidates before checking if pool has capacity.

Pre-money vs post-money confusion: Creating pool at wrong time, causing unintended dilution.

Not refreshing pool: Failing to expand pool when raising new rounds, forcing mid-round emergency expansion.

4.2 Why it matters

If you’ve promised 11% but only have 10% pool, you either:

Break promises to candidates (damages reputation)
Do emergency board approval to expand pool (dilutes founders)
Delay hiring until next fundraise (slows growth)

All bad outcomes.

4.3 How to fix it

Step 1: Calculate current pool status

Total option pool size (authorized)
Granted (issued to employees, vested or unvested)
Reserved (promised to accepted offers not yet started)
Available (not granted or reserved)

Step 2: Forecast 12-18 month hiring needs
List every planned hire with expected equity grants. Sum total.

Step 3: Compare forecast to available pool
If forecast exceeds available, you need to expand the pool.

Step 4: Expand pool strategically

Before fundraising: Expand pre-money so investors don’t share dilution
After fundraising: Only if you underestimated hiring needs and can’t wait for next round

Step 5: Track pool utilization monthly
Set alerts when pool drops below 3% available (time to plan expansion).

4.4 Prevention

Create a 12-month hiring plan with estimated equity per role. Reserve equity for accepted offers immediately (mark as “reserved” in cap table). Expand pool proactively before it runs dry.

5. Error #5: Tracking failures on convertible instruments

5.1 What the error looks like

You raised $500k via SAFEs (Simple Agreement for Future Equity) with $5M cap and 20% discount. Your cap table shows the $500k as debt or doesn’t show it at all.

Six months later, you raise Series A at $8M pre-money. The SAFEs convert, but you:

Forgot to include them in fully diluted calculations during negotiations
Can’t remember if you had valuation caps or discounts
Discover you actually raised $750k in SAFEs, not $500k (second SAFE batch forgotten)

Now Series A investors realize the post-money is different than they thought, and they’re pissed.

Common convertible tracking errors:

Not tracking SAFEs/notes on cap table at all (they’re “not equity yet”).

Forgetting conversion terms: Cap, discount, interest rate (for notes), maturity date.

Losing count: Multiple SAFE rounds with different terms, all mixed together.

Not modeling conversion impact: Investors think they’re getting 20%, but after SAFE conversion they’re actually getting 17%.

5.2 Why it matters

SAFEs and convertible notes will convert into equity. If you don’t model this upfront, you’ll face:

Surprised investors who realize their percentage is lower than discussed
Unexpected dilution to founders
Messy cap table during Series A negotiations

Some investors walk away when they discover material SAFE/note amounts not disclosed upfront.

5.3 How to fix it

Step 1: Find all convertible instruments
Search email, bank accounts, DocuSign, legal files for every SAFE or note issued.

Step 2: Create convertible tracking section in cap table
For each instrument, document:

Principal amount
Issue date
Valuation cap (if any)
Discount rate (if any)
Interest rate (for notes)
Maturity date
Investor name

Step 3: Model conversion scenarios
Use formulas to calculate how many shares each instrument converts into under different Series A prices:

If Series A at $8M pre: SAFE at $5M cap converts at $5M, discount SAFEs convert at 20% off $8M, etc.

Step 4: Include converted amounts in “fully diluted” calculations
When pitching Series A investors, show cap table post-SAFE conversion so everyone sees the real dilution.

5.4 Prevention

Add every SAFE or note to cap table immediately upon issuance. Use cap table software that models conversion automatically (Carta, Pulley, AngelList Stack). Before any priced round, run conversion scenarios to avoid surprises.

6. Error #6: Excel formula errors and version control chaos

6.1 What the error looks like

Your cap table totals don’t sum to 100%. Or you have three files: “CapTable_Final.xlsx,” “CapTable_Final_v2.xlsx,” “CapTable_ACTUAL_FINAL.xlsx”—and you’re not sure which is current.

Or someone accidentally deleted a column of vesting data, and you didn’t notice until due diligence.

Common Excel mistakes:

Broken formulas: Copying/pasting cells breaks relative references, causing totals to reference wrong rows.

Circular references: Formula loops create Excel errors.

Deleted columns/rows: Accidentally deleting data that formulas depend on.

Multiple versions: Different stakeholders working on separate copies, creating divergent “truth.”

No audit trail: Can’t see who changed what or when.

6.2 Why it matters

During due diligence, investors request your cap table. If it shows 103% ownership or broken formulas, they question your financial rigor. If you can’t explain discrepancies, they assume worse errors exist elsewhere (revenue recognition, burn rate, etc.).

Bad cap table = delayed funding or lost deal.

6.3 How to fix it

Step 1: Audit all formulas

Check every SUM formula references correct range
Verify percentage calculations use correct denominators (fully diluted shares)
Test edge cases (what if someone exercises all options? Does total break?)

Step 2: Lock down the “master” version

Pick one file as canonical source of truth
Archive old versions in “/Archive” folder
Name master file simply “CapTable.xlsx” (no version numbers)

Step 3: Implement single-editor rule
Only one person (CFO, founder, finance lead) can edit master cap table. Others can view read-only copies.

Step 4: Set up change tracking

Use Excel’s “Track Changes” feature (limited but better than nothing)
Or migrate to Google Sheets with version history
Or move to dedicated cap table software

Step 5: Weekly backups
Save dated backup copies weekly: “CapTable_Backup_2026-02-13.xlsx”

6.4 Prevention

Stop using Excel for cap tables beyond seed stage. Excel works for 5 stakeholders and 2 funding rounds. Beyond that, errors compound too fast. Migrate to Carta, Pulley, or similar platforms that prevent formula errors and maintain complete audit trails.

7. Error #7: Over-allocating equity early (dead equity problem)

7.1 What the error looks like

You gave your first employee 5% equity (generous for employee #1). They left after 14 months, vesting only 35% of their grant (1.75%). The remaining 3.25% returned to the option pool.

But you also gave:

Advisor A: 2% (left after 6 months, vested only 0%)
Contractor B: 1.5% (completed project, fully vested but added little value)
Co-founder’s cousin C: 3% (never contributed meaningfully)

Total “dead equity” wasted: 6.75% that could have gone to key hires but instead went to people who added minimal value.

Over-allocation mistakes:

Generous early grants: Giving 2–5% to first employees when 0.25–1% would have sufficed.

Fully vested advisor equity: Granting advisors 1–2% fully vested upfront instead of vested over 2 years.

Equity to contractors: Paying contractors in equity instead of cash for one-off projects.

Friends and family equity: Giving equity to people who helped early but aren’t committed long-term.

7.2 Why it matters

Every percentage point of equity wasted early means less equity available for critical hires later (VP Sales, VP Eng, Head of Growth). When you need to recruit a world-class executive, you might only have 0.5% left to offer when market rate is 1.5–2%.

This forces:

Lowball offers that lose candidates
Emergency pool expansions (diluting founders)
Overpaying in cash because equity pool is exhausted

7.3 How to fix it

Step 1: Identify dead equity
Review everyone who received equity. Mark those who:

Left early (vested <50%)
Never contributed meaningfully
Were overpaid relative to value added

Step 2: Reclaim unvested shares
For anyone who left, ensure unvested shares returned to pool. Verify this in your cap table.

Step 3: Negotiate buybacks (if possible)
If someone has vested equity but left and isn’t contributing, you can offer to buy back their shares at fair market value. This is optional and requires board approval.

Step 4: Reset equity granting philosophy

Use industry benchmarks (0.1–0.5% for early employees, 0.25–0.5% for advisors)
Always vest over 4 years with 1-year cliff
Reserve generous grants (1–5%) only for C-level executives

7.4 Prevention

Grant equity conservatively early. You can always grant more later (refreshers, bonuses), but you can’t claw back vested equity. Use cash bonuses for short-term contributions, equity only for long-term value-add.

8. Error #8: Failing to link options to 409A valuations

8.1 What the error looks like

You granted options to employees at $0.10/share in January 2024. Then you raised Series A in June 2024 at $2.00/share. You got a 409A valuation in July 2024 showing fair market value (FMV) of $1.50/share.

But you kept granting options at $0.10/share through September 2024 because you didn’t realize you needed to update the strike price after 409A.

Result: IRS treats $1.40/share difference as taxable income to employees. Massive tax penalties, and employees are furious.

Common 409A mistakes:

Not getting 409A valuations: Required annually and after any “material event” (funding round, major product launch).

Granting options below 409A FMV: Creates immediate tax liability for employees.

Using outdated 409A: Granting options at old FMV when company value has clearly increased.

Not understanding safe harbor: 409A provides safe harbor for 12 months or until material event.

8.2 Why it matters

IRS requires stock options to be granted at or above fair market value (409A valuation). If you grant below FMV:

Employees owe income tax on the difference (at ordinary income rates, not capital gains)
Company may owe penalties
Employees can’t exercise options at the lower strike price (defeats purpose of options)

Investors will notice during due diligence and may require you to fix retroactively (expensive).

8.3 How to fix it

Step 1: Get current 409A valuation
If you don’t have one or it’s >12 months old, hire a valuation firm immediately (costs $2k–$5k for early-stage, $10k–$25k for growth-stage).

Step 2: Update option strike price in cap table
Any new grants must use current 409A FMV as strike price.

Step 3: Review past grants for compliance
Check if any grants occurred between material event (like funding round) and next 409A. If so, consult counsel—you may need to amend grants or file corrections with IRS.

Step 4: Set 409A reminder system
Calendar annual 409A renewal (month before expiry). Set automatic reminder 30 days after any funding round (material event triggers new 409A).

8.4 Prevention

Get 409A valuations on schedule (annual + post-material events). Use cap table software that integrates 409A and automatically updates strike prices for new grants. Never grant options without confirming current FMV.

9.1 What the error looks like

Your cap table shows “Preferred Stock” but doesn’t specify:

Liquidation preference (1x, 2x, participating?)
Voting rights (how many votes per share?)
Conversion rights (when does preferred convert to common?)
Protective provisions (what decisions require investor approval?)

Or you accidentally issued common stock to investors instead of preferred stock, giving them no liquidation preference.

Common share class mistakes:

Not distinguishing between common and preferred: Treating all equity as identical.

Granting common instead of preferred to investors: Loses key investor protections.

Creating multiple preferred classes inconsistently: Series A preferred has 1x liquidation preference, Series B has 1.5x—but cap table doesn’t track this.

Not modeling liquidation waterfall: Can’t calculate who gets what in exit scenarios.

9.2 Why it matters

In an exit (acquisition or IPO), the distribution of proceeds depends on share class rights:

Example liquidation waterfall (simplified):

Preferred shareholders get liquidation preference (1x invested capital) first
Remaining proceeds distributed pro-rata to all shareholders

If your cap table doesn’t track liquidation preferences, you can’t model exit scenarios. Investors will demand this during diligence.

9.3 How to fix it

Step 1: Identify all share classes
Review legal documents (charter, board resolutions, stock purchase agreements) to identify every class:

Common stock
Series Seed Preferred
Series A Preferred
Series B Preferred
etc.

Step 2: Document rights for each class
For each preferred class:

Liquidation preference (1x, 2x, participating, non-participating)
Conversion ratio (typically 1:1, but can vary)
Voting rights (typically 1 vote per share, but not always)
Dividend rights (rare for startups, but check)
Anti-dilution protection (full ratchet vs weighted average)

Step 3: Add share class columns to cap table

Stakeholder name
Share class (Common, Series A Preferred, etc.)
Shares owned
Liquidation preference amount ($ invested × preference multiple)

Step 4: Build liquidation waterfall model
Create separate tab in cap table showing who gets what at various exit values ($10M, $50M, $100M exits). This helps you understand dilution impact and investor returns.

9.4 Prevention

Use cap table software that models share classes and liquidation preferences automatically. When raising new rounds, ensure legal counsel documents all rights and preferences clearly in charter amendments.

10. Error #10: Cap table and legal document mismatches

10.1 What the error looks like

Your cap table shows Investor X owns 500,000 shares of Series A Preferred. But the signed Stock Purchase Agreement says 525,000 shares. The certificate of incorporation says 510,000 shares. Three different numbers for the same investor.

Or your cap table shows employee options with 4-year vesting, but the signed option agreement says 3-year vesting.

Common document mismatches:

Cap table vs stock purchase agreements: Share counts don’t match.

Cap table vs option agreements: Vesting schedules differ.

Cap table vs charter: Authorized shares, issued shares, or share classes inconsistent.

Cap table vs 409A report: FMV per share doesn’t match.

Cap table vs board minutes: Option grants not approved by board, or approved amounts differ from cap table.

10.2 Why it matters

During due diligence, investors cross-reference your cap table against every legal document. If they find mismatches, they assume:

Cap table is unreliable (what else is wrong?)
Legal docs might be incomplete or forged
Company has poor financial controls

This can kill deals or force extensive legal cleanup before close (delaying funding, adding legal costs).

10.3 How to fix it

Step 1: Gather all legal documents

Stock purchase agreements for all investors
Option grant agreements for all employees/advisors
Charter and amendments (certificate of incorporation)
Board resolutions approving equity grants
409A valuation reports

Step 2: Reconcile cap table to each document
Create a spreadsheet comparing cap table entries to legal docs:

Stakeholder | Cap Table Shares | Legal Doc Shares | Match? | Notes

Step 3: Identify and investigate discrepancies
For every mismatch, determine root cause:

Typo in cap table?
Legal doc error?
Undocumented transaction (shares issued but not recorded)?

Step 4: Correct errors and update documents

Fix cap table if it’s wrong
Amend legal documents if needed (requires board approval, stakeholder signatures)
Get legal counsel involved for complex corrections

Step 5: Create reconciliation checklist
Going forward, every equity transaction must include:

Board approval (documented in minutes)
Signed legal agreement
Cap table update within 48 hours
Quarterly reconciliation audit

10.4 Prevention

Implement “document first, cap table second” rule: Never update cap table until signed legal docs exist. Use cap table software that stores legal docs alongside equity records and flags mismatches.

When building your data room for fundraising and investor due diligence, platforms like Fundreef help you understand exactly what investors will scrutinize in your cap table and legal documents—research which funds have strict cap table hygiene requirements vs more flexible approaches, so you can prioritize cleanup efforts based on your target investor list and avoid last-minute fire drills during diligence.

11. When to switch from Excel to cap table software

11.1 Signs Excel is no longer working

You should migrate to cap table software if:

You have 10+ stakeholders (founders, investors, employees, advisors)
You’ve raised 2+ funding rounds (Seed + Series A or beyond)
You’ve issued convertible instruments (SAFEs, notes) that will convert
Employees are exercising options frequently
You’re spending >2 hours/month maintaining cap table manually
You’ve had errors or discrepancies in past 6 months
You’re preparing for Series A or later fundraising (diligence requires clean cap table)

11.2 Top cap table software platforms

Platform	Best For	Pricing	Key Features
Carta	Series A+ startups, large employee base	$2k–$15k+/year	Full equity management, 409A valuations, secondary markets
Pulley	Seed to Series B, budget-conscious	Free to $500/month	Simple UX, scenario modeling, investor-friendly
AngelList Stack	Pre-seed to Seed	Free for small teams	Integrated with AngelList fundraising, SPVs
Shareworks (Schwab)	Late-stage, pre-IPO	Enterprise pricing	Public company transition, stock plan administration
Cake Equity	Non-US startups	$10–$200/month	Global compliance, multi-currency

11.3 What to look for in cap table software

Must-have features:

Automated vesting calculations (saves hours/month)
SAFE/note conversion modeling (essential for fundraising)
Scenario planning (model dilution across multiple future rounds)
409A integration (ensures compliance)
Document storage (links equity grants to signed agreements)
Audit trail (tracks who changed what and when)
Stakeholder portal (employees/investors can view their own equity)

Nice-to-have features:

Secondary market access (Carta’s liquidity programs)
Integrated 409A valuations (order directly through platform)
Cap table sharing (send read-only access to investors during diligence)
Waterfall modeling (calculate exit proceeds by scenario)

11.4 Migration process

Step 1: Clean up Excel cap table (fix errors above before migrating).

Step 2: Choose platform and sign up.

Step 3: Import data (most platforms accept CSV uploads or offer white-glove migration service).

Step 4: Verify accuracy (cross-check imported data against source documents).

Step 5: Invite stakeholders (employees, investors get portal access to view their equity).

Step 6: Decommission Excel (archive final Excel version, switch fully to platform).

Most platforms offer free migration support for new customers.

Frequently asked questions about cap table errors

What are the most common cap table mistakes?

Outdated records (not updating after departures or grants), missing vesting schedules (showing all shares as fully vested), phantom equity without signed agreements, mismanaged option pools (over-promising or exhausting pool), poor convertible instrument tracking (forgetting SAFEs/notes), Excel formula errors and version control chaos, over-allocating equity early to low-value contributors, not linking options to 409A valuations, misunderstanding share class rights, and cap table-legal document mismatches.

How do I fix a messy cap table before fundraising?

Audit all equity events since inception, rebuild cap table from legal documents (charter, stock purchase agreements, option grants), reconcile to board minutes and 409A reports, identify and correct discrepancies, add missing vesting schedules, model SAFE/note conversions, verify totals sum to 100%, get legal counsel review for complex errors, and migrate to cap table software (Carta, Pulley) before due diligence begins.

When should I switch from Excel to cap table software?

Switch when you have 10+ stakeholders, raised 2+ funding rounds, issued convertible instruments, employees exercising options regularly, spending 2+ hours monthly on manual updates, experienced errors in past 6 months, or preparing for Series A+ fundraising. Excel works for simple early-stage cap tables but breaks down as complexity grows.

What happens if my cap table doesn’t match legal documents?

Investors will discover mismatches during due diligence, which delays funding, damages credibility, requires expensive legal cleanup, and can kill deals entirely. Common mismatches: cap table vs stock purchase agreements (different share counts), cap table vs option agreements (different vesting schedules), cap table vs charter (authorized shares inconsistent). Always reconcile cap table to legal docs quarterly.

How do I prevent cap table errors going forward?

Use cap table software instead of Excel, assign single owner responsible for updates, update within 48 hours of any equity event, never grant equity without signed board-approved agreements, get 409A valuations on schedule (annual + post-material events), reconcile cap table to legal documents quarterly, maintain document version control, and model dilution scenarios before every funding round.

What’s the difference between vested and unvested equity?

Vested equity is earned and owned by the stakeholder (cannot be forfeited even if they leave). Unvested equity has not yet been earned (subject to forfeiture if stakeholder leaves before vesting completes). Standard vesting: 4 years monthly with 1-year cliff (0% vests until 12 months, then 25% vests, then monthly thereafter). Cap tables must track both vested and unvested separately.

Suggested visuals to create

Cap table error severity matrix
2×2 grid showing Common (X-axis) vs Catastrophic (Y-axis): Phantom equity (rare but catastrophic), Excel errors (common but low severity), SAFE tracking failures (common and severe), Document mismatches (moderate both).
Vesting schedule visualization
Timeline showing 4-year vest with 1-year cliff: Month 0 (0% vested) → Month 12 (25% vests at cliff) → Month 24 (50% vested) → Month 48 (100% vested), with departures at different points showing forfeiture.
Cap table software comparison table
Side-by-side comparison of Carta, Pulley, AngelList Stack, Cake Equity showing: Pricing, Best for (stage), Key features, 409A integration, Migration support, Stakeholder portal.

Table of Contents