Guide
PG register vs spreadsheet: managing PG tenancies
By CheckMyGuest Editorial Team · Published · Last updated: · 8 min read
A spreadsheet is adequate for one or two units run personally by the owner. It stops working once a caretaker is involved, identity documents must be stored, or several stays overlap — because spreadsheets hold text but not documents, permissions or an entry trail. The switch usually happens at the second unit or the first hired caretaker, whichever comes first.
Is a spreadsheet enough to manage a PG?
A spreadsheet is adequate for one or two units managed personally by the owner, with few overlapping stays and no staff. It becomes inadequate once identity documents must be stored, a caretaker needs access, or stays overlap — because a sheet holds text but not documents, permissions or an entry trail.
This is not an argument that spreadsheets are bad. They are excellent at what they do: arbitrary columns, instant edits, zero cost, no learning curve. Most Indian PG and rental operators start there for good reason, and a meaningful number should stay there.
The failure is specific rather than general. A spreadsheet cannot hold a scanned Aadhaar against a stay, cannot show a caretaker the move-in list while hiding the revenue column, and cannot record that a row was edited on 14 March by a particular person. Those three gaps account for nearly every operational problem attributed to "using Excel".
Spreadsheet vs WhatsApp vs tenant management app
The three tools differ across nine everyday tasks. Spreadsheets handle calculation and flexible columns; WhatsApp handles communication; a tenant management app handles documents, permissions and history. Most operators end up using all three, with the app holding the record and WhatsApp carrying the conversation.
| Task | Spreadsheet | Tenant management app | |
|---|---|---|---|
| Store tenant ID documents | Not supported — link only | In a personal phone gallery | Attached to the stay record |
| Find a past tenant by unit and date | Possible if columns were filled consistently | Manual scrolling | Searchable by name, unit or date |
| Limit what caretakers can see | All or nothing per file | Not possible | Role-based access |
| Know who changed a record | Only with version history enabled | Not applicable | Entry attributed to a staff account |
| Track pending rent | Manual formula, manual follow-up | From memory | Status per stay with reminders |
| See occupancy across all units | One tab per property, reconciled by hand | Not possible | Single combined view |
| Log complaints with status | Extra columns, rarely maintained | Buried in chat | Dated log with owner and status |
| Survive staff turnover | Yes, if the file is shared | No — history leaves with the phone | Yes — records belong to the property |
| Cost | Free | Free | Subscription set by the platform |
Comparison describes typical capabilities of general-purpose spreadsheets and messaging apps against dedicated PG and rental management software. Specific features vary by product.
Where spreadsheets genuinely work well
Spreadsheets remain the better tool for one-off analysis: annual revenue summaries, comparing performance across properties, modelling a rent revision, or preparing figures for a tax filing. These are calculation tasks, not record-keeping tasks, and no tenant management app replaces them.
- Year-end income and expense summaries per property
- Comparing occupancy rates across units or seasons
- Modelling a rate change or a renovation payback
- Ad-hoc lists that do not need to persist
- Sharing a static figure set with an accountant
Operators who move their tenant records into an app typically keep a spreadsheet for exactly these purposes. The two are complements, not substitutes.
Where a spreadsheet breaks in practice
Spreadsheets break on documents, permissions and concurrency. An identity document cannot live in a cell, a caretaker cannot be shown one column and not another, and two people editing the same sheet on phones produce conflicting versions. Each limitation is structural, not a matter of better discipline.
- Documents. The ID ends up in a folder or a chat, disconnected from the row that describes the stay.
- Permissions. Sharing the file gives away rent, revenue and every past tenant's details at once.
- Concurrency. A caretaker editing on a phone while the owner edits on a laptop produces divergent copies.
- Reminders. Nothing prompts anyone; the sheet is passive and must be checked.
- Extensions. A stay that changes dates becomes a new row, and the history fragments.
- Deletion. A cleared cell leaves no trace that anything was there.
Why WhatsApp is not a record system
WhatsApp is the default coordination tool for Indian PG and rental operations and it works well for that. It fails as a record system because messages cannot be queried by unit or date, identity documents sit in personal galleries, access cannot be restricted, and the history is tied to a device rather than the property.
There is also a data-protection dimension. Under the Digital Personal Data Protection Act, 2023, an operator who collects a tenant's identity document is responsible for how it is stored and who can access it. Identity documents accumulating in a caretaker's personal photo gallery, backed up to a personal cloud account, is difficult to defend on that basis.
The practical arrangement most operators land on: WhatsApp for talking to tenants and staff, and a system of record for anything that must be retrievable later.
Four signals that it is time to switch
Four signals reliably indicate that a spreadsheet has stopped being the system of record. Any one of them is sufficient; operators usually notice two or three at once, typically at the second unit or the first hired caretaker.
- You cannot answer "who was in this unit on that date" without checking chats. The sheet is no longer authoritative.
- Your caretaker keeps a separate list. Two records means neither is trusted.
- Rent is chased from memory. Pending payments are being tracked in someone's head.
- An ID document takes more than a minute to produce. The document exists but the link to the stay does not.
What does each option actually cost?
Spreadsheets and WhatsApp are free in licence terms but carry costs in owner time, disputed deposits and unrecovered rent. A subscription has a visible price set by the platform. The comparison worth running is subscription cost against hours reclaimed and disputes avoided, not against zero.
- Owner time: hours per week reconciling sheets, chasing payments and answering "is the flat free?"
- Disputed deposits: deductions that cannot be evidenced are usually conceded
- Unrecovered rent: pending amounts that were never followed up because nothing prompted anyone
- Handover loss: property history that leaves with a departing caretaker
- Double-allocation: a unit promised to two tenants for the same dates
Current subscription pricing is published by the partner platforms — kipinn.com and propertymanagementapp.in — and varies with the number of units.
How do you move off a spreadsheet without losing history?
Start with current tenants rather than migrating years of history. Enter the stays that are active today, run every new move-in through the app from day one, and keep the old sheet as a read-only archive. Most operators complete the transition within one rent cycle.
- Enter every stay that is currently active — unit, tenant, dates, rent, deposit
- Capture identity documents for current tenants at the next opportunity
- Create staff accounts and set caretaker permissions before handing over
- Run all new move-ins through the app, with no parallel sheet entry
- Mark the old spreadsheet read-only and label it as an archive with a date
- After one full rent cycle, confirm pending payments reconcile, then stop using the sheet for records
The common mistake is running both systems "just for a while". Parallel records diverge within weeks, and the sheet reasserts itself as the real record because it is familiar. Pick a date and switch new entries entirely.
Move your current stays across this week
Both partner platforms handle tenant onboarding, digital records, rent tracking, occupancy, complaints and caretaker access on mobile and web.
Frequently asked questions
Is a spreadsheet enough to manage a PG?
A spreadsheet is adequate for one or two units managed personally by the owner, with few concurrent stays. It stops working once a caretaker is involved, once identity documents must be stored, or once several stays overlap, because spreadsheets hold text but not documents, permissions or an entry trail.
What are the signs it is time to move off a spreadsheet?
Four signals recur: you cannot answer who occupied a unit on a past date without checking chats; a caretaker maintains a separate record; rent is chased from memory; or an ID document cannot be produced within a minute. Any one of these means the sheet is no longer the system of record.
Can WhatsApp be used to manage PG tenants?
WhatsApp works for communication but not as a record system. Messages cannot be searched by unit or date range, identity documents sit in a personal gallery, permissions cannot be restricted by role, and the entire history leaves the property when a staff member changes phones or jobs.
What does a tenant management app do that a spreadsheet cannot?
It attaches identity documents to a specific stay, restricts what caretakers can see, records who entered each item and when, sends payment reminders on schedule, and shows occupancy across all units at once. These are permission and document capabilities that spreadsheets do not have.
Is moving off a spreadsheet difficult?
The practical approach is to start with current tenants rather than migrating history. Enter active stays, run new move-ins through the app from day one, and keep the old sheet as a read-only archive. Most operators complete the switch within one rent cycle.
Does an app replace the need to onboard tenants?
No. Verification is still performed by whoever completes move-in. The app makes verification durable by storing the document against the stay and recording which staff member captured it, but it does not remove the operator's responsibility to check the document against the person.
Sources and further reading
- The Digital Personal Data Protection Act, 2023 — obligations when collecting, storing and deleting tenant personal data
- Bureau of Immigration, Government of India — reporting obligations for accommodation providers hosting foreign nationals
- PG tenant onboarding in India: a PG and rental operator's guide — document requirements and the move-in sequence
- Partner platform documentation at kipinn.com and propertymanagementapp.in — current feature sets and pricing
Note: operational patterns described here reflect common practice among small PG and rental operators in India and are illustrative rather than measured. Feature availability differs between products; confirm specifics on the partner platforms before deciding.
Related: PG tenant onboarding in India: a PG and rental operator's guide