How to Track Dividends: Methods & Tools

Many investors start tracking dividends in Excel or Google Sheets spreadsheets. It's a valid approach for small portfolios — you have full control over the data and can create custom formulas.

However, as your portfolio grows, problems emerge:

Manual maintenance: Each dividend needs to be entered manually. With 20+ assets paying on different dates, it's easy to miss entries.

No advanced analysis: Spreadsheets don't automatically calculate dividend yield, don't generate projections, and don't make visual comparisons between periods.

Multi-currency: If you invest in Brazil and the US, you need complex formulas to convert and consolidate values.

Specialized apps like PaxMoney solve all these problems. Recording is quick, calculations are automatic, and AI generates forecasts a spreadsheet could never achieve. For anyone with more than 5 dividend-paying assets, switching to an app is practically mandatory.

PaxMoney was designed to make dividend tracking as simple as possible:

Step 1 — Add your assets: Register your stocks, REITs, and ETFs in your portfolio. PaxMoney supports Brazilian, American, and other market assets.

Step 2 — Record dividends: You have two options. Manual entry lets you add one dividend at a time, entering asset, amount, date, and currency. Batch import lets you import multiple dividends at once — ideal when you receive your monthly brokerage statement.

Step 3 — Explore the views: Use the monthly view to see how much you received this month and compare with previous months. Use the annual view to track your passive income evolution over time.

Step 4 — Filter by currency and class: If you invest in BRL and USD, filter to see dividends from each market separately. Filter by asset class to compare stocks vs. REITs.

Step 5 — Use the AI forecast: Access the forecast module to see future dividend projections based on your actual history.