Dividend records are scattered because the money can arrive through four routes: the company's registrar, your broker or depository account, your mutual fund folios and your bank statement. Check each source for the April to March year and collect the results into one sheet, one row per credit.
Where is each kind of dividend recorded?
| Source | What you find there | Good for |
|---|---|---|
| Registrar or company advice | Dividend advice or warrant for shares held with a registrar | Gross amount, record date and any deduction shown |
| Broker report or ledger | Dividend credits for shares held in your demat account | A list of all dividends in one place |
| Depository statement | Corporate action entries for the demat account | Cross-checking what was declared against what you hold |
| Mutual fund statements | Dividend or IDCW payout lines on a folio's transaction statement | Payouts from funds, separate from shares |
| Bank statement | The actual credit with its narration and date | Proof that the money arrived |
Portal names and menus differ, so look in your own account for words like dividend report, ledger, corporate actions or transaction statement. If you cannot find one, ask the broker or registrar what report lists dividends for a date range.
How do I assemble the year, step by step?
- Pick the period: 1 April to 31 March.
- Download the broker's dividend or ledger report for the period.
- Download the fund statements for each folio that pays out, if you hold any.
- Check your bank statement for credits with narrations that mention a company, a registrar or a fund.
- Enter each credit as a row in your sheet and save the proof in the same folder.
What does the sheet look like? A worked example
Create columns for date, company or fund, source, amount credited and proof file. Say your year has three credits: Company X ₹1,200 from the broker report, Company Y ₹850 from a registrar advice and a fund payout of ₹2,000 from a folio statement. These numbers are made up. If the amounts are in column D, rows 2 to 40, the year's total is =SUM($D$2:$D$40), which gives 1,200 + 850 + 2,000 = ₹4,050. To total only the broker lines, with sources in column C, use =SUMIFS($D$2:$D$40,$C$2:$C$40,"Broker report"), which here returns ₹1,200.
Why might the amount credited differ from the amount declared?
Some advices show the amount before any deduction and some show the amount after. A credit that looks lower than the dividend per share times your quantity may be explained by a deduction shown on the advice. Where both figures appear, enter both in the sheet and mark which is which, and ask your CA how they want them treated. If a credit has no explanation on any document, write to the broker or registrar with the date and amount.
What about shares held by family members?
If a parent or spouse holds shares in their own name, their statements and bank credits belong to them. Keep a separate sheet per person, or add a holder column, so the totals never mix. If you operate an account for someone with their permission, never ask for their login details to be shared in messages; ask them to download the report themselves or sit with them while they do it.
Where does an expense tracker come in?
Only for the bank side. If your statements are already imported into SpendixAI, each dividend credit sits under the account it reached, so you can check a row of your sheet against it quickly. The broker and registrar documents remain the proof of what the credit was for.
A tidy-up before the year closes
- Every row has a proof file.
- Dividends from funds and from shares are on separate lines.
- Totals by source add up to the grand total.
- Unexplained credits are listed in a note for the CA.
- The sheet and its proof folder sit in the financial year's folder.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


