PG or paying guest accommodation · 5 min read

Can I run a 20-bed PG on a rent sheet and UPI, and when do I need software?

The short answer

Yes, for a while. A single sheet with one row per bed, a UPI QR code in the PG's own account and a fixed monthly routine will run a 20-bed PG, if one person owns the sheet and updates it the same day a payment arrives. It starts to fail when a caretaker changes, when you add a second building, when residents pay in several ways, or when you spend more than a couple of hours a month chasing and matching. Those are the signs that software is worth its small monthly cost.

Not sure about your case? Ask an expert, free ↓

The fifth of the month

By the fifth, nine residents have paid by UPI, three have sent a screenshot and say they paid, two have paid cash to the caretaker, and one has said 'tomorrow' for the third time. The bank statement has nineteen credits and four of them have only a phone number in the remarks. The owner sits with a notebook and a phone, working out who is who.

A sheet does not stop this from happening, but it makes it a ten-minute job instead of an evening, as long as it is set up well.

The sheet

Use a shared online sheet with edit rights for two people at most, and a copy saved each month.
ColumnWhat goes in it
Bed or room IDOne row per bed, not per room, so shared rooms show each payer
Resident name and phoneThe person who pays, not a relative, with the payer's UPI name if different
Joining date, agreement date, notice dateSo you know who is due to leave
Monthly rent and what it coversMeals, power, Wi-Fi, laundry, as agreed
Due date and grace daysAs in the agreement
Month columnsAmount paid, date, mode (UPI, cash, bank) and the UPI reference number
Dues carried forwardLate fee if the agreement has one, electricity and mess extras
Deposit paid, receipt number, refund due dateSo the deposit is never a memory

Add a second sheet for expenses (food, power, water, repairs, salaries) and a third for the complaint log. With those three, you have the daily accounts that the basics page on bookkeeping describes.

The monthly routine

  1. Before the first: send a rent reminder to every resident with the amount, the due date and the QR code.
  2. On payment: update the sheet the same day, using the UPI reference number. Send a receipt on WhatsApp.
  3. On the fifth: list who has not paid. Call each. Do not post the list on a notice board or in a group.
  4. At the end of the week: match the bank statement with the sheet. Anything that does not match gets a message to the payer.
  5. At the end of the month: close the month, save a copy, and note the dues carried forward.

One QR, in the PG's account

Receive rent in a current or business account in the name of the PG, or the owner's own account if that is your arrangement, on one QR code, rather than a different personal number each month. Check the basics page on payments with UPI, cards and cash for the rules and charges: payments up to ₹2,000 carry no charge to the payer or receiver, and small merchants receiving up to ₹1,00,000 a month on a QR pay no UPI charge, though PG rents are usually larger single payments. Do not let a resident pay to a caretaker's personal number; money that goes there is hard to trace if the caretaker leaves. If you take cash, give a written receipt and enter it the same day.

Do not tell residents that paying online adds GST. Whether GST applies to PG rent depends on the value and the length of stay, not on how the rent is paid: nil rate if the value is ₹20,000 or less per person per month and the stay is at least 90 continuous days (Sl. 12A, Notification 04/2024-CT(Rate), from 15 July 2024). This is general information, not tax advice; ask a CA.

When the sheet stops working

  • Someone else enters the data and gets it wrong, or stops.
  • You add a building and the sheets begin to diverge.
  • Reminders eat your evenings, because you are copying and pasting messages.
  • Electricity or meals are billed per resident and the sheet needs formulas for each.
  • You need documents (ID, agreements) stored with each resident, not in a phone gallery.
  • A dispute needs a history and you cannot show one.

Then look at PG management software and what it costs. Published plans cost a few hundred rupees a month for one building, which is small against a rent roll. The decision is about discipline and handover, not price. If you move to software, import the sheet as it is; do not start from zero.

By size and type

A home PG with three to eight beds needs the sheet and a QR code and a family member who owns it. A converted house of fifteen to twenty-five beds can use the sheet with a caretaker, but only if the owner reviews it weekly. A leased building with a manager needs more than a sheet: the owner must see payments before the manager does. Coaching hostels and ladies' PGs add a parent's contact to each row and often a separate payer, which the sheet should show.

What usually goes wrong

  • Rent goes to the caretaker's personal UPI and the caretaker leaves.
  • The sheet is on one phone, and the phone is lost.
  • Screenshots are taken as proof; the credit has not arrived. Match the bank credit, not the screenshot.
  • Cash is not receipted and the resident disputes it.
  • The deposit is not on the sheet and its refund is forgotten.
  • The list of defaulters is shared in the group.

Apply it to your own PG

Build the sheet from the table this evening, fill it from your last month's bank statement, and see how many credits you cannot match to a bed. That number is your problem size. If it is more than two or three, set up one QR, the reference number habit and a weekly match. If you want help moving to software without losing the history, tell us where you are.

Questions people ask

Is a spreadsheet enough for a PG?

For a small PG with one owner who updates it daily, yes. When the register must survive a change of staff or you add buildings, move to software.

Should residents pay by UPI or cash?

UPI to one QR in the PG's account leaves a trace on both sides. If you take cash, give a receipt and enter it the same day.

Does paying by UPI add GST to PG rent?

No. GST on PG rent depends on the value per person per month and the length of stay, not on the mode of payment. Ask a CA about your case.

Where these numbers come from

  1. UPI payment size up to which no bank or payment provider may charge the payer or the receiver: ₹2,000 (all India, by notification of 14 September 2026 under section 10A of the Payment and Settlement Systems Act 2007; applies per payment). Official source: Gazette of India, Ministry of Finance notification S.O. 5067(E), 14 September 2026, checked 9 November 2026.
  2. UPI QR receipts a month up to which a small shop pays no UPI charge on any payment: ₹1,00,000 a month (all India; the person-to-person-merchant (P2PM) category, a QR paying into the owner's own account; zero charge continues under the new framework; above this for 3 months in a row, the shop moves to the ordinary merchant category; GST registration not needed). Official source: NPCI, FAQs on Merchant Discount Rate (MDR) on select UPI (P2M) transactions, 15 September 2026, checked 9 November 2026.
  3. Accommodation exempt if value <= 20,000 per person per month and stay >= 90 continuous days: nil rate if the value is ₹20,000 or less per person per month and the stay is at least 90 continuous days (Sl. 12A, Notification 04/2024-CT(Rate), from 15 July 2024) (India, Notification 04/2024-CT(Rate), from 2024-07-15). Official source: CBIC Circular 228/22/2024-GST, paras 9.2 to 9.4 (Notification 04/2024-Central Tax (Rate), Sl. 12A), checked 14 November 2026.

Fees, rates and rents change. Check the official source before you pay or sign anything.

Tools and software · PG or paying guest accommodation

More on tools and software for a pg or paying guest accommodation

3 pages on this. You are on number 1.

  1. Can I run a 20-bed PG on a rent sheet and UPI, and when do I need software?
  2. Which PG management software or rent app should I use, and what does it cost?
  3. How do I do online police verification and e-agreements for residents?
The tools and software page →

Reading about it is one thing; doing it in your pg or paying guest accommodation is another. If you'd like a hand choosing and setting up your tools, tell us where you are and a person will reply, free.

Get help with this ↓

What now?

Menu

Read

Ask an expert Ask an expertFree, real peopleHub
Ask an expert