A retiree's monthly cash flow sheet lists money in by source (pension, rent, interest) on one side and spending by group on the other, then shows the difference. Add an expected date and a received date for rent, and the sheet will flag a late month before it upsets the rest of your plans.
How do you set up the credits?
| Source | Expected on | Received on | Amount | Status |
|---|---|---|---|---|
| Pension | 1st | your date | ₹38,000 | On time |
| Rent | 5th | your date | ₹22,000 | Late |
| Interest, averaged | monthly | your date | ₹6,000 | Average of quarterly credits |
The amounts are made up. Interest is often credited quarterly or at maturity, so list it either on the day it arrives or as a monthly average, and say which you chose. Do not mix the two methods in one sheet.
Which formulas flag a late rent?
With the expected date in B2 and the received date in C2, both real dates, these work in Excel and Google Sheets.
- Status in E2: =IF(C2="","Not received",IF(C2>B2,"Late","On time"))
- Days late in F2: =IF(C2="","",MAX(0,C2-B2))
- Money in for a month, with dates in column C and amounts in D, and the first of the month in H1: =SUMIFS($D$2:$D$200,$C$2:$C$200,">="&$H$1,$C$2:$C$200,"<"&EDATE($H$1,1))
A tenant who pays a few days late is common. What matters is a pattern, such as three late months in a row, and the sheet shows that without anyone having to remember.
What does a normal month and a bad month look like?
Take the hypothetical credits above: ₹38,000 plus ₹22,000 plus ₹6,000 is ₹66,000. Say spending is household ₹24,000, medical ₹8,000, society and utilities ₹5,000, domestic help ₹6,000 and travel and gifts ₹7,000, which is ₹50,000. The surplus is ₹16,000.
Now suppose rent does not arrive. Money in is ₹38,000 plus ₹6,000, which is ₹44,000, and spending is still ₹50,000, so the month shows a gap of ₹6,000. If the sheet has a buffer line, you can see how many such months it can absorb and decide when to call the tenant.
A year view helps too. Over twelve months, total each source separately: pension, rent and interest. Seeing that rent is, say, a third of income tells you how much one vacant month, or a tenant who leaves, would hurt. A vacancy of two months between tenants is common to plan for, so keep a line in the sheet for repairs and painting before a new tenant arrives, and total it at year end.
What should you do when rent is late?
- Check your bank statement first, in case the credit came on another date or from another account.
- Call or message the tenant on the day after the expected date, politely.
- Keep a note of every reminder with the date.
- Keep your rent agreement handy for terms on notice and payment.
- If delays continue, speak to a lawyer about the next step.
What about tax on pension, rent and interest?
Rules and limits change, and your position depends on your whole income, so confirm the current treatment with your CA or the official source. For your records, keep the pension certificate, rent agreement, rent receipts and interest certificates in a folder for each financial year, April to March.
Where an expense tracker fits
The credits side is easiest in a sheet. For the spending side, SpendixAI can import your bank and card statements, categorise spending into groups you define, and show monthly reports, so the spending figure in your sheet comes from the statements and not from memory.
A monthly routine
- Enter each credit with its date.
- Check the status column for late rent.
- Total spending from your statements.
- Write the surplus or gap.
- Move any surplus to your buffer, and note it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


