How to track rent across multiple properties

A practical method for tracking rent across several properties: what to record, how to match payments and how to follow up early and kindly.

In short: give every tenancy a clear rent schedule, record each payment against the right tenancy, match your bank transactions on a regular rhythm and follow up the moment a payment is late. With a simple routine, rent tracking takes minutes a week instead of a spare weekend.

Start with one rent schedule per tenancy

Rent tracking works best when every tenancy has its own schedule. Record the tenancy start date, the rent amount, how often it is due, the due day and the people responsible for paying. If a tenancy has joint tenants, record them on the same tenancy so you track one rent, not several. When rent changes, add the new amount from its start date and keep the old amount in the history. This gives you a reliable answer to the most important question in rent tracking: what should have been paid, and by when? Every other step depends on it, so it is worth setting up carefully once.

Choose a method that grows with you

Most landlords begin with a spreadsheet: one row per tenancy, one column per month, and a running balance. That works well for a handful of homes, as long as you update it promptly and keep formulas intact. As the portfolio grows, a dedicated rent ledger saves time because it creates the expected charges for you and keeps payments, balances and history together. Whichever method you use, keep it in one place. Rent split across a notebook, a banking app and a spreadsheet is much harder to trust than a single record you update consistently.

What to record for every payment

For each payment, record the date it arrived, the amount, the tenancy it belongs to, how it was paid and the reference shown on your bank statement. If a payment covers more than one period, or only part of one, note how you allocated it. Add a short note for anything unusual, such as a payment made by a guarantor or a one-off arrangement agreed with the tenant. These details make your records easy to follow later, whether you are answering a tenant's question, reviewing a property's performance or preparing figures for your accountant.

Match payments to your bank on a regular rhythm

Matching means comparing what arrived in your bank account with what each tenancy owed. Pick a rhythm that suits you, such as a few days after your most common due date, and stick to it. Ask tenants to use a consistent payment reference, such as their unit or property name, so each payment is easy to recognise. If your bank supports Open Banking, you can connect the account and import transactions automatically, then confirm each match instead of typing figures in by hand. Anything that does not match neatly, such as a different amount or an unfamiliar reference, goes on a short list to check.

Follow up early and kindly

The best time to follow up a late payment is soon after it becomes late. A short, friendly message often resolves the issue quickly, because the most common causes are simple: a changed bank account, a payment date that moved, or a reminder that slipped. Keep a record of each contact and any arrangement you agree. If a tenant is finding things difficult, a clear plan agreed early is better for everyone than a balance that quietly grows. Rules about rent arrears and notices vary by country and region, so check your local or national guidance before taking formal steps.

Review the whole portfolio monthly

Once a month, step back and look at the full picture. Which tenancies are up to date, which have a balance, and which payments are still waiting to be matched? Compare the rent you expected with the rent you received for each property. This monthly review also catches quieter issues, such as a rent increase that was never applied or a tenancy that ended while payments continued. Ten minutes with a clear overview gives you confidence in your income and helps you plan for repairs, mortgage payments and tax.

Keep records your accountant will thank you for

Good rent records double as good accounting records. When every payment is linked to a tenancy and a property, year-end figures become a summary rather than a project. Keep your ledger, bank matches and notes together, and you will have a clear trail for every figure you report.

Handle part payments and overpayments clearly

Part payments and overpayments are common, and both are easy to manage when you record them carefully. For a part payment, allocate the amount to the oldest outstanding charge first unless you have agreed something different with the tenant, and note the remaining balance. For an overpayment, record it as a credit on the tenancy so it can be applied to the next charge or returned. Avoid adjusting the expected rent to match what arrived, because that hides the difference. Keeping charges and payments separate means your balance always tells the truth, and anyone reading your records later can see exactly what happened and why.

Plan for changes during a tenancy

Tenancies change over time. Rent may be reviewed, a tenant may move out and another move in, or a payment date may shift by agreement. Record each change with its effective date, and keep the history rather than overwriting it. When a tenancy ends, close its schedule on the final date so no further charges appear, and settle any remaining balance or credit. When a new tenancy starts, create a fresh schedule rather than reusing the old one. These small habits keep each tenancy's history clean and make your reports accurate for every period.

Track rent in Letzo!

Letzo! creates rent schedules for each tenancy, shows who has paid and who is due, and matches bank transactions through Open Banking. Explore Rent & payments and Open Banking, and grab the free landlord's year checklist to keep your monthly routine on track.

RentArrearsOpen Banking
Keep every property task connected.
Start free trial

7 day free trial. No card required. Cancel before day 7 and pay nothing. Terms apply.

The landlord's year, on one page. Every monthly, quarterly and yearly task in one free checklist.Get the free checklist