Skip to main content
LetCompliance
Letting Agents

Three-way reconciliation for letting agents, step by step: what a difference means and how to trace it

When the bank, the cash book and the client ledgers do not agree, which two of them agree tells you where to look. The usual causes, and one made-up month traced from three different totals to one.

12 min read

Sample account, an agency’s letting pipeline: 6 properties to market and none yet at viewings, applications, holding deposit, agreement or ready to move in; 14 Brackenholt Road, Sheffield for Margaret Holroyd in the Sheffield branch, 19 Quarnby Rise, Leeds for Gail Whitworth and 27 Fennick Grove, Leeds for Priya Ashworth in the Leeds branch, each not advertised yet
Sample account, an agency’s landlord client: Margaret Holroyd, active, 2 properties, full management at 10% of rent
Sample account with made-up details, 18 Oct 2026

See how LetCompliance works for letting agents

A three-way reconciliation sets three figures side by side on one date: the client account’s bank balance (adjusted for money recorded but not yet through the bank), the client cash book, and the total of every client ledger. All three should agree to the penny. When they do not, the pattern tells you where the problem is: which two figures agree points to the third as the one to examine.

A difference left standing is either a client’s money missing or money in the wrong place, and at month end it costs an hour to find. Left until an accountant’s report or a scheme inspection, it takes far longer to trace, and it is much harder to explain to a landlord who hears about it from someone else. This guide is about the month that does not agree. The method itself, and a clean month worked to the penny, are in client accounting for letting agents.

The three figures, in brief

  1. 1The bank. The client account’s balance on the statement for the day, plus money recorded as received that is not yet in the bank, less payments recorded that have not yet gone through it. These timing items are what RICS calls reconciling items.
  2. 2The cash book. The record of every movement in and out of the client account, from the opening balance to the day.
  3. 3The client ledgers. What is held for each landlord and each tenant, added up, together with anything else the records say is in the account, such as fees earned and not yet moved.

Propertymark’s rules define a reconciliation as an analysis of the differences between those three on a given date. Neither client money regulation sets how often. The schemes do, for their own members:

SchemeHow often
PropertymarkAt least once every two calendar months, and within ten weeks of the last
UKALANot less than once a month
RICSRegularly; guidance says once a calendar month, within six weeks of the last, or quarterly with only one or two transactions a month
Client Money ProtectAt regular intervals

Monthly is the rhythm that keeps the causes below small enough to find. How long to keep each signed reconciliation is in letting agent record keeping.

Which two agree tells you where to look

What you seeWhere to lookUsual causes
Bank and cash book agree, ledgers differBetween the cash book and the ledgersAn entry in the cash book not posted to any ledger, posted twice, or posted with a different amount
Cash book and ledgers agree, bank differsThe bank statementA bank charge, an unidentified receipt or a payment the records do not hold, or a timing item not listed
All three differBoth, bank side secondMore than one cause: clear the cash book and ledgers first, then the bank
All three agree, one ledger below zeroThat landlord’s ledgerMore paid out for them than came in, or money posted to the wrong landlord

Two of those rows need a word more.

A posting to the wrong landlord does not change any total. The cash book and the ledgers still agree; one ledger is too high and another too low. It surfaces as a negative balance, or as a landlord asking where their rent went. Check the tenant’s reference on the bank line against the ledger it was posted to.

A negative ledger is never just a figure. Propertymark’s rules forbid paying out for one client more than is held for that client, because the excess is another client’s money. Find the cause the same day: an overpayment is recovered from the landlord or made good by the agency, and a misposting is moved to the right ledger.

The usual causes, and what to do with each

CauseHow it showsWhat to do
Rent received and recorded, not yet clearedBank below the cash bookList it as a reconciling item with its date; it should clear within days
Payment recorded, not yet through the bankBank above the cash bookList it with its date; follow it up if it does not go through
Bank charge taken from the client accountBank below the cash bookRecord it, replace it from the office account, and ask the bank to charge the office account in future
Money in with no referenceBank above the cash bookTreat it as client money until identified, hold it apart, then post it to the right ledger
Rent posted twiceCash book and ledgers above the bankReverse the duplicate in both
Entry in the cash book, missing from a ledgerCash book and ledgers differPost it to the ledger it belongs to
Fee moved to the office account but not recordedBank below the cash bookRecord the transfer, and check the fee had been earned
Office money paid into the client accountBank above the cash bookMove it out promptly; Client Money Protect’s rules give three working days

