Reesure

Rent reconciliation and month-end close: every receipt on the right tenant

Every month, each rent receipt has to land on the right tenant and the right month. This guide shows how rent reconciliation works, how to handle payments that do not fit, and what to finish before you close the month.

The short answer

Rent reconciliation means matching every receipt to the tenant and the rent period it pays. A fixed payment reference per tenancy does most of the work. Part-payments, receipts without a reference and returned Direct Debits need a person to check them. Letting agents also reconcile the client account: the bank balance, the cash book (their own record of money in and out) and the client ledgers (the balance held for each landlord) must agree. Close the month only when every receipt has a home or a written explanation.

1. What rent reconciliation means

Each month you raise a charge for every tenancy: the rent due under the tenancy agreement. Reconciliation links each receipt in the bank to one of those charges, for the right rent period. A receipt in November can pay October's rent. A fully paid charge is cleared; any part still open stays visible as arrears.

Until you match a receipt, your arrears list is wrong. A tenant who has paid can get a reminder they do not deserve. A tenant who has not paid can disappear among the other credits on the statement.

2. Why the payment reference matters

A payment reference is a fixed code per tenancy that the tenant adds to every payment. With it, you see at once who paid. Without it, you search by name, account or amount, which often fails with joint accounts and equal rents.

  • Show the reference everywherePut it in the tenancy agreement, on the rent demand, in every reminder and in any payment link.
  • Keep one reference per tenancyLeave it unchanged after a rent increase or a missed month, so standing orders keep working.
  • Let the Direct Debit carry itWith a Direct Debit you pull the payment from the tenant's account, so you set the reference on every collection.
  • Correct a wrong reference straight awayIf a tenant uses an old or wrong reference, send the right one with the payment confirmation.

Read more: Ways to collect rent: every option explained

3. Part-payments and overpayments

With a part-payment, the tenant pays less than the charge. Match the amount paid and leave the rest open as arrears. If you mark the whole charge as paid, the shortfall drops out of sight.

  • Record what the tenant saysIf the tenant writes that the payment is for a specific month, note it and match it that way.
  • Use one fixed order when the tenant says nothingFor example, match to the oldest open charge first. Write the order down and use it every month.
  • Link it to any payment planIf the part-payment is an agreed instalment, note that so nobody chases it as a missed payment.

An overpayment works the other way. Keep it as a credit on the tenant's own account and ask whether it should go towards next month's rent or back to the tenant.

4. Receipts you cannot identify

Put a receipt without a usable reference in a suspense ledger first: a separate line where money sits until you know whose it is. Then search by the payer's account details, name and amount.

Sometimes a partner, a parent or a guarantor pays the rent. Match that receipt to the tenant's account and save the payer's details, so you recognise the next payment straight away.

Keep the suspense ledger short, or a tenant who paid may still show as owing. An unidentified receipt in a client account is still client money. RICS treats it as a reconciling item the reconciliation must list and explain. Propertymark keeps its client suspense ledger inside its accounting rules and reconciliations.

5. Returned Direct Debits and refunds

A Direct Debit can look paid on collection day and still come back unpaid, for example when the account lacks funds or the tenant has cancelled the instruction.

The Direct Debit Guarantee also lets a tenant get money back later. If the collecting organisation or the bank makes an error in a payment, the tenant is entitled to a full and immediate refund from their bank. A tenant can also cancel a Direct Debit at any time through their bank.

  • Reopen the charge for the rent period it belongs to, and record the return in the cash book on the date it arrives.
  • Contact the tenant and agree how they will now pay.
  • Check whether the instruction is still active before the next collection.
  • Handle a refund that arrives months later by the same rule.

Read more: Failed rent payments: returns, claims and next steps

Reesure starts each collection, confirms every payment as it is made and allocates part-payments to the right period. Your team keeps control of the close.

6. A worked example: November for six flats

A letting agent manages six flats for two landlords. Landlord A owns flats 1, 4, 5 and 6; landlord B owns flats 2 and 3. Rent is due on Sunday 1 November 2026, so the agent collects Direct Debits on Monday 2 November. The client account started November empty, and the agent pays nothing out before the close.

ExampleRent due and received in November

Five tenants pay. A part-payment and a returned Direct Debit leave money open.

Flat 1: standing order with the right reference
£1,150 of £1,150
Flat 2: Direct Debit collected on 2 November, then returned unpaid
£0 of £950
Flat 3: part-payment, tenant writes 'November rent'
£700 of £1,150
Flat 4: transfer without a reference, held in suspense
£825 of £825
Flat 5: bank transfer with the right reference
£1,300 of £1,300
Flat 6: Direct Debit collected on 2 November
£1,050 of £1,050
Received after the return, out of £6,425 due
£5,025

