Dividends Inside How To Validate Imported Broker Trades
A checklist for reviewing broker imports before they become part of your portfolio history.
Check The Basics First
Before saving an import, confirm that each row has the expected ticker, date, action, price, and share count. Small format issues can create large errors in portfolio value, cost basis, and dividend entitlement.
Pay close attention to decimal separators, date formats, and whether the broker export includes fees or currency conversions in the displayed price.
Review Sells Against Existing Lots
A sell should not create an impossible negative position unless short positions are intentionally supported. If a sell appears before the matching buy, the file may be incomplete or sorted incorrectly.
For long-term dividend tracking, accurate share counts by date are important because dividend eligibility depends on what was held at the relevant time.
Resolve Unknown Tickers Before Relying On Results
Broker files may use local symbols, ISINs, exchange suffixes, or internal product names. If a ticker cannot be matched confidently, review it before importing.
A clean import is worth the extra minute. It protects dividend totals, portfolio charts, allocation views, and future exports.