Dividend Income Tracker preview
Dividend Register sheet with columns for company, sector, shares, yield on cost, ex-dividend date, pay date, expected cash, and payment status. 1/4

About this dividend income tracker spreadsheet template

This Dividend Income Tracker spreadsheet helps investors monitor dividend payments across multiple stock positions in one organized workbook. The template includes a Dividend Register for recording company details, share counts, cost basis, annual dividends per share, yield on cost, current yield, ex-dividend and pay dates, expected and received cash, currency, and payment status for each holding.

A dedicated Income Queue sheet tracks upcoming, scheduled, and received payments with action prompts such as confirming entitlement and monitoring overdue items. The Income Dashboard aggregates positions, annual income, and average current yield by sector, plus a 90-day expected cash forecast. A Lists & Guide reference sheet explains every control rule — from yield calculations to reconciliation workflows — so you can adapt the tracker to your portfolio.

Every cell, column, and formula is fully editable in WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers. Replace the sample tickers and amounts with your own holdings, adjust sector groupings, and extend the register as your portfolio grows.

4 structured sheets

Register, queue, dashboard, and reference guide for complete dividend tracking.

Fully editable

Replace sample data with your own portfolio holdings, sectors, and dividend schedules.

Clean dashboard layout

At-a-glance income summary by sector with yield metrics and cash forecasts.

Standard XLSX format

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.

Frequently asked questions
The Dividend Income Tracker template is designed for individual investors and portfolio managers to track dividend payments, monitor yield on cost and current yield, forecast upcoming cash, and reconcile received payments across multiple stock positions. Customize the sample data, sectors, and formulas in WPS Office for your own portfolio.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the data structure and tracking logic in a Notion database; for branded financial reports, adapt the dashboard content in Adobe Express.
Download the template, open it in WPS Office, and replace the sample company names, tickers, share counts, dividend amounts, dates, and sector groupings with your own portfolio data. All formulas, columns, and dashboard references update automatically.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for personal investment tracking, client portfolio reporting, financial planning, and income reconciliation. It is available for personal and commercial projects, subject to the applicable template license.