Best Value Complete Financial Planning Bundle →
✓ Financial Planning✓ Net Worth Tracker✓ Monthly Budgeting✓ Travel Budget Planner✓ Annual Budgeting Planner✓ Monthly Expense Tracker✓ Annual Tax Planner✓ Retirement Planning
$139 One purchase, no subscription
View Bundle →
by Segmio
View Bundles
Language
ENEnglishDEDeutschESEspañolFRFrançaisPTPortuguêsITItalianoARالعربيةNLNederlandsZH中文
Dividend Tracker Ultimate ›

Instant digital delivery · Terms & Conditions apply

Essentials Template - Excel & Google Sheets

Essentials Dividend Tracker Spreadsheet Template for Google Sheets & Excel

Payments logged as they land, thirty rows deep, each carrying both dates - the one that decided entitlement and the one the money arrived. The Essentials Dividend Tracker spreadsheet template records the shares held at entitlement, so a historic payment stays correct after the position changes, and derives the amount from those shares and the declared dividend per share. The qualified marker is yours to set. Google Sheets and Excel, one file. No macros, no VBA.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

View Ultimate Dividend Tracker Spreadsheet Template
$29
Essentials Dividend Tracker spreadsheet template - Google Sheets and Excel preview

What's Included

  • Received payments on one log
  • Both dates recorded - the one that decides entitlement and the one the money arrives
  • Shares held at entitlement, so historic payments stay correct after a position changes
  • Payment amount derived from the shares and the declared dividend per share
  • A column for marking a dividend qualified, set by you
  • Dashboard with total income, the largest single payment and the income marked qualified
  • Unique payers, payment count and the income you marked qualified
  • A chart breaking income down by company, where concentration shows up
  • A currency dropdown on the Dashboard that relabels money columns across both sheets
  • Works in Microsoft Excel and Google Sheets with no setup required
Ultimate Version Available

Need more from this template?

The Essentials Spreadsheet Template covers everyday tracking. The Ultimate Spreadsheet Template gives each part of the template its own sheet, with more capacity and deeper reporting on top.

Essentials - $19
  • Received payments on one log
  • Both dates recorded - the one that decides entitlement and the one the money arrives
  • Shares held at entitlement, so historic payments stay correct after a position changes
  • Payment amount derived from the shares and the declared dividend per share
Ultimate - $29
  • A Holdings sheet carrying cost basis, current price, market value and yield
  • Sector and payment frequency on every holding
  • A Dividend History of what was received, with a reinvestment marker
  • Monthly Income showing every holding across all twelve months
  • Yield on Cost measured against what you originally paid rather than today's price
See what's in the Ultimate version› One-time purchase. No subscription.

The FinancialAha Essentials Dividend Tracker Spreadsheet Template for Google Sheets and Excel is a two-sheet workbook that records what actually landed, with a How to Use guide on a third tab. It works as an Essentials Dividend Tracker Excel template and an Essentials Dividend Tracker Google Sheets template from the same download. Where the Free build projects what a portfolio should pay, this Essentials Dividend Tracker spreadsheet template logs each payment as it arrives, with both dates and the shares held when it was declared. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Essentials Dividend Tracker spreadsheet template

The FinancialAha Essentials Dividend Tracker Spreadsheet Template runs on two working sheets - one you type into, one that reports back - plus the guide. It works in both Microsoft Excel and Google Sheets and here is what the Essentials Dividend Tracker spreadsheet holds.

  1. 01 of 02

    Dividends

    The sheet you type into, a row per payment. Each row records one dividend: the company, the date that decided entitlement and the date the money arrived, how many shares you held at that point, and what was declared per share - with the payment itself following from the last two. Keeping both dates rather than one is what makes the record usable later, because the date that determines a payment and the date it lands are rarely the same. A column for marking a dividend qualified sits alongside, for you to fill in as you see fit.

    FinancialAha Dividend Tracker spreadsheet template - Dividends sheet

  2. 02 of 02

    Dashboard

    The record summarised: everything received, the largest single payment, how many companies are paying, how many payments there have been, and how much of the income you marked qualified. A chart breaks the income down by company, which is where concentration in a portfolio becomes visible. The per-month figure divides the total by the span it was actually logged over - the months between your earliest and latest pay date, inclusive - rather than by a fixed period, so it stays a real average whether the log covers a quarter or a full year.

    FinancialAha Dividend Tracker Google Sheets template - Dashboard sheet

  3. Included guide

    How to Use

    A step-by-step guide on its own tab, covering setup, what each column expects, the difference between the two dates, and how the dashboard reads. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Essentials Dividend Tracker Spreadsheet template for Google Sheets

