When income varies from month to month, work out your savings rate on totals: add six months of income, add six months of spending, subtract, and divide the difference by the income total. Averaging six separate monthly percentages gives a different and usually misleading answer. In the made-up freelance run below, the totals method gives 28% while the average of the monthly rates gives about 13%.
Why does averaging monthly percentages go wrong?
A monthly rate is savings divided by that month's income. In a thin month, a small shortfall becomes a huge negative percentage, and in a fat month a decent surplus becomes a big positive one. When you then average the percentages, a ₹24,000 month counts exactly as much as a ₹90,000 month even though it carried far less money. June alone shows the problem: its -58.3% on a ₹24,000 income drags the average down by 9.7 points (-58.3 ÷ 6) all by itself. The total method weights every rupee equally, which is what you want, because you are asking how much of all the money that came in was kept.
What do six irregular months look like?
| Month | Income | Spending | Saved | Monthly rate |
|---|---|---|---|---|
| April | ₹48,000 | ₹40,000 | ₹8,000 | 16.7% |
| May | ₹90,000 | ₹44,000 | ₹46,000 | 51.1% |
| June | ₹24,000 | ₹38,000 | -₹14,000 | -58.3% |
| July | ₹70,000 | ₹46,000 | ₹24,000 | 34.3% |
| August | ₹36,000 | ₹41,000 | -₹5,000 | -13.9% |
| September | ₹82,000 | ₹43,000 | ₹39,000 | 47.6% |
| Six-month total | ₹3,50,000 | ₹2,52,000 | ₹98,000 | 28.0% |
The totals row: income ₹3,50,000 minus spending ₹2,52,000 is ₹98,000, and ₹98,000 ÷ ₹3,50,000 is exactly 28%.
Now average the six monthly rates instead: 16.7 + 51.1 - 58.3 + 34.3 - 13.9 + 47.6 = 77.5, and 77.5 ÷ 6 is about 12.9%. Two methods, two answers, and only the first describes what happened to your money across the half-year.
How do you set it up in a sheet?
Put income for the six months in B2:G2 and spending in B3:G3. The six-month savings rate is =(SUM(B2:G2)-SUM(B3:G3))/SUM(B2:G2), formatted as a percentage. To keep the figure current, build a rolling version: each month, shift the range forward by one column so the window always covers the latest six months. A twelve-month window is better still if your work is seasonal, since six months can catch only the busy or only the quiet half.
How should you treat tax money and business costs?
- If you set money aside for tax, decide once whether that counts as spending or saving and keep the same rule. Which treatment is appropriate for you is a question for your CA.
- Keep business costs, such as software or a co-working desk, out of personal spending, otherwise the rate mixes two things. If the same account carries both, give business outflows their own category and exclude them.
- Count income when it arrives, not when you invoice. A payment that slips a month moves your figure, which is one more reason to use a long window.
What can you do when a month is negative?
June and August were negative, and that is normal in irregular work. The question is whether the buffer built in good months covers the thin ones. In the example, the two bad months cost ₹19,000 in total (₹14,000 plus ₹5,000) while the four good months saved ₹1,17,000, so the buffer was comfortable. Check yours by adding the negative months over the last year; if your buffer is smaller than that sum, a longer dry patch would hurt.
Quick routine
- At month end, record income received and total spending.
- Keep a running six-month window of both rows.
- Compute the savings rate on the window totals.
- Once a quarter, list the negative months and compare with your buffer.
With statements imported into SpendixAI, monthly outflow totals come from reports, which leaves you to add the income side.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


