Money tips

Yearly spending by category: plan next year as a gig worker

Use a yearly spending by category report as a gig worker: total twelve months, split costs of earning from living costs, and plan April to March.

Editorial illustration for Yearly spending by category: plan next year as a gig worker

A yearly spending report by category gives a gig worker something a monthly view cannot: the real size of costs that arrive in lumps, such as vehicle insurance, repairs, phone upgrades and festival months. Total the year, divide by twelve, and you have a monthly figure to plan with that does not flatter your good months.

Why a year, not a month

Your income swings, and so do some costs. A tyre change in June and an insurance renewal in November make two ordinary months look bad and the rest look good. Over twelve months those lumps show up as a steady cost that was always there.

Step one: separate costs of earning from living costs

  • Costs of earning: fuel, vehicle service, data plan used for work, platform fees, phone mount, uniforms
  • Living costs: rent, groceries, family, school, medicine
  • Savings and loan repayments: EMI, emergency fund

Mixing them makes your earnings look smaller than they are and your living costs look larger.

A worked example with made-up numbers

Say your April to March year of costs of earning was: fuel ₹66,000, vehicle service and repairs ₹14,400, insurance ₹5,600, phone and data ₹9,600. Total: 66,000 + 14,400 = 80,400; plus 5,600 = 86,000; plus 9,600 = ₹95,600. Divide by 12: ₹7,966, about ₹8,000 a month. If you had planned only ₹5,000 a month for fuel and nothing for the lumps, you were short by about ₹3,000 a month overall: 7,966 - 5,000 = ₹2,966.

CategoryYear totalPer month
Fuel₹66,000₹5,500
Service and repairs₹14,400₹1,200
Insurance₹5,600₹467
Phone and data₹9,600₹800
Costs of earning₹95,600₹7,967

Per-month figures are rounded: 5,500 + 1,200 + 467 + 800 = ₹7,967.

What do I do with the numbers?

  1. Set aside the per-month figure for costs of earning before spending anything else.
  2. Create a sinking fund for service and insurance so they are paid from saved money.
  3. Compare year totals by category with last year's, if you have it, and note the biggest rise.
  4. Plan next April to March using the real totals plus an allowance for rising prices that you choose yourself.
  5. Review at the halfway point in September.

Where do I get the report?

If you track in a sheet, a SUMIFS over a category column and a date range does the job, for example =SUMIFS($C$2:$C$800, $B$2:$B$800, "Fuel", $A$2:$A$800, ">="&DATE(2025,4,1), $A$2:$A$800, "<"&DATE(2026,4,1)) with amounts in column C, categories in column B and real dates in column A. In SpendixAI, reports and the report builder show spend by category over any period, so you can set April to March and read the totals. It does not know what is a cost of earning unless you give those their own categories.

What if I only have six months of data?

Use it, and say so. Take the six months, double the lumpy items only if you know they come twice a year, and treat the plan as a first draft to revise in October. Say fuel for six months was ₹33,000. A simple scaling gives ₹66,000 for a year, but if the last two months included a festival surge you may want to look at them separately. Where a category swings widely, use the higher of the average and the last three months for planning purposes, and mark it as uncertain. A cautious estimate you revise is better than none.

Before the new year starts

Print or save the year's category totals, pick the two lines that surprised you, and write one rule for each. For example: service fund topped up on the first of each month; fuel reviewed monthly against earnings.

SPENDIXAI JOURNAL

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

Explore your reports