A portfolio tracker is only useful when its numbers agree with the broker record. Reconciliation is the check that proves they do.
The fastest way to reconcile a portfolio tracker is to work in this order:
- Compare positions and share counts.
- Compare cash balances separately from holdings.
- Review recent transactions that changed shares, cash, or cost basis.
- Check dividends, DRIPs, splits, fees, transfers, and corporate actions.
- Fix the source transaction instead of forcing the final total to match.
Do not start by chasing the total account value. Start with the pieces that create it. A $600 account-value gap can come from one missing dividend reinvestment, one unsettled trade, one stale price, one ignored fee, or one split that was never applied.
What Reconciliation Means
Reconciling your tracker with your broker statement means confirming that both records describe the same portfolio activity. The screens do not need to look identical, but the economic facts should line up:
- Same open positions
- Same share quantities, including fractional shares
- Same cash movements
- Same buys, sells, transfers, dividends, fees, and corporate actions
- Cost basis and realized gain calculations that are explainable, even if not always identical
The broker statement is the outside record. The tracker is your working view. Reconciliation is how you keep the working view honest.
Worked Example
Here is a realistic five-position reconciliation using AAPL, MSFT, VTI, VXUS, and BND. The broker statement shows a total account value of $187,422. The tracker shows $186,798. The gap is $624.
Three positions match immediately:
- MSFT: 80 shares in both systems, matching cost basis and market value.
- VXUS: 250 shares in both systems, matching cost basis and market value.
- BND: 180 shares in both systems, matching cost basis and market value.
Two positions need investigation:
- AAPL: the broker shows 100 shares. The tracker shows 98 shares. The transaction history shows an old 14-share lot that was adjusted by a 7-for-1 split, creating 98 shares. That explains most of the position, but not the broker’s extra 2 shares. The missing item is not the split itself; it is a later dividend reinvestment that bought 2 fractional or whole shares depending on the broker’s DRIP settings. Fix: add the missing DRIP transaction rather than editing the current share count by hand.
- VTI: both systems show 320 shares, but cost basis differs by $0.07 per share. That creates a $22.40 aggregate basis difference. Share count is not the problem. The likely issue is fee handling: the broker included a commission or transaction fee in basis, while the tracker recorded it separately or omitted it. Fix: make fee treatment consistent with how you want cost basis and realized gains reported.
After adding the missing DRIP and handling the VTI fee consistently, the gap falls to a small amount that can be explained by price timing or settlement timing. The useful lesson is the pattern: share-count gaps usually point to missing trades, DRIPs, transfers, or corporate actions; cost-basis gaps with matching shares usually point to prices, fees, dates, or tax-lot logic.
Start With Holdings
Current holdings are the quickest way to find the break. Compare the broker statement and tracker line by line:
- Does every symbol appear in both places?
- Do share counts match exactly, including decimals?
- Are closed positions still showing as open?
- Are transferred positions duplicated in one account and missing in another?
- Are ticker changes or share-class conversions mapped correctly?
If holdings do not match, pause there. Performance, allocation, and cost basis reports are downstream of the position record.
Then Reconcile Cash
Cash deserves its own check. Many investors skip it because the positions look right, but cash mismatches often explain why account totals do not match.
Common cash differences include:
- Unsettled buys or sells
- Pending dividends
- Recently posted interest
- Withdrawals, deposits, or transfers that were not imported
- Fees recorded by the broker but missing from the tracker
- Foreign-currency cash balances converted at different rates
Cash does not always need to match to the penny on the same day if trades are still settling. It should become explainable once you separate settled cash, unsettled activity, and pending income.
Use The Transaction Trail
If a position or cash balance is wrong, the cause is usually in the recent transaction history. Review the activity that can change the record:
- Buys and sells
- Dividend payments
- Dividend reinvestments
- Stock splits and reverse splits
- Return of capital
- Fees and commissions
- Transfers between accounts
- Currency conversions
This is why transaction-level tracking matters. A holdings-only tracker can show that a number is wrong. A transaction-aware tracker gives you somewhere to look for the cause.
Common Mismatch Patterns
| Mismatch | Likely cause | What to check |
|---|---|---|
| Share count is wrong | Missing buy, sell, DRIP, transfer, split, or fractional share | Recent trades, corporate actions, reinvestment activity, account transfers |
| Shares match but cost basis differs | Fees, tax lots, reinvested dividends, return of capital, imported price errors | Purchase lots, fee treatment, basis adjustments, lot-selection method |
| Market value differs | Price timing, stale quote, currency conversion, unsettled trade | Quote timestamp, broker pricing date, FX rate, settlement status |
| Cash differs | Pending dividend, unsettled trade, transfer, interest, fee, currency cash | Cash ledger, settlement dates, income activity, deposits and withdrawals |
| Realized gain differs | Different tax-lot method or missing basis adjustment | Specific lots sold, FIFO versus specific identification, fees, return of capital |
Check Imported Data
A successful import only means the file was accepted. It does not mean the imported portfolio is accurate.
After a CSV import, check:
- Symbol mapping, especially for funds, ADRs, and old tickers
- Dates, because trade date and settlement date can differ
- Quantities, especially fractional shares
- Transaction types, especially dividends versus reinvested dividends
- Fees, because some broker exports include them as separate rows
- Cash rows, which are easy to drop during spreadsheet cleanup
If you use Portfolio Tracker, the relevant fit is specific: it supports CSV import and editable transaction records, so you can import the broker file, compare the result, and correct the transaction that caused the mismatch. That is more useful than a dashboard that only lets you overwrite the final holding.
Do Not Force The Total
When the broker total and tracker total disagree, it is tempting to make a single adjustment so the number matches. That usually creates a worse record.
Work backward instead:
- If shares are wrong, find the missing or duplicated share-changing event.
- If cash is wrong, separate settled cash from pending activity.
- If basis is wrong, inspect lots, fees, reinvestments, and return of capital.
- If market value is wrong, compare price timestamps and currency rates.
- If realized gains are wrong, review the lot-selection method used on sales.
The goal is not cosmetic agreement. The goal is a tracker whose numbers can be traced back to real activity.
When To Reconcile
You do not need to reconcile after every market move. Market prices change constantly; reconciliation is about holdings, cash, and transaction records.
A practical schedule is:
- After the first import from a broker file
- After a cluster of trades
- After dividends, DRIPs, splits, mergers, or return-of-capital events
- After moving assets between accounts
- Monthly for active portfolios
- Quarterly for lower-activity portfolios
The more often the portfolio changes, the more often the tracker needs to be checked against the broker.
FAQ
Does cash need to match exactly?
Eventually, yes, but not always on the same day. Unsettled trades, pending dividends, interest, fees, and foreign-currency balances can create temporary differences. Reconcile settled cash separately from pending activity.
Why does cost basis differ when share counts match?
The most common causes are fees, reinvested dividends, return of capital, tax-lot selection, transferred basis, or imported purchase prices. Matching share count only proves the quantity is right. It does not prove the basis is right.
How should I handle unsettled trades?
Keep the trade in the transaction history, but compare it to the broker using the same date convention. Some views use trade date; others use settlement date. A mismatch may disappear once both systems are viewed on the same basis.
What if the broker and tracker use different prices?
Check the quote timestamp and currency conversion rate before changing transactions. If quantities and cash are correct, a market-value gap may simply be a pricing-date issue.
Should transfers between accounts create gains?
Usually no. A transfer should move the position and its basis; it should not look like a sale unless assets were actually sold. If a transfer creates realized gain in the tracker, review how the import classified the event.
Bottom Line
Reconciliation is not paperwork for its own sake. It is how you keep your portfolio record usable after imports, trades, dividends, splits, transfers, and fees start adding complexity.
Start with holdings. Reconcile cash. Use the transaction trail. Fix the event that caused the mismatch. If you follow that order, most discrepancies become much easier to explain and much less likely to return.