Client Money Reconciliation Workbook
The client-account reconciliation your accountant will ask for — ready-made.
Enter your bank balance, cash book and client ledgers. See instantly whether they agree three ways, what an accountant would flag, when your balancing statements are due and what’s missing for your Accountant’s Report — then take it all away as an Excel workbook.
2 months
to prepare each balancing statement — two a year1 month
the longest agency fees may sit in the client account7 years
how long client-money accounting records are kept6 weeks
before expiry: renewal and signed Accountant’s Report dueClient money is where agencies get sanctioned
The PSRA reads your reporting accountant’s opinion on client money first. A reconciliation that doesn’t agree is the finding — before anything else is looked at.
A six-month suspension
New Ireland Lettings had its licence suspended for six months for failing to account for client money — a major sanction confirmed by the High Court.
28 complaints about money kept back
Of the 304 complaints the PSRA received in 2025, 28 were about money being kept back. Every one starts with records that don’t reconcile.
Any breach, any size
Your reporting accountant must report a breach of the Client Moneys Regulations — a late lodgement counts whatever the amount.
Reconcile your client account three ways
The result updates as you type. Everything stays in your browser until you ask for the workbook.
1.The bank
Your client account statement, and anything in the cash book that hasn't reached it yet.
€0.00
The statement date — usually a month end
€
Closing balance on that date
Lodgements in transit
Receipts in the cash book, not yet on the statementUnpresented payments
Payments in the cash book that haven't cleared the bank2.The cash book
The client cash book balance on the same date.
€0.00
€
3.The client ledgers
What you hold for each landlord client. Leave agency fees and unidentified money out — they go below.
€0.00
€
€
Fees and commission due to you, not yet drawn
So we can check the 1-month rule
€
Money in the account you haven't yet put on a client ledger
4.Your year
Your accounting year end sets your two balancing dates; your licence sets the Accountant's Report deadline.
Optional · usually 5 November
For your time-saved estimate
Three-way reconciliation
Balanced
Nothing to flag
Three-way reconciliation · 15 Nov 2026
Balanced
Bank, cash book and client ledgers agree — no shortfall, no overdrawn ledger.
Bank
statement, after items in transit
€0.00
Agrees
Cash book
client cash book balance
€0.00
Agrees
Client ledgers
plus agency fees and unidentified receipts
€0.00
Nothing to flag on these figures. Sign the reconciliation off and file it with the year’s records.
Your balancing dates and Accountant’s Report checklist
Two balancing statements a year, one Accountant’s Report with every renewal. See when each is due and tick off what your accountant will ask for.
Your balancing dates
Six months into your accounting year and at the year end. Each balancing statement is due within two months.
31 Dec 2026 · accounting date
30 Jun 2027 · mid-year
31 Dec 2027 · accounting date
Licence renewal + signed Accountant’s Report by 24 Sept 2027 (313 days) — six weeks before your licence expires on 5 Nov 2027.
Keep this year’s client-money records until at least 31 Dec 2033.
Accountant’s Report checklist
0%
Tick what you already have. 0 of 19 in hand.
Get the workbook, opened at this reconciliation
Nine tabs with live formulas, starting from the balances above — plus a printable Accountant’s Report prep pack. Emailed to you, and to your principal if you like.
The workbook + the prep pack
An Excel workbook that opens at the reconciliation you just ran — yellow cells are yours, the rest is formulas — and a printable PDF for your accountant.
Every tab in this workbook is a screen in TenantSync — with no formulas to maintain.
Bank accounts
Designated client-account register — including an account already connected through Open Banking
Cash book + client ledgers
A ledger per landlord, rebuildable from the bank movements (Open Banking syncs every six hours)
Reconciliation
Monthly reconciliation of bank against ledgers, signed off — balanced, or with the discrepancy recorded
Balancing dates
Each signed-off reconciliation dated against its balancing date
Accountant’s Report
The annual Accountant’s Report pack, assembled from your signed-off reconciliations
On your figures
72 h
a year back, of the 96 h you spend reconciling
1
landlord ledger kept for you, from the bank movements
0% → 100%
Accountant’s Report readiness, built as you sign off each month
How the checks work
Three ways
Bank statement + lodgements in transit − unpresented payments = cash book = client ledgers + agency money not yet drawn + unidentified receipts. Any difference is shown to the cent, with the most likely cause.
What an accountant flags
A shortfall (owed to clients but not in the account), overdrawn client ledgers, agency fees in the account over a month, unallocated receipts, lodgements in transit over 5 days and payments unpresented over 6 months.
Dates
Balancing dates six months into your accounting year and at its end, each statement due within two months; your renewal and Accountant’s Report six weeks before your licence expires (usually 5 November); records kept seven years.
Client money and the Accountant’s Report — your questions
What is a three-way reconciliation of a client account?
It checks the same money three ways on one date. The bank statement balance, adjusted for lodgements in transit and unpresented payments, must equal the client cash book; and the cash book must equal the total of the client ledgers (what you hold for each landlord, plus any agency money not yet drawn and receipts you have not yet identified). If all three agree, and no client ledger is overdrawn, the account balances.
How often must a letting agent reconcile the client account?
The Client Moneys Regulations 2012 require a balancing statement within two months of each balancing date — one six months into your accounting period and one at the accounting date itself. Reconciling every month is best practice rather than the legal minimum, but it is what makes the balancing statements and the Accountant’s Report straightforward.
How long can agency fees stay in the client account?
Money owed to the agency — management fees, commission — must not stay in the client account for more than a month. Transfer it to the office account and record each transfer on the client’s ledger. The workbook’s Agency fees tab tracks each fee against that deadline.
What is a client money shortfall, and what should I do?
A shortfall is when the client account (after timing items) holds less than the client ledgers say you owe clients — often because one client’s ledger has gone overdrawn and other clients’ money covered it. Find the cause, make it good from agency funds straight away, record what you did, and tell your reporting accountant.
Which Accountant’s Report do I need for my PSRA renewal?
If you hold a client account, the PSRA’s Accountant’s Report for licensees holding client money must be signed by your reporting accountant and sent with your licence renewal, at least six weeks before the licence expires. If you also hold service charges or sinking-fund money in a relevant account, a second report covers that account. Always download the current forms from psr.ie.
How do HAP payments fit in?
The local authority pays HAP for the tenancy up to its limit; where the rent is higher, the tenant pays you the difference (a top-up) directly. Both are client money for the landlord’s ledger. The workbook’s HAP matching tab checks each month’s HAP and top-up against what was expected.
What do you store?
The calculation runs in your browser; nothing is sent until you ask for the workbook. Then we keep the balances, dates and ledger references you entered, your email and, if you give them, your name, role, agency and your principal’s email — so your private link and downloads keep working. Never bank account numbers. Your principal gets one copy and is not added to any list.
Is this accounting or legal advice?
No. It is a working aid based on the Property Services (Regulation) Act 2011 (Client Moneys) Regulations 2012. Your reporting accountant decides what the Accountant’s Report says; check the current forms and guidance on psr.ie.