Business

Expense tracker for a PG owner in India: what to record

An expense tracker for a PG owner in India: the real cost lines, which are business and which personal, a category list and a simple monthly routine.

Editorial illustration for Expense tracker for a PG owner in India: what to record

A PG owner's tracker needs to answer one question every month: after the rent comes in, how much is left once the building, the kitchen and the staff are paid? Record rent collected, deposits held, and each cost line under a handful of fixed categories, and you can answer it in ten minutes.

The cost lines of a paying-guest business

A PG is a service business: tenants pay for a bed, and often meals, wifi and laundry too. That means your costs are more like a small hotel than a rental flat. Start by listing everything you pay for so a bed stays usable, and then draw a line between those costs and your family's household spending.

A category list of ten that fits most PGs

CategoryWhat goes inBusiness or personal?
Building rent or loanRent you pay for the premises; loan instalments if you own itBusiness, but ask your CA how to treat the principal part of a loan
Kitchen and groceriesRice, vegetables, milk, oil, teaBusiness for the mess; your family's own groceries are personal
Cooking gasCylinders, stove repairBusiness if it feeds the mess
StaffCook, helper, caretaker, night watchmanBusiness
Electricity and waterCommon meter, motor, water tankerSplit if the family shares the meter
Wifi and TVBroadband, cableBusiness
Repairs and fittingsPlumber, mattress, fan, lock, paintBusiness
Laundry and linenBedsheet washing, pillow coversBusiness
Marketing and brokerageListing fees, broker payment for a new tenantBusiness
Deposits refundedMoney returned when a tenant leavesNot an expense: it is returned money held earlier

What does one hypothetical month look like?

Say you run 14 beds at ₹7,000 each, so full occupancy would bring in ₹98,000. This month 13 beds are filled, so you collect ₹91,000. Your costs: building rent ₹30,000, staff ₹18,000, groceries ₹20,000, gas ₹3,600, electricity and water ₹9,500, wifi ₹1,200, repairs ₹2,300, laundry ₹1,400, and small odds and ends ₹1,000. Total costs come to ₹87,000, so ₹91,000 − ₹87,000 leaves ₹4,000 before any amount you set aside for repairs or your own pay. One empty bed cost you ₹7,000, which is more than the entire margin.

These numbers are made up to show the method. Your rent, tenants and bills will look different.

Which deposits and cash items get missed?

  • Security deposits: write them in a separate list, not in income, because most will go back.
  • Cash rent from tenants who do not use UPI: note the date and the receipt number you gave.
  • Cash to the vegetable seller or gas delivery boy: a line the same evening beats a guess at month end.
  • Small repairs paid on the spot, like a tap washer or a switch.
  • Late fees or damage deductions: record the amount and which tenant, so the deposit refund adds up.

Which costs are business and which are the family's?

If your family eats from the same kitchen as the tenants, the groceries are mixed. One workable habit is to keep the PG's grocery bill in a separate shopping trip, or to agree a fixed share with your CA. The same applies to an electricity meter that supplies your own flat. Pick a method, write it down, and stick to it.

A monthly routine that takes under an hour

  1. On the first, list every tenant with rent due and mark who has paid, in full or in part.
  2. Upload or type in the month's bank and UPI entries, then add cash spending in one batch.
  3. Check that each large spend has a photo of its bill.
  4. Compare staff, groceries and electricity with last month and look into any jump.
  5. Note the deposits held and the deposits returned, and make sure the balance matches your list.

If your bank statement is a PDF, CSV or Excel file, SpendixAI can take it in and you review the rows before they are saved. You can also add cash spending in bulk. It is a personal workspace, so it does not issue rent receipts or manage tenant agreements.

SPENDIXAI JOURNAL

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

Explore your reports