Track Portfolio Across Brokerages Free: What Actually Works

Why the accounts multiply

A four-account stack usually looks like this: a 401(k) from a job you left, the rollover IRA that came out of it, a taxable account at the firm your spouse already used, and an app you opened for fractional shares. Each one was opened for a different reason, in a different year, and none of them closed when the next one opened.

Direct ownership of stocks rose from 15% of U.S. families in 2019 to 21% in 2022, and 54.3% of families held a retirement account, according to the Federal Reserve's Survey of Consumer Finances (published October 2023). That six-point rise in direct stock ownership happened across three years.

What actually breaks across accounts

Your statement already does part of the job. The SEC describes the allocation section as the one that shows "the account by investment type, providing the percentage held in cash, equities (stock), fixed income (bonds), mutual funds, and other types of securities" (Investor.gov, Understanding Your Brokerage Account Statement). Note the wording: the account. Four statements give you four allocation breakdowns and no portfolio-level one, since percentages with different denominators don't add.

Three specific things go wrong.

• Blended allocation. Two accounts reading fully invested and one sitting in cash tell you nothing about your real mix until you know the dollar weights.
• Duplicate holdings. The same index fund bought at two firms looks like diversification on two screens and like concentration on one.
• Cost basis. Basis is tracked per account, per lot. Neither broker knows about the other's lot, so neither statement can show your real average price.

Illustrative example, with hypothetical holdings: you own a large-cap index fund in a taxable account at one broker and the same fund in a rollover IRA at another, plus four individual stocks in an app account. Every statement looks diversified on its own. Rolled into one sheet, the two funds overlap almost completely and the four stocks sit in one sector. To see what that sector actually weighs, you convert each position to dollars and divide by the total across all three accounts, because each statement's percentages use only that account's balance as the denominator.

The free workflow, step by step

The whole thing is one spreadsheet and a date you actually keep.

1. Pull every account as of the same day. Month-end is the obvious choice, since that's when brokers close statement periods. Mixing a March 31 balance with a February 28 one produces a total that was never true.
2. One row per lot, not per account. Columns: symbol, shares, account, account type (taxable, IRA, 401k), cost basis, purchase date. Lot level is what keeps the basis math honest later.
3. Sum by symbol first, then by asset type. Use the SEC's own buckets: cash, equities, fixed income, mutual funds, other. Now the percentages finally share one denominator.
4. Reconcile against trade confirmations. Per the SEC guidance above, this is per account, so do it with the statement already open.
5. Repeat on a fixed date. Monthly is plenty; quarterly works if you aren't adding money often.

A monthly cadence means twelve updates a year, and each one repeats steps one through four for every account you hold. Investors considering this route often schedule the update for the first weekend after month-end, once the statements have posted, and keep last month's tab in the same file so the prior numbers are there to compare against.

Spreadsheet or linked accounts

Check the supported-institution list before building a routine around linking, since an unsupported broker is the one constraint you can't work around.

Link your brokerage to MarketPlays to track your real holdings in one place. If you'd rather look around first, Explore shows trending symbols and recent insights, and Browse tags shows which themes symbols get grouped under.

Key takeaways

• Account sprawl is now ordinary: 21% of U.S. families directly owned stock in 2022, up from 15% in 2019, and 54.3% held a retirement account (Federal Reserve Survey of Consumer Finances, October 2023).
• Convert every position to dollars and divide by the combined total across accounts. Per-account allocation percentages each use a different denominator, so they can't be added together.
• Cost basis is tracked per account and per lot, so a combined sheet needs one row per lot rather than one row per position.
• A free sheet works if it has one row per lot and a fixed update date.
• The SEC's statement-versus-confirmation check is per account, so the review burden scales with how many brokers you hold.

FAQ