Preparing the Cap Table for Audit

In brief: At year-end, auditors want the ownership position as at the balance sheet date, every share and instrument movement in the period, the terms behind each instrument, support for interest accruals, and a reconciliation to the statutory accounts and share register. If the cap table is a dated, transaction-based record, most of that is a single export; if it lives in spreadsheets, it is a fortnight of reconstruction.

What do auditors actually ask for?

Audit requests around capitalisation are remarkably consistent. Expect to be asked for:

Ownership as at the balance sheet date — the full cap table for each company as at year-end, by shareholder and instrument class;
Movements in the period — every issuance, transfer, redemption and conversion between the prior year-end and this one;
Instrument terms — the coupon or interest rate, day-count basis, compounding frequency and any variable-rate history for each preference share and shareholder loan class;
Interest accrual support — a schedule showing how accrued interest was calculated for the period, per investor, so it can be tied to the accounts;
Reconciliation — agreement of the cap table to the statutory share register and to the numbers in the financial statements.

Why year-end is painful in spreadsheets

The difficulty is rarely that the information does not exist — it is that it is scattered. With one workbook per company, reconstructing the exact position as at 31 December means finding the right version of the right file, and trusting that its interest formulas match every other company's. Accrual schedules have to be rebuilt to show the auditor the working, and a single manual roll-up error across the holding structure can leave the cap table failing to reconcile to the accounts. Much of where Excel breaks down shows up precisely at audit.

The evidence auditors want to see

Auditors are testing that the numbers are complete, accurate and supportable. What satisfies them is a clear audit trail: every figure traceable back to an underlying transaction, with a date and an attributable change history, and interest schedules that show the calculation rather than just the result. A position they can reproduce from source is far stronger evidence than a summary they have to take on trust.

A year-end checklist

Item	Ready when…
Cap table as at year-end	Producible for every company as at the exact balance sheet date
Period movements	Every issuance, transfer and redemption in the year is recorded and dated
Instrument terms	Rate, day-count and compounding documented per instrument class
Interest schedule	Per-investor accrual for the period, showing the calculation
Reconciliation	Cap table agrees to the share register and the statutory accounts
Audit trail	Each figure traces to a transaction with a change history

Being audit-ready by design

The firms that find audit season painless are the ones whose cap table is audit-ready all year, not assembled in January. Because CapTab derives every cap table from a dated transaction register and keeps a full audit log, the year-end position — and the interest schedule behind it — is a one-click export as at any date, with the working visible for the auditor. For definitions of the terms auditors and LPs use, see the glossary.