Capitalization Table Templates for Startups: Google Sheets, Carta, and When Legal Review Matters

A capitalization table template is one of the first documents a startup needs — and one of the most neglected. Founders who track equity loosely in the early days tend to discover the consequences later, usually right before a funding round when an investor asks for a clean cap table and the numbers don't reconcile. Getting the structure right from incorporation, and maintaining it through every grant and financing event, saves significant time and legal cost down the road.

The cap table is a legal record, not just a financial spreadsheet. It documents who owns what, at what price, on what terms — and it governs how proceeds are distributed if the company is ever acquired or liquidated. Investors, acquirers, and auditors will scrutinize it. Errors in the cap table compound over time: a forgotten SAFE, a vesting schedule entered wrong, an option grant that was never formally authorized — these problems don't stay small.

This guide covers what belongs in a capitalization table template, when a Google Sheets structure works and when it doesn't, what Carta and similar platforms offer, and — critically — when you need a startup attorney to review your cap table before you take on new money or issue new equity.

What Is a Capitalization Table?

A capitalization table is a spreadsheet or software record that lists every security a company has issued — who holds it, how much they paid, and what percentage of the company they own as a result. It starts simple: two founders, equal shares, day one. By Series A, it typically spans multiple share classes, dozens of option holders, convertible instruments with different terms, and warrants issued to service providers or lenders.

Cap tables matter across nearly every significant company event. When you raise a funding round, investors want to see exactly how their money changes the ownership structure — including dilution to existing holders. When you issue options to employees, the cap table determines how much of the company's equity pool is available and what percentage each grant represents on a fully diluted basis. In an M&A process, the acquirer's legal team will use the cap table to model proceeds distribution and identify any ownership disputes or structural issues. And during investor due diligence, an inconsistent or poorly maintained cap table is a red flag that slows deals and raises questions about operational discipline.

The two most important ownership figures in any cap table are basic shares outstanding (shares actually issued and held) and fully diluted shares outstanding (everything issued plus all shares that could be issued — options, warrants, convertible instruments). Investors price their ownership on a fully diluted basis. Understanding the difference between these two numbers is foundational.

What Every Cap Table Template Must Include

A complete capitalization table template captures every class of security the company has issued or reserved. At the founder stage, that typically means common stock with vesting schedules. As the company grows, it expands to include option holders, SAFE investors, and eventually preferred stockholders.

Founder Shares

List each founder's name, the number of shares issued, the price paid (often a fraction of a cent at incorporation), the vesting schedule (typically four years with a one-year cliff), and the current vesting status. If a founder has departed and their unvested shares were repurchased, note the repurchase date and share count. A co-founder separation with a messy, undocumented equity adjustment is one of the most common problems that surfaces at due diligence.

Employee Option Pool

The option pool section should show three figures: shares authorized for the plan, shares issued (granted) under the plan, and shares exercised. The difference between authorized and issued is the unallocated pool — the equity available for future grants. Each individual grant should be tracked with its grant date, exercise price (the 409A fair market value at the time of grant), vesting schedule, and expiration date. Options that expire unexercised return to the pool.

SAFEs and Convertible Notes

Simple Agreements for Future Equity and convertible notes don't convert to shares until a triggering event — usually a priced round. Until then, they sit on the cap table as outstanding instruments. For each SAFE or note, track the investor name, principal amount, valuation cap, discount rate, and the type of instrument (post-money SAFE, pre-money SAFE, MFN SAFE, or convertible note with interest). These terms determine how much equity each instrument converts into, and modeling conversion scenarios is essential before pricing any round.

Preferred Stock (Post-Seed or Series A)

Once you've closed a priced round, preferred stockholders appear on the cap table with their share class (e.g., Series Seed Preferred, Series A Preferred), share count, price per share, liquidation preference, and participation rights. Each class of preferred has different rights, so the distinctions matter — especially in a waterfall analysis modeling acquisition proceeds.

Warrants

Warrants issued to lenders, advisors, or service providers should be tracked separately with the number of warrant shares, exercise price, issuance date, and expiration. They're easy to overlook because they aren't tied to employment, but they count toward fully diluted shares and must appear in the cap table.

Building a Cap Table Template in Google Sheets

A cap table template in Google Sheets is the right starting point for most pre-seed companies. Before you have institutional investors, a complex option plan, or multiple share classes, a well-structured spreadsheet is sufficient to track ownership and run basic dilution scenarios. The barrier to entry is low, you can share it with advisors or co-founders instantly, and it forces you to understand the underlying math — which matters when you're negotiating your first round.

A functional cap table template Google Sheets structure typically includes: a summary tab showing total authorized shares, total outstanding shares (basic and fully diluted), and ownership percentages by stakeholder; a founders tab with individual share grants and vesting status; an option pool tab tracking each grant; and a convertible instruments tab for SAFEs and notes. Column structure for each stakeholder row should include name, security type, shares or principal, ownership percentage (basic), and ownership percentage (fully diluted). Color-coding hard-coded inputs versus calculated fields is a standard practice that reduces entry errors.

