Run a PG on a Google Sheet and a WhatsApp group until you pass about 25 to 30 beds or a second building. The real data in a PG is small: who is in which bed, what each resident owes this month, what was paid, meals served, complaints open and which documents you hold.
Software helps most with three jobs: collecting rent and deposits on time with receipts, keeping resident ID safe, and answering 'who is in which bed from when to when'. Prices below are estimates, and I have not verified current prices for any product, so check vendors directly.
The data a PG actually needs to track
| Record | Fields to keep | Why it matters |
|---|---|---|
| Bed register | Building, floor, room, bed number, sharing type, rent, status (occupied, notice, vacant, held) | The core of the business: one row per bed, never per resident |
| Resident file | Name, phone, parent or emergency contact, check-in date, notice date, deposit, ID reference, police verification status | Needed for rent, parents' calls and police queries |
| Monthly rent ledger | Due date, amount, amount paid, mode (UPI, bank), receipt number, late days | Late rent is the main cash problem |
| Deposit ledger | Amount received, deductions, refund date, refund reference | Disputes at exit are mostly about this |
| Meal counter | Residents signed up, skipped meals, guest meals, daily grocery spend | Controls the cost per plate |
| Utility log | Electric meter reading per floor or room, water tanker count, internet bill | Tells you whether AC charges and power cuts are covered |
| Complaint register | Date, room, issue, who assigned, closed date | Proof you fixed things; shows repeating problems |
Build the bed register first. If you can answer 'which beds fall vacant in the next 30 days' in under a minute, you can plan marketing and brokers around it.
Google Sheets and WhatsApp: good up to roughly 30 beds
A sheet with five tabs (beds, residents, rent, deposits, complaints) covers a single building. The skill is in the discipline: one owner of the sheet, a rule that nothing is entered in WhatsApp only, and a monthly lock on past rows.
- Rent tracker: one row per resident per month, with a formula that flags overdue days and a conditional colour. A reminder on the 1st and the 5th costs nothing.
- UPI collection: share a QR for the business account or a UPI payment link; ask residents to add the room number in the note. Match against the bank statement weekly.
- WhatsApp groups: one announcement group where only the owner and warden post, one chat group for residents, and one staff group. Keep the announcement group to timings, outages and rule changes.
- Meal poll: a form or WhatsApp poll for tomorrow's guest count, closed at a fixed hour.
- Receipts: a numbered receipt on a template sheet or a simple billing tool works. If you need GST invoices at any point, read the GST billing software guide first.
- Backups: keep the sheet in the business Google account, not on the warden's phone, and share it by role.
ID documents carry personal data. Collect only what you need, store copies in a locked cabinet or access-controlled folder, and delete them after the legally needed period. The DPDP checklist explains the general duties; confirm specifics with a lawyer.
Off-the-shelf options for a PG
When sheets start to creak, a PG or hostel management tool is the next step. These categories do the job; compare current features and prices before paying.
| Category | What it covers | Watch for |
|---|---|---|
| PG and hostel management apps | Bed grid, resident profiles, rent reminders, receipts, complaints, sometimes police form export | Whether data can be exported, per-bed pricing, support in your language and whether staff can use it on a phone |
| Rent collection and payment links | UPI and card collection, auto reminders, reconciliation | Settlement times, fees on each payment and how a failed or part payment shows up |
| Accounting software | Ledgers, expenses, GST if needed, reports for the accountant | Not meant to track beds; keep it for the books |
| Messaging and CRM | Enquiry tracking, templates, follow-ups from listing sites and WhatsApp | Duplicate leads from multiple listing sites |
| Biometric or RFID access | Entry logs and door control | Local support, backup power, and how resident data is stored |
| Mess and meal tools | Meal sign-ups and cost tracking | Often overkill; a form and a sheet may do |
Pick on two tests: can the warden mark a payment received from a phone in 30 seconds, and can you export every record to a sheet if you leave? If either answer is no, keep looking.
Verification and police forms: what software can and cannot do
Most PG owners are expected to report residents to the local police. The process and form vary by state and city, and some places offer an online portal while others expect a paper form at the police station. I have not verified the current procedure for every city, so ask your local station and check the police website. This is general guidance, not legal advice.
- Keep a verification status column in the resident file: submitted, receipt number, date, and pending.
- Collect ID copies once at check-in and store them securely. Where possible, ask for a masked Aadhaar copy rather than the full number.
- Use the sheet or app to export a resident list in the format the station asks for. Some PG tools offer this; check before depending on it.
- Do not scrape or share resident data with third parties such as marketing tools without consent.
When custom software pays for itself
Custom software is worth considering once your process is stable and a standard tool stops fitting. That usually means more than 150 beds or three or more buildings, a co-living brand with services like cleaning slots and events, or a pricing model off-the-shelf tools can't handle.
| Situation | Standard tool? | Custom pays when |
|---|---|---|
| One building, 12 to 30 beds | Sheet and WhatsApp | Almost never |
| Two or three buildings, 60 to 150 beds | PG management app | You need your own branding, resident app or special billing |
| Co-living with services | Partly | You sell add-ons (laundry, cleaning, events) and want one resident app with payments and requests |
| Franchise or management contracts | Rarely | Owners need dashboards, and payouts to building owners need to be automated |
A custom system for a PG operator would usually cover: a resident app for rent, receipts and requests; a staff app for the bed grid, complaints and meal counts; an owner dashboard with occupancy and dues; and payment reconciliation. Start with an MVP; the MVP guide explains how to scope it.
Where the Wanderbunk concept and The Saral fit
Wanderbunk is a concept build we made for backpacker hostels, with a guest app, a staff app showing a bed occupancy grid and a bed picker. It is not a PG product: it does not cover monthly rent cycles, deposits and refunds, meal plans or police verification records. What carries over is the bed-grid idea and the staff-app pattern.
If you outgrow sheets and standard tools and want something built around a PG's monthly cycle, The Saral builds custom apps and websites for businesses in India. See the travel booking website solution for the nearest standard scope, or the real estate website solution if listing and enquiry pages matter most. Start with the cheaper tools above, and talk to us only when the numbers say custom pays.
In the PG accommodation business library
More on starting a PG accommodation business
- Start hereThe full playbook →Models, licences, startup costs and the steps to your first customer.
- Go deeperWhat to buy →Per-bed room kit, water, kitchen and safety gear costed, plus what to skip until the building fills.
- Go deeperWho to hire →Warden, cook, housekeeping and night staff: pay, trial tasks and written terms, by building size.
- Go deeperGetting customers →College and office tie-ups, listings, brokers, launch rent and the first 10 beds, with seasonality.
Questions people ask
Can I run a PG on Google Sheets?
Yes, up to roughly 25 to 30 beds in one building. Use one row per bed, one row per resident per month for rent, and a complaint tab, with one person responsible for entries. Move to a PG management app when overdue rent, receipts and parents' queries start taking more than an hour a day.
How should a PG collect rent?
Collect by UPI or bank transfer to the business account, with the room number in the payment note, and issue a numbered receipt. Remind residents on the 1st and again on the 5th. Avoid cash where you can, since a payment trail makes deposits and disputes simpler to settle later.
Do I need GST software for a PG?
Often not for a typical PG, as accommodation for longer stays under a stated monthly limit has been exempt from GST since a July 2024 decision, subject to conditions such as at least 90 continuous days. I have not verified the current notification text, so confirm with a chartered accountant before relying on it.
Is it safe to store residents' Aadhaar copies?
Store only what you need, keep copies in a locked cabinet or access-controlled folder, and delete them when no longer required. Where you can, use a masked copy. India's data protection law adds duties on how personal data is handled, so read a general checklist and ask a lawyer about your own case.
When should I switch from a sheet to a PG app?
Switch when you pass about 30 beds, add a second building, or spend more than an hour a day on rent chasing and receipts. Check that staff can use it on a phone, that you can export your data, and that it handles part payments and deposit refunds, which are the common gaps.
