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
- 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.
- 2The cash book. The record of every movement in and out of the client account, from the opening balance to the day.
- 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:
| Scheme | How often |
|---|---|
| Propertymark | At least once every two calendar months, and within ten weeks of the last |
| UKALA | Not less than once a month |
| RICS | Regularly; guidance says once a calendar month, within six weeks of the last, or quarterly with only one or two transactions a month |
| Client Money Protect | At 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 see | Where to look | Usual causes |
|---|---|---|
| Bank and cash book agree, ledgers differ | Between the cash book and the ledgers | An entry in the cash book not posted to any ledger, posted twice, or posted with a different amount |
| Cash book and ledgers agree, bank differs | The bank statement | A bank charge, an unidentified receipt or a payment the records do not hold, or a timing item not listed |
| All three differ | Both, bank side second | More than one cause: clear the cash book and ledgers first, then the bank |
| All three agree, one ledger below zero | That landlord’s ledger | More 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
| Cause | How it shows | What to do |
|---|---|---|
| Rent received and recorded, not yet cleared | Bank below the cash book | List it as a reconciling item with its date; it should clear within days |
| Payment recorded, not yet through the bank | Bank above the cash book | List it with its date; follow it up if it does not go through |
| Bank charge taken from the client account | Bank below the cash book | Record it, replace it from the office account, and ask the bank to charge the office account in future |
| Money in with no reference | Bank above the cash book | Treat it as client money until identified, hold it apart, then post it to the right ledger |
| Rent posted twice | Cash book and ledgers above the bank | Reverse the duplicate in both |
| Entry in the cash book, missing from a ledger | Cash book and ledgers differ | Post it to the ledger it belongs to |
| Fee moved to the office account but not recorded | Bank below the cash book | Record the transfer, and check the fee had been earned |
| Office money paid into the client account | Bank above the cash book | Move 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 ledger | Held |
|---|---|
| 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.