What the schemes say about the harder cases:

  • Unidentified money. UKALA’s standard treats an unidentifiable transaction as clients’ money until it can be identified. Propertymark’s rules send old or dormant funds that cannot be traced to a client suspense ledger, which stays within the reconciliation.
  • Old reconciling items. RICS guidance says a reconciliation should not carry regularly occurring adjustments or reconciling items more than three months old, or unpresented cheques more than six months old; an old cheque is cancelled, written back and reissued.
  • Bank charges. RICS guidance says charges on a general client account should be taken from an office account, not the client account. The 2018 regulations allow a client account to hold only client money, money paid in to replace a sum taken out in error, and interest.
  • Errors. RICS guidance says any error found should be put right immediately.

A worked month that does not agree

A made-up agency holds client money for three landlords, Patel, Morgan and Okafor, in one client account. It runs the check for 31 October 2026. Two timing items are known: £950.00 of rent was received and recorded on 31 October and clears on 2 November, and a £600.00 payment to Okafor was recorded on 30 October and goes through the bank on 2 November.

The first run gives three different totals:

Figure
Bank statement balance, 31 October£7,355.00
Plus rent received, not yet cleared£950.00
Less payment recorded, not yet through£600.00
A. Bank, adjusted£7,705.00
B. Cash book£8,180.00
C. Client ledgers (Patel £2,700.00, Morgan £4,000.00, Okafor £1,780.00)£8,480.00

All three differ, so start between the cash book and the ledgers.

Step 1: the cash book against the ledgers

The ledgers are £300.00 above the cash book. Looking for an entry of exactly £300.00 finds a repair at Patel’s property: paid from the client account and in the cash book, but never posted to Patel’s ledger. Posting it brings Patel to £2,400.00 and the ledgers to £8,180.00, equal to the cash book.

Step 2: the bank

Now the cash book and the ledgers agree and the bank is £475.00 below them, so the cause is on the bank side. Two bank lines are not in the records: a £25.00 bank charge on 28 October, and £400.00 paid in on 29 October with no reference. Recording both moves the cash book to £8,180.00 − £25.00 + £400.00 = £8,555.00. The £400.00 is client money until someone can say whose, so it goes to a suspense ledger, taking the ledgers to £8,580.00. The bank charge belongs to no client, so no ledger takes it.

Step 3: what is left

The bank is still £850.00 below the cash book. A figure of exactly £850.00 is a rent: Morgan’s October rent appears twice in the cash book and twice on Morgan’s ledger, and once on the bank statement. Reversing the duplicate brings the cash book to £7,705.00, equal to the bank, and the ledgers to £7,730.00, with Morgan at £3,150.00.

Step 4: the last £25.00

The ledgers now say the agency owes its clients £25.00 more than the account holds. That is the bank charge: the bank took client money for an agency cost. It is not explained away; it is replaced. The agency pays £25.00 in from its office account and asks the bank to charge the office account from now on. Then all three figures read £7,730.00:

Client ledgerHeld
Patel£2,400.00
Morgan£3,150.00
Okafor£1,780.00
Suspense, £400.00 received 29 October, unidentified£400.00
Total£7,730.00

The suspense line stays on every reconciliation until the money is identified. Here the agency traces it a week later to an Okafor tenant who paid early from a new bank account, and posts it to Okafor’s ledger.

Sign it off, and keep it

A reconciliation is finished when it is signed. Propertymark’s rules say it should be checked and signed by a principal, or someone appointed, who did not prepare it, and that reconciliations are kept ready for audit or inspection. RICS guidance says the reviewer signs and dates it. Keep with it the bank statement, the list of reconciling items with their dates and the client ledger balances, so that anyone reading it later can follow each figure.

