unmatched rent paymentsrent reconciliationrent arrears5 October 2026

How to review unmatched rent payments without guessing

Review unmatched rent payments with evidence, not hunches. Check reference, amount, date and payer, park the rest, and only allocate what you can prove.

How to review unmatched rent payments without guessing

Unmatched rent payments are money in your account that you can't yet tie to a tenant and a rent period. To review them without guessing, check each one against the evidence in the same order every time. Park anything you can't prove and ask before you allocate. An unmatched payment sitting in a list for a few days is annoying. A payment booked to the wrong tenant is a proper mess, and it shows up months later as an arrears letter going to someone who paid.

What is an unmatched rent payment?

It's a line on the bank statement where money came in but nothing links it to a tenancy with confidence. The reasons are usually boring:

  • The tenant typed their own name instead of the reference you gave them.
  • Someone else paid. A partner, a parent, a guarantor, an employer.
  • Two months came in one go, or one month came in two halves.
  • A council or Universal Credit managed payment arrived with its own reference, sometimes covering more than one tenant.
  • The reference is right but the amount is a few pounds out.
  • It isn't rent at all. A deposit top-up, a supplier refund, a contractor sending back an overpayment.

None of these are hard on their own. They get hard when there are forty of them and it's Friday afternoon.

Why guessing costs more than waiting

Here's the part people hate hearing. An unmatched payment isn't the problem. A wrongly matched one is.

Book it to the wrong tenant and you've made two errors, not one. One tenant shows as paid when they haven't. The other shows in arrears when they have. Then somebody chases the wrong person, the tenant who paid gets annoyed, and you're on the phone apologising while you dig back through statements.

I built a maintenance company in London working for letting agents and housing associations, and I've always run money the same way. If you can't show where it came from and what it's for, you don't book it. You park it and find out. That rule is slower on the day. It's much faster over a year.

The order to review unmatched rent payments

Work every line in the same order. Don't jump to the payer name because it looks familiar. Familiar is how mistakes happen.

1. Start with the reference

Look for typos, swapped digits, a missing prefix, a flat number written as a word. A reference that's one character off a live tenancy is good evidence. On its own it's still not enough.

2. Check the amount against what's due

Does it match the rent for that tenancy exactly, or the exact outstanding balance? On a weekly tenancy, check whether it's four or five weeks paid at once. An amount that matches nothing on the account is a reason to slow down.

3. Check the date against the usual pattern

Standing orders tend to land around the same day each period. If a tenant always pays on the 1st and this lands on the 1st, that counts. If it lands mid-month with no explanation, it counts for less.

4. Then the payer name, carefully

Names are the weakest evidence you've got. Two tenants called J Smith. Joint tenants paying from one account. A guarantor with a different surname. Use the name to support a match, never to make one.

5. Look at the tenancy's history

Is there a gap this period on the tenancy you think it belongs to? Did the same amount come from the same payer last month? History either backs up your match or tells you you're wrong.

6. If the evidence doesn't agree, ask

Contact the tenant or the payer through your normal route. Write down what you asked and when. Don't allocate while you wait.

My threshold is simple. Two independent checks agree, allocate it. Only one, park it. A reference plus an exact amount is two. A name plus a vaguely right amount is not.

Part-payments, lump sums and overpayments

Most of the work isn't finding the tenant. It's deciding what the money covers.

A part-payment goes against the period it was meant for, and the balance stays in arrears. Don't round it off and don't let it quietly clear the period. If the tenant agreed a payment plan, record that so the next person reading the account understands what they're looking at.

A lump sum covering several periods needs splitting. Allocate it in the order agreed with the tenant or your landlord client, and record the decision. If the account is anywhere near formal arrears action, get proper advice on how the money should be applied before you decide. I'm not going to give you legal advice in a blog post.

An overpayment is the tenant's money until someone decides otherwise. Hold it as credit, tell the tenant, and agree whether it rolls forward or goes back. Don't let it disappear into next month.

A council or Universal Credit managed payment covering several tenants should be split using the payment schedule that goes with it. If you don't have the schedule, you don't have a match yet.

And if the money isn't rent, take it out of the rent review completely. A contractor refund sitting in a tenant ledger will confuse everyone who touches that account after you.

What needs a person's decision

Software can line things up and show you the evidence. It shouldn't decide whose money it is when the evidence is thin. These are the calls a person makes:

  1. Allocating a payment when the checks don't agree.
  2. Splitting a lump sum across periods or tenants.
  3. Treating an overpayment as credit or as a refund.
  4. Writing anything off.
  5. Contacting a tenant about arrears.
  6. Anything heading towards legal action.

If your process lets any of those happen without someone signing it off, that's the bit to fix first.

How the review works in Plan@Job Rent Book

Rent Book is the rent side of Plan@Job. You set up tenancies with weekly or monthly rent periods. You bring transactions in by importing your bank statements, or through a bank connection where your account setup is supported.

Lines that match a tenancy reference get matched to it. Lines that don't go into an unmatched review. Someone on your team works through that list and decides on each line. Assign it to a tenancy and period, record it as a part-payment, or hold it as credit. Arrears are worked out from what's been allocated, so the arrears figure is only as good as that review.

To be clear about what it isn't: rent goes straight from the tenant's bank to yours. Plan@Job doesn't collect rent, doesn't hold it and doesn't run Direct Debits. It records, matches and shows you what's outstanding. The decisions above stay with you.

Illustrative example

This is a made-up example, not a real customer. A manager imports the month's statement. One line is £950 from K OSEI with the reference FLT2 HIGH ST. The tenancy reference is HS-FLAT2, rent is £950 monthly, and the tenant's standing order always lands on the 1st. Reference close, amount exact, date right. Three checks agree, so it gets assigned.

The next line is £1,425 from an account name the manager doesn't recognise, with no reference. It could be one and a half months on a £950 tenancy. It could be something else entirely. Only the amount points anywhere, so it stays in unmatched review and the manager contacts the tenant they suspect. Nobody guesses.

Stop the same payment going unmatched next month

Fixing the line is half the job. Fixing the cause is the other half.

Send the tenant their correct reference in writing and ask them to update their standing order. Keep a note on the tenancy of who else pays for it, whether that's a parent, a guarantor or an employer. Ask councils for payment schedules before the money lands, not after. And look at the pattern. If the same tenant ends up unmatched every month, a quick phone call will save you twelve reviews a year.

The goal isn't an empty unmatched list. It's a list where everything on it is there for a reason you can explain.

If you're doing this on spreadsheets and highlighter pens, look at how Rent Book handles statement imports, reference matching and unmatched review. For the wider picture of how Plan@Job works for letting agents and managers, see the property managers page. Match what you can prove. Ask about the rest.

FAQ

How long should an unmatched rent payment sit before I act?

Review it at your next reconciliation, which for most managers means weekly. If you still can't match it after checking the evidence, contact the likely payer straight away rather than letting it age. The longer it sits, the harder it is to trace.

Can I match a rent payment on the payer's name alone?

No. Names are the weakest evidence because of joint tenants, guarantors and people who share a name. Use the name to back up a match on reference, amount or date, never as the only reason to allocate.

Does Plan@Job collect rent from tenants?

No. Rent goes directly from the tenant's bank account to yours. Plan@Job Rent Book imports your statements or uses a supported bank connection, then matches payments, flags unmatched ones and tracks arrears, part-payments and credit.