A personal care expense tracker needs just five columns: date, amount, item, category and how you paid. Everything else, including monthly totals and per-person splits, can be calculated from those five. The skill is in making entry so quick that you actually do it, especially for cash at the barber or salon.
Which columns does the tracker need?
- Date of purchase or visit.
- Amount in rupees.
- What it was, in two or three words, such as haircut or face wash.
- Category: Basics, Hair, Skin, Salon, Occasion.
- Paid how: UPI, card, cash.
- Optional: who it was for, if you track more than one person.
Keep the category list short. Five choices are easier to apply consistently than fifteen, and you can always split them later.
What does a sample month look like?
Here is a made-up month to show how the sheet fills in. The figures are invented.
| Date | Amount | Item | Category | Paid |
|---|---|---|---|---|
| 3 Nov | ₹330 | Haircut | Hair | Cash |
| 6 Nov | ₹640 | Shampoo, soap, toothpaste | Basics | UPI |
| 11 Nov | ₹1,150 | Moisturiser and sunscreen | Skin | Card |
| 19 Nov | ₹1,800 | Facial before a wedding | Salon | UPI |
| 24 Nov | ₹260 | Razor refill | Basics | Cash |
The total is 330 + 640 + 1,150 + 1,800 + 260 = ₹4,180. That is higher than a normal month because of the wedding, which is exactly why a separate Occasion or Salon category is useful: you can see that the spike is a one-off.
How do you total each category in Excel or Google Sheets?
Put the amounts in column B, the category in column D, and the category names to total in column G. Then in H2 use:
=SUMIFS($B$2:$B$500, $D$2:$D$500, G2)
Copy it down beside each category name. For one month only, add a date test, with the start of the month in K1 and the start of the next month in K2:
=SUMIFS($B$2:$B$500, $D$2:$D$500, G2, $A$2:$A$500, ">="&$K$1, $A$2:$A$500, "<"&$K$2)
This works in Excel and Google Sheets alike. The date column must hold real dates, not text, or the comparison will silently match nothing.
When does a spreadsheet stop being enough?
A sheet is fine for one person with a few dozen rows. It gets tiring when you want to bring in a whole bank statement every month, tag hundreds of rows and keep receipts attached. At that point an app that reads statements helps: SpendixAI lets you upload a PDF, CSV or Excel statement, review the rows, apply your own categories, and add cash spending by hand. Receipts can sit beside their transactions too.
Can you track personal care for the whole family?
Add a Who column and use a second SUMIFS with that column as another criterion. You will quickly see, for example, that one person's skincare is most of the category, which is useful to know before arguing about it.
What if you pay the salon by UPI?
UPI payments to a salon or barber arrive on your statement with a payee name or handle, not the word haircut. The first time, categorise the row as Salon or Hair and add a rule or alias for that payee, so the next visit labels itself. If the owner uses a personal handle that also receives money from friends, check the amount before trusting the rule: a ₹330 payment is a haircut, a ₹2,500 payment may be something else entirely.
Keep one column for notes. Writing a short reason next to the ₹1,800 facial is what lets you explain November's spike in December, and it costs you three seconds.
Monthly routine in five minutes
- Import or paste the month's statement.
- Mark each grooming row with its category.
- Add the cash items.
- Read the five totals.
- Write one line about anything unusual, so next month's you remembers why November was high.
Useful ideas start with a clearer picture of your own spending.
Explore your reports