---
title: Free Dividend Reinvestment Tracker Spreadsheet (Step‑by‑Step)
siteUrl: https://logzly.com/dividendtracker
author: dividendtracker (Dividend Spreadsheet Hub)
date: 2026-07-11T23:00:36.516956
tags: [dividend_reinvestment, spreadsheet_tracker, finance_tools]
url: https://logzly.com/dividendtracker/free-dividend-reinvestment-tracker-spreadsheet-stepbystep
---


**Disclosure: We are reader supported, and earn affiliate commissions when you buy through us.**


**Stop guessing how your dividend drip compounds** – this guide shows you exactly how to build a **[dividend reinvestment](https://www.amazon.com/s?k=dividend+reinvestment&tag=organizationtip101-20) tracker spreadsheet** in minutes, with a ready‑made template you can download for free. Follow the step‑by‑step instructions, copy the formulas, and watch your share count grow automatically.

## Why Most Dividend Trackers Fail

Most DIY trackers become a nightmare of extra tabs, nested IF statements, and manual copy‑pastes. The result? **Time‑consuming errors** and a spreadsheet you avoid opening. The key is to strip the tracker down to five core columns and let two simple formulas do the [heavy lifting](https://www.amazon.com/s?k=heavy+lifting&tag=organizationtip101-20).

## How to Build a Dividend Reinvestment Tracker Spreadsheet

1. **Create a new sheet** – open [Google Sheets](https://www.amazon.com/s?k=Google+Sheets&tag=organizationtip101-20) (auto‑save, mobile‑ready) or Excel.  
2. **Paste the header row** into A1:E1:

| Date | Dividend Amount | [Share Price](https://www.amazon.com/s?k=share+price&tag=organizationtip101-20) | Shares Bought | Total Shares |
|------|----------------|------------|--------------|--------------|

3. **Enter your first dividend** in row 2:  
   - *Date*: when the cash arrived.  
   - *Dividend Amount*: the cash received (e.g., **$50**).  
   - *Share Price*: [stock price](https://www.amazon.com/s?k=stock+price&tag=organizationtip101-20) on that date (e.g., **$25**).  

   In **Shares Bought** (D2) type: `=B2/C2` (**Dividend Amount ÷ Share Price**).  

4. **Calculate the running total**:  
   - In **Total Shares** (E2) enter `=D2`.  
   - In E3 (and all rows below) enter `=E2+D3` and drag down.  

   These two formulas automatically update as you add new dividends.

5. **Optional: Show dollar value** – add a column **Value** with `=E2*C2` (Total Shares × Share Price). Update the Share Price column for a fresh snapshot.

**Tip:** Freeze the header row (View → Freeze → 1 row) so column titles stay visible while you scroll.

## Add Insightful Extras (No Extra Cost)

- **Growth %** – insert a column and use `=(E3-E2)/E2` to see the percentage increase in total shares after each payout.  
- **[Conditional formatting](https://www.amazon.com/s?k=conditional+formatting&tag=organizationtip101-20)** – highlight rows where the dividend amount exceeds a threshold, making big payouts pop out instantly.  
- **Bold the header row** for instant visual reference.

## Download the Ready‑Made Template

Skip the copy‑paste step and download the **free dividend reinvestment spreadsheet template** with all headers and formulas pre‑filled. [Download here] (link placeholder).

## Wrap‑Up

You now have a **free, automated dividend reinvestment tracker spreadsheet** that turns raw cash numbers into a clear visual of compounding growth. Plug in your data, watch the totals climb, and finally see how your dividend drip builds wealth over time.

Enjoy the tracker? Subscribe for more no‑fluff finance hacks, and share this guide with anyone who could use a simple, cost‑free solution.