Your Cap Table Is a Ledger, Not a Spreadsheet

Double-entry bookkeeping works because it enforces invariants. If the books do not balance, something is wrong.

Five hundred and thirty-two years later, most startups track their ownership structure in a spreadsheet that doesn’t enforce any invariants at all. A cap table where the shares don’t add up, where a founder’s percentage is calculated by a formula that references the wrong cell, where the option pool size was updated in one tab but not the other.

The cap table is the most important financial record your company has. It determines who owns what. It governs voting rights, liquidation preferences, pro rata participation, and the distribution of proceeds in an exit. Every investor, every acquirer, every regulator, and every tax authority will examine it. And you’re keeping it in the same tool you use for grocery lists.

What a cap table actually is

A cap table is an ownership ledger. It records every equity instrument the company has issued, every holder who owns those instruments, and every position, which is the current state of a holder’s ownership of a specific instrument.

The data model has three layers:

Instruments. These are the things that represent ownership: Common Stock, Preferred Stock, Membership Units, Stock Options, SAFEs, Convertible Notes, Warrants. Each instrument has an authorized quantity, an issue price, and terms that define its economic and governance rights.

Holders. These are the entities that own things: founders, employees, investors, trusts, funds, SPVs. Each holder has an identity, a type, and a link to the natural or legal person they represent.

Positions. These are the intersections: holder A owns X units of instrument Y, acquired at price Z, as of commit N. Positions are the current state of ownership. They change when grants vest, options exercise, shares transfer, or SAFEs convert.

A spreadsheet conflates all three. A proper ledger separates them, tracks them independently, and enforces the invariants between them.

When the Certificate of Incorporation authorizes “10,000,000 shares of Common Stock, par value $0.0001,” it’s creating a share class with specific properties:

Par value is the minimum price at which shares can be issued. At $0.0001, it is effectively a legal formality, but it still matters for franchise tax calculations and the initial stock purchase price.

Authorized shares is the maximum number of shares that can exist in this class. You can issue fewer, but not more, unless you amend the certificate.

Common Stock carries basic voting rights (one vote per share) and residual economic rights (after all preferences are paid, common shareholders split what’s left). This is what founders and employees get.

Preferred Stock is what investors get. It comes in series — Series Seed, Series A, Series B — each with negotiated terms: liquidation preference, anti-dilution protection, pro rata rights, board seats. The blank-check preferred authorization in your certificate lets the board create these series without amending the charter.

Membership Units are the LLC equivalent of shares. They don’t have par value. Ownership is expressed as a percentage interest rather than a share count. Voting and economic rights are defined in the operating agreement rather than by statute.

Authorized versus issued versus outstanding

Three numbers that founders routinely confuse:

Authorized: The maximum shares the company can issue. Set in the Certificate of Incorporation. Changing it requires a charter amendment.

Issued: The shares the company has actually issued to someone. Always less than or equal to authorized. Issuing shares is a Tier 3 action — it requires board authority.

Outstanding: The issued shares that are currently held by someone (not repurchased by the company). Usually equal to issued, unless the company has bought back shares.

When an investor asks “what’s the fully diluted share count?”, they want issued shares plus all shares that could be issued under existing commitments: unexercised options, unvested grants, unconverted SAFEs. This number determines their ownership percentage.

Your cap table must track all four: authorized, issued, outstanding, and fully diluted. A spreadsheet usually tracks one, badly.

The grant lifecycle

An equity grant has a lifecycle more complex than most founders realize:

Issued. The grant is created. Shares are allocated but may be subject to vesting restrictions.

Vesting. Over time, shares vest according to the schedule. Each vesting event — the cliff, the monthly tranches — changes the split between vested and unvested shares. The holder owns all the shares from the moment of issuance, but the unvested ones are subject to repurchase by the company if the holder leaves.

Exercised. For stock options, this is the point where the holder pays the exercise price and receives actual shares. For RSAs, this already happened at grant — the holder paid the purchase price upfront.

Forfeited. If the holder leaves before vesting is complete, the unvested shares are forfeited (for options) or repurchased at cost (for RSAs). The shares return to the authorized-but-unissued pool.

Transferred. Shares can change hands — through a sale, a gift, an estate distribution. Every transfer must go through the company’s transfer restrictions: right of first refusal, board approval, bylaws review.

Every transition in this lifecycle must be recorded. Every recording must be consistent with every other recording. The total issued shares across all grants must equal the company’s issued share count. The total authorized minus total issued must equal the shares available for future issuance.

These are the invariants. A spreadsheet doesn’t enforce them. A ledger does.

The option pool

At some point — usually right before raising a round — the board will create an equity incentive plan and reserve a pool of shares for future grants to employees and advisors. The standard is 10–20% of the fully diluted share count.

The option pool matters because it dilutes the founders before the investor’s money comes in. A 20% option pool on a $10M pre-money valuation means the founders are effectively giving up 20% of their $10M — $2M in dilution — before the investor writes a check. This is why option pool negotiation is one of the most consequential parts of a fundraise.

The cap table must track options granted from the pool, options exercised, options forfeited (which return to the pool), and the remaining unallocated pool. These numbers must reconcile. An option pool that doesn’t add up is a red flag in due diligence that can delay or kill a deal.

Voting rights and governance

Equity isn’t just economics. It’s governance.

Common Stock typically carries one vote per share. When the board proposes a charter amendment, a merger, or a dissolution, shareholders vote. The cap table determines who gets to vote and how much their vote counts.

Preferred Stock may carry voting rights (often on an as-converted-to-common basis) plus special protective provisions: the right to block certain actions, the right to approve changes to the preferred’s own terms, the right to appoint board members.

Your cap table must accurately reflect who has what voting power. A mistake in the share count is a mistake in the governance structure. If a contested vote is decided by a margin smaller than your spreadsheet’s rounding error, you have a problem that no amount of legal argument can fix.

Integrity is the whole point

A cap table has the same integrity requirements as a bank account. The numbers must add up. The transactions must be traceable. The current state must be derivable from the history of all prior transactions.

A spreadsheet doesn’t give you this. It gives you a snapshot that someone manually updates, that multiple people can edit without coordination, that has no audit trail, and that breaks silently when a formula references the wrong row.

A version-controlled ledger gives you everything: immutable history, atomic updates, conflict detection, cryptographic signatures, and the ability to answer “what did the cap table look like on June 15th?” with a single command instead of a prayer.

Every position in your cap table should be traceable to a specific grant, at a specific price, authorized by a specific board resolution, and committed at a specific point in history. Regulators care about that, but the more basic point is ownership: the cap table is the record of who owns your company.

Your bank wouldn’t track your balance in a spreadsheet. Your cap table deserves the same respect.