Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceInvestment TrackingDividend Income Tracker

SpreadsheetInvestment TrackingFree

Dividend Income Tracker

Forward annual income, yield and yield on cost per holding, plus every payment logged by month.

Shown with sample data

Colour

Dividend Income Tracker

Forward annual income, yield and yield on cost per holding, plus every payment logged by month.

Forward annual income
$1,439
Per month
$119.95
On average
Portfolio yield
2.2%
Received this year
$953.61
Dividends by month
  • Jan$106.08
  • Feb$37.93
  • Mar$172.74
  • Apr$74.40
  • May$6.50
  • Jun$178.14
  • Jul$78
  • Aug$6.50
  • Sep$183.04
  • Oct$110.28
Forward income by holding
  • O$386.4027%
  • VTI$334.9023%
  • JNJ$31222%
  • PG$168.8012%
  • SCHD$151.5011%
  • MSFT$59.764%
  • Other$262%

How to use it

  1. 1List each dividend holding on the Holdings sheet with shares, average cost, current price and annual dividend per share.
  2. 2Log each payment on the Payments sheet as it arrives.
  3. 3Check the By month sheet to see which months pay the most.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

See what your portfolio pays you. Enter each dividend holding with its annual dividend per share and the tracker projects your forward annual and monthly income, yield and yield on cost. Log payments as they arrive to see income by month and how much was reinvested.

Who it’s for

  • Dividend growth investors
  • Planning passive income in retirement
  • Tracking reinvested dividends

What’s included

  • Holdings sheet: Forward income and yield for each holding.
  • Payments sheet: Every dividend payment received.
  • By month sheet: Dividends received in each month of the year.

How to use it

  1. 1List each dividend holding on the Holdings sheet with shares, average cost, current price and annual dividend per share.
  2. 2Log each payment on the Payments sheet as it arrives.
  3. 3Check the By month sheet to see which months pay the most.

Tips

  • Use the annual dividend from the company's latest declaration multiplied by payments per year.
  • Yield on cost grows as companies raise dividends; it rewards holding.

Questions

What is yield on cost?

Annual dividend divided by what you paid per share. It shows the return on your original investment.

Is forward income guaranteed?

No. It assumes current dividends continue; companies can cut or raise them.

Related searchesdividend trackerdividend incomepassive incomeyield on costdividend portfolio

Details

Format
Spreadsheet
Category
Investment Tracking
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetInvestment TrackingFree

Dividend Income Tracker

Forward annual income, yield and yield on cost per holding, plus every payment logged by month.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Investment Tracking
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More investment tracking templates

View all
Investment Portfolio Tracker2 sheets

Portfolio value

$74,144

Unrealised gain

$13,013

Total return

21%

Allocation by asset class
51%
  • US stocks
  • International stocks
  • Bonds
  • Real estate
SpreadsheetInvestment Tracking

Investment Portfolio Tracker

Holdings, gains, allocation by asset class and the exact buys and sells to rebalance to your targets.

10 min setupPreview
Asset Allocation & Rebalancing Planner3 sheets

Portfolio value

$117,300

Classes out of range

2

Largest drift

10%

ABCD
1Asset classTargetCurrent valueCurrent share
2Global equities55%$75,70065%
3Home equities10%$9,8008%
4Bonds20%$17,40015%
5Property5%$6,1005%
Allocation
SpreadsheetInvestment Tracking

Asset Allocation & Rebalancing Planner

Current holdings against your target mix, drift by asset class and the trades that bring you back.

10 min setupPreview
Crypto Portfolio Tracker2 sheets

Portfolio value

$49,891

Unrealised gain

$4,034

Realised gains this year

$1,270

Allocation by coin
48%
  • BTC
  • ETH
  • LINK
  • USDC
SpreadsheetInvestment Tracking

Crypto Portfolio Tracker

Holdings built from your buys, sells and staking rewards, with average cost, unrealised and realised gains, allocation and rebalancing.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