Money tips

Calculate your average daily spending, even with irregular gig income

Work out your average daily spending with one division, split fixed from variable costs and use it to judge purchases, with a worked example.

Editorial illustration for Calculate your average daily spending, even with irregular gig income

Your average daily spending is your total spending in a period divided by the number of calendar days in it, and it is more useful when you split fixed costs from variable ones. The variable figure tells you how much a normal day costs, so a purchase can be judged as a number of days of living, not as a vague worry.

Why calendar days and not spending days?

Days when you spend nothing are still days you have to fund. If you divide by only the days you made a payment, the average looks higher and your plan looks harsher than it is. Use every day in the period.

How do you work it out?

  1. Pick a month or a recent 30 days.
  2. Add up total spending, excluding transfers to your own accounts.
  3. Add up the fixed costs: rent, EMIs, insurance, school fees.
  4. Subtract fixed from total to get variable spending.
  5. Divide variable spending by the days in the period.

A worked example with made-up numbers

Say total spending in a 30-day month is ₹31,000, of which rent is ₹9,000 and EMI is ₹4,000.

LineCalculationAmount
Total spendingGiven₹31,000
Fixed costs9,000 + 4,000₹13,000
Variable spending31,000 - 13,000₹18,000
Average per day, all spending31,000 / 30about ₹1,033
Average per day, variable18,000 / 30₹600

A ₹2,400 purchase equals 2,400 / 600 = 4 days of variable spending. That is a clearer way to judge a purchase than saying it feels big.

How do gig workers handle uneven income?

Compare the daily spending with daily earnings for the same period. If you earned ₹35,500 in the month, that is about ₹1,183 per day over 30 days, against ₹1,033 spent. Better still, use your lowest recent month for the earnings side, because that is the one your plan has to survive.

How do you do it in a spreadsheet?

  • Total for a month in cell E1 (first of the month): =SUMIFS($C$2:$C$500,$A$2:$A$500,">="&$E$1,$A$2:$A$500,"<="&EOMONTH($E$1,0))
  • Days in month: =DAY(EOMONTH($E$1,0))
  • Average per day: total divided by days.
  • For variable spending, use SUMIFS with a Type column marking each row Fixed or Variable.

These formulas work in Excel and Google Sheets. When the data comes from several accounts, an expense tracker saves the typing: SpendixAI imports bank and card statements, and its dashboard and insights summarise the period, so you only need the daily division yourself.

How do you check the figure is believable?

Multiply your daily average back up. At ₹600 a day for 30 days you get ₹18,000, which is your variable spending, so the maths closes. Then compare with a second month. If the two daily averages are close, say ₹600 and ₹640, the figure is stable enough to plan with. If they differ by half, look for a one-off in the higher month before you rely on either.

Keep the average in a place you see often, such as the first line of your tracking sheet, and refresh it every month. It takes a minute and turns a purchase decision into a quick sum.

How do you use the number?

  • Judge a purchase in days of variable spending.
  • Set a daily limit slightly below your average for a tight week.
  • Check whether your cash buffer would last a number of days: buffer divided by daily spending.

For example, a ₹12,000 buffer at ₹600 a day lasts 20 days of variable spending, although fixed costs also fall due. Treat it as a rough guide, not a promise.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports