Groceries, rent, fuel, medical bills and clothing all behave differently, so one method will not fit them all. Rent is fixed, groceries are weekly, fuel follows your travel, medical bills come in lumps and clothing is seasonal. To get a true monthly figure, take twelve months for each line, add it up and divide by twelve, instead of looking at one month.
Why do the five lines need different treatment?
| Line | Rhythm | How to get the monthly figure |
|---|---|---|
| Rent | Same every month | Take the agreed amount, and add any maintenance billed separately |
| Groceries | Weekly top-ups plus monthly bulk | Total all shops for the month, including kirana and quick delivery |
| Fuel | Follows how much you drive | Add every fill-up and divide by the months covered |
| Medical | Irregular and sometimes large | Use twelve months and divide by twelve |
| Clothing | Seasonal, peaks at festivals | Use twelve months and divide by twelve |
The first three are steady enough for a three-month look. The last two need the full year, or one big purchase will swing the answer.
A worked example, with made-up numbers
Say a household has these twelve-month totals.
- Rent: ₹18,000 a month, which is 18,000 × 12 = ₹2,16,000 a year
- Groceries: ₹8,500 a month, which is 8,500 × 12 = ₹1,02,000
- Fuel: ₹2,200 a month, which is 2,200 × 12 = ₹26,400
- Medical: ₹14,500 across the year, which is 14,500 ÷ 12 = ₹1,208 a month
- Clothing: ₹18,000 across the year, which is 18,000 ÷ 12 = ₹1,500 a month
The monthly total is 18,000 + 8,500 + 2,200 + 1,208 + 1,500 = ₹31,408, rounded. Notice that medical and clothing look small per month but are not small in the months they hit, which is why the yearly total matters.
How do I count groceries properly?
Groceries leak into several places: the kirana shop paid by UPI, a monthly ration bill paid in cash, a bulk order in the festive season, quick-delivery top-ups, and the vegetable seller who takes cash. Search the statements for each of these, add a note of cash spend each week, and keep receipts for any big shop. If you share shopping with a flatmate or a relative, decide who records what, or the same shop will be counted twice or not at all.
What about fuel and medical?
For fuel, fill-ups are the data points. Note the date and amount each time, and if you want a rate, divide the money by the kilometres driven. For medical, separate the routine, such as regular medicines, from the occasional, such as a consultation or a test. Keep the bills, because insurers and your CA may ask for them. For any question on what is claimable, check the current rules with your CA or the official source.
Which tools save the hunting?
A spreadsheet works if you add one row per spend. A tracker takes the typing out. SpendixAI reads bank and card statements you upload as PDF, CSV or Excel, lets you review the rows, and sorts them into categories you can colour and name, such as Rent, Groceries, Fuel and Medical. Cash entries can be added by hand, several at once. A report by category then gives the twelve-month totals to divide. It does not connect to your bank, so the statements you upload are the source.
Do it for each line
- Rent: confirm the agreed amount and any extras.
- Groceries: add kirana, quick delivery and cash.
- Fuel: add every fill-up and divide.
- Medical: use twelve months, and keep the bills.
- Clothing: use twelve months, and mark festival buys.
- Add the monthly figures to see what your household really needs.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

