Holding changes: separate cash trades from noncash events
A change in shares held does not necessarily represent a cash purchase or sale. In-kind transfers, stock distributions and corporate actions can change a position without an external cash flow. Build separate quantity and cash bridges before using account changes to explain investment behavior or exposure.
Use the statement’s activity records
Investor.gov’s brokerage-statement guide distinguishes holdings, account activity and cash-related information. The actual custodian statement and transaction confirmations provide the account-specific evidence. This article offers a manual reconciliation worksheet; it does not claim any software automatically classifies every event correctly.
Choose a clear account perimeter. Moving securities between two accounts is an inflow to one account and an outflow from the other, but can be internal to a combined household portfolio. Record both the local account view and the combined view instead of choosing whichever makes performance look stronger.
Hypothetical two-bridge example
Assume an account opens with 100 shares. It buys 20, sells 10, receives 30 shares from another account and receives a stock distribution of five. Ending quantity is 145. Only the purchase and sale necessarily correspond to trade cash in this simplified case.
| Quantity worksheet | Shares | Event classification |
|---|---|---|
| Opening holding | 100 | Starting balance |
| Purchase | +20 | Cash trade |
| Sale | −10 | Cash trade |
| In-kind transfer | +30 | Security movement |
| Stock distribution | +5 | Corporate action |
| Ending holding | 145 | Reconcile quantity |
Now assume opening cash is 1,000, an external deposit is 200, the purchase costs 400, sale proceeds are 220, cash dividends are 30 and fees are 10. Ending cash is 1,040. The incoming 30 shares should not also appear as a cash deposit unless cash actually moved.
The bridges answer different questions: quantity explains ownership units; cash explains receipts and payments. Valuing the in-kind transfer may be necessary for a portfolio-flow analysis, but its valuation is a separately labeled noncash flow, not bank cash.
Match events before investigating residuals
Record security identifier, trade date, settlement date, event type, quantity, cash and source reference. A trade can affect the trade-date holding before settlement cash appears. Do not classify the temporary difference as missing money without aligning the accounting basis used in each statement section.
Transfers can also arrive with historical cost information later than the shares. That delay affects cost-basis completeness, not necessarily ownership. Keep a cost-status field rather than replacing missing historical cost with current market value and presenting it as purchase cost.
Keep corporate actions distinct
A split, spinoff or merger can replace one security with another. Connect the event records so a removed symbol is not automatically described as a discretionary sale. Cash in lieu of fractional shares and processing fees may accompany an otherwise noncash event; separate those cash components.
If the final quantity or cash does not reconcile, leave an explicit unresolved line and investigate confirmations or custodian explanations. Do not invent an adjustment transaction simply to make the worksheet balance. A reconciled total proves arithmetic completeness under the selected records, not that every source record is correct.
For the next review, compare the event classification with the actual account perimeter and retain the original raw entries. The useful output is a quantity bridge, a cash bridge and a list of unmatched events. This workflow explains holdings records and does not calculate tax liabilities, predict returns or instruct trade execution.
FAQ
Is an incoming share transfer new cash invested?
Not inside the receiving account’s cash ledger. It can be a separately valued portfolio inflow, depending on the analysis perimeter.
Can a balancing adjustment close an unexplained gap?
Only if supported by a real event and evidence. Otherwise retain the residual as unresolved rather than fabricating activity.