To track rent across multiple properties, keep a payment record tied to each lease and a monthly summary showing expected rent, recorded receipts, and any difference you still need to investigate. Update the record when you confirm a payment, then compare it with the original payment evidence before closing out the month.
That routine can work in a spreadsheet or a property management app. The important part is being able to answer three questions: which rental does this payment belong to, what period does it cover, and what still needs attention?
Give every payment a clear home
A bank entry might say a person's name, a transfer reference, or simply that a check was deposited. Your rent record needs enough context to connect that entry to the right rental.
For each receipt, record:
- Property and unit: use the same names every time.
- Tenant or lease: identify the tenancy, especially when occupants change.
- Amount received: record the actual amount, including a partial payment.
- Date received: keep it separate from the date rent was due.
- Rent period: note which month or period the payment relates to.
- Method and reference: for example, a check number or a payment-service reference.
- Supporting note: explain anything another person would need to understand later.
Avoid putting bank account numbers or other sensitive details in free-text notes. A reference that lets you locate the source record is usually more useful.
Separate the payment history from the monthly summary
These two views answer different questions. The payment history shows individual receipts. The monthly summary shows where each lease stands for a particular period.
Suppose Unit B has $1,400 in rent due for October, with no prior balance, credits, or other charges. You confirm a $900 payment on October 1 and a $500 payment on October 6.
After the first payment, the record contains one $900 receipt and a $500 difference against October's rent. After the second, it contains two receipts totaling $1,400 and no remaining difference for that month's rent.
Keep both receipts. Replacing the first entry with $1,400 loses the history; adding a third $1,400 entry counts the same money twice.
This example is deliberately simple. Earlier balances, credits, adjustments, or payments intended for another period need their own explanation. Do not assume subtracting this month's receipts from monthly rent always describes the full account balance.
Use a repeatable routine when money arrives
- Confirm what happened. Use the actual payment record. A message saying a tenant intends to pay is not a receipt, and a pending transfer needs follow-up.
- Find the correct lease. Similar names and multiple units at one address can make a quick entry easy to misplace.
- Record the receipt once. Include its amount, date, reference, and intended period where your tool supports it.
- Review the result. Check that the receipt appears under the right property and that any remaining difference makes sense.
Recording a payment in software does not move money or verify a bank deposit. It creates a record based on what you enter. Keep using the original payment source to confirm its status.
If you already use UnlockAbode, the record a rent payment walkthrough explains how to select the lease, enter the amount and date, and add a note.
Review exceptions before sending a follow-up
Before contacting a tenant about an apparent missing payment, check for an unrecorded receipt, a payment attached to the wrong lease, a partial payment, or a transfer that is still pending. Also check whether a credit or an earlier arrangement explains the difference.
Keep the question specific: what does your record show, and what information do you need to resolve it? A missing entry in your own tracker is not proof that the tenant failed to pay.
This workflow helps you maintain records. Decisions about fees, notices, or enforcement require a separate review of the lease and applicable rules.
Close the month with a short checklist
Review each property separately before looking at the portfolio total. Two misplaced entries can cancel each other out in a total while leaving both tenant records wrong.
- Match each recorded receipt to its supporting payment record.
- Investigate unmatched deposits and receipts without supporting evidence.
- Check partial payments, duplicate entries, and payments recorded under the wrong lease.
- Explain any remaining differences rather than changing a number just to make totals agree.
- Keep a backup or export you can open independently of your everyday tool.
If several receipts were deposited together, preserve enough detail to explain how they relate to the combined deposit. A matching total is useful, but the individual records still matter.
When a spreadsheet is enough
A spreadsheet can be a reasonable choice when you update it consistently, can find the supporting records, and understand how its totals are calculated. Use stable property names and keep a copy before changing formulas or reorganizing historical entries.
Consider a dedicated tool when you repeatedly need to connect receipts with leases, expenses, repairs, and tenant conversations. The useful question is whether the tool reduces the work you actually do. Our guide to leaving rental spreadsheets explores that decision.
Whichever tool you choose, check that you can take your records with you. You should understand its export before committing your history to it.
Put the routine into practice
UnlockAbode lets you record rent you receive against a lease while continuing to collect payments through your existing methods. Start with the payment-recording walkthrough, then review how to export your data.
If that fits the way you manage your rentals, review the current pricing or create an account. For questions about whether your workflow fits, talk to a person.