Gross credits were £5,975; the returned £950 brings this to £5,025. Still open: £950 for flat 2 plus £450 for flat 3, so £1,400.

The £825 for flat 4 came from an account in another name. The agent traced it by amount and account details and moved it from suspense to flat 4.

7. Client account reconciliation for letting agents

A letting agent who collects rent holds it as client money: money that belongs to the landlord, not the agent. In England, an agent holding client money must belong to an approved client money protection scheme. That duty has applied since 1 April 2019, with a fine of up to £30,000 for not joining.

The agent must also display its membership certificate in each office where it deals with the public and on its website. Scotland, Wales and Northern Ireland have their own rules. RICS and Propertymark set client money rules for their members.

Both RICS and Propertymark require a reconciliation of three figures: the bank balance, the cash book and the total of the client ledgers. Every difference must be explained, and a senior person signs the result. Each body sets its own minimum interval, so check yours.

ExampleThe client account on Monday 30 November

The agent runs a first reconciliation before entering the returned Direct Debit in the cash book.

Bank statement
£5,025
Cash book, before entering the return
£5,975
Difference: the returned Direct Debit for flat 2
£950
Cash book, after entering the return
£5,025
Ledger landlord A: £1,150 + £825 + £1,300 + £1,050
£4,325
Ledger landlord B: £700
£700
Ledgers added together, equal to bank and cash book
£5,025

Before the agent identified flat 4, the £825 sat in suspense and landlord A's ledger was £3,500. The total was still £5,025, but the reconciliation had to list the £825 as unidentified.

Read more: Client money and client accounts for letting agents

8. Arrears reporting at month-end

The month-end arrears list is only as good as the matching behind it. Run it after you have matched every receipt and reopened every return. In the example, it shows £1,400 open over two tenancies.

  • Split by tenancy and monthShow which month each amount belongs to.
  • Give the cause where knownA returned Direct Debit needs a different response from a tenant who chose to pay less.
  • Show payment plans separatelyKeep arrears under an agreed plan apart from the rest.
  • Add the last actionNote the last contact or letter, so the next step is clear.

A useful figure to follow month by month is rent received against rent due. In the example, £5,025 of £6,425 came in: 78.2%. The trend says more than one month.

Read more: Arrears figures that matter: six measures for rent income

9. What the landlord statement shows

After the close, each landlord wants to know what came in, what you deducted, what you paid out and what is still owed, per period.

ExampleNovember statement for landlord B

Landlord B owns flats 2 and 3. In this example the agreed management fee is 10% of rent received; VAT and other costs are left out to keep the sum simple.

Rent due: £950 for flat 2 + £1,150 for flat 3
£2,100
Received: flat 3 part-payment
£700
Flat 2 Direct Debit, collected and returned
£0
Management fee, 10% of £700
£70
To pay out to landlord B after the close
£630

The statement also lists £1,400 still owed for November. Without the return on it, landlord B would expect £950 more.

10. The month-end close

Closing the month draws a line under it: the figures for that month no longer change. Enter a receipt that arrives later in the next month and match it to the old charge. Close the month only when you have done the following:

  • Raise every rent charge for the month, including new tenancies and rent changes.
  • Import every bank transaction up to the last day of the month.
  • Match every receipt, or add a note saying why not.
  • Empty the suspense ledger, or explain every item in it.
  • Record every returned Direct Debit and reopen its charge for the right period.
  • For a client account: agree the bank balance, cash book and client ledgers, and get the reconciliation signed.
  • Check the arrears list against the open charges and the landlord statements against the ledgers.

If you use a PMS (the system that holds tenancies and tenants) alongside separate accounting software, check that open charges agree in both.

Read more: Rent payments and reconciliation with Reesure

Checked on 20 November 2026 against multiple sources.

This is a general explanation, not advice for your situation.

Common questions

What is a three-way reconciliation?

A check that three figures agree on the same date: the client account balance on the bank statement, the cash book balance and the total of all client ledger balances. You list and explain any difference.

What do I do with a receipt that arrives after the month is closed?

Enter it in the month it arrives and match it to the old charge. The closed month stays as it was, so earlier reports and landlord statements still add up.

Can I pay out rent from a Direct Debit that could still come back?

A Direct Debit can be returned unpaid after collection day, and a tenant can claim a refund under the Direct Debit Guarantee later. Check your client money rules and your management agreement before you pay it out.

All articles in this guide

Read next

A month-end close that adds up, without searching for payments.