In a company with three shareholders and no options, a spreadsheet is fine. You can track everything that matters in a dozen rows. The total share count, each person's stake, any convertible instruments. It takes maybe 30 minutes to build and 10 minutes to update whenever something changes.
This works well enough that founders continue using it as the company grows. The spreadsheet accumulates columns. Then it accumulates tabs. Then it accumulates workarounds: a cell that references a calculation from a different tab, a conditional formula that only works correctly if you enter the vesting cliff date in a specific format, a note in the margin that says "check with Tanaka-san before changing this row." The spreadsheet becomes institutional knowledge that lives in the head of the person who built it, not in the tool itself.
This is not a criticism of spreadsheets. A well-designed spreadsheet with clear formulas, input validation, and documented assumptions can track a modest equity program for a surprisingly long time. The problem is that most equity tracking spreadsheets are not designed with that discipline. They grow organically, one column at a time, without a systematic model of the data structures they need to represent.
The inflection points where spreadsheet complexity spikes
Complexity in equity management does not grow linearly with headcount. It spikes at specific events, and those spikes are where spreadsheet-based tracking tends to fail.
The first spike comes when you issue your first convertible instrument, a J-KISS or a similar structure. The cap table now needs to model future dilution contingent on a financing event that has not happened yet. The conversion mechanics depend on the eventual round price, the valuation cap, and any discount terms. A spreadsheet that worked fine for a static ownership table needs to be extended with a dynamic dilution model. Getting this right requires understanding the conversion math precisely, and testing it against the actual contract terms.
The second spike comes when you have more than about eight option holders. At eight holders, tracking each person's vesting schedule, exercise history, and remaining annual exercise capacity under the 12-million-yen zeisei-tekikaku cap is still manageable if someone is paying close attention. At 15 holders, the number of events to track per month, vest dates, anniversary dates, post-termination exercise windows for departed employees, annual cap calculations, grows to the point where a cell reference error in the vesting schedule tab can produce an incorrect fully diluted count that is hard to catch.
The third spike comes when you have multiple grant tranches at different exercise prices. Options issued in 2024 at a certain exercise price, additional grants in 2025 at a higher price after a fundraise, and supplemental grants to new hires throughout the year: each tranche has its own grant date, exercise price, vesting schedule, and exercise period. The fully diluted cap table must reflect all of these correctly, and the calculation of the total in-the-money options at any given share price requires accurate data on every tranche.
The audit trail problem
A spreadsheet has no built-in audit trail. When a cell value changes, the prior value is gone unless someone has been manually maintaining a version history. In equity management, an audit trail is not optional. When a potential investor asks "what was the fully diluted share count on March 15 of last year?" you should be able to answer that question without reconstructing it from board minutes and email records.
The same issue applies to individual transactions. When an employee exercises 2,000 options, that event needs to be recorded with a date, the number of options exercised, the exercise price paid, and the resulting share issuance. When an option grant is forfeited because an employee left within their cliff period, that forfeiture needs to be recorded with a date and the number of options returned to the pool. Without an immutable transaction log, the state of the cap table at any prior point in time is a reconstruction, not a record.
Permission controls matter more than most founders realize
A shared Google Sheet or Excel file has limited permission controls. The person who owns the file can restrict who can edit it, but anyone with edit access can change any cell, including the formula cells that define the calculation logic. It is easy for someone to accidentally overwrite a formula with a static value and not notice the error.
Beyond accidental edits, there is a confidentiality dimension. Individual option holder positions are sensitive information that not every team member should have access to. A shared spreadsheet where the entire team's equity positions are visible to anyone with access to the document is not appropriate once the team has grown beyond a small co-founding group.
What purpose-built equity management actually solves
The value of purpose-built equity management is not primarily in the user interface, though a clean UI helps. The value is in the data model. A purpose-built system is designed around the actual structure of equity ownership: shares, option pools, grants, tranches, vesting schedules, exercises, forfeitures, convertible instruments, and their interactions. The system enforces consistency: you cannot record an option exercise that would take the annual exercise value above the zeisei-tekikaku cap without a warning. The fully diluted cap table is calculated from the transaction history, not maintained as a manually updated number.
The audit trail is immutable. Every transaction is recorded with a timestamp and a reference to the underlying authorization. When an investor asks for a point-in-time cap table view, the system can produce it without reconstruction work.
We built Nstock because we saw the same spreadsheet failure patterns showing up in company after company preparing for fundraises. The spreadsheet worked fine at the beginning. Then the company grew and the complexity grew with it, but the spreadsheet did not. The cleanup work that resulted was expensive and sometimes turned up compliance issues that the founders did not know they had. Getting the data structure right from the beginning, before the complexity hits its first spike, is much cheaper than cleaning it up later.
This is not a universal argument against spreadsheets in every context. For a company at the founding stage with two or three shareholders and no options, a spreadsheet is entirely appropriate. The question to ask is: what will my equity program look like in 18 months, after I have hired six people and issued a J-KISS to my first angel investors? If the answer involves multiple option holders, convertible instruments, and vesting schedules, planning the transition to a more structured system now is a better choice than discovering the limits of the spreadsheet in the middle of due diligence.
