A single big purchase, such as a new phone, a vehicle repair or an annual insurance premium, can make one month look wildly expensive and distort the average. To see your real monthly spending, put one-offs in their own category, compare months with and without them, and use a median or a trimmed average instead of a plain average.
Why one purchase misleads
Averages are pulled by large values. If a gig worker spends around ₹28,000 in a normal month and then pays ₹30,000 for a bike service and tyres in one month, the average over three months jumps even though daily life did not change. The trend you want to see is hidden inside the spike.
A worked example with made-up numbers
| Month | Total spent in rupees | Of which one-off in rupees | Regular in rupees |
|---|---|---|---|
| August | 27,500 | 0 | 27,500 |
| September | 28,200 | 0 | 28,200 |
| October | 58,300 | 30,000 | 28,300 |
The plain average of the three months is (27,500 + 28,200 + 58,300) / 3 = 38,000. The average of regular spending is (27,500 + 28,200 + 28,300) / 3 = 28,000. A plan built on the first figure would suggest you are spending ₹10,000 a month more than you are. The one-off of ₹30,000 deserves its own line, perhaps spread across a year as a sinking fund of ₹2,500 a month.
Three ways to see the real number
- Separate category: tag big non-recurring items as One-off and report them apart.
- Median: the middle month, which ignores a single extreme value.
- Average of rows under a threshold: removes large rows from a row-level average.
In a sheet with monthly totals in B2:B13, the median is =MEDIAN(B2:B13). For a row-level average that ignores amounts of ₹20,000 or more, with amounts in C2:C500, use =AVERAGEIF($C$2:$C$500, "<20000"). Both work in Excel and Google Sheets.
How do I find the outliers first?
Sort the month's transactions by amount, largest first, and read the top ten. Anything unusual in size is a candidate. A tracker's dashboard and insights views can help you spot the biggest spends of a period, and SpendixAI offers both, but check the numbers they show against the rows themselves.
Plan for the one-offs you can see coming
- List the irregular costs of the last year: insurance, vehicle service, school fees, festival spending, travel.
- Add them up and divide by 12.
- Move that sum into a separate account each month.
- When the bill arrives, pay it from that account.
- Your regular monthly spending then stays steady.
An example of a sinking fund
Say your irregular costs for the year are a ₹9,000 vehicle insurance premium, ₹12,000 for two services, ₹6,000 for tyres and ₹3,000 for a festival trip home. Together that is 9,000 + 12,000 + 6,000 + 3,000 = ₹30,000. Divided by 12, it is ₹2,500 a month. Set that aside every month and the bill, when it comes, is paid from money you were already treating as spent. Your regular monthly figure then stays near ₹28,000 plus ₹2,500, which is ₹30,500, a number you can plan around.
Gig income makes the regular figure doubly important, because your earnings also swing from week to week. Compare the regular spending number with your lowest earning month of the last six, not your best one. If regular costs of ₹30,500 sit close to a thin month's income, there is little room for a one-off, and that is worth knowing before the next big bill rather than after it.
A closing check
Once a quarter, compare the regular average, the one-off total and your income. If one-offs are large every quarter, they are not really one-offs and should be planned for as regular costs.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

