Dividend Tracker: Log Your Investment Income (Free Template)
Dividends are quiet money. They drop into your account a few dollars or pounds at a time, often while you are busy with something else, and they are easy to lose track of. A simple dividend tracker turns those small payments into a clear record of what you earned, what was reinvested and what you may need for tax time. Here is how to build one in an afternoon, with a free template you can copy.
Key takeaways
- A dividend tracker logs each payment with its ex-dividend date, pay date, amount, any withholding tax and whether it was reinvested.
- Reinvested dividends matter for your records, because in the US they generally adjust the cost basis of the shares you hold.
- In the US, dividends are reported on Form 1099-DIV. In the UK, the dividend allowance is £500, and dividends inside an ISA or pension are tax-free.
- A spreadsheet works fine for most people. Tools such as Sharesight and Snowball Analytics can automate more of the work.
If you own a few dividend-paying shares or funds, you probably see the payments come in and think, "nice," and move on. That is fine for a while. Then tax season arrives, or you sell a holding, or you want to know whether your income portfolio is actually growing, and suddenly you need numbers you never wrote down.
A dividend tracker fixes that. It is not a fancy portfolio dashboard. It is a running log of investment income, kept in one place, updated once a month. This guide covers what to record, how to set up the template, how to handle reinvested and foreign dividends, and when it might be worth using an app instead of a sheet. If you already keep a broader portfolio tracker, think of this as the income tab that sits beside it.
Why a dividend tracker is worth 10 minutes a month
Your broker or platform already shows your dividends, so why keep your own log? A few good reasons:
- You probably have more than one account. A workplace plan, a personal brokerage account, an ISA or IRA, maybe an old account you forgot about. Each one reports separately. Your tracker is the only place that shows all your investment income together.
- Reinvested dividends are easy to forget. When dividends buy more shares automatically, nothing lands in your cash balance. Without a record, you can lose sight of how much you have actually added to each holding.
- Tax time gets calmer. You can check the figures on your tax forms against your own log, rather than taking them on trust.
- You see real progress. Watching your monthly income line climb, even slowly, is one of the most motivating parts of long-term investing.
Pro tip
Pick one fixed day each month to update the tracker, such as the first Sunday. Ten minutes on a regular schedule beats three hours of detective work in March.
What to record for every dividend
You do not need dozens of columns. These fields cover what most households and small business owners need, both for planning and for tax records.
The core fields
- Holding and ticker: the company or fund name and its symbol.
- Account: taxable brokerage, IRA, 401(k), ISA, pension and so on. This matters because the tax treatment can be very different.
- Ex-dividend date: you generally need to own the shares before this date to receive the dividend. Logging it helps you understand why a dividend did or did not appear after you bought or sold.
- Pay date: the day the money actually arrives.
- Amount received: the gross dividend, plus the net amount if anything was withheld.
- Withholding tax: for foreign shares, some tax may be taken at source before the money reaches you. Record it separately.
- Reinvested? Yes or no, and if yes, how many shares were bought and at what price.
Optional fields that add insight
- Currency: useful if you hold shares in more than one market.
- Dividend type: in the US, qualified or ordinary. Your Form 1099-DIV will confirm this at year end, but noting it as you go helps you plan.
- Yield on cost: your annual dividends from a holding divided by what you originally paid for it. It shows how your income has grown relative to your investment.
- Notes: special dividends, changes in payout, anything unusual.
Common mistake
Recording only the net amount that landed in your account. For foreign shares, the withholding tax is part of the story, and in some situations it may be relevant when you file. Log the gross figure, the tax withheld and the net amount, even if it feels like extra work.
Set up your dividend tracker step by step
You can build this in Google Sheets, Microsoft Excel or any spreadsheet you like. Here is a simple setup that takes well under an hour.
- List your accounts. Write down every account that holds dividend-paying investments, including old workplace plans and tax-advantaged accounts.
- List your holdings. Create a small "Holdings" tab with each holding, its ticker, the account it sits in and your total cost so far.
- Create the income log. Add a second tab with the columns from the template below, one row per dividend payment.
- Backfill this year. Download statements or transaction history for the current year and enter each dividend. If that feels like too much, start from this month and backfill slowly.
- Add simple totals. Use a pivot table or SUMIF formulas to total income by month, by account and by holding.
- Update monthly. On your chosen day, add new payments, check reinvestments and glance at the totals.
- Reconcile at year end. When your tax forms arrive, compare them with your log and fix any gaps.
Using GOOGLEFINANCE in Google Sheets
If you build the tracker in Google Sheets, the GOOGLEFINANCE function can pull in market data such as a current price for a ticker. That is handy on your Holdings tab for showing a rough current value next to your cost. Check which data the function supports for your exchange, and treat the figures as approximate, not as official records. Your broker statements remain the source of truth for what you were actually paid.
Free dividend tracker template
Copy these columns into a new sheet. Add one row each time a dividend is paid. The example rows use made-up tickers and amounts for illustration only.
| Pay date | Ex-div date | Holding | Account | Gross amount | Tax withheld | Net amount | Reinvested? | Shares bought | Notes |
|---|---|---|---|---|---|---|---|---|---|
| 2026-10-15 | 2026-09-30 | Example Co (EXCO) | Taxable brokerage | $42.00 (example) | $0.00 | $42.00 | Yes | 0.85 | Regular quarterly payment |
| 2026-10-20 | 2026-10-02 | Sample Global Fund (SGF) | ISA | £18.50 (example) | £0.00 | £18.50 | No | 0 | Inside ISA, tax-free |
| 2026-11-03 | 2026-10-14 | Demo Industries (DEMO) | Taxable brokerage | $30.00 (example) | $4.50 | $25.50 | No | 0 | Foreign share, tax withheld at source |
On a separate summary tab, add a small table with one row per month and columns for total gross income, total withheld and total reinvested. A simple chart of the monthly totals makes your progress easy to see at a glance.
Example
Imagine Leo, a freelance photographer with a small taxable brokerage account and an IRA. He bought shares in a made-up company for $2,000 a few years ago, and that holding now pays him $80 a year in dividends. His yield on cost is $80 / $2,000 = 4%. Because his dividends are reinvested, he logs the extra shares each quarter, so when he eventually sells he can show what he added to his cost. (All numbers here are invented for illustration.)
Reinvested dividends and your cost basis
Many brokers let you reinvest dividends automatically through a dividend reinvestment plan, often called a DRIP. It is a simple way to compound your income, but it adds a record-keeping wrinkle.
In the US, your cost basis is generally what you paid for an investment plus purchase costs, adjusted for things like reinvested dividends and stock splits. Each reinvested dividend buys new shares, and those shares have their own cost. The dividend itself is still generally taxable in the year it is paid in a taxable account, even though you never saw the cash. If you lose track of reinvestments, you risk understating your basis when you sell, which could mean reporting a larger gain than you really had.
The fix is easy: every time a dividend is reinvested, log the date, the amount and the number of shares bought. Brokers often track this for you too, but your own log is a useful backup, especially if you ever move accounts.
Pro tip
Keep your dividend log for as long as you hold the investment, and then for a few more years after you sell. In the US, the IRS says to keep records relating to property until the period of limitations expires for the year you dispose of it, which is generally 3 years after you file that return.
How dividends are taxed: the basics for 2026
This section is general information, not tax advice. Rules depend on your country, your account type and your income, so check the official source or talk to a qualified tax professional about your own situation.
In the US
Dividends are reported to you on Form 1099-DIV. Qualified dividends are taxed at the long-term capital gains rates, which are 0%, 15% or 20% depending on your income. Ordinary dividends are taxed at your regular income tax rates. Your 1099-DIV shows which is which. Dividends inside tax-advantaged retirement accounts follow the rules for those accounts. Check IRS.gov for current guidance.
In the UK
For 2026/27, the dividend allowance is £500. Dividends above that are taxed at 10.75% for basic rate taxpayers, 35.75% for higher rate taxpayers and 39.35% for additional rate taxpayers. Dividends inside an ISA or a pension are tax-free, which is why the "Account" column in your tracker matters so much. Rates and allowances can change, so check gov.uk for updates each tax year.
In Europe and elsewhere
Rules vary widely from country to country, and foreign dividends may have tax withheld at source. Your tracker will not answer every tax question, but it gives you or your accountant the clean data needed to work it out.
Spreadsheet or app?
A spreadsheet is free, flexible and private. You control every column, and nothing is connected to your accounts unless you choose. The trade-off is manual entry.
Dedicated portfolio and dividend tools can import transactions, track reinvestments and show income forecasts. Tools you might look at include Sharesight and Snowball Analytics. If you prefer to stay in a spreadsheet, a Google Sheets template that uses the GOOGLEFINANCE function is a solid middle ground. Before you choose any tool, check its current features, pricing and privacy policy, and think carefully before linking brokerage logins to a third party.
Common mistake
Chasing the highest yield because your tracker makes income feel exciting. A high yield can sometimes signal risk, and a tracker is a record-keeping tool, not an investment strategy. If you want help choosing investments, speak with a qualified, regulated adviser.
Your dividend tracker checklist
- List every account that holds dividend-paying investments
- Create a Holdings tab with tickers, accounts and total cost
- Create an income log using the template columns
- Backfill this year's dividends from statements
- Log gross amount, withholding tax and net amount for each payment
- Record every reinvested dividend and the shares it bought
- Add monthly totals and a simple chart
- Set a monthly update reminder and reconcile with tax forms at year end
Frequently asked questions
Do I need to track dividends inside an ISA, IRA or pension?
For tax purposes it is less critical, since UK dividends inside an ISA or pension are tax-free and US retirement accounts follow their own rules. Many people still log them because it shows the full picture of their investment income and how it grows over time.
What is the difference between the ex-dividend date and the pay date?
The ex-dividend date is the cutoff that generally decides who receives the dividend. The pay date is when the money actually arrives. Logging both helps you understand why a payment did or did not show up after a trade.
Are reinvested dividends still taxable?
In a US taxable account, reinvested dividends are generally still taxable in the year they are paid, even though you did not receive cash. They also add to your cost basis. In the UK, the dividend is income whether or not you reinvest it, unless it sits inside a tax-free wrapper such as an ISA.
How often should I update my dividend tracker?
Once a month is plenty for most people. Many dividends are paid quarterly, so a monthly check catches everything without becoming a chore.
Related reading
The bottom line
A dividend tracker is one of the easiest money habits you can build. Log each payment with its dates, gross and net amounts, any withholding tax and whether it was reinvested. Keep track of which account it sits in, add simple monthly totals, and reconcile with your tax forms once a year.
Copy the template, spend an evening backfilling this year, and then give it ten minutes a month. Before long you will have a clear, reliable record of your investment income and a very satisfying chart to look at.
