
How to Fill a PG Rent Register: Cash, UPI and Partial Payments
A worked PG rent register example covering opening dues, partial UPI payments, cash, payment proof and closing balances, with a free template.
Short answer
Keep one rent row per tenant per month and a separate entry for each payment. Record the opening balance, monthly charges, payment date, amount and method. Subtract verified payments to find the closing balance. A screenshot submitted by a tenant is evidence to review, not proof that money reached your account.
Start with a monthly row and a payment log
A rent register answers what is due; a payment log answers when money arrived. Combining several payments into an unexplained total makes later checks difficult. Include tenant reference, room or bed, month, rent, agreed additional charges, opening balance and due date in the monthly row. Keep each cash or UPI payment linked to that row. Use the free PG rent register template as your starting point.
Worked example: rent paid in two parts
This is an illustrative example, not a customer record. A tenant has ₹1,000 carried forward, ₹8,000 rent and ₹500 in agreed charges: total due ₹9,500. They pay ₹5,000 by UPI on the third and ₹3,000 cash on the tenth. After both payments are verified, the remaining balance is ₹1,500. Record both dates and methods instead of writing only “₹8,000 paid”. Carry ₹1,500 into the next period once, without counting it again as a new charge.
Check UPI proof before changing the balance
Compare the amount, recipient, date and transaction reference with the payment you received. Keep a pending-proof note while reviewing a tenant submission. If two screenshots describe the same transaction, link them to one payment instead of adding two credits. A failed or pending transfer should not reduce the verified outstanding balance.
Record cash while the details are still clear
Record the amount, collection date, tenant and month, plus who received the cash when several people handle collections. Give the tenant an acknowledgement through your usual process. Keep a rent receipt separate from the internal register: the rent receipt template helps prepare a separate document. A spreadsheet row alone is not a signed receipt.
Close the month without losing unpaid balances
Compare the register with cash collected and incoming bank transactions. Review partial payments and pending proof, then confirm each remaining balance. Keep an export or dated copy before starting the next period. Do not erase a disputed entry to make totals match; add a correction with a reason so the original record remains understandable.
Move from the register to shared rent records
With EasyAavaas rent management, owners can record direct payments and tenants can submit proof for approval. Automatic WhatsApp reminders help follow up dues. EasyAavaas does not collect or hold rent. Start with one tenant and compare the app balance with your register before moving the rest. See the PG management software workflow or watch the demo.