If you don't reconcile your bank accounts, you don't actually know what your books say.
You have a guess. A reasonable estimate based on the transactions you remember. But until your bank statement, your general ledger, and your client ledgers all match exactly, you're operating on assumptions.
For most businesses, that's bad practice.
For property managers, it's a license risk.
Most state real estate commissions require monthly bank reconciliation for trust accounts. Failing to reconcile (or doing it wrong) is one of the most common reasons property managers face audit findings, fines, and disciplinary action. The work itself isn't difficult once you understand the process. But the discipline of doing it correctly every month, across every account, is where most operations break down.
This guide walks through how property management bank reconciliation works, the difference between two-way and three-way reconciliation, the accounts you need to reconcile, and the mistakes to avoid.
Bank reconciliation is the process of comparing your internal accounting records against your bank statement to confirm they match.
You probably do this in your personal life without thinking about it. You check your bank balance, look at recent transactions, and notice if something looks off. That's reconciliation in its simplest form.
For a business, the process is more structured. You compare every transaction on the bank statement against the corresponding entry in your accounting records, identify any differences (called reconciling items), and adjust your books or flag bank errors as needed.
The goal is simple: confirm that your records reflect reality.
When the records and the bank statement don't agree, you have a problem to investigate. It might be an outstanding check that hasn't cleared, a deposit in transit, a bank fee you didn't record, or something more serious.
Property managers don't have just one bank account. They typically run several, each with different reconciliation requirements.
Here's how the accounts typically break down.
| Account Type | What It Holds | Reconciliation Type |
|---|---|---|
| Operating account | Management company revenue and expenses | Two-way |
| Trust account (operating) | Rent collected on behalf of owners, owner reserves | Three-way |
| Security deposit trust account | Tenant security deposits | Three-way |
| Escrow accounts | Funds held for specific purposes (insurance, taxes) | Two-way |
This is your business's primary checking account. It holds your management fee revenue, business expenses, payroll, and other operating cash flow.
Reconciliation here is straightforward. You're matching your bank statement against your check register or general ledger. This is two-way reconciliation.
This is where rent collected on behalf of owners lives. Owner distributions flow out of this account. Reserves held for property maintenance live here too.
Trust accounts require three-way reconciliation because the money belongs to multiple parties (each property owner). You need to confirm that the bank balance matches both your general ledger and the sum of all individual owner ledgers.
Some states require security deposits to be held in a separate trust account from operating trust funds. Where required, you reconcile this account independently using the same three-way process.
If you hold funds for specific purposes (property tax escrow, insurance escrow, capital improvement reserves), each one needs its own reconciliation.
The difference between two-way and three-way reconciliation comes down to whether the money in the account belongs entirely to your business or to multiple clients.
Used for accounts where all the money is yours (operating accounts, business savings, etc.).
You match two numbers:
If the two numbers match, you're reconciled.
Required for trust accounts where you're holding money on behalf of multiple clients.
You match three numbers:
All three must match exactly. The third number (the sum of client ledgers) is what separates trust account reconciliation from regular reconciliation. It's also what most property managers either skip entirely or get wrong.
If your bank balance and general ledger match but the sum of client ledgers doesn't, you have a misallocation problem. Money is in the account, but it's been recorded against the wrong client. That's a fixable issue, but you have to know about it to fix it.
This is the process most state commissions expect property managers to follow every month for every trust account. The steps are the same whether you're using property management software or working in spreadsheets.
Here's how to do it.
Pull three things:
If any of these aren't readily available, that's the first problem to solve.
Start with two-way reconciliation between the bank statement and your general ledger.
Mark every cleared transaction on both sides. Anything unmarked is a reconciling item:
Apply the formula:
Ending Bank Balance + Deposits in Transit – Outstanding Checks = Your Book Balance
If those numbers match, you've completed step one.
Now pull a property trial balance (a report listing every owner ledger and tenant ledger with their month-end balance).
Add up all the individual balances. The total should equal your general ledger balance and your reconciled bank balance.
If it does, you're done. All three numbers match. The trust account is reconciled.
If it doesn't, you have a misallocation issue to investigate.
If the three numbers don't match, work backward to find where the difference came from.
Common causes:
Having said that, the longer a discrepancy sits unresolved, the harder it gets to find. A discrepancy from the current month is usually traceable in an hour. A discrepancy from six months ago can take days.
Most state commissions require a signed reconciliation worksheet for every monthly reconciliation. Even if your state doesn't formally require the signature, retain a worksheet showing the three balances and any reconciling items.
Keep these worksheets for at least the period required by your state (typically three to seven years). They're the documentation auditors will ask for first.
Most reconciliation problems come from a small handful of mistakes. They're easy to avoid once you know what to watch for.
Here are the ones that come up most often.
The biggest mistake. A small discrepancy in March becomes an unfindable mystery by December. Reconcile every month, ideally within a week of receiving the bank statement.
If any individual owner or tenant ledger goes negative, that's a deficiency. You've effectively used another client's funds to cover a shortfall. State commissions specifically prohibit this. Your software should alert you before a disbursement creates a negative balance.
Bank fees should never come out of a trust account. If your bank charges a monthly service fee on the trust account, those fees need to be reimbursed from your operating account immediately. Most states allow you to keep a small amount of your own money in the trust account ($100-$200) specifically to absorb fees, but you have to maintain a separate ledger for it.
This is the one auditors flag most often. The bank balance and general ledger match, but the property manager never adds up the individual client ledgers. That's a two-way reconciliation, not a three-way. Trust accounts require all three.
A reconciling item that's been "outstanding" for six months isn't really outstanding. It's an error. Outstanding checks should clear within 30-60 days. Deposits in transit should clear within a few days. Anything older needs investigation.
For HOA managers, this is the equivalent mistake. Operating fund expenses paid from reserve fund accounts (or vice versa) make reconciliation impossible because the funds are supposed to be tracked separately.
Reconciling against your accounting software without pulling the actual bank statement misses bank errors and unauthorized transactions. Always reconcile against the bank's source document.
Most state real estate commissions require monthly reconciliation. The North Carolina Real Estate Commission's Rule 21 NCAC 58A .0117(e) explicitly requires brokers to reconcile trust accounts monthly and retain a worksheet showing the bank statement balance, journal balance, and trial balance in agreement. Oregon's OAR 863-025-0028 requires property managers to reconcile each clients' trust account within 30 days of the bank statement date using a three-component reconciliation, with the property manager required to sign and date the document.
But beyond compliance, monthly reconciliation matters for practical reasons.
The truth is, fraud and errors are easier to catch when you find them quickly. A misappropriation that gets caught within 30 days can usually be reversed and corrected. The same misappropriation discovered six months later may already have grown into a larger problem with more entries to untangle.
Vendor relationships also depend on accurate reconciliation. If your records say you paid a vendor but they say you didn't, the only way to resolve it is by going back to the bank statement.
For property managers serious about scaling, monthly reconciliation is the discipline that keeps everything else working.
If you're reconciling trust accounts in spreadsheets or general accounting software, you already know how the process goes. Pull the bank statement. Export transactions from your software. Build a worksheet. Cross-check every transaction. Add up the client ledgers. Hope they match.
That manual process is exactly the kind of work that causes the reconciliation mistakes we just covered.
Mocha Manage was built by CPAs who understand bank reconciliation at a compliance level. The Banking feature connects directly to your bank accounts and handles the reconciliation work that creates errors when done manually.
Here's what you can do with Mocha:
Bank transactions feed directly into the platform. Your general ledger updates automatically. Client ledgers reconcile against the trust account balance in real time. And the three-way reconciliation reports your auditor or state commission expects are generated within the platform, not assembled from exported spreadsheets.
For property managers who've spent hours every month on manual reconciliation (or worse, discovered a discrepancy during an audit), the difference between a general accounting tool and a platform built for trust accounting is the difference between hoping you're compliant and knowing you are.
Try Mocha Manage free to see what bank reconciliation looks like when it's built into the accounting from day one.
Monthly, ideally within a week of receiving the bank statement. Most state real estate commissions require monthly reconciliation for trust accounts.
Two-way reconciliation matches your bank statement against your general ledger. Three-way reconciliation adds a third check: the sum of all individual client ledgers must also match. Trust accounts require three-way.
Depends on your state. Some states require separate trust accounts for security deposits. Others allow a single trust account as long as your records clearly separate the funds. Check your state real estate commission's rules.
Investigate immediately. Common causes include transactions posted to the wrong client ledger, missing entries, or bank errors. The longer a discrepancy sits, the harder it is to fix.
No. Bank fees on trust accounts should be reimbursed from your operating account. Most states allow you to keep a small amount of your own funds in the trust account to absorb fees, but you must maintain a separate ledger for it.
A signed reconciliation worksheet for every month, retained for the period your state requires (typically 3-7 years). Auditors will ask for these first when they review your trust account compliance.
Disclosure: Mocha Manage publishes this blog. This guide is for informational purposes only and does not constitute legal or accounting advice. Trust accounting and reconciliation laws vary by state. Consult an attorney or CPA for advice specific to your situation.
