A property management trust account reconciliation compares three things at one cut-off date: the bank balance after timing items, the broker's record of all trust money received and paid out, and the total of every owner and tenant ledger. When all three agree, each owner and tenant's money is accounted for. Regulators expect it at least monthly.
What goes into a property management trust account reconciliation?
A property management trust account reconciliation uses three records. The bank statement shows what the bank holds. The control record, sometimes called the trust journal or register, is the firm's running record of every receipt and payment through the account. The beneficiary records are the ledgers for each owner, tenant or transaction whose money is in it.
Broker rules give these records formal names. The California Department of Real Estate's guide to the ten most common audit violations describes three regulations that fit together:
- Regulation 2831 requires a columnar record of all trust funds received and paid out, in date order, showing the date received, the payer or payee, the amount received, the date of deposit, the amount paid out, the check number and date, and a daily running balance.
- Regulation 2831.1 requires a separate record for each beneficiary or transaction, with its own running balance after every entry.
- Regulation 2831.2 requires the total of those separate records to be reconciled to the record of all trust funds at least once a month, except in a month with no activity in the account.
Other states use different names and periods, and a firm licensed in several states may face several rule sets. The structure carries over wherever a property manager holds other people's rent: bank, control record, beneficiary ledgers.
The property manager's version of this work has more beneficiaries than most trust accounts. One pooled account may hold rent for many owners, repair reserves, prepaid rent and, sometimes, tenant deposits. A real estate brokerage that only holds earnest money for sales has a simpler set of ledgers; real estate escrow account reconciliation for brokers covers that case.
Reconciling the property management trust control record to the bank
The property management trust control record is reconciled to the bank first, at a single cut-off date, usually the last day of the month. Start from the statement's closing balance, add deposits recorded but not yet credited, subtract checks and payments issued but not yet paid, and compare the result to the control record's balance.
The DRE guidance makes the order explicit. It says the record of all trust funds must first be reconciled with the bank statements as of a cut-off date, which it describes as the calendar date after which no activity is counted. Corrections and reconciling items are applied to each side until the control record equals the adjusted cash balance. Only then does the beneficiary comparison mean anything.
Property management accounts have their own timing items:
- Rent batches. Portal and ACH rent often settles one or two business days after the tenant pays, so the last days of the month produce deposits in transit.
- Vendor checks. Repair vendors may hold checks for weeks. Each outstanding check needs a number, date, payee and the owner ledger it was charged to.
- Owner draws by ACH. A draw sent on the last business day may post after the cut-off.
- Bank fees. These belong to the firm. Any fee the bank takes from trust should be covered from the firm's own funds, within the limits the rules allow, and recorded.
When the control record and the adjusted bank balance disagree, the cause is usually a receipt recorded in the wrong month, a voided check still in the record, or a bank posting the firm has not entered. Find it and correct it before you total the ledgers.
Matching owner and tenant ledgers to the property management trust balance
Owner and tenant ledgers are matched to the property management trust balance by listing and adding every beneficiary's cut-off balance. The total must equal the corrected control record and the adjusted bank balance. A total that is lower means the account is short. A total that is higher means money belongs to no one on the list.
The DRE guidance states the purpose plainly: to determine whether all trust funds held for others are on deposit, and to confirm there is no unidentified overage and no more than 200 dollars of broker money in the account. It also lists what the reconciliation record should show: the bank account name and number, the date, each principal, beneficiary or transaction, and the amount held for each.
A worked example month
The figures below are an example for a fictional firm, Elm Row Management, for June. They are illustrative only.
Step A: bank to control record
| Item | Amount |
|---|---|
| Closing balance per trust statement, June 30 | 61,940.00 |
| Add rent batch settled July 1, paid by tenants June 30 | 2,300.00 |
| Less outstanding check 4410, roofing contractor | -5,600.00 |
| Less outstanding check 4413, landscaping | -340.00 |
| Adjusted bank balance | 58,300.00 |
| Control record balance, June 30 | 58,300.00 |
Step B: beneficiary listing
| Beneficiary | Balance |
|---|---|
| Owner Castillo, fourplex | 14,120.00 |
| Owner Brandt, two houses | 9,760.00 |
| Owner Lindqvist, retail unit | -1,450.00 |
| Owner Patel, eight-unit building | 21,370.00 |
| Prepaid July rent, three tenants | 4,800.00 |
| Tenant deposits held in this account | 9,700.00 |
| Total of beneficiary records | 58,300.00 |
The three figures agree at 58,300.00, but the listing shows a problem the totals do not. Owner Lindqvist's ledger is 1,450.00 below zero. The roofing check for Lindqvist's unit was paid while the owner had too little on deposit, so other owners' and tenants' money covered it. A matching total does not cure that. The firm must restore the shortfall and find out why the payment was released.
Where tenant deposits fit in a property management trust reconciliation
Tenant deposits fit into a property management trust reconciliation as beneficiary balances, one per tenant, in whichever account holds them. If deposits share the rent account, each tenant's deposit appears on the listing for that account. If they sit in a separate deposit account, that account gets its own three-way reconciliation.
Deposits are easy to lose track of because they rarely move. A tenant may hold a deposit for years while rent flows past it every month. Three practices keep them visible:
- One ledger per tenant and unit. A lump "deposits held" figure, as in the example above, is only a summary. The detail must exist behind it, tenant by tenant.
- A separate line for deposit interest, where the lease or local law requires interest to be paid or credited to the tenant.
- A move-out record for every release, with the deduction list and the refund check number, so the deposit leaves the listing on the same day it leaves the bank.
When a building is sold, the deposits go with the tenancies. The transfer should appear as a payment out of trust with the buyer's acknowledgement, and the tenant ledgers should close to zero on the same date. Security deposit trust account records and rules covers the tenant side of this in more detail.
What do regulators check in a property management trust account?
Regulators check whether the firm kept the required records, kept them accurately, reconciled them on schedule, deposited trust money on time, and never let the account fall below what it owes. In California, examiners test the columnar records, the daily running balances, the monthly reconciliation, signatory authority and commingling.
The DRE's list of common violations reads like an examiner's checklist. Using California as the worked case:
- Records missing, incomplete or without a daily running balance. The DRE cites brokers for records with a missing column, a wrong amount or date, or no accurate running balance. The columns each record needs are set out in what each trust journal and ledger line must show.
- Electronic receipts nobody can identify. The DRE lists failure to identify who owns funds received by electronic deposit as a reason brokers are cited.
- Late deposits. Trust funds must reach a trust account, the owner or a neutral escrow no later than three business days after receipt.
- Shortages without consent. Under regulation 2832.1, a disbursement that drops the account below the total owed to all owners needs prior written consent from every owner of the funds.
- Signers. Withdrawals must be made by the broker or properly authorised people, and unlicensed signers need fidelity bond or insurance coverage.
- Commingling. Depositing trust funds to the general business account, or keeping more than 200 dollars of broker money in trust, is a violation.
Other states check similar points with their own thresholds. The useful habit is the same everywhere: keep each month's reconciliation package complete enough that an examiner can trace one rent receipt from the tenant's payment, through the bank, to the owner's ledger and the owner's statement.
When bounced rent and early owner draws create a property management trust shortage
A property management trust shortage appears when the firm pays an owner draw or a vendor against rent that later fails. The rent was credited, the money went out, and then the tenant's payment came back. The owner's ledger is now below zero, and other beneficiaries' funds have covered the gap.
This is how a well-run firm can end up with a negative owner ledger. A tenant pays by check or ACH on the 3rd. The firm posts the rent, pays the owner on the 10th, and on the 12th the bank returns the tenant's payment for insufficient funds. Nothing was stolen and every entry was honest, yet the pooled account is short for that owner.
The DRE guidance notes that ordinary record-keeping errors, such as an unrecorded disbursement or an overstated deposit, make a beneficiary ledger look larger than it is, and the overstated balance is then more likely to be paid out. A returned rent payment has the same effect until it is recorded.
What to do when it happens
- Record the returned payment and the bank's returned-item fee on the day the bank posts them. The fee belongs to the tenant or the firm under the lease, never to another owner.
- Reverse the rent on the tenant's ledger and reduce the owner's ledger by the same amount.
- If the owner's ledger is now negative, restore it from the owner or from firm funds as your rules allow, and document the source.
- Change the release rule: hold owner draws until rent has been in the account long enough to clear.
How an NSF check shows on a bank reconciliation covers the bank-side entries for a returned item.
Returned items, rent batches and vendor checks all arrive on the bank statement first. PreciseBankFlow reads each trust statement line by line, proves the statement foots from opening to closing balance, and flags duplicate lines and check number gaps for review before you start the beneficiary work. The owner and tenant ledgers stay in your property management system. Request early access to try it on one month.