To track a retirement drawdown, record every withdrawal with its date, the balance left afterwards, and a months-covered figure that divides the balance by your recent average withdrawal. Three columns and one formula give you a picture of how long the money lasts at your current pace, which is the number worth looking at each month.
What columns does the log need?
- Date of the withdrawal, as it appears on the statement.
- Amount withdrawn, in rupees.
- Balance after, taken from the statement or deposit record, not from memory.
- Months covered, calculated from the other two.
- Note: the reason for any unusual withdrawal, such as a hospital bill or a family wedding.
A made-up example
Say you start with ₹30,00,000 set aside for withdrawals and take out ₹40,000 a month. For simplicity this example ignores interest, which your real balance will include. The table shows the first six months.
| Month | Withdrawn (₹) | Balance after (₹) |
|---|---|---|
| 1 | 40,000 | 29,60,000 |
| 2 | 40,000 | 29,20,000 |
| 3 | 55,000 | 28,65,000 |
| 4 | 40,000 | 28,25,000 |
| 5 | 40,000 | 27,85,000 |
| 6 | 40,000 | 27,45,000 |
The third month included a one-off ₹15,000 withdrawal, so the six withdrawals total 40,000 × 5 + 55,000 = ₹2,55,000 and the balance is 30,00,000 − 2,55,000 = ₹27,45,000. The one-off is exactly why the note column matters.
How do I work out months covered?
Divide the balance by the average of recent withdrawals. With the balance in C7 and the six withdrawals in B2:B7, the formula is =C7/AVERAGE(B2:B7). Here the average withdrawal is 2,55,000 ÷ 6 = ₹42,500, so months covered is 27,45,000 ÷ 42,500 ≈ 64.6. If you leave out the one-off and use ₹40,000, it is about 68.6 months. The two answers differ, and showing both is more honest than showing one.
How does this fit into a wider monthly record?
A withdrawal from savings to the spending account is a transfer, not income, so label it that way. Otherwise your income looks larger than it is, and the pace of drawdown is hidden. In SpendixAI you can import both accounts' statements, mark the withdrawal as a transfer, and use the report builder to filter by that category. The months-covered calculation stays in your sheet.
How should I treat a big one-off withdrawal?
A hospital bill, a home repair or a family wedding can be many times your normal monthly figure. Record it in the same log with a clear note, but exclude it from the average you use for months covered, and show both versions side by side. If you leave it in, one ₹3,00,000 expense makes next year's monthly average look ₹25,000 higher and makes your runway seem shorter than your everyday life warrants. If you leave it out and forget it, the balance still falls. Seeing both numbers keeps you honest.
What should I review every quarter?
- Total withdrawn in the last three months compared with the plan.
- Months covered with and without one-off items.
- Whether the withdrawal amount still matches actual spending.
- Whether any other income, such as a pension or rent, has changed.
- The balance on the statement against your sheet.
To see how sensitive the answer is, raise the withdrawal and rerun it. If you moved from ₹40,000 to ₹50,000 a month, the same ₹27,45,000 balance would last 27,45,000 ÷ 50,000 = 54.9 months instead of about 68.6. A ten-thousand-rupee habit change costs nearly fourteen months of cover, which is the kind of trade-off worth knowing before you make it.
When to ask for help
If the months-covered figure drops quickly from one quarter to the next, if medical costs are climbing, or if you are unsure how withdrawals are taxed, speak to a CA or a fee-only adviser with your log in hand. A dated list of real withdrawals makes that meeting short and useful.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