Upload the Essentials Dividend Tracker Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Essentials Dividend Tracker Google Sheets template needs no conversion step and the chart survives the trip intact - the totals keep working exactly as they do in Excel. The currency dropdown on the Dashboard relabels every money column across both sheets at once.

Essentials Dividend Tracker Google Sheets template setup

A shared copy of the Essentials Dividend Tracker Google Sheets template suits a portfolio held jointly, and Sheets version history covers a payment logged twice. Because the reporting sits on its own tab, the log stays a log.

Sharing the Essentials Dividend Tracker Google Sheet

The Essentials Dividend Tracker Google Sheet is a per-payment job: a line when a dividend lands, and the dashboard follows. Because dividends arrive on their own schedule rather than daily, keeping it current is a matter of minutes a month.

Also available as:

Essentials Dividend Tracker Spreadsheet template for Excel

The Essentials Dividend Tracker spreadsheet Excel download is a plain .xlsx. Excel opens this Essentials Dividend Tracker Excel template directly, with no import step and no compatibility prompt, and the chart is a native Excel chart that redraws as payments go in. There are no macros and no VBA in the file, so it opens without a security warning.

Essentials Dividend Tracker Excel template setup

The same Essentials Dividend Tracker Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Essentials Dividend Tracker spreadsheet download to choose between.

Essentials Dividend Tracker spreadsheet Excel notes

The Essentials Dividend Tracker spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt. The same Essentials Dividend Tracker spreadsheet Excel download also opens in Excel for the web, which matters when you move between a work machine and a personal one.

Opening the Essentials Dividend Tracker spreadsheet Excel file

Nothing in the Essentials Dividend Tracker Excel template is version-specific, so this Essentials Dividend Tracker spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.

Also available as:

Spreadsheet template highlights

What the Essentials Dividend Tracker spreadsheet template tracks

You log the payment and the Essentials Dividend Tracker Spreadsheet Template works out the rest:

Stock
the company paying the dividend
Ex-Date
the date that decides entitlement to the payment
Pay Date
when the money actually arrived
Shares Held
how many you held when entitlement was decided
Div / Share
the amount declared per share
Total Dividend auto
derived, the shares against the declared amount
Qualified
a marker you set on the row yourself

Compare builds

FinancialAha Dividend Tracker spreadsheet template: Free, Essentials, and Ultimate compared

Feature Free View Spreadsheet Template Essentials This page Ultimate View Spreadsheet Template
Working sheets 1 2 6
What it holds 16 holdings 30 payments 30 holdings + 100 payments
Records payments received – Yes, with both dates Yes, with reinvestment noted
Forward annual income Yes – Yes
Yield Per holding – Per holding and portfolio-wide
Charts – 1 1
Income by month – Average only Every month, per holding
Yield on cost – – Dedicated sheet
Reinvestment projection – – Dedicated sheet
Sector and frequency – – Yes

The FinancialAha Essentials Dividend Tracker Spreadsheet Template covers two working sheets, a row per payment, and it records rather than projects. That is the inversion against the Free Dividend Tracker Spreadsheet Template, which lists holdings a row each and works out what they should pay over a year but keeps no dates and no history. This build logs each payment as it lands with both the entitlement date and the pay date, and reports the total, the largest payment and how many companies are paying, with a chart by company. The Ultimate Dividend Tracker Spreadsheet Template does both jobs at once - holdings with sector and frequency alongside a log of what was received - and adds income by month, yield measured against what you originally paid, and a reinvestment projection.

Compare the other builds: Free Dividend Tracker spreadsheet template or the Ultimate Dividend Tracker spreadsheet template .

Good to know

Notes on working in the Essentials Dividend Tracker spreadsheet template

  • The two dates do different jobs: one decides whether a payment is yours, the other is when it arrives. Both are worth recording.
  • Shares held is the count at the entitlement date rather than today, which is what keeps a historic payment correct after a position changes.
  • The qualified column is a marker you set. Nothing in the sheet determines it, and it carries no consequence beyond the total it feeds.
  • The chart by company is where concentration shows up - a portfolio's income can be far less spread than its holdings suggest.
  • The currency dropdown sits on the Dashboard and relabels money columns across the whole Essentials Dividend Tracker spreadsheet. It changes the label only and does not convert the numbers.
  • The per-month tile divides the total by the number of months between your earliest and latest pay date, so it stays a real average as the log grows.

How to Use the Essentials Dividend Tracker Spreadsheet Template

