Multi-Account Tracking & Data Quality
Reconciliation
Definition
The process of checking that transactions balances cash and holdings agree across your records and actual accounts.
Reconciliation is the control layer that validates whether portfolio data is complete, internally consistent, and aligned with source-of-truth account records.
Why it matters
Without reconciliation elegant dashboards can still be wrong in ways that matter.
What most investors miss
The gap between what the term means and how it is usually applied.
They assume the broker statement is correct. Errors in dividend recording transaction classification and FX conversion all occur and go unnoticed without reconciliation.
How to read it
Check the portfolio record against the broker statement at least quarterly. Differences are more common than most investors expect.
Multi-account lens
How this term reads differently across brokers and accounts.
Reconciliation is most critical and most complex in multi-account portfolios. Each broker must be reconciled independently before the consolidated view can be trusted.
Concrete example
What this looks like with real numbers.
Scenario
A portfolio shows £187,400 in the tracking app. Broker statements total £188,060. The £660 gap traces to a dividend posted by the broker on T+2, recorded in the tracker on T+4 with a stale EUR/GBP rate from the previous week.
What it reveals
Reconciliation is not about being exact to the penny — it is about understanding what every gap means before it erodes trust in the whole picture.
Related terms
Terms that connect to reconciliation.
Transaction History
A complete record of every buy sell dividend reinvestment and cash movement in the portfolio over time.
Missing Dividends
Dividend income that was paid by a holding but was not recorded in the portfolio tracking system.
Spreadsheet Tracking
The use of a manually maintained spreadsheet to consolidate and track portfolio data from multiple sources.
Continue only if the next question is clearer now
Diagnosis first, then workflow, then fit.
Follow Upogee on X
Product updates, portfolio review ideas, and building notes.