What does a trust account auditor want to see in a property management reconciliation report?

Key takeaways

• An examiner is testing one claim: that every dollar held for an owner or tenant is accounted for, supported and independently verifiable.

• Three figures must agree on the same date: adjusted bank balance, trust ledger balance, and the sum of individual owner and tenant balances.

• Matching totals are necessary but not sufficient. A perfectly balanced report can still conceal a misallocation between two owners.

• The exceptions schedule is the section most firms leave out and the first section an experienced examiner turns to.

• Named preparer, named reviewer and a date carry real weight. A reconciliation nobody signed is not evidence of a control.

Quick answer

• Proof that the money in the bank, the figure in your ledger, and the total owed to individual clients are the same number on the same day.

• Evidence behind that proof: statements, transaction listings, a complete client balance report, and authorizations for anything that moved.

• An honest account of what did not reconcile, how long it has been open, what you did about it, and who reviewed the whole thing.

An examiner is not auditing your bookkeeping skill. They are testing a single claim: that the money you hold for other people is all still there and correctly attributed. Everything in the report exists to support or undermine that claim, which is why a tidy report with no exceptions schedule often draws more scrutiny than a messy one that documents its problems.

Numetix works on an AI-powered, experts-in-the-loop model. Automation assembles the reconciliation continuously, so the report is a by-product of the month rather than something built the week before an examination. An experienced person owns the exceptions and the sign-off, because those are the parts an examiner actually reads.

The three figures that must agree

Every trust reconciliation report resolves to one comparison. Three independently derived numbers, struck at the same date, that should be identical.

Showing the variance line when it is zero matters more than it sounds. A report that simply presents three equal numbers asks the reader to do the subtraction and trust the result. A report that states the variance has made an assertion it can be held to. Figures above are illustrative.

What a clean three-way check still misses

This is the part most guidance skips, and it is the reason an examiner keeps going after the totals agree. A balanced reconciliation proves the aggregate is intact. It does not prove the attribution is right.

• Two owners can be misallocated against each other by the same amount. The total is unchanged and both statements are wrong.

• A disbursement can be correctly recorded and still have been unauthorized. The arithmetic has no opinion about permission.

• A deposit can sit in the right account and the wrong tenant ledger, which surfaces only at move-out.

• Fees can be swept at the wrong rate every month and reconcile perfectly every month.

• Balances can be correct on the reporting date and have been short for three weeks before it.

That last one explains why examiners ask for transaction listings rather than just period-end balances. It is also why reconciliation cadence matters independently of the report, which is covered in our guide to the property management month-end close.

How the report should be laid out

Order matters because it mirrors how the work is verified. Each section should let the reader check the one before it.

• Identification. Firm name, the specific trust account and its last four digits, the period, and the date prepared.

• Bank reconciliation. Statement balance, each reconciling item listed individually rather than netted, and the adjusted balance.

• Ledger summary. The trust control account balance straight from the general ledger.

• Client funds summary. The total of individual balances, with the detailed schedule attached rather than summarized.

• Three-way comparison. All three figures side by side with the variance stated.

• Exceptions schedule. Treated below, because it deserves its own attention.

• Supporting schedules. Full ledgers and transaction listings for the period.

• Certification. Prepared by, reviewed by, dates, and whatever signature the rules in your state require.

The exceptions schedule decides the tone of the visit

Firms leave this out because listing problems feels like volunteering for trouble. The opposite is true. An examiner who finds an issue you had already documented is reviewing a functioning control. An examiner who finds the same issue in a report that claimed everything was clean is now questioning the report itself, and by extension every other month of it.

A usable exceptions schedule carries four columns: what the item is, the amount, how long it has been open, and what is being done. Age is the column firms forget and the one that gets read first, because an exception that has been open for five months is a different conversation from one that arose last week.

Red flags, and what they suggest

A shortage or unexplained difference should be investigated, documented and resolved. Carrying it forward is bad practice. Clearing it with a journal entry that has no support is considerably worse, because it changes a bookkeeping failure into something that looks deliberate.

A note on whose rules apply

Ask a general assistant this question and the answer you get may be framed for another country entirely, with its own vocabulary and its own report format. In the United States, trust account examinations are run by individual state real estate commissions, and the required format, deadlines, signatures and record retention periods differ between them. Confirm the specifics in our state-by-state trust account requirements guide before setting your report template, and keep the owner statements you issue consistent with what the reconciliation supports.

So what does an examiner actually want? A report that would let a competent stranger rebuild your trust position from the evidence attached, and that tells them where the problems are before they have to find them.

Common questions

Is a bank reconciliation enough on its own?

No. A bank reconciliation proves your ledger agrees with the bank. It says nothing about whether the money is correctly divided between the people it belongs to. The third leg, the sum of individual owner and tenant balances, is what turns a bookkeeping check into a trust control, and it is the leg examiners find missing most often.

Should I report an exception I have not resolved yet?

Yes, with its age and what you are doing about it. An unresolved item that is documented and being worked reads as a functioning process. The same item discovered by an examiner in a report that showed no exceptions undermines everything else in the file, including the months that were genuinely clean.

Who can sign the reconciliation as reviewer?

Someone who did not prepare it and cannot release trust payments. In a small firm that is often the broker or principal rather than a second accountant. What matters is that two names appear, that they are different people, and that the reviewer saw the exceptions rather than only the summary page.

A reconciliation pack that is always current

Numetix assembles the three-way reconciliation, the client schedule and the exceptions list every month, with a named reviewer on each one, so an examination request is a download rather than a project.

See accounting services or how this works for property management firms.

This article is for informational purposes only and does not constitute legal, regulatory or accounting advice. Trust account examination requirements are set by individual state real estate commissions and vary. Figures shown are illustrative. Confirm the required report format with your state regulator. For ongoing support, see monthly bookkeeping.