# Dividends

![Partial screenshot of Dividends tab](https://1515266990-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MSuatx32f5nztfqTHft%2F-MSvLwAvf3M4_PrjBFaw%2F-MSvOCQm0cxvbuU6crzQ%2FDividends.png?alt=media\&token=d1f1f694-b198-4592-a3cf-91de033e1009)

<details>

<summary><strong>Manual User Cells:</strong></summary>

&#x20;• Dividend History and 6 respective columns\
&#x20;• Dividend Reinvestment - Dividend Payout frequency\
&#x20;• Dividend Reinvestment - DRP on/off status

</details>

Entering Dividends into the Dividends tab automatically filters through to the ETF, Stock and Managed Funds tab (if applicable). This in turn factors into your *Total Return* and *Dividends* figures ensuring your *total return* figures are accurate.

## Entering a Dividend

To enter a dividend, fill out a new row according to the below:

| Column       | Explanation                                                                                                                                                                    |
| ------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| Payment Date | This is the date that the payment is made to you, either to your Bank or DRP.                                                                                                  |
| Ticker       | This is the Ticker code responsible for the dividend, matched to your Watch table.                                                                                             |
| Holding Type | The category of the dividend (see dropdown).                                                                                                                                   |
| Ex-Dividend  | The date that the fund went ex-dividend. This is used to calculate the yield of the holding. Please see the holding providers announcement or Google search to find this date. |
| Reinvested?  | Yes/No to whether the dividend was reinvested.                                                                                                                                 |
| Net Amount   | The *NET* *after-tax* amount that you were paid.                                                                                                                               |

![](https://1515266990-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MSuatx32f5nztfqTHft%2F-MSvLwAvf3M4_PrjBFaw%2F-MSvO2sYHYsBrYZHujsK%2FDividendHistory.png?alt=media\&token=849e8ca2-c005-4a1c-a372-3445ba951d65)

{% hint style="info" %}
Crypto staking is planned for a future Sheet version.
{% endhint %}

## Dividend Reinvestment Analyser

The Sheet can help you determine and calculate how long it will take for your reinvested dividends to purchase one whole unit. This is based on yields and how often Dividends are paid. \
\
\&#xNAN;*Dividends Freq (m)* refers to how often a particular holding pays Dividends. Please see the holding website for this information. This may be quarterly, annually or twice annually for example. Enter this figure in terms of months (ie. 3,6,12).

![](https://1515266990-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MSuatx32f5nztfqTHft%2F-MSvLwAvf3M4_PrjBFaw%2F-MSvO4v_HUcG2MQZ_TBm%2FDRPSettings.png?alt=media\&token=9799d0e1-c180-4a3c-a742-8cc72c7c15d8)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://guide.cspersonalfinance.io/investments/dividends.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