Two more checks belong to the same sitting. Propertymark’s rules ask for money due to the firm, its earned fees, to be taken out before a final reconciliation. And each landlord statement drawn from the same records should agree with that landlord’s ledger; what a statement should show is in what a landlord statement should include. The scheme duty behind all of it is in client money protection for letting agents.

Running the check in LetCompliance

Set the three figures side by side on any day, to the penny. In LetCompliance, letting agent software with the reconciliation built in, Reconcile client account takes the bank figure from an imported statement, or one typed in, adjusted for what is recorded but not yet through the bank, then works out the cash book and adds up each landlord client’s ledger. Each bank line is matched to a rent, a cost, a payout or a fee transfer, and several records paid in one line, such as weekly rents, can be matched together. A difference nobody has explained is counted in full, so a receipt and a payment of the same size never cancel each other out, and a landlord below zero is flagged.

Saving keeps who signed off which day and when, every figure, the differences with their notes and the month’s client money report, as a PDF and a CSV, and a saved reconciliation never changes. The limits, plainly: there is no separate suspense ledger, so a line that cannot be matched gets a note saying what it is or stays listed as a difference; sign-off has one signer, so a second check is arranged by the agency; and bank interest is not shared between clients. Nothing on the page moves money.

The agency plans run from £24 a month for up to 5 properties to £129 a month for unlimited properties. Every agency plan has every agency tool and unlimited seats and branches; only the number of properties and the storage differ.

Frequently asked questions

What is a three-way reconciliation for a letting agent?

Setting three figures side by side on one date: the client account’s bank balance adjusted for timing items, the client cash book, and the total of the client ledgers. All three should agree to the penny, and any difference is explained and put right.

How often must a letting agent reconcile the client account?

No law sets a frequency; each client money protection scheme does for its members. Propertymark asks for at least once every two calendar months, UKALA not less than once a month, and RICS guidance says once a calendar month.

What does it mean if the cash book and ledgers agree but the bank does not?

The cause is on the bank side: a bank charge, money paid in with no reference, a payment the records do not hold, or a timing item that has not been listed. Compare the bank statement line by line with the cash book.

What should an agent do with money paid in with no reference?

Treat it as client money until it is identified, as UKALA’s standard says, hold it on a suspense ledger that stays in the reconciliation, and post it to the right client once the payer is traced. Never move it to the office account.

Can a client ledger go below zero?

It should not. A negative ledger means more was paid out for that client than was held for them, and the excess was another client’s money. Propertymark’s rules forbid it for member firms. Find the cause and put it right the same day.

Who should sign off a client account reconciliation?

Someone other than the person who prepared it, under Propertymark’s rules: a principal or a person they appoint. RICS guidance says a principal or senior member of staff reviews it and signs and dates it.

Sources and scope

Every source above is a government or regulator’s page the guide cites, linked where it is used. A scheme’s rules bind its own members only, and RICS’s guidance is worded as what firms should do. The worked month uses made-up figures. The guide also links other publishers in its text, where it uses them. This is guidance, not individual legal advice.

Ask an AI about this guide

Opens your assistant with this page as its source.

Share this guide

𝕏
Free PDF, instant by email

New Tenancy Document Checklist

What to give a new tenant in England, and when: before the tenancy is agreed, before they move in, and within 30 days of taking the deposit. With the source and the penalty for each.

  • Written statement of terms before the tenancy is agreed
  • Gas, electrical and EPC certificates before move-in
  • Deposit protection and prescribed information within 30 days
  • What not to give a new tenant any more

The guides only come if you tick the box, and you can unsubscribe in one click.

You have read the guide. Now run the let.

Advertise and reference tenants, sign the agreement, collect the rent, log repairs and keep the tax figures ready all year. Certificates, deposits and deadlines are tracked alongside, so nothing expires unnoticed.

Plans from £7.99 a month, with a 3-day trial and no card. Making Tax Digital, recognised by HMRC, comes with every paid plan, not the trial.