How to Reconcile a Letting Agent Statement with Your Rent Ledger

The amount your letting agent transfers is not necessarily the rent your tenant paid. Reconcile the tenant receipt, agent deductions and landlord remittance separately before chasing an apparent shortfall.

This is a UK landlord bookkeeping workflow, not tax advice or an assessment of an agent’s client-money compliance. The examples are fictional. Use the actual agreement, statement and supporting transactions; ask your agent or accountant about unexplained entries.

1. Define the period before comparing totals

Choose a statement period and a cut-off date. A payment collected on the last day of one month may arrive in your account the next month. That timing difference is not automatically arrears. Note the statement’s opening balance, receipts, deductions, retained funds and closing balance.

Check what each date represents: rent due, tenant payment received, agent processing or bank settlement. Keep the original reference rather than changing every date to make the columns line up. If the starting balance is unsupported, label it as awaiting confirmation instead of quietly setting it to zero.

2. Separate four different records

• Rent charge: the amount due under the tenancy for the relevant period.
• Tenant receipt: money the agent confirms collecting from the tenant.
• Deduction: a fee, repair or other item supported by the statement and invoice.
• Remittance: money the agent actually sends to you.

Record the tenant receipt once. A subsequent transfer from the agent is movement of that money, not another tenant payment. Similarly, an invoice and its appearance on the agent statement describe the same expense unless the evidence establishes otherwise.

3. Worked example: why £940 can represent £1,200 rent

Fictional example: the agent collected £1,200 rent, charged a £120 management fee and paid a £140 approved repair invoice. With no opening or retained balance, the expected remittance is £1,200 − £120 − £140 = £940.

The tenancy ledger records £1,200 received, not £940. The £260 difference is supported by two deductions; it is not tenant arrears. If only £900 reaches your account, the remaining £40 is an agent reconciliation question until explained. Do not send a £300 arrears demand based on the net bank deposit.

Now suppose the statement also shows £80 of money held from the previous month and £50 retained for an agreed reserve. The expected transfer becomes £80 + £1,200 − £120 − £140 − £50 = £970. Retained money should remain visible with a reason and a follow-up date.

4. Use this reconciliation note

• Property, tenancy and statement period.
• Supported opening funds held by agent.
• Tenant receipts and references.
• Itemised deductions with invoice references and approval evidence.
• Closing funds retained and explanation.
• Expected remittance, actual remittance and remaining difference.
• Question sent, responsible contact and next review date.

This is an administrative record, not an accounting-standard determination. HMRC distinguishes rental income from allowable expenses; a deduction on an agent statement does not automatically establish the correct tax treatment. Flag mixed work, improvements or ownership questions for your accountant.

5. Prevent duplicates when importing

Keep an import register showing the source file, covered dates and last reviewed transaction. Compare an import preview with records already entered manually. Matching amounts alone are not enough: two tenants may pay the same rent, and one tenant may make two genuine equal payments.

Use source references, dates, tenancy and amount together. Keep suspected duplicates unresolved until checked. If a correction is needed, retain an explanation of the original entry and change rather than deleting the history that made the discrepancy understandable.

Common questions

What if the agent statement and bank disagree?

Ask for the remittance reference and any pending settlement or retained-funds explanation. Keep an exception open with the evidence. Do not alter tenant receipts simply to force the landlord bank total to match.

Should I send the accountant my whole bank account?

Agree the necessary scope and secure delivery route. The ICO’s principles include minimising personal data and protecting it. Supply relevant supporting records without exposing unrelated people’s information.

Continue with the accountant handover checklist once the remaining questions are clearly listed.