1

Log the payment

Enter the company and both dates - the one that decided entitlement and the one the money arrived.

2

Add the detail

Record how many shares you held at that point and what was declared per share.

3

Mark it if you want

The qualified column is yours to set. It feeds a total on the dashboard and nothing else.

4

Read the dashboard

Total income, the largest payment, how many companies are paying and how much you marked qualified, with a chart by company.

Stress-tested with AI.

Every template starts with deep research into how people actually track the topic. We design the layout, build the formulas, and polish the design until it feels like something we would use ourselves. Along the way, we use AI to stress-test the calculations: unusual inputs, edge cases, and formula behavior, checked until the numbers hold.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

Frequently Asked Questions

Is the FinancialAha Essentials Dividend Tracker Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". The Essentials Dividend Tracker Google Sheets template needs no conversion step and the chart survives the trip intact.

Is the FinancialAha Essentials Dividend Tracker Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Essentials Dividend Tracker Excel template opens directly in Excel with no import step. The chart is a native Excel chart, and there are no macros or VBA.

Will the FinancialAha Essentials Dividend Tracker spreadsheet Excel file open in older versions of Excel?

Yes. The Essentials Dividend Tracker spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.

Does the Essentials Dividend Tracker spreadsheet template list my holdings?

No. This build is a log of payments received rather than a list of positions - it records what landed, not what you own. The Ultimate build carries both: holdings with sector and payment frequency alongside a log of what was received.

Why does the Essentials Dividend Tracker spreadsheet record two dates?

They do different jobs. One decides whether a payment belongs to you, the other is when it actually arrives, and they are rarely the same - keeping both is what makes the record usable months later.

What does the qualified column do in the Essentials Dividend Tracker spreadsheet?

It is a marker you set on the row. The sheet totals the income you have marked, and nothing more - it does not determine the status or apply any consequence to it.

How many payments can I log in the Essentials Dividend Tracker spreadsheet?

Thirty. The Ultimate build holds a hundred, alongside a holdings list and month-by-month income.

Why does the Essentials Dividend Tracker spreadsheet say shares held at the ex-date?

Because that is the count the payment was based on. Recording it, rather than your current position, is what keeps an older payment correct after you buy or sell.

How do I open the Essentials Dividend Tracker spreadsheet template in Google Sheets?

Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.

More Essentials Investing & Trading Templates

Investment Portfolio Tracker

A name beside every ticker and a percentage return on each position, so holdings of very different sizes can be compared. The Essentials Investment Portfolio Tracker spreadsheet template carries 20 holdings, works out market value and gain per position, and puts total portfolio value and total gain on a dashboard with a chart of how the value splits between holdings. Google Sheets and Excel, one file. No macros, no VBA.

$19

Stock Trading Journal

Each of the thirty rows is one side of a trade, so buys and sells are logged apart and the cash flow takes its direction from the side, its size from the quantity and price, and its fees netted in. The Essentials Stock Trading Journal spreadsheet template settles a realised figure on closing rows against what you paid for that ticker, and an open position stays visible as a buy with no sell against it. Two working sheets and a chart, Google Sheets or Excel. No macros, no VBA.

$19

Options Trading Journal

Pick the leg you traded and the money works itself out - direction, premium, contract count and fees all folded into one cash flow. The Essentials Options Trading Journal spreadsheet template handles opening and closing legs in both directions so the sign follows the action, nets fees into the result rather than reporting them separately, holds thirty trades on a single log, and shows the net total, the win rate and the number logged on a dashboard. Google Sheets and Excel. No macros, no VBA.

$19

Crypto Portfolio Tracker

Percentage return sits beside value and gain on every one of twenty holdings, so a small position that doubled is tellable from a large one that drifted. The Essentials Crypto Portfolio Tracker spreadsheet template takes coin, symbol, quantity, average cost and current price per row, with a Dashboard carrying total value, total gain, overall return, total cost basis and how many holdings are ahead. Two working sheets and an allocation chart. Google Sheets and Excel. No macros, no VBA.

$19
Essentials
Preview
See Investing Ultimate Pack 8 templates included • Save $123

Instant digital delivery · Terms & Conditions apply

Highlights:

Dashboard with charts and KPIs
Pre-filled categories and sample data
No sign-up, no subscription
Lifetime free updates
Works in
Excel Google Sheets

Looking for premium spreadsheet templates?

Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.

View Premium Templates Browse All Essentials Templates

Private & secure

Your financial data stays on your device. We never see it.

Learn more →

Need help?

Check our guides or reach out with questions.

View FAQ →