How Property Managers Run a Three-Way Trust Account Reconciliation
Editorial Staff
Content published by Hemlane is created and reviewed by members of our editorial team, including experienced technical writers and real estate professionals.
A 120-unit portfolio with 40 owners can close the month with its trust account numbers $70 apart. The difference might come from a payment posted to the wrong ledger or a transaction that never made it into the books. Either way, the longer it goes unnoticed, the harder it becomes to track down.
Three-way reconciliation catches those discrepancies before they affect owner balances or financial reporting. Whether you run a property management group, a brokerage with a property management arm, or a firm expanding toward 200 units, the process comes down to comparing three records at the same cutoff date.
Here's how to complete a three-way reconciliation, investigate differences, and keep your monthly close organized.
What does a three-way reconciliation compare?
A three-way reconciliation checks whether your adjusted trust bank balance, receipts and disbursements register, and supporting ledger balances agree as of the same date. It goes beyond a standard bank reconciliation by confirming that the funds recorded in your books match the balances attributed to the owners whose money you hold.
The Oregon Real Estate Agency's trust account guidance identifies three components for a clients' trust account reconciliation:
- Adjusted bank balance: The bank statement balance, adjusted for outstanding checks and deposits.
- Book balance: The receipts and disbursements register balance as of the bank statement date.
- Owner ledger total: The sum of all positive owners' ledger balances as of that same date.
These three amounts must agree. If they don't, you'll need to identify the difference and correct or document it according to the applicable rules [1][2].
For property managers handling funds across multiple owners, this third comparison is particularly important. Your bank balance might match the check register while a payment remains assigned to the wrong owner.
Hemlane's trust accounting software gives each owner entity a separate virtual trust account and ledger. Automatic reconciliation keeps owner transactions and balances organized without rebuilding the records in spreadsheets.
Why does reconciliation get harder between 50 and 200 units?
The process doesn't change much as your portfolio grows, but the number of transactions does. A firm managing 150 units may handle rent payments, management fees, repair invoices, reserves, and owner distributions across dozens of separate accounts and ledgers.
A $70 discrepancy can be easy to miss among hundreds of legitimate transactions. If it carries into the next month, you're now reviewing two periods of activity to find the original mistake.
A consistent monthly routine keeps that work manageable. When transactions are recorded throughout the month and outstanding items are reviewed regularly, your team has fewer unresolved entries to investigate at closing.
For firms managing rentals on behalf of third-party owners, Hemlane's property management platform brings payment activity, owner records, and accounting workflows together.
What do you need before starting?
Gather the records for the same accounting period before you begin. You'll need:
- The bank statement for the trust account being reconciled.
- The receipts and disbursements register through the statement date.
- The supporting ledger balances for that trust account.
- A list of outstanding checks and deposits in transit.
- The previous reconciliation and any unresolved adjustments.
If your firm holds security deposits in a separate account, prepare a separate reconciliation using that account's bank statement, register, and individual deposit balances.
You can also review receipts collected through online rent collection to match payment activity against the bank statement.
How to do a three-way reconciliation, step by step
A three-way reconciliation follows six steps: establish the cutoff date, adjust the bank balance, calculate the book balance, total the appropriate ledgers, compare the figures, and resolve any differences.
Step 1: Pick the cutoff date
Use the bank statement closing date for all three records. Comparing a bank balance from the last day of the month against ledgers updated several days later can create differences that aren't actual accounting errors.
Step 2: Adjust the bank balance
Start with the ending balance on the bank statement. Subtract outstanding checks that haven't cleared and add deposits in transit that were made before the statement cutoff but haven't appeared on the statement.
Account for any other valid reconciling items to arrive at the adjusted bank balance.
Step 3: Find the book balance
Calculate the balance in your receipts and disbursements register as of the same date. This reflects the funds your accounting records show should be in the trust account.
Review entries that haven't reached the bank statement yet, including checks issued and deposits awaiting processing.
Step 4: Total the ledgers for that trust account
Add the applicable ledger balances as of the cutoff date. For an Oregon clients' trust account, this means the sum of all positive owners' ledgers.
Security deposits held in a separate account require their own reconciliation. In Oregon, that comparison uses the adjusted bank balance, the deposit account's receipts and disbursements register, and the sum of positive balances for individual security deposits and fees held [1][2].
Hemlane provides separate owner ledgers through its trust accounting tools. Owner statements, expense records, and year-end tax preparation draw from the same reconciled ledger, keeping financial records consistent across reporting periods.
Step 5: Compare the three numbers
Put the totals side by side. Here's an illustrative clients' trust account example:
The bank and register agree, but the owner ledgers are $70 lower. That tells you where to begin investigating.
Check whether a receipt reached the register but wasn't assigned to the correct owner, or whether a fee or adjustment was entered in one record but missed in another. Comparing ledger entries against the register can narrow the difference.
Step 6: Resolve the variance and sign off
Investigate the discrepancy, make any necessary corrections, and document what caused it. Keep supporting records with the reconciliation so someone reviewing the account later can follow the adjustment.
Oregon requires the reconciliation to be completed, signed, and dated within 30 calendar days of the bank statement date. Adjustments must be resolved before the next reconciliation or supported by documentation of good-faith efforts to resolve them [2].
Hemlane keeps unreconciled clearing-account transactions visible until the balance returns to zero. Your team can review outstanding items before closing the period, although the software doesn't replace required regulatory review or approval.
Why don't the numbers match?
Most reconciliation differences come from transaction timing, missing entries, or payments assigned to the wrong ledger. Common causes include:
- Outstanding checks missing from the reconciliation.
- Deposits in transit that haven't reached the bank statement.
- Rent or other payments assigned to the wrong owner.
- Bank fees or returned payments missing from the register.
- Disbursements that leave an owner ledger overdrawn.
- Security deposit transactions recorded in the wrong account.
- Prepaid rent or repair reserves recorded incorrectly.
A balanced bank account doesn't always mean every owner's funds are accounted for correctly. As Hemlane explains in its guide to negative owner ledgers, one owner's balance can fall below zero while another owner's funds cover the difference. The overall account may still balance, leaving the shortage hidden until someone reviews the individual ledgers.
Prepaid rent and reserves deserve particular attention because those funds may need to remain available for future obligations. Your records should show what the money is being held for and which owner or account it belongs to.
Security deposit requirements also vary by state. Keep deposits in the accounts required by your jurisdiction and reconcile each account using its own supporting records.
Hemlane's trust accounting features support separate owner ledgers, reserves, and automatic reconciliation. The platform also connects owner statement entries to underlying bank transactions, leases, or entities, making discrepancies easier to investigate.
How often should you reconcile, and who signs off?
Reconciliation requirements depend on the state where your firm operates. Some jurisdictions specify the frequency, supporting documentation, retention period, and person responsible for approving the work.
The Oregon Real Estate Agency requires each clients' trust account and security deposit account to be reconciled monthly. The property manager or principal broker must review and approve each reconciliation, and records must be retained for six years [1].
Oregon's requirements appear in OAR 863-025-0025 through 863-025-0028. The rules also address the reconciliation documents and supporting records that must be maintained [2].
Oregon's requirements won't necessarily apply to a firm operating elsewhere. For example, Illinois requires reconciliation within ten days of receiving the monthly bank statement, while other states set different deadlines and documentation requirements. Hemlane's comparison of trust account rules across nine states outlines these differences, including deposit deadlines and record retention.
Before setting your firm's reconciliation schedule, confirm the requirements with the appropriate state regulator. Software can automate parts of the process, but the licensed professional remains responsible for required reviews and approvals.
Keep reconciliation from becoming a month-end scramble
Monthly reconciliation is easier when your team reviews financial activity throughout the month. Waiting until the statement arrives to investigate every unmatched payment leaves more work for the closing process.
Four habits keep things organized:
- Review clearing-account activity regularly and investigate unmatched transactions.
- Separate payment responsibilities from reconciliation review when staffing allows.
- Maintain a dated list of unresolved items and the person responsible for each.
- Keep signed reconciliations, bank statements, and supporting records together.
Make sure your process also accounts for any separate security deposit accounts and their required reconciliations.
Hemlane reconciles synced clearing-account activity daily and keeps unresolved transactions visible. Its property management accounting tools also support financial reporting, while trust accounting records and transactions can sync with QuickBooks.
The goal is to arrive at month-end with most transactions already reviewed, leaving fewer surprises when you compare the final balances.
Where does Hemlane fit for property managers with 50-plus units?
Hemlane fits property management firms and brokerages that need to manage owner funds across a growing portfolio without relying on disconnected spreadsheets and manual reconciliation processes.
Each owner entity receives a separate virtual trust account in the owner's name, with its own ledger. Hemlane also supports automatic owner payouts, reserve management, daily clearing-account reconciliation, and QuickBooks integration.
Property managers can review payments, track owner balances, and prepare financial records through one platform instead of maintaining separate spreadsheets. Your firm remains responsible for meeting applicable trust accounting requirements, including state-mandated reconciliations and approvals.
Want to see how it runs on your portfolio? Start a Hemlane account or book a demo.
Frequently Asked Questions
What is three-way reconciliation in property management?
Three-way reconciliation compares the adjusted trust bank balance, receipts and disbursements register, and applicable supporting ledger balances as of the same date. All three amounts should agree, with any differences investigated and documented.
How is three-way reconciliation different from bank reconciliation?
A standard bank reconciliation compares the bank statement with the accounting register. Three-way reconciliation adds the supporting ledgers to confirm that the recorded funds agree with the amounts held for the relevant owners or deposit holders.
How often should a property manager reconcile a trust account?
Requirements vary by state. The Oregon Real Estate Agency requires monthly reconciliation of each clients' trust account and security deposit account, with review and approval by the property manager or principal broker. Check your state's requirements for timing, documentation, and sign-off [1].
Do security deposits belong in the reconciliation?
Security deposits must be accounted for, but they shouldn't automatically be included in the owner-ledger total of a clients' trust account. Some states require a separate security deposit account and reconciliation.
In Oregon, a security deposit account reconciliation compares its adjusted bank balance, receipts and disbursements register, and the positive balances of individual deposits and fees held. Specific exceptions and account requirements are addressed in state rules [2].
Can trust accounting software help with reconciliation?
Yes. Hemlane supports separate virtual trust accounts and ledgers for owner entities, daily clearing-account reconciliation, and visibility into unresolved transactions. These tools reduce manual accounting work, but your firm must still complete any required reviews and reconciliations under applicable state law.
References
Get the Latest in Real Estate & Property Management!
I consent to receiving news, emails, and related marketing communications. I have read and agree with the privacy policy.
