Expense Guide - Lakshmi Personal Finance Assistant
Overview
Guide for logging, categorizing, and tracking all expenses for Vignesh's personal finance management. Use standardized categories with Tamil language tags to ensure consistent classification across all time periods.
Primary Expense Categories (13)
1. Food / Saapadu (உணவு)
Daily food and beverage expenses including groceries and eating out.
- Groceries: Vegetables, fruits, grains, dairy, pantry items from supermarkets (Reliance, Lulu, local vendors)
- Swiggy/Zomato: Online food delivery orders
- Restaurants & Cafes: Dining out, dine-in at restaurants
- Chai/Coffee: Daily tea, coffee, and beverages
- Office Lunch: Lunch at workplace or near office
- Bakery: Bread, cakes, baked goods
2. Transport / Pokkuvarathu (போக்குவரத்து)
All transportation-related expenses.
- Ola/Uber/Rapido: Ride-sharing services
- Auto Rickshaw: Local auto transport
- Fuel: Petrol/Diesel for personal vehicle
- Public Transport: Bus, metro, train fares
- Parking: Parking fees for vehicle
- Vehicle Maintenance: Servicing, repairs, spare parts
3. Shopping
Non-food retail purchases excluding groceries.
- Amazon/Flipkart: Online shopping
- Apparel: Clothes, shoes, accessories
- Electronics: Mobile, laptop, peripherals
- Home Goods: Household items, furniture
- Personal Items: Toiletries, cosmetics
4. Bills
Utility and regular payment obligations.
- Electricity: Power bill (if paying separately)
- Water: Water bill
- Internet/Mobile: Phone bill, broadband subscription
- Insurance Premiums: Health, vehicle, home insurance
- Rent: Monthly rent (if not part of major expense)
- Society/HOA: Housing society maintenance charges
5. Health / Udal Nalam (உடல் நலம்)
Medical and healthcare-related expenses.
- Doctor Consultation: Clinic visits, consultations
- Medicines: Pharmacy purchases, medications
- Dental: Dental checkups and treatments
- Gym/Sports: Gym membership, fitness classes
- Hospital: Hospital stays, major treatments
- Medical Tests: Lab tests, diagnostics
6. Entertainment / Pozhuthu Pokku (பொழுது போக்கு)
Leisure and entertainment spending.
- Movies: Cinema tickets
- Streaming: OTT subscriptions (Netflix, Prime, Disney+)
- Books: Books and audiobooks
- Games: Gaming subscriptions, in-app purchases
- Events/Concerts: Ticket purchases
- Hobbies: Art supplies, musical instruments
7. Education / Kalvi (கல்வி)
Learning and educational expenses.
- Courses: Online courses, certifications
- Tuition: Private tutoring, coaching
- Books: Textbooks and reference materials
- Exam Fees: GATE, competitive exam registration
- Coaching Classes: Engineering, UPSC preparation
8. Personal Care
Personal grooming and wellness.
- Saloon/Haircut: Haircut, salon services
- Spa: Massage, spa treatments
- Personal Grooming: Shaving supplies, beauty products
- Tailoring: Stitching, alteration services
9. Gifts / Koduppu (கொடுப்பு)
Gifts and charitable giving.
- Gifts for Friends/Family: Birthday, wedding gifts
- Charity/Donations: Charitable contributions
- Occasions: Festival gifts, returns gifts
10. EMI & Loans / Kadan (கடன்)
Loan and credit obligations.
- Home Loan EMI: Monthly mortgage payments
- Car Loan EMI: Vehicle loan installments
- Personal Loan EMI: Personal loan payments
- Credit Card Payment: Credit card bill payment
- Interest: Additional interest charges
11. Insurance
Insurance-related payments (if separate from Bills).
- Health Insurance: Mediclaim premium
- Term Insurance: Life insurance premium
- Vehicle Insurance: Motor insurance
- Home Insurance: Property/home insurance
- Travel Insurance: Travel coverage
12. Investments / Mudhaleedu (முதலீடு)
Investment and wealth-building expenses.
- Mutual Funds: SIP/lump sum MF investments
- Stocks: Direct equity purchases
- FD/RD: Fixed deposits, recurring deposits
- PPF: Public Provident Fund contributions
- NPS: National Pension Scheme payments
- Gold: Gold purchase (physical, ETF)
- ELSS: Tax-saving mutual funds
13. Miscellaneous / Mattavai (மற்றவை)
Other expenses that don't fit categories.
- Laundry: Dry cleaning services
- Repairs: Home repairs, maintenance
- Subscriptions: Other subscription services
- Miscellaneous: Other expenses
Payment Methods Tracking
Always record the payment method used:
- Cash: Direct cash payment
- UPI: Google Pay, PhonePe, Paytm, BHIM
- Credit Card: Name of card issuer
- Debit Card: Bank name
- Net Banking: Direct bank transfer
- Wallet: Digital wallet systems
- Cheque: Check payment (rare)
Recurring Expenses Handling
Monthly Recurring
Identify and mark recurring expenses (marked as "Recurring: Yes"):
- Rent/Housing
- Internet/Mobile bill
- Insurance premiums
- Gym membership
- Streaming subscriptions
- Office food subscriptions
Quarterly/Annual Recurring
- Insurance premium renewals
- Vehicle registration
- Domain renewals
- Tax payments
Tracking Method
When logging recurring expense first time:
- Note the frequency (Monthly/Quarterly/Annual)
- Set reminder for next payment
- Track variations in amount if applicable
Split Expenses
When expense is shared with others:
- Log full amount with category and note "Split: Yes"
- Add participant names (e.g., "Split: Raj, Priya")
- Percentage split (e.g., "33.33% each", "50-50")
- Your amount to be paid separately if tracked
- Example: Dinner bill ₹3000, split 3 ways = ₹1000 per person
Smart Categorization Rules
Apply these rules for common merchants and transactions:
- Amazon: Shopping (break down by type: Electronics, Apparel, Home)
- Swiggy/Zomato: Food → Eating Out
- Ola/Uber: Transport → Ride-sharing
- UPI to Restaurant: Food → Restaurants
- Bill Payment Online: Bills → specific utility
- Amazon Prime: Entertainment → Streaming (if not shopping)
- Gym App: Health → Gym/Sports
- Nykaa/Flipkart Beauty: Shopping → Personal Items or Personal Care
- BookMyShow: Entertainment → Movies
- HDFC Bank Salary Credit: Income (not expense)
Monthly Expense Excel Format
Create spreadsheet with these columns:
| Date | Amount (₹) | Category | Subcategory | Description | Payment Method | Tags | Notes |
|---|---|---|---|---|---|---|---|
| 01-03-2026 | 450 | Food | Groceries | Weekly veggies | Cash | Saapadu | DMart |
| 02-03-2026 | 250 | Transport | Uber | Office commute | UPI (GPay) | Pokkuvarathu | |
| 03-03-2026 | 1200 | Shopping | Apparel | T-shirts | Credit Card | Amazon | |
| 04-03-2026 | 5000 | Food | Restaurants | Dinner | Debit Card | Saapadu | Marriott |
| 05-03-2026 | 800 | Health | Doctor Consultation | GP visit | Cash | Udal Nalam | Clinic |
Data Quality Rules
- No missing categories: Always assign primary category
- Consistent spelling: Use exact category names from list above
- Payment method required: Must specify how paid
- Description clarity: Brief but descriptive (not "misc" or "shopping")
- Date format: DD-MM-YYYY consistent
- Amount format: Numbers only, no currency symbol in sheet
Monthly Review Checklist
- All expenses logged with categories
- Payment methods recorded
- Recurring expenses verified
- Split expenses calculated correctly
- No duplicate entries
- Total matches bank/card statements
- Category distribution analyzed