Log each annuity credit as income under a pension-or-annuity label, on the date it reaches your account, with the amount as credited. Then compare it with the previous month. The money you paid to buy the annuity is a different thing, a one-time movement of savings, and it should not sit in this income line.
Where does an annuity belong among income labels?
Keep it apart from salary, rent and interest. A label such as Pension and annuity, or simply Annuity, is enough. If you have more than one policy or payer, add the provider's name in the note so you can see which credit came from which. Do not mix in a lump-sum payout or the return of a premium, which are not regular income and need their own label.
What should each entry contain?
- Date credited, from the statement.
- Amount credited, in rupees, as it appears.
- Provider or policy name in a note.
- Account that received it.
- Any reference or narration worth keeping.
How do I check the date and the amount?
Your annuity papers state how often it is paid and the amount. Write the expected date and amount in a row of your sheet and put the actual credit beside it. Say the expected annuity is ₹18,400 and one month the credit is ₹16,560. The difference is 18,400 − 16,560 = ₹1,840. Something changed: a deduction, an adjustment, or a payment in two parts. Look at the provider's statement of the payment or ask the provider through its official channel before assuming a mistake. Rules about deductions change, so confirm the current position with your CA or the official source.
| Month | Expected (₹) | Credited (₹) | Difference (₹) |
|---|---|---|---|
| January | 18,400 | 18,400 | 0 |
| February | 18,400 | 18,400 | 0 |
| March | 18,400 | 16,560 | 1,840 |
| April | 18,400 | 18,400 | 0 |
How do I compare months in a sheet?
With expected in B2 and credited in C2, the difference is =B2-C2. To flag any month that is off, use =IF(B2<>C2,"Check",""). To see how many days late a credit was, put the expected date in D2 and the credit date in E2 and use =E2-D2. Total the year with =SUM(C2:C13). These work in Excel and Google Sheets.
What if it pays quarterly or yearly instead of monthly?
Then your income line is lumpy, like savings interest. Record it on the day it arrives and, for planning, divide the year's credits by twelve to see the monthly equivalent. Keep both views, as the credit date is what the bank shows and the average is what you plan with.
How does this work in a tracker?
After you import the statement, SpendixAI shows the annuity credit among the rows and you can place it in an income category you create. Because corrections become history, the same payer's credit is usually suggested correctly next month. The weekly summary and reports help you see whether income has arrived; the expected figure stays in your own notes.
Keep the purchase of the annuity apart from the credits. If you paid ₹20,00,000 from savings to buy it, that was one outflow of your own money and belongs under savings or transfers. The monthly credits are what you receive afterwards. Do not net one against the other in your head. How each credit is treated for tax depends on rules that change, so ask your CA or the official source.
A short checklist
- Create one label for annuity income and use it every time.
- Record the first credit with the policy name in a note.
- Compare each month with the expected amount.
- Keep the provider's yearly statement with your records.
- Ask the provider or your CA about anything that does not match.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

