You can track dividends and interest in one sheet with six columns: date, source, type, account, amount and financial year. Add a small summary area using SUMIFS to give monthly and yearly totals. This is a records sheet only; it does not work out tax, and it works the same in Excel and Google Sheets.
Which columns does the sheet need?
| Column | Header | What goes in it |
|---|---|---|
| A | Date | The date of the credit on your statement |
| B | Source | Company, fund, bank or deposit name |
| C | Type | Dividend or Interest, spelt the same way every time |
| D | Account | The bank account that received it |
| E | Amount | Rupees credited, as a number without the ₹ sign |
| F | FY start | The year the financial year began, from a formula |
Start in row 2 and keep entries below. Type the labels in column C exactly the same each time, because SUMIFS treats Dividend and Dividends as different words.
How do I fill the financial year column?
The Indian financial year runs April to March. A credit in February 2026 belongs to the year that began in 2025. In F2 write =IF(MONTH(A2)>=4,YEAR(A2),YEAR(A2)-1) and copy it down. April 2025 to March 2026 then all show 2025, which you can read as the year 2025-26.
How do I get monthly totals?
Put the first day of each month you want in column H, starting with H2 as a real date such as 1-Apr-2025. Then in I2 enter the dividends and in J2 the interest.
- I2 (dividends): =SUMIFS($E$2:$E$500,$C$2:$C$500,"Dividend",$A$2:$A$500,">="&H2,$A$2:$A$500,"<"&EDATE(H2,1))
- J2 (interest): =SUMIFS($E$2:$E$500,$C$2:$C$500,"Interest",$A$2:$A$500,">="&H2,$A$2:$A$500,"<"&EDATE(H2,1))
- K2 (both): =I2+J2
- H3 (next month): =EDATE(H2,1), then copy the row down twelve months.
The criteria ">="&H2 and "<"&EDATE(H2,1) catch every date from the first of the month up to, but not including, the first of the next. This avoids the usual mistake of missing credits on the 31st.
What about yearly and per-source totals?
For a year, use the FY start column. In M2, with 2025 typed in L2: =SUMIFS($E$2:$E$500,$F$2:$F$500,L2). For a single source, say a company named in B, use =SUMIFS($E$2:$E$500,$B$2:$B$500,"ABCD Industries"). If you want dividends only for a year, add a second pair: =SUMIFS($E$2:$E$500,$F$2:$F$500,L2,$C$2:$C$500,"Dividend").
A made-up test to check your formulas
Enter three rows: a dividend of ₹600 on 12 August 2025, interest of ₹1,310 on 30 September 2025 and interest of ₹1,240 on 31 December 2025. The yearly total for 2025 should be 600 + 1,310 + 1,240 = ₹3,150, with dividends at ₹600 and interest at ₹2,550. If your sheet says something else, check spellings in column C and that the dates are real dates, not text.
If a bank sends a credit in two parts, for example a dividend with a small separate adjustment, enter them as two rows with the same source name rather than editing one amount. That keeps every row traceable to a line on a statement. A Note column in G is worth adding for anything unusual, such as a reversed credit or a corrected narration.
When does a sheet stop being enough?
If you are typing in dozens of rows from several accounts each year, a sheet starts to cost time. SpendixAI can take the bank statements as PDF, CSV or Excel, let you review rows, and place credits in income categories you create, with reports and a CSV download. Until then, the sheet above is perfectly good.
Sheet habits worth keeping
- Add rows the week the credit lands, not at year-end.
- Keep one tab for entries and another for summaries.
- Never overwrite old rows; add a correction row if a credit is reversed.
- Match the sheet to the statements every quarter.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


