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
| Category | What goes in | Business or personal? |
|---|---|---|
| Building rent or loan | Rent you pay for the premises; loan instalments if you own it | Business, but ask your CA how to treat the principal part of a loan |
| Kitchen and groceries | Rice, vegetables, milk, oil, tea | Business for the mess; your family's own groceries are personal |
| Cooking gas | Cylinders, stove repair | Business if it feeds the mess |
| Staff | Cook, helper, caretaker, night watchman | Business |
| Electricity and water | Common meter, motor, water tanker | Split if the family shares the meter |
| Wifi and TV | Broadband, cable | Business |
| Repairs and fittings | Plumber, mattress, fan, lock, paint | Business |
| Laundry and linen | Bedsheet washing, pillow covers | Business |
| Marketing and brokerage | Listing fees, broker payment for a new tenant | Business |
| Deposits refunded | Money returned when a tenant leaves | Not 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
- On the first, list every tenant with rent due and mark who has paid, in full or in part.
- Upload or type in the month's bank and UPI entries, then add cash spending in one batch.
- Check that each large spend has a photo of its bill.
- Compare staff, groceries and electricity with last month and look into any jump.
- 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

