TF
Template Flow Hub

Dividend Tracker Template for Google Sheets

Track your dividend income with this free Google Sheets template. No signup required — copy to Google Sheets or download Excel and CSV. Monitor dividend payments, yields, payout dates, and annual income.

Google SheetsExcelCSV
Copy Google SheetsDownload ExcelDownload CSV
Cost

Free

Signup

No signup

Formats

Sheets, Excel, CSV

Best for

Finance

Updated

2026-06-01

Dividend Tracker Template for Google Sheets preview — free Google Sheets template

What Is This Dividend Tracker Template?

This dividend tracker template is a free Google Sheets spreadsheet for income-focused investors who want to monitor their dividend payments, yields, and ex-dividend dates. It calculates estimated annual dividend income, tracks payment history, and provides a clear overview of your dividend portfolio across all holdings.

Why Use a Google Sheets Dividend Tracker Template?

A Google Sheets dividend tracker keeps all your dividend data in one place without requiring a premium subscription. You can see your estimated annual passive income, track payment schedules, and log actual payments received. The template can be downloaded as Excel or CSV for tax reporting and portfolio analysis.

When Should You Use This Dividend Tracker Template?

Use this template when you own dividend-paying stocks and want to track your passive income stream. It works well for retirement planning, income portfolio management, and monitoring dividend growth over time. For a complete view of your portfolio, pair it with the stock portfolio tracker template.

What's Included

  • ✓Ticker symbol
  • ✓Company name
  • ✓Shares owned
  • ✓Dividend per share
  • ✓Payment frequency
  • ✓Next ex-dividend date
  • ✓Next pay date
  • ✓Estimated annual income
  • ✓Dividend yield
  • ✓YTD dividend income
  • ✓Payment history log

How to Use This Template

1Copy the template to your Google Drive.
2Add your dividend stock tickers and share counts.
3Enter the dividend per share and payment frequency.
4Track ex-dividend and pay dates for each holding.
5The template calculates estimated annual dividend income and yield.
6Log each dividend payment received in the history section.

Who This Template Is For

Dividend InvestorsIncome InvestorsRetirement PlannersLong-term Investors

Available Formats

Google Sheets — Copy the template directly to your Google Drive. You can edit, share, and use it online from any device.

Excel (.xlsx) — Download the file and open it in Microsoft Excel, Apple Numbers, or any compatible spreadsheet application.

CSV — Download the comma-separated values file for use in data applications, databases, or legacy spreadsheet software.

Customization Tips

  • 💡Sort tickers by payment frequency (monthly vs quarterly) to see when each dividend payment arrives.
  • 💡Add a target column for annual dividend income goals and track progress throughout the year.
  • 💡Export to CSV quarterly to maintain a dividend income record separate from your brokerage statements.

Use Cases

  • Dividend income tracking
  • Passive income monitoring
  • Portfolio yield analysis

Download or Copy

Copy Google SheetsDownload ExcelDownload CSV
Disclaimer: This template is for tracking and educational purposes only. It does not provide financial, investment, tax, or legal advice.

Frequently Asked Questions

Yes. Copy the Google Sheets version or download Excel/CSV for free.
Yes. The template calculates dividend yield based on your average cost or current price.
Yes. Add as many stocks as you like. The template aggregates annual income from all holdings.
Yes. Use the payment history log to record each dividend received and track YTD totals.
Yes. Based on your shares, dividend per share, and payment frequency, the template estimates your annual dividend income.

Related Templates

Last updated: 2026-06-01

Copy Google Sheets