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
| Column | What goes in it |
|---|---|
| Bed or room ID | One row per bed, not per room, so shared rooms show each payer |
| Resident name and phone | The person who pays, not a relative, with the payer's UPI name if different |
| Joining date, agreement date, notice date | So you know who is due to leave |
| Monthly rent and what it covers | Meals, power, Wi-Fi, laundry, as agreed |
| Due date and grace days | As in the agreement |
| Month columns | Amount paid, date, mode (UPI, cash, bank) and the UPI reference number |
| Dues carried forward | Late fee if the agreement has one, electricity and mess extras |
| Deposit paid, receipt number, refund due date | So 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
- Before the first: send a rent reminder to every resident with the amount, the due date and the QR code.
- On payment: update the sheet the same day, using the UPI reference number. Send a receipt on WhatsApp.
- On the fifth: list who has not paid. Call each. Do not post the list on a notice board or in a group.
- At the end of the week: match the bank statement with the sheet. Anything that does not match gets a message to the payer.
- 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
- 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.
- 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.
- 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.
- Can I run a 20-bed PG on a rent sheet and UPI, and when do I need software?
- Which PG management software or rent app should I use, and what does it cost?
- How do I do online police verification and e-agreements for residents?
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?
Where are you?
One tap, and we point you to the right next step.