Stock Ledger and Share Register Template

What a stock ledger is

A stock ledger template is a single Excel workbook that records who owns a company’s shares and logs every issuance and transfer between shareholders — an ownership snapshot plus an append-only transaction history in one file.

Corporation law expects a company to keep this kind of internal share record — who holds what, and how each share moved between holders. A stock ledger is that record, kept current as ownership changes. That habit matters most when a lender, buyer, or court later asks who owned what and when — the ledger has the answer already.

This is a stock ledger, not a cap table. There are no valuations, no option pools, no vesting schedules, no 409A math. It records who owns what and how it changed hands — nothing it can’t stand behind.

What’s inside the Excel workbook

This share register template in Excel ships as one file, three sheets deep. A Start Here tab leads, followed by two data sheets — Equity Ownership and Equity Transactions — holding 18 fields behind 2 dropdown lists. No formulas, no sample rows — every dropdown list is pre-built, so a transaction type or equity class is a pick from a list.

This stock ledger opens in Google Sheets as well as Excel, dropdowns included, so a shared workbook stays consistent no matter who opens it. That consistency matters when the workbook passes between founders, counsel, and an incoming investor without a shared style guide.

Here’s what the two data sheets track:

The ownership snapshot

Equity Ownership — 8 fields — is the current picture: who holds what, right now. Ownership percent and voting percent sit in separate columns, so economic share and control can diverge across share classes. This equity ownership ledger template also works as a shareholder ledger template for a company with more than one class outstanding.

Cost basis and acquisition date sit on the same row, so you can check a later sale or transfer against what was paid. Units tie the percentage to a real number, not just a share of one hundred. Notes hold whatever detail a position needs — a side letter reference, a restriction, a reminder for next reconciliation.

The transaction log

Equity Transactions — 10 fields — gives every issuance and transfer its own row. Real transaction types cover how shares move: Grant, Exercise, Conversion, Gift, Inheritance, alongside Purchase and Sale. Equity class spans Common through Preferred A/B/C, plus partnership and membership interests.

This corporate stock transfer ledger template doubles as an equity transaction log spreadsheet — append-only, so a prior transfer is never lost.

Price per unit and total consideration record what changed hands, not an estimate of value. A Gift or Inheritance row can leave those fields blank, since nothing was paid. Each row stands on its own, so a later question about one transfer never touches another.

Keep a stock ledger in Excel

A stock ledger earns its name by never overwriting a row — every change gets a new one instead. Each row is a fact about a point in time, not a value to edit later. The habit is simple, but it’s the difference between a ledger and a list that happens to track shares.

To keep a stock ledger in Excel:

1. Add a row per shareholder on Equity Ownership, with ownership percent and voting percent tracked separately.
2. Record share class and units on every position — Common, Preferred A/B/C, or another equity class.
3. Log every issuance as its own row on Equity Transactions, with transaction type Grant, Purchase, or Conversion.
4. Log every transfer with both seller and buyer named on the same row.
5. Never overwrite a prior transaction — add a new row instead, even for a correction.
6. Reconcile the snapshot to the log periodically, confirming Equity Ownership matches what Equity Transactions shows actually happened.

That append-only discipline is what makes this a ledger rather than a list — the history survives every change, not just the current balance. A reconciliation catches drift before it compounds — a transaction logged but never reflected in the snapshot, or the reverse. Five minutes spent matching the two sheets is cheaper than an hour spent guessing which one is right before a closing.

When a spreadsheet stops working

Founders, corporate secretaries, and small-company counsel use it as a shareholder register for a small company. It strains for a firm tracking issuances across many holdings — as private equity teams tracking portfolio ownership tend to discover. A dozen shareholders and a handful of transfers a year is exactly what a spreadsheet is good at.

No history, shared risk

The workbook holds raw records only, with no version history. An overwritten transfer erases its own past, and nothing flags the gap before it becomes one. There’s no permission model either — anyone with the file can edit any shareholder’s position.

A shared link makes that risk worse, not better. Everyone with edit access can change any row, including one they shouldn’t touch. Nothing warns a reader that the version they’re looking at might already be stale.

From workbook to software

This template’s column headers match Lextree’s import templates, so it loads directly into equity ownership software — no re-keying, no remapping. Access control, an immutable transaction history, and ownership keyed to the entities that already hold each other’s shares move with it.

A stock ledger that’s outgrown Excel usually shows the strain first at a financing or a transfer with outside counsel involved. Software doesn’t replace the discipline the workbook taught — it just keeps the discipline from depending on one person remembering to add a row.

Frequently asked questions

What is a stock ledger template? A stock ledger template is a single Excel workbook that records who owns a company’s shares and logs every issuance and transfer between shareholders — an ownership snapshot plus an append-only transaction history in one file. It functions as a shareholder ledger template for a company of any size.

What should a stock ledger include? A stock ledger should include current ownership — owner, holding, ownership percent, voting percent, units, cost basis — plus a full transaction history recording every issuance and transfer, with seller, buyer, transaction type, and equity class on each row.

Is this a cap table? No. A cap table models valuations, option pools, and dilution scenarios. This stock ledger records who owns shares today and every transfer that got them there — nothing more.

Does it track valuations or vesting schedules? No. There are no valuations, vesting schedules, or 409A calculations. Price per unit and total consideration are recorded for actual transactions only, not projected value.

How do I log a share issuance or transfer? Add a row to Equity Transactions with the holding, transaction date, transaction type, equity class, and units — and for a transfer, both seller and buyer. Never overwrite a prior row; each change gets its own — logging every transfer this way is what a corporate stock transfer ledger does.

Does my corporation need a stock ledger? Yes. Corporation law expects a company to keep an internal record of who owns its shares and how ownership has changed. A stock ledger is that record, kept current as shares are issued or transferred.

Does it track stock certificate numbers? It records the parties, date, share class, units, price, and consideration for each transaction — not certificate numbers. If your corporation issues certificates, add a column for the number.

Does it record shareholder addresses? The workbook keys each position to the owner and holding, not a mailing address. Add an address column to Equity Ownership if your share records need one.

Can I use it as a shareholder register for a small company? Yes. Equity Ownership works as a shareholder register for a small company with one or a few share classes, and Equity Transactions keeps the issuance and transfer history behind it.

Does it handle multiple share classes? Yes. Equity class covers Common, Preferred A, Preferred B, Preferred C, Units, Partnership Interest, Membership Interest, and Other, so a multi-class structure fits in the same two sheets.

Is it free, and does it work in Google Sheets? Yes. Enter your email below and the workbook is sent to your inbox — no credit card, no sales call. It opens in Google Sheets as well as Excel, dropdowns included.