1099-CAP Shareholder Data Preparation Workbook

Obtain the stock ledger or transfer-agent extract supporting the relevant exchange. Record its effective date, extraction date and version. A current capitalization table can differ from the transaction-date shareholder population because of later transfers or administrative changes.

Keep security class, account reference, shares and holder identity on every source row. Do not merge common and preferred positions merely because they have the same mailing address. Preserve subclasses or series where they distinguish the interests exchanged.

Compare the source population with the closing share schedule. Identify missing accounts, cancelled positions and unmatched share classes before enriching the register with tax-recipient information. A balanced ownership total makes the later allocation review easier to trace.

The IRS CAP instructions contain shareholder exceptions and specific clearing-organization rules. A ledger holder, beneficial owner, broker and reporting recipient are not automatically interchangeable. Keep their roles explicit and ask the advisers to resolve the applicable reporting treatment.

Record proposed recipient identity with a source reference, plus a separate reviewed disposition such as included, exception supported or unresolved. These are workbook labels, not IRS filing statuses. Attach the basis for an exception rather than treating a blank recipient field as an approved exclusion.

For intermediary holdings, preserve the original account and related ownership support. Do not create both intermediary and underlying-owner forms from the same shares without a reviewed explanation of the reporting population.

IRS Publication 1099 provides the general recipient-data framework. Keep sensitive identifiers in the protected preparation system; use internal row references in broadly shared review notes.

Fictional 2026 example. Assume advisers have established the relevant reporting scope for a larger qualifying transaction. A small extract of its shareholder register contains four common-share accounts. Documented review establishes that two accounts belong to the same recipient and may be combined for this example.

The source total is 600 shares: 100 + 200 + 120 + 180. The proposed recipient rows retain 100, 200 and 300 shares, also totaling 600. Three proposed recipients do not mean one source account disappeared.

The workbook keeps the C and D links underneath R3. If their tax documentation actually identified different owners, the team would leave them separate and investigate. Similar names or addresses alone would not justify the combination.

Compare legal identity, source account, share class and supporting documentation before marking a duplicate. Distinguish an identical repeated export row from two valid holdings of one recipient. Removing a true holding can make both share quantities and consideration allocations incomplete.

For every excluded or unresolved row, retain the shares and the reason in a reconciliation category. The ownership population should bridge to included, documented exception and unresolved groups. Do not drop exception rows before they contribute to that completeness check.

Ask the responsible reviewer to resolve conflicting tax documentation or intermediary roles. Record the conclusion and source date. If ownership evidence changes later, update the mapping through a visible revision so the consideration workbook can be refreshed consistently.

Retain a cross-reference when the transfer agent changes an account identifier during the project. An identifier change can otherwise look like a new shareholder and duplicate the same holding. Compare the effective dates and documented share movement before deciding whether the old and new account rows describe one position or two.

Save a versioned population with the source extracts, mappings and exception support. Record the totals by share class and the number of proposed reporting records. These are different controls: share quantities measure the ownership bridge, while record counts describe the preparation output.

The CAP instructions require an account number when multiple accounts for a recipient produce more than one CAP and encourage account references generally. Preserve those identifiers in the preparation design so later corrections can locate the right record.

Pass the reviewed population to the consideration and filing teams with unresolved items clearly identified. The workbook should allow them to trace every proposed recipient back to the original holdings and understand why any source account was combined, excluded or left pending.