Back to Cookbook

Unified Portfolio Ledger

One source of truth when your brokers disagree

Consolidates holdings, cash flows, dividends, and performance across brokers into a single ledger with clear assumptions and reconciled totals.

CommunitySubmitted by CommunityPersonal10 min

INGREDIENTS

📄Google Docs✉️Email

PROMPT

Create a skill called "Unified Portfolio Ledger". Help me consolidate portfolio data across one or more brokers into a single, repeatable ledger that tracks: - holdings, - cash flows, - dividends, - and performance. Give me a normalization checklist, reconciliation workflow, and update routine.

How It Works

This recipe is for people forced into spreadsheets because broker dashboards

do not tell a trustworthy performance story.

Triggers

  • Multiple brokerages with conflicting numbers
  • Dividend tracking gaps
  • Inconsistent performance reporting
  • Need for a clean ledger of cash flows and holdings

Inputs

  • Account exports
  • Holdings snapshots
  • Dividend history
  • Cash contributions and withdrawals

Outputs

  • Unified ledger
  • Reconciliation checklist
  • Performance view
  • Allocation summary

Steps / Actions

  1. Import all broker exports.
  2. Normalize columns and dates.
  3. Separate market returns from cash flows.
  4. Reconcile positions and dividends.
  5. Produce a repeatable update workflow.

Failure Modes

  • Missing exports or incomplete history
  • Different cost basis methods across brokers
Tags:#portfolio-tracking#reconciliation#ledger#performance