How to Track Dividends Across Multiple Brokerage Accounts
Your dividend income is scattered across Schwab, Vanguard, Fidelity, and your 401k. Here's how to see the complete picture in one place — from free spreadsheet methods to automatic tracking.
Why Tracking Dividends Across Accounts Is So Difficult
Each brokerage was built assuming you'd do everything with them. They don't talk to each other, and they have no incentive to show you the bigger picture.
Incomplete Income Visibility
You might know you received dividends last month, but do you know the exact total across all accounts? Most investors are guessing.
Diversification Blind Spots
Your Schwab account looks diversified. So does your Vanguard. Combined, you might be 45% concentrated in one sector without realizing it.
Tax Season Friction
Come April, you're logging into four different platforms to gather 1099-DIV forms and reconcile numbers. Having your dividend data consolidated in one place makes it easier to cross-check.
Progress Tracking Gaps
Building toward financial independence? Knowing your total dividend income growth over time is essential. Fragmented data makes this nearly impossible.
Research consistently shows that most US investors hold accounts at multiple financial institutions. Employer 401ks, Roth IRAs, inherited accounts, spousal accounts — your dividend income ends up in silos. The more accounts you have, the harder it gets to see the full picture.
Four Methods for Tracking Dividends Across Accounts
There's no single best approach. The right method depends on your portfolio complexity, time, and budget.
Method 1: Manual Spreadsheet
Free — best for small, simple portfoliosCreate a spreadsheet and manually enter dividend payments from each brokerage. Include columns for date, ticker, amount, account, and running totals by month and year. Google Sheets works well since it's cloud-based and free.
Pros
- Free to use
- Full customization
- No third-party access
Cons
- Time-consuming to maintain
- Easy to miss payments
- Doesn't scale with portfolio growth
Works well until around 20 holdings across 1–2 accounts. Beyond that, maintenance becomes a burden and errors creep in.
Method 2: Brokerage Consolidation
Free — eliminates the problem at the sourceTransfer all investment accounts to a single institution via ACATS (Automated Customer Account Transfer Service). Schwab, Fidelity, and Vanguard all offer this, often covering transfer fees as incentives.
Pros
- Single login for everything
- One 1099 at tax time
- No ongoing effort
Cons
- Can't transfer employer 401k
- Takes 1–3 weeks
- May trigger taxable events if not transferred in-kind
Most dividend investors can't fully consolidate. Current employer 401ks are stuck at the designated provider, and spousal accounts add more fragmentation.
Method 3: General Portfolio Aggregators
Free — good for net worth, limited for dividendsApps like Empower (formerly Personal Capital) pull data from multiple brokerages into a single dashboard. They show your combined portfolio and net worth, with some dividend visibility.
Pros
- Free for basic features
- Automatic syncing
- Works with many brokerages
Cons
- Dividends are a secondary feature
- No yield on cost or income projections
- Often pushes wealth management upsells
These tools were designed for portfolio tracking, not dividend income tracking. They'll show you own JNJ across three accounts, but asking "What's my projected annual income?" often returns a blank stare.
Method 4: Dedicated Dividend Tracker
From $5.99/mo — built for income investorsThis is what MerryDiv does. Connect your brokerage accounts through Plaid and automatically track every dividend payment. Analytics focus on what income investors actually care about: yield on cost, income trends, projections, and diversification.
Pros
- Built specifically for dividend investors
- Automatic tracking, zero manual work
- Income-centric metrics and projections
- Mobile app for on-the-go tracking
Cons
- Monthly subscription cost
- Requires comfort with account linking
Best for dividend investors with 2+ accounts who want complete income visibility without the manual work. MerryDiv starts with a free plan — see pricing.
Side-by-Side Comparison
How the four tracking methods stack up across the factors that matter most.
| Spreadsheet | Consolidation | Aggregator | Dividend Tracker | |
|---|---|---|---|---|
| Cost | Free | Free | Free | From $5.99/mo |
| Setup Time | 1–2 hours | 1–3 weeks | 15–30 min | 5–10 min |
| Ongoing Work | 1–2 hrs/month | None | Minimal | None |
| Accuracy | Low–Medium | High | Medium | High |
| Dividend Focus | ||||
| Multi-Account | ||||
| Auto Sync | ||||
| Mobile App | ||||
| Best For | Small portfolios (<20 holdings, 1–2 accounts) | Investors who can move all accounts to one brokerage | Net worth tracking with some dividend visibility | Dividend investors with 2+ accounts |
How to Choose the Right Tracking Method
Your ideal approach depends on portfolio complexity, time, and what you're optimizing for.
Simple Portfolio (1–2 accounts, <20 holdings)
A spreadsheet may be all you need. The overhead is manageable and you maintain full control.
Moderate Portfolio (2–4 accounts, 20–50 holdings)
An aggregator gives basic visibility, but a dedicated tracker starts to pay for itself in time saved and dividend-specific insights.
Complex Portfolio (4+ accounts, 50+ holdings)
Automatic dividend tracking is the clear winner. Manual methods break down at this scale, and general aggregators lack the depth you need.
The cost-benefit reality
MerryDiv's plans start at $5.99/month. If you earn $500/month in dividends and spend two hours monthly maintaining a spreadsheet, you're effectively paying yourself less than $3/hour for data entry. The tracking tool pays for itself in time savings alone — before considering the value of better analytics and catching missed payments.
Step-by-Step Setup Guides
Setting Up a Spreadsheet Tracker
Setting Up Brokerage Consolidation
Setting Up a Dividend Tracking App
About security
MerryDiv uses Plaid for read-only account connections — the same service trusted by Venmo, Robinhood, and major banks. Your brokerage credentials are handled by Plaid and never stored by MerryDiv. All connections use encrypted channels. Learn more about our security practices.
See All Your Accounts in One Dashboard
MerryDiv connects to your brokerages through Plaid and shows your combined dividend income, holdings, and growth across every account.
Start Tracking Dividends — FreeSecure, read-only access — your credentials are never stored
5 Common Mistakes When Tracking Dividends Across Accounts
1. Forgetting retirement account dividends
Your 401k and IRA dividends are real income, even if you can't spend them yet. Many investors unconsciously exclude these from their passive income calculations, creating an incomplete picture of growth.
2. Not tracking DRIP reinvestments
If you reinvest dividends automatically, those payments still happened — they just converted to additional shares. Failing to track DRIP understates your actual income and makes tax prep harder.
3. Ignoring foreign withholding taxes
International dividends often have taxes withheld at the source. Your $100 foreign dividend might arrive as $85 after withholding (rates vary by country, commonly 10-30%). Tracking only what hits your account understates earnings.
4. Inconsistent manual tracking schedule
The spreadsheet that works 'when I remember to update it' quickly becomes useless. Three months of forgotten entries is worse than no tracking at all.
5. Using the wrong tool for your situation
A sophisticated platform is overkill for five holdings in one account. A spreadsheet becomes a burden for 50 holdings across five accounts.
What to Track Beyond Basic Dividend Payments
Basic tracking answers "how much did I receive?" Better tracking answers "how is my income strategy performing?"
Income Growth Over Time
Are your dividends increasing year over year? Track quarterly and annual totals to see your income trajectory. This matters more than portfolio value for income investors.
Yield on Cost
Your current yield shows what new money earns. Yield on cost shows what your original investment earns. For long-held positions, YOC reveals the true power of dividend growth.
Sector & Geographic Concentration
Each account looks diversified alone. Combined, you might be 40% in one sector. Multi-account tracking reveals concentration risks that single-account views hide.
Income Projections
Based on current holdings and historical growth, what will your income be in one year? Five years? Essential for FIRE planning and retirement income calculations.
Frequently Asked Questions
Disclaimer: This article is for informational and educational purposes only and does not constitute financial, investment, or tax advice. Dividend payments are not guaranteed and can be reduced or eliminated at any time. Past performance does not guarantee future results. The mention of specific brokerages, financial products, or third-party services does not constitute an endorsement. Always conduct your own research and consult a qualified financial professional before making investment decisions.
One Dashboard for All Your Dividends
Stop logging into three brokerages. Connect them all to MerryDiv.
Start Tracking for Free