For letting agents & accounts staff
Free · runs in your browser
Excel workbook + PDF prep pack

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 year

1 month

the longest agency fees may sit in the client account

7 years

how long client-money accounting records are kept

6 weeks

before expiry: renewal and signed Accountant’s Report due
Sources: Property Services (Regulation) Act 2011 (Client Moneys) Regulations 2012 (S.I. 199/2012); PSRA renewal guidance; PSRA Annual Report 2025.

Client 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.

Step 1 of 3 · reconcile

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 statement

Unpresented payments

Payments in the cash book that haven't cleared the bank

2.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

Your result

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

Cash book

client cash book balance

€0.00

Client ledgers

plus agency fees and unidentified receipts

€0.00

No shortfall
No overdrawn ledgers
Owed to clients €0.00
What to clear first

Nothing to flag on these figures. Sign the reconciliation off and file it with the year’s records.

Step 2 of 3 · get ready

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

Statement due 28 Feb 2027 · 105 days

30 Jun 2027 · mid-year

Statement due 31 Aug 2027 · 289 days

31 Dec 2027 · accounting date

Statement due 29 Feb 2028 · 471 days

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.

Bank and accounts
Books of account
Reconciliations and balancing
Accountant and renewal
Step 3 of 3 · take it away

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.

Bank accounts
Every client and office account, with a "client" in the title check
Cash book
Receipts and payments, running balance, days to lodge
Client ledgers
One per landlord, filled from the cash book, overdrawn flagged
Reconciliation
Three-way, with timing items, shortfall check and sign-off
Balancing dates
Both statements a year, due dates and status
Agency fees
The 1-month rule, fee by fee
HAP matching
Local-authority payments against tenant top-ups
Accountant’s Report
The document checklist, with your ticks carried over
Start here
Your year end, licence date and the rules on one page
Free · no spam · unsubscribe anytime.
Reconcile without the spreadsheet

Every tab in this workbook is a screen in TenantSync — with no formulas to maintain.

In the workbookIn TenantSync

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

Start a 14-day free trialSee a client-account reconciliation in a demoHow the PSRA module works →PSRA module on Growth, from €149/month · free migration · no card to start

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

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.

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.

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.

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.

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.

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.

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.

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.

A working aid based on the Property Services (Regulation) Act 2011 (Client Moneys) Regulations 2012 — not legal or accounting advice. Your reporting accountant decides what the Accountant’s Report says; check the current forms and guidance on psr.ie.

Automate this in TenantSync

This tool does the job once. TenantSync does it for every tenancy you manage, and reminds you when it is due again.

We use cookies to see how TenantSync is used and to measure our Google and LinkedIn ads. Privacy Policy