How to track your dividend income across multiple brokers
Many investors spread their holdings across multiple brokerage accounts. You might have a Roth IRA at Fidelity, a taxable account at Schwab, and a few speculative positions at Robinhood or Webull. Each of these accounts may hold dividend-paying stocks or ETFs, and each broker reports dividend income independently.
When tax season arrives, or when you simply want to understand how much income your portfolio generates, piecing together information from three, four, or five different brokers becomes a real headache. This guide covers how to consolidate your dividend tracking so you can see everything in one place.
Disclaimer: This article is for informational purposes only and does not constitute financial or tax advice. Consult a qualified tax professional before making investment decisions based on tax considerations.
The problem with fragmented dividend tracking
When your dividend income is scattered across multiple brokers, several problems emerge.
Multiple 1099-DIV forms
Each brokerage account generates its own Form 1099-DIV at the end of the year. If you have accounts at four brokers, you receive four separate forms, each reporting dividends from only the holdings in that account. To understand your total dividend income, you need to add them all together manually. And if you need to distinguish between qualified and ordinary dividends for tax planning, you are doing that calculation across multiple documents.
No unified view of payment dates
Different brokers present dividend payment information in different formats and on different schedules. Knowing when your next dividend payment is coming, across all your holdings in all your accounts, requires checking each broker individually. This makes it difficult to plan around dividend income for monthly expenses or reinvestment.
Difficulty projecting annual income
If you want to know how much total dividend income your portfolio will generate this year, you need to look up the dividend yield and payment frequency for each holding, multiply by the number of shares in each account, and add everything up. With holdings spread across multiple brokers, this projection becomes time-consuming and error-prone.
Inconsistent record-keeping
Each broker tracks your dividend history in its own format. Some provide detailed transaction histories, while others only show summary data. If you need to go back and verify a specific dividend payment from two years ago, you may need to log into the correct broker, navigate their specific reporting interface, and hope they still have the historical data available.
The manual approach: spreadsheets
The most common solution investors reach for is a spreadsheet. You create columns for the ticker symbol, payment date, amount per share, number of shares, total payment, and whether the dividend is qualified or ordinary. Then you manually enter each dividend payment as it arrives.
Advantages of spreadsheets
- Full control: You decide exactly what to track and how to organize it
- No cost: Free tools like Google Sheets work well for basic tracking
- Flexibility: You can add custom calculations, charts, and analysis as needed
- Historical record: You build a permanent record of all dividend payments over time
Disadvantages of spreadsheets
- Manual data entry: Every dividend payment needs to be entered by hand, which is tedious and error-prone
- No automatic price updates: You need to manually look up current yields and ex-dividend dates
- No projections: Building forward-looking income projections requires complex formulas
- Time-consuming maintenance: As your portfolio grows, maintaining the spreadsheet becomes a chore
- Easy to miss payments: If you forget to check a broker for a few months, payments go unrecorded
For investors with a handful of holdings in one or two accounts, a spreadsheet can work. But as the number of holdings and accounts grows, the manual approach breaks down.
What you need from a dividend tracker
Before choosing a tool, consider what an effective dividend tracker should provide:
Consolidated view across all accounts
The tracker should let you import holdings from multiple brokers and see your total dividend income in one place. Whether a dividend was paid in your Fidelity IRA or your Webull taxable account, it should appear in the same view.
Projected annual income
Based on your current holdings, their dividend yields, and payment frequencies, the tracker should estimate your annual dividend income. This projection should update automatically as you buy or sell shares.
Dividend calendar
A calendar view showing when each dividend payment is expected, across all your holdings, helps you plan for incoming cash flow. You should be able to see at a glance which months have heavy dividend activity and which are lighter.
Tax classification support
For US investors, knowing how much of your dividend income is qualified versus ordinary matters for tax planning. A good tracker should help you categorize your dividends and estimate the tax impact.
Accurate historical records
Every dividend payment should be recorded with the date, amount, and holding, creating a comprehensive history you can reference at tax time or when analyzing your income trends over the years.
How to import from popular brokers
Most brokers allow you to export your transaction history as a CSV file. Here is how to get your data from some of the most common platforms.
Webull
In the Webull app or web platform, navigate to your account activity or transaction history. Look for an export or download option to generate a CSV file. The exported file typically includes buy and sell transactions along with dividend payments. You can import this CSV into TrackMyShares to capture your full history. For step-by-step instructions, see our Webull import guide.
Robinhood
Robinhood provides account statements and tax documents through their app. For transaction history, go to Account > Statements & History. You can download monthly or yearly statements. To get a CSV-compatible format for import, check Robinhood's tax documents section for a detailed breakdown of transactions. See our Robinhood import guide for detailed steps.
Fidelity
Fidelity offers robust export options. Log into Fidelity.com, go to Accounts > Activity & Orders, and look for the download or export button. Fidelity typically exports in CSV format with detailed transaction information including dividend payments, purchases, and sales.
Schwab
Schwab allows you to export transaction history from the Activity tab in your account. Select the date range, choose the export format (CSV), and download. Schwab's export includes dividend payments as separate line items, making them easy to identify during import.
Interactive Brokers
Interactive Brokers provides extensive reporting through their Flex Queries system. You can create a custom report that includes dividend payments, trades, and other activity. The output can be exported as CSV. Due to the depth of data available, Interactive Brokers exports can be more complex to work with, but they are also the most comprehensive. See our Interactive Brokers import guide for help.
eToro
eToro provides an account statement that can be downloaded from the platform. Navigate to your portfolio, find the statement or account activity section, and export the data. See our eToro import guide for specific instructions.
For a general guide covering multiple brokers, see how to import your share trading history.
Setting up a consolidated view
Once you have your data from each broker, you need to decide how to organize it in your tracker. There are two common approaches.
Approach 1: One portfolio per broker
Create a separate portfolio in TrackMyShares for each brokerage account. This mirrors your real-world account structure and makes it easy to reconcile with each broker's statements and 1099-DIV forms at tax time.
For example:
- "Fidelity IRA" portfolio with your retirement holdings
- "Schwab Taxable" portfolio with your taxable brokerage account
- "Robinhood" portfolio with your trading positions
The advantage is clear organization and easy reconciliation. The disadvantage is that you need to use the consolidated view to see your total dividend income across all portfolios.
Approach 2: Single unified portfolio
Import all holdings into a single portfolio regardless of which broker holds them. This gives you a simpler view and makes it easy to see totals without switching between portfolios.
The advantage is simplicity. The disadvantage is that reconciling with individual broker statements becomes harder, especially at tax time when you need to match specific 1099-DIV amounts.
Our recommendation
For most investors, one portfolio per broker is the better approach. TrackMyShares provides a consolidated portfolio view that aggregates your holdings across all portfolios automatically, so you get the best of both worlds: easy reconciliation with each broker and a unified view when you need it.
Using the dividend calendar
The dividend calendar in TrackMyShares shows your projected dividend payments for the entire year, organized by month. Here is how to get the most out of it.
Monthly income overview
The calendar displays your expected dividend income for each month, based on your current holdings and their historical payment patterns. This gives you a clear picture of your cash flow from dividends throughout the year.
Identifying payment patterns
Many US companies pay dividends quarterly, but the specific months vary. Some pay in January, April, July, and October, while others pay in March, June, September, and December. The calendar helps you see when payments cluster together and when there are quieter months.
Planning reinvestment
If you plan to reinvest your dividends, knowing when they arrive helps you time additional purchases. A month with $500 in expected dividends might be a good time to add to a position, while a month with only $50 might not warrant a separate transaction.
Projected annual income
Beyond the monthly calendar view, knowing your projected annual dividend income helps with broader financial planning.
How the projection works
TrackMyShares calculates projected annual income based on:
- The number of shares you hold in each dividend-paying stock or ETF
- The current annual dividend per share (based on the most recent declared dividends)
- The payment frequency (monthly, quarterly, semi-annually, or annually)
This projection updates automatically when you add or remove holdings, so it always reflects your current portfolio composition.
Using projections for planning
Your projected annual dividend income can inform several decisions:
- Tax planning: Knowing your expected dividend income helps you estimate your tax liability for the year and make estimated tax payments if needed
- Income planning: If you rely on dividends for living expenses (common in retirement), accurate projections help you budget
- Portfolio construction: If you have a target income level, you can see how close your current holdings get you and which additions would close the gap
- Yield comparison: Comparing your portfolio's overall yield against a benchmark helps you understand whether your income focus is paying off
Tax time: matching with 1099-DIVs
When January arrives and your 1099-DIV forms start appearing, having a well-organized dividend tracker makes tax preparation significantly easier.
Reconciliation process
For each brokerage account:
- Open the 1099-DIV from that broker
- Open the corresponding portfolio in TrackMyShares
- Compare the total ordinary dividends (Box 1a) with the sum of dividends recorded in TrackMyShares for that portfolio
- Compare the qualified dividends (Box 1b) with your qualified dividend records
- Identify and resolve any discrepancies
Common discrepancies include:
- Missed dividend recordings: You forgot to record a payment that the broker captured
- Timing differences: A dividend declared in December but paid in January may appear in different tax years depending on the record date
- Return of capital distributions: Some distributions classified as dividends by your broker may actually be return of capital (Box 3 on the 1099-DIV), which reduces your cost basis rather than counting as income
Using tax reports
The US capital gains tax report in TrackMyShares includes your dividend income alongside your capital gains and losses. This gives you a comprehensive view of your investment tax obligations for the calendar year, making it easier to prepare Schedule B and the Qualified Dividends and Capital Gain Tax Worksheet.
For a deeper understanding of how dividends are taxed, including the difference between qualified and ordinary dividends and the holding period rules, see our guide on how dividends are taxed in the US.
How TrackMyShares helps
TrackMyShares is built to solve the multi-broker dividend tracking problem. Here is a summary of the key features:
CSV import from any broker
Import your trading history from Webull, Robinhood, Interactive Brokers, eToro, Fidelity, Schwab, and other brokers using CSV files. The import process maps your broker's CSV format to TrackMyShares transactions, capturing purchases, sales, and dividends.
Multiple portfolios with consolidated view
Create a separate portfolio for each brokerage account, then use the consolidated view to see your total holdings and dividend income across all accounts. This gives you both granular per-broker detail and a big-picture overview.
Dividend calendar and income projections
The dividend calendar shows projected payments by month, and the income projection estimates your annual dividend income based on current holdings. Both update automatically as your portfolio changes.
Tax reports
Generate tax reports that include dividend income alongside capital gains and losses, giving you the data you need for filing or sharing with your accountant.
Prices updated throughout the day
Stock prices and dividend yields are updated throughout the day, so your projections and portfolio values reflect current market conditions.
Tracking dividend income across multiple brokers does not have to be a fragmented, manual process. By consolidating your holdings in one tracker, you gain a clear picture of your total income, upcoming payments, and tax obligations.
Sign up for TrackMyShares to bring all your dividend income together in one place, project your annual income, and simplify tax season.