Tracking your dividends doesn’t have to be complicated. Our free dividend tracker spreadsheet keeps everything organized and makes it easy to monitor your portfolio. Perfect for both new and experienced investors, this tool simplifies the whole process.
Step 1: Download the Template
You can download the free dividend tracker spreadsheet in Excel or Google Sheets format. Simply click the download button and get started.
Step 2: Input Your Stock Information
Enter your stock symbols, the number of shares you own, and purchase prices. The spreadsheet will pull in current dividend yields and stock prices.
Step 3: Customize to Your Needs
Want to track more metrics? Add custom formulas, rearrange data, or adjust the design to suit your style.
Step 4: Automate Data Updates
Link the tracker to Wisesheets’ data sources for real-time updates on stock prices and dividends, ensuring your data is always current.
This tracker is perfect for all types of investors:
"The Dividend Tracker Spreadsheet has been a game-changer for my investment tracking. It’s so easy to use and helps me stay on top of my portfolio’s performance and dividend payments. The automatic updates feature has saved me hours of manual work."
— Emily C, Long-Term Investor
"I’ve tried many tools to manage my dividends, but this spreadsheet is by far the best. The design is intuitive, and the insights I get on yield, growth, and reinvestments have really helped me make smarter decisions. Highly recommended!"
— James A, Dividend Growth Enthusiast
"I used to struggle with tracking my income from dividends across multiple stocks, but with this spreadsheet, it’s all in one place. I can see exactly how much I’m earning, and the performance overview is incredibly helpful. Fantastic tool!"
— Sophia L, Retired Income Investor
How do I set up the dividend tracker spreadsheet?
It’s easy! Download the template, input your stocks, and watch as the tracker calculates your dividends automatically. Customize it as needed.
Can I track multiple portfolios?
Yes! You can use separate tabs to track dividends from different portfolios, all within the same spreadsheet.
How often should I update my dividend tracker spreadsheet?
With Wisesheets’ automatic updates, you can update the data every time you like using the fresh data button of the add-on.
Do I need a Wisesheets account?
The dividend tracker spreadsheet is free to use, but if you want automatic updates for historical data, you’ll need a Wisesheets account.
Stock Analysis Tool
Roaring Kitty-inspired sheet, charts, DCF template, and a ratio analysis sheet.
Earnings Power Value Model
Step-by-step earnings power value model calculation.
Simple DCF
A simple DCF to quickly assess the value of a company.