How to Track Rent Payments Across Your Property Portfolio
Missed rent is the single biggest cash flow risk for landlords. With one property it's manageable — you know when rent is due and you notice quickly if it doesn't arrive. With five, ten or twenty properties, things slip through. This guide covers the practical systems for tracking rent across a portfolio, and how to spot arrears before they become a serious problem.
The core problem: Most landlords either use spreadsheets (time-consuming, error-prone) or rely on bank statements (reactive, not proactive). Neither gives you a live view of who has and hasn't paid this month.
Why Rent Tracking Matters Beyond the Obvious
The obvious reason to track rent is to catch arrears early. But there are several less obvious reasons that matter just as much:
- Tax records: HMRC requires accurate records of rental income. A monthly payment log per property is far cleaner than sifting through bank statements at year-end.
- Arrears evidence: If you ever need to pursue a tenant for unpaid rent through the courts, a clear payment history is essential evidence.
- Refinancing: Mortgage lenders and brokers often want to see rental income records when you refinance.
- Void periods: Tracking which months had no rent highlights void periods that affect your annual yield calculations.
- Agent accountability: If a letting agent manages the property, rent tracking lets you verify their payments against the actual rent received.
Payment Statuses You Should Track
A good rent tracker distinguishes between different payment states — not just paid and unpaid:
| Status | Meaning | Action needed |
|---|---|---|
| ✅ Paid | Full rent received on time | None |
| ⏰ Late | Received but after the due date | Log the delay, consider a reminder letter if recurring |
| ❌ Missed | Not received — no payment at all | Immediate contact with tenant, consider formal notice |
| 🔵 Refurb | Property between tenants, undergoing works | Planned — no income expected |
| ⬜ Void | Property vacant, no current tenancy | Focus on re-letting urgently |
How to Track Partial Month Payments
A common situation that simple rent trackers can't handle: a tenant leaves mid-month and a new tenant moves in two weeks later. How do you record May — paid, void, or partial?
The correct approach is to track at the day level, not just the month level. When you record a rent payment, log the period it covers (e.g. 10 April to 9 May). This way, your tracker can show you that May was partially covered — say, days 1–9 by the outgoing tenant and days 19–31 by the new tenant — with a 10-day void in between that directly affected your income.
✓ OwnProperly: The day-level rent tracker shows exactly which days of each month are covered, missed or void. Click any month square to see a day-by-day breakdown, and use the full Day Tracker view to see all properties at once.
Importing from Your Agent's Statement
If you use a letting agent, they typically send a monthly PDF statement showing rent received and management fees deducted. Manually entering this for each property every month is tedious and error-prone.
The better approach is to import the statement directly. OwnProperly's statement importer reads PNE, RMS and CSV bank statement formats — extracting rent amounts, tenant names, payment periods and management fees automatically, and matching each line to the correct property in your portfolio.
After importing, you review and confirm each line before it's saved — giving you a chance to correct any mismatches. The whole process takes under two minutes for a typical 10-property statement.
Setting Up Arrears Alerts
The best rent tracking system is one that tells you about problems without you having to check. Set up automatic alerts for:
- Rent marked as missed for more than 3 days past the due date
- Two or more consecutive late payments from the same tenant
- Any property with outstanding arrears over a threshold you set
- Properties that have been void for more than 14 or 30 days
Rent Tracking and Section 21
If rent goes unpaid and you eventually need to recover possession, your rent payment history becomes a legal document. Keep records with:
- The date each payment was due
- The date each payment was actually received
- Any partial payments and the amount shortfall
- Any communications with the tenant about arrears
A clear digital record — not a spreadsheet that could be accidentally edited — is far more useful in a Section 8 or court hearing.
The Annual Reconciliation
At the end of each tax year, your rent tracker should give you:
- Total rent received per property
- Number of months paid, late, missed and void per property
- Total management fees paid (deductible expenses)
- Arrears carried forward
This is exactly the output your accountant needs for your Self Assessment return, without them having to dig through bank statements.
Track every payment, automatically
OwnProperly gives you a visual month-by-month and day-by-day rent tracker for every property, with import from agent statements, arrears alerts and annual reporting.
Start your free 14-day trial