Investment Tracker Excel Template: Multi-Broker Tracking Guide

If you have accounts at multiple brokers (Fidelity, Schwab, Interactive Brokers, Coinbase, etc.), consolidating them in one Excel tracker gives you unified visibility. Instead of logging into three accounts to check your overall performance, you see everything in one place.

This guide walks through building a multi-broker investment tracker that consolidates holdings and calculates your total portfolio performance.

The Challenge: Multiple Brokers, One Portfolio

Most investors have accounts spread across different platforms:

Fidelity for stocks and mutual funds
Schwab or Interactive Brokers for options trading
Coinbase or Kraken for crypto
Betterment or M1 Finance for automated investing

Without consolidation, you:

Have to log into 3+ accounts to see your total balance
Can't calculate true asset allocation across all accounts
Miss concentration risks (that stock might be in two accounts!)
Struggle with tax reporting and rebalancing

Building Your Multi-Broker Investment Tracker

Step 1: Create Separate Sheets for Each Broker

Start with one Excel file with multiple sheets:

Sheet 1: Fidelity Holdings (columns: Ticker, Shares, Entry Price, Current Price, etc.)
Sheet 2: Schwab Holdings (same column structure)
Sheet 3: Crypto Holdings (Ticker, Amount, Entry Price, Current Price)
Sheet 4: Consolidated Summary (pulls totals from all sheets)

Keeping each broker separate makes updating easier and helps track which account is which.

Step 2: Use Consistent Column Structure

Every broker sheet should have the same columns so your consolidation formulas work:

        Broker | Ticker | Holding Name | Shares | Entry Price | Entry Date |
        Current Price | Total Value | Gain/Loss | % Return | Date Updated
      

The "Broker" column (Fidelity, Schwab, Crypto) helps you identify which account each holding is in when troubleshooting.

Step 3: Build the Consolidated Summary Sheet

This sheet pulls data from all broker sheets and calculates totals:

        Total Portfolio Value: =SUM(Fidelity!G:G, Schwab!G:G, Crypto!G:G) Total
        Cost Basis: =SUM(Fidelity!H:H, Schwab!H:H, Crypto!H:H) Total Gain/Loss:
        =Total Portfolio Value - Total Cost Basis Overall Return %: =(Total
        Gain/Loss / Total Cost Basis) * 100
      

Now you have one number for your entire portfolio performance, across all brokers.

Step 4: Calculate Allocation by Broker

See how much of your portfolio is at each broker:

        Fidelity % of Total: =SUM(Fidelity!G:G) / Total Portfolio Value * 100
        Schwab % of Total: =SUM(Schwab!G:G) / Total Portfolio Value * 100 Crypto
        % of Total: =SUM(Crypto!G:G) / Total Portfolio Value * 100
      

This shows if you're over-concentrated at one broker (which affects liquidity and risk).

Step 5: Identify Duplicate Holdings

You might own Apple stock at both Fidelity and Schwab without realizing it. Use a pivot table or manual review to spot this:

List all unique tickers across all sheets
Sum their total values
Check if any exceed your intended allocation

⚠️ Important: Finding duplicates can reveal concentration risk. If AAPL is 8% at Fidelity and 7% at Schwab, you're actually 15% concentrated in Apple—much riskier than intended.

Adding Account-Level Performance Tracking

Individual Account Returns

Calculate return % for each account separately to see which is performing best:

        Fidelity Return %: =(SUM(Fidelity!G:G) - SUM(Fidelity!H:H)) /
        SUM(Fidelity!H:H) * 100 Schwab Return %: =(SUM(Schwab!G:G) -
        SUM(Schwab!H:H)) / SUM(Schwab!H:H) * 100
      

Account Fee Tracking

Different brokers charge different fees. Add a "Fees" column to each sheet:

        Total Fidelity Fees: =SUM(Fidelity!Fees:Fees) Total Schwab Fees:
        =SUM(Schwab!Fees:Fees) Total Fees Paid: =SUM(Total Fidelity Fees, Total
        Schwab Fees) Impact on Returns: =(Total Fees Paid / Total Cost Basis) *
        100
      

Know exactly how much you're paying across all brokers.

Data Update Strategy for Multi-Broker Tracking

Keeping data fresh across multiple accounts is harder than a single-broker tracker. Here's a sustainable approach:

Weekly Update (30 minutes total):

Log into Fidelity, export holdings as CSV
Paste current prices into your Fidelity sheet
Repeat for Schwab, Coinbase
Consolidated summary auto-updates

Monthly Deep Review (1 hour):

Check for new holdings or sales (not yet in your tracker)
Verify no duplicate positions
Review allocation drift (are you still 60/40?)
Note any large gains or losses in your tracker notes

Advanced Multi-Broker Features

Account Linking Summary

Create a reference sheet showing which account is for what purpose:

        Fidelity | Tax-deductible 401k | $450k | Stocks & Funds | Monthly
        auto-contribution Schwab | Individual brokerage | $180k | Options & day
        trading | Manual trades Crypto | Retirement diversification | $40k |
        Bitcoin & Ethereum | Long-term hold
      

Tax Lot Tracking

For proper tax reporting, track cost basis by lot (date purchased). Some brokers support this, but you can also track manually:

        Ticker: AAPL (Schwab) | Lot 1: 50 shares @$150 (Jan 2020) | Lot 2: 30
        shares @$180 (Aug 2023)
      

This matters for wash sales and long-term vs. short-term capital gains.

When Multi-Broker Excel Tracking Breaks Down

Your multi-broker Excel tracker works until:

You have > 50 holdings across 4+ brokers (updating becomes 2+ hours/month)
You need real-time consolidation (Excel is stale data)
Tax reporting requires detailed lot tracking
You want correlation analysis between accounts
You need mobile access to all accounts in one place

At this point, a dedicated multi-broker tracker automates the consolidation and gives you real-time insights. Evaluate your options in our Excel vs automated tools comparison.

Next Steps

Create one Excel file with sheets for each broker
Enter your current holdings from each account
Build the consolidated summary sheet
Set a weekly update routine (every Friday)
Review quarterly for rebalancing opportunities

Investment Tracker Excel