Trust Accounting Monthly Reconciliation: The Checklist That Survives a State Commission Audit

Updated for 2026, The monthly cadence still holds, and the new question on every examination prep call is whether any agent is allowed to post entries to the trust ledger. The answer should be no until the controls in our AI trust accounting controls for property management field guide are in place. The orgs we have advised in residential and small commercial property management almost universally underestimate how a state real-estate commission audit actually unfolds, and the consistent finding across the engagements we have run is that brokers who lose their license over trust accounting did not steal money; they failed to produce evidence on a deadline. A commission examiner does not arrive looking for a smoking gun. The examiner arrives with a checklist, a request for the most recent twelve months of reconciliations, the tenant ledger, the owner ledger, the bank statements, and the security deposit register, and the firm either hands over a clean evidence binder within the requested window or it does not. We have seen firms with immaculate cash positions fail audits because they could not produce signed monthly reconciliations, and we have seen firms with messy operating books pass cleanly because their trust workpapers were structured exactly the way the commission expected. The pattern across the property management segment is consistent: the broker-of-record carries personal license risk, the controller or bookkeeper performs the actual reconciliation work, and the handoff between those two roles is where the evidence falls apart. The reconciliation gets done. The variance gets explained verbally. Nobody signs anything. Six months later, the bookkeeper has left, the broker is in front of an examiner, and the workpapers cannot be reproduced. This guide describes the monthly cadence we install on engagements where the firm needs to convert trust accounting from a recurring panic into a defensible control surface, and it is the cadence that holds up against the real-estate commission rules we have worked with across multiple states. The partners verify state-by-state divergence on every engagement; the structure described here is the common spine. For the broader operational context, how trust accounting fits into the rest of the firm's audit-ready posture, see the property management trust accounting audit-ready workflow piece. The current guide is the monthly-cadence companion to that broader framework. The three-way reconciliation is the spine, not the formality Every property management firm we have audited that passed a state examination cleanly performed a true three-way reconciliation every single month, and every firm that failed had been performing what they called a reconciliation but was actually a two-way bank-to-book tie-out with a tenant subledger that had never been compared to the trust liability balance. The distinction matters because a state commission's working assumption is that the trust account balance must equal the sum of what the broker owes to every owner plus every tenant security deposit plus any unapplied tenant credits, and the only way to demonstrate that equality is to reconcile three balances against each other in a single workpaper that an auditor can trace line by line. The three balances are the bank statement ending balance for the trust account, the property management system's trust liability balance broken out by owner and by tenant, and the general ledger trust liability account balance. The reconciliation has to show all three agreeing to the penny, with every reconciling item documented, dated, and either resolved or carried forward with an explanation of why it remains open. We have seen reconciliations that resolve to zero on their face but contain a fifteen-thousand-dollar reconciling item described only as "timing", that workpaper does not survive an examiner who asks the obvious follow-up question about which deposit, which date, and which owner the timing item belongs to. The workpaper structure that holds. The reconciliation we install has a single cover page with the three balances, a ticked-off reconciling items schedule, a signature block for the preparer and the reviewer with dates, and supporting attachments for every reconciling item over a documented threshold. The threshold is set by the broker, documented in the firm's policy, and applied consistently across periods. The supporting attachments are not summaries; they are the actual deposit slip, the actual return-item notice, the actual NSF letter from the bank. An examiner will pull a sample, and the sample needs to resolve to source documents within the binder. Reconciling items that consistently break the workpaper. We see the same items repeatedly across engagements. Outstanding tenant deposits where the tenant paid by check at the end of the month and the deposit cleared the following month, those need a clean cutoff log. NSF returns where the rent was reversed in the property management system but the bank statement shows both the deposit and the return with different dates, those need both legs documented. Bank fees that hit the trust account by mistake when they should have hit the operating account, those need an immediate reimbursement entry from operating to trust, documented, with the bank's correction acknowledged in writing if the fee was the bank's error. Owner draws written but not yet cleared at month end, those are normal, but the schedule needs the check number, the owner ID, and the issue date. Deposit timing is where commingling allegations actually originate The compliance rule in nearly every state we have advised in is that tenant rent and security deposits must be deposited into the trust account within a specified window, and the consistent finding in audits is that the deposit timing log is the single most-reviewed document after the reconciliation itself. The window varies by state, some states specify three banking days, some specify five, some specify "promptly" with case law defining the working interpretation, and the policy needs to be calibrated to the most restrictive state in which the firm operates rather than averaged across the portfolio. The artifact that holds is a deposit log that captures, for every tenant payment received, the date received, the form of payment, the date deposited, the deposit slip reference, and the bank-acknowledged deposit date pulled from the trust account statement. We have seen firms try to maintain this log inside the property management system and run into the limitation that AppFolio, Buildium, and Yardi all record the deposit at the time the user posts it, not the time the funds were physically received from the tenant. The gap between physical receipt and system posting is where commingling allegations actually originate, because a check sitting in a desk drawer for nine days while the operating account collected operating revenue creates the appearance, and in some states the legal substance, of commingled funds even when the firm had no intent to misuse them. Cash, ACH, and credit card all need separate logs. Cash receipts have to be deposited intact and documented with a deposit slip that ties to the tenant ledger entry. ACH receipts need the originating bank's batch reference and the date the funds settled, which is not always the same date the tenant initiated the transfer. Credit card receipts that flow through a third-party processor have a settlement window that the broker does not control, and the policy needs to acknowledge that and document the standard settlement timing so an examiner does not interpret the gap as broker delay. The end-of-month cutoff is non-negotiable. Every payment received on or before the last business day of the month needs to be either deposited and posted in that month or documented as in-transit with the deposit slip dated in the following month. The cutoff log has to be reviewed and signed by the preparer and the broker before the reconciliation closes, and the signature is the artifact that demonstrates broker oversight of the trust function. Security deposits are a separate liability ledger, not a subset of trust The states we have advised in treat security deposits with greater specificity than ordinary trust funds, and the firms that pass examinations cleanly maintain a security deposit register that operates as a separate liability ledger inside the property management system rather than a subset of the general trust liability. The distinction shows up in three places: in some states, security deposits must be held in a separate dedicated account or in an interest-bearing account with the interest credited to the tenant; in nearly every state, the deposit must be returnable to the tenant within a specified window after lease termination; and in every state, the broker has to be able to produce, on demand, a per-tenant security deposit balance that ties to the trust liability and to the bank. The register that holds at audit lists every active tenant, the deposit amount on file, the date the deposit was received, the unit and lease reference, the trust account where it is held, any deductions applied at lease termination with documented support, and the disposition date when the deposit was returned or applied. The register has to reconcile to the trust account balance at the end of every month, and the reconciliation has to be a separate workpaper from the operating trust reconciliation because security deposits are typically a fixed liability that should not move month over month except for new deposits received and old deposits disbursed. Interest accrual where required. Some states require interest on security deposits to be credited to the tenant annually or at lease termination, and the calculation has to be documented per tenant with the rate basis cited. We have seen firms in states with this requirement either not credit interest at all, a finding that produces refund obligations going back the full statute, or credit interest at a rate that does not match the state's published index. The reconciliation should include an annual interest accrual workpaper that the broker reviews and signs. Deductions at termination. When a deposit is partially returned with deductions, the deductions have to be documented with vendor invoices, photographs, and a written itemization delivered to the former tenant within the state's specified window. Most state real-estate laws either bar the deduction outright or convert it into a treble-damages claim against the broker if the itemization deadline is missed. The disposition file has to live inside the security deposit register with cross-references to the source documents. Owner draws, management fees, and the controllable variances The pattern across the firms we have engaged with is that owner draws and management fee accruals are the most common source of trust account variances that examiners flag, and the cause is almost always a policy gap rather than a transactional error. The policy gap is the firm's failure to define, in writing, when management fees are accrued, when they are paid out of the trust account, and how the timing aligns with the owner's monthly statement. We see firms accrue fees on rent received, accrue on rent billed, accrue on a calendar cycle, and accrue on an owner-by-owner negotiated basis, and most firms have a mix of all four without realizing it. The reconciliation cleanup is to define a single fee accrual policy at the firm level, document any owner-specific exceptions in the management agreement file, and produce a monthly fee schedule that the controller reviews against the property management system's automated fee calculation. The variance between the calculated fee and the negotiated fee per owner is the workpaper line that gets attention from auditors who suspect the firm is taking fees the management agreement does not authorize. Owner draws have to clear the trust account, not float against it. The pattern we see in audits is that brokers cut owner draws on the last day of the month based on the projected ending balance, and the draws clear the bank in the first few days of the following month. That timing is normal and acceptable as long as the trust account had sufficient funds attributable to that specific owner at the time the draw was issued. The failure mode is when the broker issues an owner draw that exceeds the trust liability owed to that owner, a scenario that arises when the broker writes a draw against expected rent that did not actually arrive, or against rent that arrived but was reversed via NSF after the draw cleared. The variance log is signed by the broker, not the bookkeeper. Every variance the reconciliation surfaces needs an explanation, and the explanation needs the broker's signature on it. The bookkeeper can prepare; the broker has to review and acknowledge. The signature is what demonstrates to a commission examiner that the broker is exercising the supervisory responsibility the license requires. We have seen audits where the firm produced perfect reconciliations that the broker had never seen, and the commission's finding was that the broker had abdicated supervision, a finding that carries license consequences regardless of the underlying numbers being correct. Escheatment review belongs in the monthly cadence, not the year-end scramble Unclaimed property law in every state we have advised in requires the firm to review trust account balances annually for funds that have remained dormant beyond the state's dormancy period, and the firms that handle escheatment cleanly do not wait until the annual filing deadline to figure out what they owe. The dormancy periods vary, three years and five years are common, and the review identifies former tenant deposits, uncashed owner distribution checks, and stale tenant credits that have to be reported and remitted to the state's unclaimed property division. The monthly cadence we install includes a dormant-balance review that flags any tenant ledger or owner ledger position that has been static for longer than a defined threshold, with the threshold set conservatively against the shortest applicable state's dormancy period. The flagged items go on a watch list that the controller reviews quarterly and the broker reviews annually, with documented outreach to the affected party before the dormancy period elapses. We have seen firms that do this discover unclaimed deposits worth tens of thousands of dollars each year and either return them to the tenant, closing the obligation cleanly, or remit them to the state with the proper paperwork. Uncashed owner checks are the most-missed category. When an owner moves, dies, or stops responding, the firm continues issuing monthly distribution checks that pile up in the trust account as outstanding items. The bank reconciliation flags them as outstanding but the firm rarely treats them as escheatable until they have aged dramatically. The cleanup is a stale-check policy that voids distribution checks after a defined window, reissues them once with documented owner contact, and routes them to the dormant-balance watch list if the second issuance also goes unclaimed. State-by-state divergence is real and expensive. Some states require holder reports filed in March, some in November. Some states accept negative reports, some require zero reports only when funds are owed. Some states have de minimis exceptions, some do not. The partners verify state-by-state divergence on every engagement, and the firms that operate in multiple states maintain a calendar that lists every state's filing deadline, format, and threshold separately rather than averaging the requirements. The signed evidence package is the deliverable, not the reconciliation file The deliverable that survives a commission examination is a binder, physical or digital, that contains for each month: the three-way reconciliation cover page with both signatures and dates, the bank statement, the property management system's trust liability report, the general ledger trust liability detail, the security deposit register reconciliation, the deposit timing log, the owner distribution schedule with check images, the variance log with broker sign-off, the dormant-balance review, and any documented exceptions. The binder is closed within fifteen business days of month-end and stored where the broker can produce it within the examination window, typically forty-eight to seventy-two hours from the commission's request. The firms we have engaged with who treat the binder as the deliverable, rather than the reconciliation as the deliverable, are the firms that pass examinations without a corrective action plan. The shift in framing is meaningful. A reconciliation is a number-checking exercise. A binder is an evidence package. The first answers the question "did we balance"; the second answers the question "can we prove what we balanced and who reviewed it." Commissions are not asking the first question. They are asking the second. Storage and retention follow the longer rule. State retention requirements for trust account records typically run five to seven years. IRS retention requirements for related records run seven years for most categories. The firm's retention policy should default to seven years, stored in a system that survives bookkeeper turnover and software migrations, with quarterly access tests that confirm the binder for any specified prior month can actually be retrieved on demand. We have seen firms confident in their retention discover during an examination that the binder for a month two years prior was on a former bookkeeper's local drive that had been wiped at offboarding. Software-locked binders are a risk, not a control. When the binder lives entirely inside Yardi, AppFolio, or Buildium, a software change or licensing lapse can trap the historical record behind a paywall or a discontinued product. The binder should be exported to a non-proprietary format, PDF for the cover pages and supporting workpapers, CSV for the ledger detail, and stored outside the property management system as well as inside it. The procurement framing for picking the right system is in the PM software selection guide; the storage discipline applies regardless of the system selected. What we recommend The firms we have audited where trust accounting is genuinely under control share a set of practices that any property management firm can implement within a single quarter, and the cost of implementation is dramatically lower than the cost of the corrective action plan that follows a failed examination. First, install a monthly three-way reconciliation as the base discipline, with both preparer and reviewer signatures and a documented variance threshold. Second, separate the security deposit register into its own monthly reconciliation workpaper rather than burying it in the operating trust reconciliation. Third, define the fee accrual policy and owner draw timing in writing, with the broker reviewing the variance log every month rather than skimming it once a quarter. Fourth, build the dormant-balance review into the monthly cadence so that escheatment is a known, scheduled obligation rather than a surprise at year-end. Fifth, package the entire month's work into a closed binder within fifteen business days, store it where the broker can retrieve it on a forty-eight-hour audit notice, and run a quarterly retrieval test against a randomly selected prior month. Sixth, document the firm's policy on deposit timing, NSF handling, and stale-check resolution, and review the policy at least annually with whichever state-specific counsel the broker uses for license matters. The investment is real but bounded. The firms we have engaged with report that the controller's time on trust accounting increases modestly in the first three months as the cadence stabilizes, then declines below the prior baseline once the workpapers are templated and the policies are documented. The broker's time increases in the first month, declines after, and produces an evidence stream the broker can defend without rebuilding it from memory. Trust accounting is one of the few control surfaces in property management where modest discipline produces disproportionate license protection, and the firms that recognize that are the firms that pass examinations the first time, every time. For the broader operational leaks that often accompany weak trust controls, see the six hidden operational leaks piece. For how owner statement integrity ties back to the GL, see the related guide on PMS-to-GL tie-out.