How to track rent payments in five steps
- List what is due. Before the month starts, write one line per tenancy: unit, tenant, rent due and due date. This is your checklist for the month.
- Pick a fixed check day. Choose a day a few working days after the main due date, so standing orders and transfers have cleared. Put it in your calendar.
- Match each payment. Go through the bank statement line by line and tick off each tenancy. Use the payment reference, the amount and the payer's name.
- Mark the status. Paid in full, part paid (with the amount) or unpaid. Do not leave a line blank; blank and unpaid look the same a month later.
- Follow up and log it. Contact anyone who has not paid, then write the date, how you contacted them and what they said.
If you have several due dates across the month, run the check weekly instead of monthly. The steps stay the same.
In Letvy, you tap Mark Paid on a tenant and confirm. Green, yellow and red show paid, partial and overdue across all your properties. Get it on Google Play
Make payments easy to match
Most of the time spent tracking rent goes on working out who a payment came from. A little set-up at the start of a tenancy saves that time every month afterwards.
- Ask each tenant to use a fixed payment reference. Unit number plus surname works well, for example "F2 PATEL". Put it in the welcome email at the start of the tenancy.
- Encourage a standing order. It arrives on the same day for the same amount, so matching takes seconds.
- Use one bank account for rent and property costs. With your personal spending out of the way, the monthly check and the year-end figures are much easier.
- If you accept cash, write down the date and amount the same day and give the tenant a written receipt.
Common matching problems
| What you see | Likely cause | What to do |
|---|---|---|
| A payment with no reference | Tenant paid from a new app or account | Match on amount and name, then ask the tenant to add the reference next time |
| One payment for two units | A couple renting two rooms, or a parent paying for students | Split it in your records and note who paid |
| Rent from a council or benefits system | Housing support paid direct to the landlord | Note the payer's name, since it will not match the tenant's |
| The amount is slightly short | Standing order not updated after a rent increase | Record it as part paid and remind the tenant of the new amount |
Recording a partial rent payment
When a tenant pays part of the rent, record what arrived and the balance left. Do not overwrite the amount due with the amount paid, or the shortfall disappears from your records.
| Month | Rent due | Received | Balance this month | Running balance owed |
|---|---|---|---|---|
| March | £950.00 | £600.00 | £350.00 | £350.00 |
| April | £950.00 | £950.00 | £0.00 | £350.00 |
| May | £950.00 | £1,300.00 | -£350.00 | £0.00 |
In this example, the tenant paid £600 in March, the normal rent in April, and £1,300 in May to clear what was left. The running balance column is what tells you the account is now clear.
If a payment covers both current rent and older arrears, decide how you apply it, tell the tenant in writing, and apply it the same way each time. A short note against the payment ("£950 April rent, £350 March arrears") is enough.
When rent is late: what to write down
Keep a dated log for each late payment. It helps you stay consistent, and it gives you a clear history if the situation goes further.
| Record | Example |
|---|---|
| Date you noticed | 05/03 at the monthly check |
| How you contacted the tenant | Phone, then email the same day |
| What the tenant said | Wages delayed, will pay on 15/03 |
| Date promised | 15/03 |
| Outcome | £600 received 15/03, £350 outstanding |
Start with a friendly call or message. Many late payments are a changed bank account, a missed standing order or a one-off delay, and they are sorted in one conversation.
Paper, spreadsheet or app
Any method works if you use it every month. The differences are in how much typing it takes and how easy it is to see the whole picture.
| Method | Good at | Weak at |
|---|---|---|
| Rent book or paper ledger | Simple, no set-up, easy to show a tenant | No totals, easy to lose, hard to search |
| Spreadsheet | Flexible, formulas for totals and arrears | Manual copying each month, awkward on a phone |
| Landlord app | Status per unit at a glance, records on your phone | Needs a little set-up for each property |
If you prefer a spreadsheet, our rent tracker spreadsheet guide has the columns and formulas.
Make the monthly check shorter
Letvy shows each unit's rent status for the month on one screen, and you can call or email a tenant straight from their record.
Get it on Google PlayiPhone version coming soon
More guides
- Rent Tracker Spreadsheet: Columns, Formulas and LayoutSet up a rent tracker spreadsheet that shows who has paid, who paid part and who still owes: the columns, three formulas that do the checking and a 12-month schedule tab.
- Landlord Expenses List: Categories, Examples and What to KeepA landlord expenses list to use as recording categories, how HMRC separates allowable expenses from capital costs, repair or improvement examples and how to log a cost.
- Rental Yield Calculator: Gross and Net Yield Worked OutWork out gross and net rental yield with a free calculator. Formulas, a worked example in pounds, what to count as costs, voids, and yield on the cash you put in.
- Rental Income and Expenses Spreadsheet: A Year-Round LayoutLay out a rental income and expenses spreadsheet with four tabs, work out monthly property cash flow, line it up with the UK tax year and keep the records HMRC expects.
Published by Zoranta, the developer of Letvy.