The limitations of a spreadsheet cap table become significant once the company takes on complexity. Manual data entry creates version control problems — which file is current? Formulas break when rows are inserted or deleted. Modeling a funding round with SAFE conversion requires building out the math from scratch, and most founders get it wrong the first time. There's no audit trail, no integration with stock issuance documents, and no automatic 409A support. A spreadsheet cap table also can't generate the reports that institutional investors expect. Use it to learn the fundamentals and manage early-stage equity, but plan to migrate before you close your first institutional round. You can start with our cap table template to get a clean, properly structured starting point.

Cap Table Software: Carta and the Alternatives

Carta is the dominant platform for startup equity management, and for good reason. It centralizes cap table management, electronic stock certificate issuance, option grant administration, 409A valuations, and round modeling in a single platform. When you issue options through Carta, employees receive electronic grant notices, can track their equity online, and — when the time comes — can exercise through the platform. That administrative infrastructure is difficult to replicate in a spreadsheet, and the cost of errors in option administration (wrong exercise prices, missing board approval documentation, ISO vs. NSO classification errors) can be substantial.

The practical trigger for moving from a spreadsheet to Carta is the first institutional funding round or the first option grants to employees — whichever comes first. At that point, the complexity and legal consequence of equity administration outpaces what a manual process can reliably handle. Carta also produces the formatted cap table output that institutional investors and their counsel expect to receive during due diligence. For a deeper look at how cap table management works on the platform, see our full guide to Carta cap tables.

Carta isn't the only option. Pulley has built a following among early-stage startups as a lower-cost alternative with a strong interface for modeling rounds and managing options. Ledgy serves European startups and companies with international equity plans. Shareworks (now part of Morgan Stanley at Work) is more common at later-stage and pre-IPO companies. The right choice depends on your stage, investor expectations, and budget — but any of these platforms is preferable to a spreadsheet once your cap table has more than a handful of stakeholders or your first option grants are on the table.

When Your Cap Table Needs a Lawyer's Review

There are specific moments in a startup's life when the cap table isn't just a tracking document — it's the foundation of a legal transaction, and errors carry real legal and financial consequences. A startup attorney reviewing the cap table before these events is not redundant with what Carta or a spreadsheet does; it's a different kind of review, focused on legal accuracy, proper authorization, and structural issues that software won't catch.

Before Closing a Funding Round

Every priced round involves issuing new securities, and the cap table governs the entire transaction — SAFE and note conversion amounts, new share issuance, post-money ownership, and option pool treatment. If the cap table going into the round has errors (a SAFE with the wrong valuation cap, a founder share count that doesn't match the stock ledger, an option pool that wasn't properly authorized), those errors become embedded in the closing documents. Cleaning them up post-close is expensive and sometimes requires investor consent.

Before Issuing Options to Employees

Option grants require board approval, a current 409A valuation, and proper documentation. The cap table needs to correctly reflect the available pool, and the exercise price must match the 409A FMV as of the grant date. Issuing options without these elements creates tax exposure for employees (under Section 409A of the Internal Revenue Code) and potential securities law issues for the company. An attorney should confirm that the plan is properly adopted and that individual grants are correctly documented.

When Converting SAFEs or Convertible Notes

SAFE and note conversion is where cap table math gets consequential. The conversion formula — applying valuation caps, discounts, and pro-rata rights — determines how much of the company each instrument holder receives. Modeling this incorrectly, or using the wrong SAFE version (YC's pre-money vs. post-money SAFE have materially different conversion mechanics), results in the wrong number of shares being issued. An attorney should model the conversion independently and confirm it against the cap table before closing documents are executed.

When Adding a New Class of Stock

Issuing a new class of preferred stock — whether at Seed, Series A, or beyond — requires an amendment to the company's certificate of incorporation and board and stockholder approval. The cap table needs to reflect the new authorized share classes, liquidation preferences, and conversion ratios. These structural changes have downstream effects on existing holders, and the documentation needs to be complete and accurate before the round closes.

When a Co-Founder Is Departing

Co-founder departures almost always involve equity — unvested share repurchases, negotiated acceleration, and sometimes disputed vesting calculations. The cap table needs to be updated to reflect the repurchase, and the transaction needs to be properly documented to avoid future disputes. If the departing founder's equity wasn't subject to a vesting agreement, or if vesting wasn't tracked, a lawyer may need to help structure a resolution that protects the company's cap table going forward.

Actionable Next Steps

Building and maintaining a clean cap table is a process, not a one-time task. Here are the concrete steps to get it right from the start:

1. Set up your cap table at incorporation. Don't wait. The moment you issue founder shares, you have a cap table. Use our cap table template to get a properly structured Google Sheets file you can maintain from day one.
2. Track every equity event as it happens. Every SAFE, every option grant, every warrant — document it immediately. Reconstructing cap table history from memory and old emails is painful and error-prone. Real-time tracking is the only approach that works at scale.
3. Switch to Carta before your first institutional round or first option grants. The migration is easier when you do it proactively rather than under deal pressure. Give yourself a month before you expect to close your first priced round or issue your first employee options.
4. Have a startup attorney review your cap table before any funding closes. This is not the same as having Carta generate a report. Legal review catches structural problems — wrong share counts, missing authorizations, instrument terms that don't match the documents — before they become embedded in closing paperwork.
5. Keep your cap table and your corporate records in sync. The cap table should match the stock ledger, the option plan, and every board consent authorizing equity issuances. Discrepancies between these documents are the most common source of due diligence delays.