If your income changes every month, plan your EMIs against your weaker months, not your average. A simple method: take the lowest three of the last twelve months as your planning base, keep a reserve equal to about two EMIs, and watch a rolling twelve-month average to see the real trend. This is a personal planning method, not a lender rule.
Why not just use the average?
The average blends good and bad months, but EMIs are due in both. A freelancer who earned ₹90,000 in July and ₹33,000 in October still owes the same instalment in October. Planning on the average means the weak months are always a problem. Planning on the weak months means the strong months are a bonus.
What does a year of irregular income look like?
Here is an invented twelve months for a freelancer, April to March.
| Month | Income (₹) | Month | Income (₹) |
|---|---|---|---|
| Apr | 62,000 | Oct | 33,000 |
| May | 38,000 | Nov | 80,000 |
| Jun | 55,000 | Dec | 58,000 |
| Jul | 90,000 | Jan | 45,000 |
| Aug | 41,000 | Feb | 66,000 |
| Sep | 70,000 | Mar | 52,000 |
The total is ₹6,90,000, so the plain average is 6,90,000 ÷ 12 = ₹57,500. The lowest three months are October (33,000), May (38,000) and August (41,000), which add to ₹1,12,000, giving a planning base of about ₹37,333.
How do I set the planning base and the reserve?
Say EMIs total ₹14,500 a month (for example a ₹9,000 vehicle loan and a ₹5,500 personal loan). Against the planning base of ₹37,333 that is about 38.8%. Against the average of ₹57,500 it is about 25.2%. The first number is the honest one for a lean month.
The reserve should cover about two EMIs, here 2 × 14,500 = ₹29,000. Fill it first from good months, and spend from it only for EMIs when income falls short. Once it is full, extra income can go elsewhere.
- Planning base: =(SMALL(B2:B13,1)+SMALL(B2:B13,2)+SMALL(B2:B13,3))/3
- Rolling twelve-month average: =AVERAGE(B2:B13) (replace the range each month by the latest twelve)
- Reserve target: =2*C16, where C16 holds total EMIs
- EMI share of the planning base: =C16/B16, where B16 holds the planning base
What do I do in a good month and in a lean month?
In a strong month like July, pay the EMIs, living costs and tax set-aside first, then top up the reserve until it reaches ₹29,000, and only then spend on extras. In a lean month like October, the income of ₹33,000 covers EMIs of ₹14,500 and leaves ₹18,500 for living costs; if that is not enough, draw from the reserve, and top it up when income recovers.
How do I track it without spending hours?
Log income on the day it arrives in one place, with the client or source. Once a month, update the sheet and look at three numbers: the planning base, the rolling average and the reserve balance. SpendixAI is an expense tracker rather than an income planner, so use it for what leaves your account: import statements, categorise EMIs and living costs, and compare against your sheet. Use the Free plan's dashboard and insights to see the monthly pattern.
How long can the reserve last?
Test it with a bad stretch. Say living costs are ₹20,000 a month, so a month needs 14,500 + 20,000 = ₹34,500 before any extras. If two lean months bring in ₹25,000 and ₹30,000, the gaps are 9,500 and 4,500, a total draw of ₹14,000 from the ₹29,000 reserve. That leaves ₹15,000, so you got through without missing an EMI, but the reserve now needs rebuilding before you spend freely again.
When should I think twice about another EMI?
If the planning base falls, or the reserve is regularly drawn down and not refilled, a new EMI will make lean months harder. Run the same numbers with the new instalment before agreeing to it, and speak to your lender early if payments become difficult.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

