A staffed private medical practice needs a reliable ownership record when partners join or leave, interests are transferred, awards are granted, or owners contribute capital. The choice between a spreadsheet and dedicated cap table software depends on how difficult those changes are to document, review, and reconcile—not simply how many providers the practice employs.
Use a controlled spreadsheet when ownership is straightforward and changes are infrequent. Consider dedicated software when transaction history, multiple entities, document references, or access needs become difficult to manage manually. Neither option fixes incomplete agreements or unresolved ownership questions.
A cap table, short for capitalization table, summarizes ownership interests and related instruments. It does not establish legal ownership or replace executed agreements, governing documents, required approvals, or other applicable ownership records. Ask licensed legal and tax advisers to resolve ownership eligibility, document interpretation, and tax treatment before recording an uncertain transaction as final.
What a Practice Ownership Record Should Track
For a practice organized as a corporation, the record may track shares. For an LLC, it may track membership units or another ownership measure established by its governing documents. Do not force every structure into a share-count template.
At minimum, maintain these distinct categories:
- Issued interests: Interests recorded as issued and outstanding based on the applicable executed documents and approvals.
- Outstanding awards: Awards that remain outstanding, with their status and terms referenced separately. Do not automatically treat them as issued ownership; their treatment depends on the instrument.
- Potential dilution: A clearly labeled scenario showing what ownership could look like under specified assumptions about future issuances or exercises.
- Proposed changes: Negotiations, draft grants, and planned contributions that have not become completed ownership transactions.
Record the entity’s legal name, holder, interest class, quantity or ownership measure, effective date, transaction type, supporting document references, and review status. Where rights differ by class, a single percentage may not describe voting or economic rights accurately.
For multi-location practices, distinguish locations from legal entities. A new office does not necessarily create a new ownership table. Conversely, a practice entity and a separately owned real-estate entity should not be combined merely because the same physicians own both.
sbb-itb-17e8ec9
Comparison Matrix: Spreadsheets vs. Dedicated Systems
Evaluate actual workflows rather than assuming every software product has the same capabilities.
| Decision factor | Controlled spreadsheet | Dedicated cap table system: what to verify |
|---|---|---|
| Entity fit | Can be tailored, but the structure and formulas need review | Supports the practice’s entity type, classes, and ownership measures |
| Version control | Requires one official file, restricted editing, and dated approved copies | How competing edits, corrections, and approved versions are handled |
| Transaction history | Needs a separate transaction register; overwriting balances loses context | Whether transaction-level history can be reviewed and exported |
| Document references | Document IDs or links must be maintained manually | Whether entries can reference the correct executed documents and amendments |
| Issued interests and awards | Separate schedules and formulas must be designed | Whether issued interests, awards, and hypothetical dilution remain distinguishable |
| Access | File-sharing and workbook permissions require careful testing | Whether users can see only the entities and information they need |
| Review workflow | Reviewer signoff must be documented separately | Whether the system supports the practice’s review process without implying legal approval |
| Accounting reconciliation | Usually uses a manual bridge to supporting entries and receipts | Whether reports provide enough detail for reconciliation; do not assume an integration exists |
| Portability | Familiar exports, but formulas and links may depend on other files | Whether complete records, history, and document references can be exported |
| Total workload | Includes maintenance, formula checks, and reviewer time | Includes subscription, configuration, migration, training, and ongoing review |
A system is useful only if it represents the practice’s actual documents correctly. An attractive ownership chart is not enough if the underlying transaction history cannot be explained.
When a Spreadsheet Is a Reasonable Choice
A spreadsheet can work well for a practice with stable ownership, a limited number of interest classes, and infrequent transactions. It also needs an accountable administrator and a reviewer who understands the supporting records.
Build the workbook around separate schedules:
- Entity and holder register: Identify each entity and holder consistently.
- Transaction register: Record each issuance, transfer, cancellation, or other approved change without erasing earlier activity.
- Issued-interest summary: Calculate current balances from the transaction register.
- Award register: Track outstanding awards and status changes separately.
- Scenario sheet: Model potential dilution without changing the current ownership record.
- Reconciliation log: Record differences, document requests, resolutions, and reviewer signoff.
Protect calculation cells where practical and restrict editing to designated maintainers. Keep an approved snapshot before material changes, and identify the authoritative live file so emailed copies do not become competing records.
A spreadsheet becomes less suitable when maintaining these controls takes more effort than the practice can reliably provide. Repeated formula repairs, missing transaction history, and conflicting ownership reports are reasons to reassess the process—not merely to add another worksheet.
When to Evaluate Dedicated Cap Table Software
Dedicated software deserves consideration when ownership activity creates recurring coordination problems. Examples include partner admissions across several entities, repeated award activity, or frequent requests for different holder-level views.
Before buying, ask the vendor to demonstrate a representative, de-identified workflow:
- Establish an opening balance for one entity.
- Record an approved transfer without changing total issued interests.
- Record a new issuance with its supporting document reference.
- Track an outstanding award separately from issued interests.
- Correct an entry while preserving an understandable history.
- Produce an entity-specific report and a complete export.
Use the demonstration to identify limitations. If the software cannot represent a governing-document provision without a workaround, have the adviser and administrator assess that workaround before purchase.
Also ask what happens when the subscription ends. Confirm how the practice can retrieve records and document references, and whether exported information remains understandable without the platform. These are selection questions, not capabilities to assume.
Illustrative Ownership-Record Reconciliation
The following is an illustrative example, not an ownership recommendation. Assume advisers have confirmed that the entity and instruments are appropriate for this hypothetical practice and have identified the documents supporting each entry.
The practice starts with 1,000 issued shares: 600 held by Partner A and 400 by Partner B. Executed documents support issuing 200 additional shares to Partner C. A separate outstanding award covers 100 shares for a prospective holder, but those shares have not been issued.
Reconcile Issued Interests First
| Issued-interest movement | Shares | Supporting record to check |
|---|---|---|
| Opening issued balance | 1,000 | Previously reconciled ownership register and supporting documents |
| New issuance to Partner C | 200 | Executed issuance documents and applicable approvals |
| Transfers during the period | 0 | Transaction register and transfer documentation, if any |
| Cancellations during the period | 0 | Cancellation or repurchase documentation, if any |
| Closing issued balance | 1,200 | Opening balance plus verified movements |
A transfer between existing holders would change their individual balances but would not, by itself, increase total issued shares. Recording it as a new issuance would overstate the denominator.
Keep Awards and Potential Dilution Separate
| Holder or category | Issued shares now | Current issued ownership | Additional shares assumed in scenario | Illustrative ownership after assumed exercise |
|---|---|---|---|---|
| Partner A | 600 | 50.00% | 0 | 46.15% |
| Partner B | 400 | 33.33% | 0 | 30.77% |
| Partner C | 200 | 16.67% | 0 | 15.38% |
| Outstanding award holder | 0 | 0.00% | 100 | 7.69% |
| Total | 1,200 | 100.00% | 100 | 100.00% |
The scenario assumes all 100 award shares become issued, producing a denominator of 1,300 shares. Percentages are rounded. It excludes other possible future issuances and is not a statement of current ownership or a prediction that the award will be exercised.
Do not label a report “fully diluted” without explaining its denominator and assumptions. Different instruments may require different treatment, which advisers should confirm.
Reconcile the Financial Side Without Inferring Ownership
Suppose, in this same illustrative example, the practice receives $20,000 associated with Partner C’s transaction. The reviewer should trace the receipt to the entity’s bank records and the accounting entry, then confirm its relationship to the executed documents.
A cash contribution does not, by itself, establish a share count or ownership percentage. A receipt could relate to an issuance, an owner loan, or another transaction. Its classification requires supporting documentation and adviser review.
The IRS guidance on business recordkeeping supports maintaining complete business records, separate business accounts, and bank reconciliation. Those accounting controls help substantiate the money movement; they do not determine legal ownership.
A Practical Update and Review Workflow
1. Collect the Source Records
Gather governing documents and amendments, executed transaction agreements, applicable approvals, award documents, and relevant financial support. Assign stable document references so an entry remains traceable if a folder moves.
If documents conflict, record the discrepancy as pending adviser verification. Do not choose whichever version produces the expected percentage.
2. Assign a Maintainer and Reviewer
A practice administrator may maintain the register, while an owner or designated adviser reviews changes. Separate data entry from approval where staffing permits. Define who can authorize an update and who resolves legal or accounting questions.
Provider compensation, administrative payroll, and ownership are different records. A payroll change should not automatically become an ownership change.
3. Reconcile by Entity and Event
After an ownership event, compare opening balances, documented movements, and closing balances. Check holder totals, class totals, outstanding awards, and document references. Reconcile related cash and accounting entries separately.
For multiple entities, perform this process for each legal entity. Do not use a consolidated practice P&L as evidence that ownership percentages match across entities.
4. Release a Clearly Labeled Report
Show the entity, effective date, preparation date, reviewer status, and calculation basis. Separate current issued ownership from scenarios and unresolved items.
Limit access to the information each recipient needs. Ownership reconciliation generally should not require patient-identifiable records; use transaction references and appropriate financial summaries instead.
Choosing and Migrating Without Carrying Errors Forward
Choose a spreadsheet if the practice can maintain one authoritative record with reliable review. Evaluate software if transaction complexity or access requirements make that process difficult to sustain.
Before migration, reconcile the existing records. Importing an unexplained balance merely relocates the problem. Establish a cutoff date, preserve the prior approved record, and compare the new system’s holder balances, entity totals, award statuses, and document references against that baseline.
Lucid Financials provides CPA-led bookkeeping, tax, and CFO services for staffed US private medical practices. Its finance team can support the accounting side of ownership changes, including reconciling related receipts and maintaining entity-level financial visibility. Legal ownership questions and interpretation of governing documents belong with licensed legal advisers.
FAQs
Does cap table software establish who owns the practice?
No. A cap table summarizes ownership information. It does not replace executed agreements, governing documents, applicable approvals, or other required records. Have licensed counsel resolve conflicting documents and ownership eligibility questions.
Can a multi-location practice use one spreadsheet?
Yes, if the workbook clearly separates legal entities and their records. Several locations may belong to one entity, while another practice structure may include multiple entities with different owners. Organize ownership records by legal entity, not simply by office address.
Should outstanding awards appear in current ownership percentages?
Not automatically. Keep awards separately identifiable and have advisers confirm their treatment. If a report models future issuance or exercise, label it as a scenario and state the denominator rather than presenting it as current issued ownership.
How often should ownership records be reconciled?
Update and review records after documented ownership events, and set a periodic review cadence suited to transaction activity. Before using the record for a partner admission, buyout discussion, or adviser review, confirm that relevant transactions and supporting documents are included.
What should the practice test before switching tools?
Test entity fit, transaction history, document references, access restrictions, corrections, exports, and the separation of issued interests from awards and scenarios. Reconcile the migrated opening balances before treating the new system as authoritative.