How to Build a Free Dividend Tracker in Google Sheets
You own a few dividend stocks. Maybe an index fund or two. Every so often a little cash lands in your brokerage account with a label you don’t really read, and you think “oh nice, free money,” and close the app. Then someone asks how much your shares actually pay you in a year, and the real answer is usually a shrug.
Your brokerage is not going to make that number easy to find. It wants you staring at the account balance, not the income. So the fix is a boring, wonderful little Google Sheet that adds it up for you and refreshes the prices on its own. A dividend tracker’s real job is simple: turn a scattered pile of tickers into one clear number, the actual cash your shares pay you over a year.
I built a free dividend tracker in Google Sheets that you can copy in about ten seconds, and below I’ll walk through how every part of it works so you trust the math instead of a black box. If you’d rather see other ways to build income that shows up without clocking in, that’s a fair next stop. For now, let’s get your dividends on paper.
Jump to a section
What a dividend tracker actually tells you
A dividend is a slice of a company’s profit paid out to the people who own the stock, usually every quarter. Own the share, collect the cash. That’s the whole idea, and it’s worth reading the plain-English version straight from the SEC’s investor glossary if you’re new to it.
The problem is that one payment on its own tells you almost nothing. Forty dollars showing up in March is nice, but is that good? Compared to what? A tracker answers the questions your brokerage app dodges: how much income the whole portfolio throws off in a year, what that works out to per month, and how hard each dollar you invested is actually working.
That last one has a name: yield on cost. It’s your annual dividend measured against what you originally paid, not today’s price. Buy a steady payer early and hold it, and your yield on cost tends to drift up over the years even when the headline yield looks the same to everyone else. Watching that number climb is the fun part of dividend investing, and it’s the thing a plain brokerage screen will never show you.
Grab the free Google Sheets template
You could build this from a blank sheet, and I’ll show you every formula so you can. But there’s no reason to start from scratch when the whole thing is already sitting here.
Grab your free dividend tracker
Make your own copy and the whole tracker lands in your Google Drive, every formula intact, yours to edit and completely private. It costs nothing.
The layout is two parts. Up top, a row per holding. Down below, a small summary that rolls everything into the numbers you actually care about. Two example rows come pre-loaded so you can see it working before you touch anything. Delete them once you add your own.
Only four columns are your job. You type in the ticker (the stock symbol, like SCHD or JNJ), the number of shares you own, your average cost per share (what you paid), and the annual dividend per share (how much one share pays over a full year). Those are the only four things the sheet can’t figure out on its own, and even the dividend you can find in a few seconds on any brokerage or finance site.
Everything to the right is automatic: the live price, your position’s current value, the annual income each holding produces, its current yield, and that yield-on-cost number worth caring about. You never touch those cells. They recalculate the moment you change an input, which is what makes the sheet feel less like a chore and more like a dashboard.
How the sheet pulls live prices for free
This is the part that feels like a magic trick the first time. Google Sheets has a built-in function called GOOGLEFINANCE that reaches out to Google’s market data and drops a current price right into a cell. No add-on, no subscription, no API key.
In the template the live-price cell reads like this:
=GOOGLEFINANCE(A6,"price")
A6 is the cell holding the ticker, and “price” is what you’re asking for. Change the ticker and the price follows. Prices refresh on their own every few minutes during market hours, so the sheet you copied this morning is not the sheet you’ll see tonight, without you lifting a finger. Google notes the data can run on a short delay, which is fine for a portfolio you check now and then, not day-trade.
One catch: GOOGLEFINANCE can pull a price, but it won’t reliably pull the dividend amount, which is why that stays a column you fill in by hand. It changes a few times a year at most, so it’s a two-minute update, not a burden.
The math it runs for you
None of the formulas here are fancy. They’re the same arithmetic you’d do on a napkin, just done instantly and without mistakes. Walking through them once means you’ll always know what the sheet is claiming and why.
Position value is shares times live price. Own 100 shares at a live price of 27 dollars and the cell shows 2,700 dollars. It moves with the market all day.
Annual income is shares times the annual dividend per share. If a holding pays 1.20 a share each year and you own 100 shares, that’s 120 dollars a year landing in your account, spread across the quarterly payments. Add up that column and you’ve got the whole point of the exercise.
Current yield is the annual dividend divided by today’s price, shown as a percent. It answers “if I bought this right now, what would it pay me?” Yield on cost swaps today’s price for what you actually paid, so it answers the better question: “what is this paying me on the money I put in?” Same dividend, two different denominators, and the gap between them is the story of a good long-term hold. If you want the textbook definition of yield to sit alongside the sheet, Investopedia’s rundown is a clean one.
Down in the summary, the sheet totals your portfolio value and your annual income, then does two small kindnesses: it divides the yearly income by twelve for a monthly figure and by 365 for a per-day one. Seeing “about 18 dollars a month” or “58 cents a day” makes an abstract portfolio feel real, and real is what keeps you investing. Tracking that kind of progress is the same habit that makes any money goal actually stick: you can’t stay motivated by a number you never look at.
What a dividend tracker can’t do for you
A tracker is a mirror, not a crystal ball. It shows you clearly what you own and what it pays today. It says nothing about what you should own, and it can’t promise any of those numbers hold.
Dividends are not guaranteed. A company can trim or cancel its payout in a rough year, and when it does, the income column you were admiring shrinks with it. A stock’s price can fall faster than its dividend flatters you. And a very high yield is often a warning, not a gift, because it can mean the price has dropped for a reason the market already knows. The sheet will happily calculate a great-looking yield on a company in trouble, because a spreadsheet only knows the numbers you feed it.
So use this for what it’s built for: seeing your income plainly, watching your yield on cost grow, and staying interested enough to keep going. This is general education, not personalized advice for your situation. For the actual “what should I buy” questions, and anything touching taxes, talk to a professional who knows your whole picture.
Copy the sheet, plug in your holdings, and let it tell you the one number your brokerage keeps burying. Then check it once a month, not once an hour. What’s the first ticker you’re dropping into row six? Tell me in the comments, I’m curious what everyone’s holding.
Who wrote this
Robby Naka writes The Millennial Budget, a no-shame take on money for people who want a great life now and later. He’s not a financial advisor, just a guy a little obsessed with spending on purpose and figuring out his own kind of rich. More about Robby. This article is general education, not financial or tax advice for your situation.
