How to track dividends in Portfolio Slicer

Overview

Dividends can have a major effect on portfolio performance, so it is important to decide early how you want to track them in Portfolio Slicer.

In this guide, the word “dividends” is used broadly to include dividends and other investment distributions.

Two Main Approaches

Portfolio Slicer supports two broad approaches:

  • generated dividends based on Dividends.csv
  • manually entered dividend-related transactions

Both approaches can be useful, but they serve different needs.

Generated Dividends

Generated dividends use data from Dividends.csv.

Portfolio Slicer can combine:

  • dividend-per-share data from the file
  • your historical holdings

That allows the workbook to estimate dividend amounts received over time.

Generated dividends example

When Generated Dividends Work Well

Generated dividends are most useful when:

  • your Dividends.csv data is accurate
  • you mostly buy and hold investments
  • you want a practical income estimate without entering every dividend manually
  • you are analyzing hypothetical portfolios

Limitations of Generated Dividends

Generated dividends are not perfect.

Important limitations include:

  • results depend on the quality of Dividends.csv
  • special distributions such as return of capital or notional distributions are not fully represented by simple dividend-per-share files
  • DRIP scenarios are not always handled the way a fully manual transaction record would handle them
  • migration to v3.x from older version should be checked for current version-specific dividend limitations

Manual Dividend Entry

Manual entry is more work, but it gives you tighter control and better alignment with brokerage or bank statements.

This is usually the better approach when:

  • you want exact transaction-level tracking
  • you care about tax-sensitive distributions
  • you need to track return of capital or notional distributions correctly
  • your external dividend source is incomplete or unreliable

Typical Manual Dividend Workflow

You may use dividend-related transaction types such as:

  • Div
  • DivTA
  • DRIP
  • ReturnOfCapital
  • NotionalDistrib

The exact mix depends on what kind of distribution you are recording.

Manual dividend transaction example

Dividend transaction example

DRIP

A DRIP reinvests the distribution into additional units.

In practice, DRIP handling is more accurate when it is recorded as transactions rather than assumed only from generated dividend data.

Return of Capital

Return of capital distributions reduce cost basis.

If you track cost basis, these adjustments are important and usually need to be entered manually.

This kind of distribution is often reported after year end and may need adjustment entries to reflect the final tax treatment correctly.

Return of capital example

Notional or Reinvested Distributions

Notional distributions do not necessarily create cash received in the account, but they can still affect cost basis and tax reporting.

These also usually require manual treatment if you want accurate cost basis behavior.

Notional distribution example

Practical Recommendation

A good practical approach is:

  • use generated dividends if you want easier setup and approximate income tracking
  • use manual entries if you need exact tracking or tax-sensitive adjustments
  • manually handle return of capital and notional distributions when cost basis matters
  • review broker or fund year-end statements for distribution reclassifications