Tenant document review screen used while moving PG records into EasyAavaas
Back to resources
PG Operations8 min read

How to Move a PG from Excel and WhatsApp to Management Software

Do not copy every old chat. Move the live operating record in a controlled order, verify opening balances and keep a clear cutover date.

EasyAavaas Editorial Team

PG, Hostel & Co-Living Operations

Operational guides for PG, hostel, and co-living operators in India — written by the EasyAavaas team from real product workflows: rent collection, bed-level occupancy, visitor gate passes, staff permissions, and tenant lifecycle.

Short answer

Move current rooms, active tenants, opening rent balances, deposits and essential documents first. Choose one cutover date, verify the totals, invite tenants only after the owner record is correct, and keep the old sheet read-only for reference. Do not spend weeks copying irrelevant chat history.

Before migrating: decide what becomes the source of truth

A migration fails when staff continue updating the notebook, spreadsheet and new software at the same time. Select a cutover date. Before that date, the old records explain history. From that date onward, the management system holds current occupancy, rent, complaints and changes.

Old recordMove nowKeep only as archive
Room or bed sheetEvery current property, floor, room, bed and maintenance blockDeleted test rows and obsolete layouts
Tenant listActive tenants, contacts, joining date, bed, rent and depositOld leads and duplicate contacts
Payment sheetCurrent month status and any genuine opening balanceRows already settled and no longer disputed
WhatsApp documentsCurrent ID, address proof and agreement files you still needRoutine chat and unrelated media
Complaint chatOpen issues that still require actionResolved conversations with no continuing obligation

Recommended migration sequence

  1. Create the property structure. Add floors, rooms and beds in the same order people use inside the building. Mark any bed unavailable for maintenance.
  2. Reconcile occupancy. Walk the property or confirm the current tenant of every occupied bed. Fix the spreadsheet before copying a known mistake.
  3. Add active tenants. Keep name, phone, emergency contact, joining date, rent, deposit, room or bed and work or study information together.
  4. Set opening rent status. Decide which month and balance will become the starting point. Never invent a balance just to match an unclear old total.
  5. Move essential documents. Upload only the files the property is entitled and expected to retain. Record owner review separately from government verification.
  6. Record deposits and issued items. A deposit, key, mattress or other issued item should be visible before the next move-out.
  7. Invite tenants and team members. Explain the new actions: document upload, payment proof, complaints and visitor requests. Give staff only the access they need.
  8. Freeze the old sheet. Keep a read-only archive and stop entering new activity there after the cutover.
Choosing a vacant room and bed in the EasyAavaas Add a tenant form for an active PG tenant
Reconcile the real bed first, then assign the tenant in the system.

The four totals to verify before inviting tenants

  • Occupancy: occupied beds plus vacant beds plus maintenance beds should equal total beds.
  • Active tenants: every current tenant should appear once and be assigned to the correct room or bed.
  • Opening rent: the sum of genuine pending balances should match the amount the owner expects to collect.
  • Deposits: each retained deposit should match the owner record, receipt or other available evidence.

Do not call document upload “digital KYC” without explaining it

A tenant can upload documents and an owner can review them in EasyAavaas. That creates a useful document record, but it is not Aadhaar, DigiLocker, police or government verification. Keep the wording precise so staff and tenants understand the difference.

How to run the first month after cutover

For the first rent cycle, compare the pending list with actual payments daily. Ask tenants to upload proof only after paying the owner directly, and approve a proof only after confirming receipt. Record cash yourself. Resolve complaints in the system rather than replying only in a private chat, and send property-wide updates as notices instead of maintaining a second announcement list.

EventWho records itWhat remains available later
Tenant pays by UPITenant uploads proof or owner records paymentAmount, method, proof, UTR, status and reviewer
Tenant pays cashOwner or permitted staff records paymentAmount, date, method and recorder
Complaint is raisedTenant, owner or permitted staffIssue, photo, priority, assignment and status updates
Room changesOwner or permitted staffCurrent occupancy and continuing tenant record
Tenant leavesOwner or permitted staff completes checksHistorical tenant, rent, documents, deposit and item record
Can I import my PG Excel sheet directly into EasyAavaas?

No. There is no Excel import. You can add tenants individually or add up to 25 from phone contacts, then complete their property details.

Do I need to move every old payment?

Usually no. Move the current opening balance and records still needed for an active dispute or obligation. Keep the old file as a read-only archive.

Should tenants pay through EasyAavaas after migration?

No. Tenants continue paying the owner directly by UPI, cash, bank transfer or another agreed method. EasyAavaas keeps the record and proof.

Can I migrate one property before the others?

Yes. Starting with one property makes reconciliation easier. Verify the first rent cycle, then repeat the same documented process for the remaining properties.