Reconciliation software for property management has to do more than match a bank statement. A firm holds money for many owners and tenants, so each trust account must agree three ways: bank balance, trust journal and the total of owner and tenant ledgers. The software should prove that every month, flag negative ledgers, and produce reports an examiner can follow.
Why property management reconciliation outgrows a single bank rec
Property management reconciliation outgrows a single bank reconciliation because one bank account holds many people's money. A firm's trust account may carry rents collected for dozens of owners, reserves for repairs and deposits held for hundreds of tenants. The bank balance can be right while one owner's share is wrong.
An ordinary bank reconciliation answers one question: does the ledger's cash balance agree with the bank once timing items are listed? A trust account needs a second answer: does that cash belong to the right people in the right amounts? Money moved from one owner's ledger to cover another owner's repair bill leaves the bank total unchanged. Only a ledger-level check catches it.
What the portfolio adds
- Account count. A firm may run an operating account, one or more pooled trust accounts, a security deposit account and separate accounts for owners who require them.
- Ledger count. Each trust account sits under many owner ledgers and tenant ledgers, and all of them must be kept current.
- Payment mix. Rent arrives by check, ACH, card and online portals, often in batches that combine several tenants.
- Outgoing checks. Repairs, owner draws and refunds go out by check, and uncashed checks pile up.
The checks are a reconciliation task of their own. What check reconciliation software matches covers issued and paid lists and the sequence gaps that point to missing or altered checks.
Three-way reconciliation in property management software
Three-way reconciliation proves that three figures agree for a trust account at the same date: the adjusted bank balance, the trust journal balance, and the sum of every owner and tenant ledger. Property management software should produce all three side by side and refuse to call the account reconciled unless they match.
The adjusted bank balance is the statement balance plus deposits in transit, minus outstanding checks. The trust journal balance is the firm's own cash record for that account. The ledger total is the sum of what the firm owes to each owner and tenant. If any one of the three disagrees, money is either missing, misrecorded or assigned to the wrong person.
A worked three-way reconciliation
The example below is a pooled trust account at month end. All figures are made up for illustration.
| Step | Item | Amount |
|---|---|---|
| Bank | Balance per statement | 84,600.00 |
| Bank | Add deposit in transit, rent batch on the 31st | 1,100.00 |
| Bank | Less outstanding checks, two repair vendors | -3,200.00 |
| Bank | Adjusted bank balance | 82,500.00 |
| Journal | Trust journal balance | 82,500.00 |
| Ledgers | Owner A, two buildings | 21,400.00 |
| Ledgers | Owner B, one building | 18,250.00 |
| Ledgers | Owner C, three units | 9,850.00 |
| Ledgers | Tenant security deposits held | 33,000.00 |
| Ledgers | Total of ledgers | 82,500.00 |
All three figures equal 82,500.00, so the account ties three ways. Now suppose Owner C's ledger had shown 8,850.00. The bank and the journal would still agree at 82,500.00, but the ledgers would total 81,500.00. The missing 1,000.00 is cash nobody's ledger claims, often a receipt posted to the wrong owner or left unapplied. That is exactly what a two-way bank rec cannot see.
Where the rules come from
Whether a three-way reconciliation is required, how often, and who must sign it depends on the state and the licence the firm holds. Check your state's real estate or property management rules for the exact frequency and retention period. The software should let you set the schedule to match, not assume one.
How should property management software handle security deposit accounts?
Property management software should track every security deposit to a named tenant and unit, keep the deposits' total tied to the bank account that holds them, and record each release or deduction with its support. A deposit account balances only when the bank figure equals the sum of individual tenant deposits.
The deposit lifecycle
- Receipt. The deposit posts to the tenant's ledger and to the deposit bank account, not to the owner's operating funds.
- Holding. The deposit sits unchanged, sometimes with interest where the lease or local rules provide for it.
- Move-out. Deductions for damage or unpaid rent are recorded against the tenant ledger with an itemised list.
- Release. The balance is refunded to the tenant, and the refund check is tracked until it clears.
Where deposit reconciliations go wrong
- A deposit recorded as rent income, which inflates the owner's balance and understates the deposit liability.
- A move-out refund check that never cleared, which keeps cash in the account that belongs to a former tenant.
- Deposits transferred between properties when a building is sold, with the tenant ledgers left behind.
Each of these leaves the bank balance plausible and the tenant ledger total wrong, so the three-way check is again the control that finds them.
Owner statements and the reconciliation behind each property
An owner statement reports one owner's income, expenses and balance for the month. It is only as reliable as the reconciliation behind it. If the trust account does not tie three ways, at least one owner statement is wrong, even when each one looks sensible on its own.
Before statements go out, the firm should confirm that each owner's closing balance on the statement equals that owner's ledger balance in the three-way reconciliation. Reconciliation software for property management should make that comparison a report, not a manual cross-check.
Owner-level items worth watching
- Mortgage payments made from trust. Some owners have the firm pay their loan from collected rent. Those payments should tie to the lender's statement, a check covered in how to reconcile a loan account to the lender's statement.
- Reserves. An agreed repair reserve should appear as a held balance, not drift as rent comes in.
- Draws. Owner distributions should never exceed the owner's available balance on the day they are paid.
Statement date versus bank cutoff
Owner statements are often run a few days after month end, once late rent and vendor bills are posted. The bank statement, by contrast, stops on the last day of the month. If the owner statements include activity after the cutoff, their balances will not equal the ledger figures in the month-end three-way reconciliation, and the comparison fails for a reason that has nothing to do with errors. Pick one cutoff for both, or have the software report owner balances as of the bank statement date and show later activity separately. Either way, the reviewer should be able to explain every difference between an owner statement and the ledger by date alone.
What audit-ready reports should property management reconciliation software produce?
Property management reconciliation software should produce a three-way reconciliation report for each trust account, the bank reconciliation behind it, a list of outstanding checks and deposits in transit with dates, and a trial balance of owner and tenant ledgers. Each report should show who prepared and reviewed it, and when.
The monthly report set
- The three-way summary, as in the worked example above.
- The bank statement for the period, with every reconciling item listed.
- A ledger listing with every owner and tenant balance, sorted to show negatives first.
- An outstanding check list with the age of each check.
- A log of edits made after the reconciliation was prepared.
That last item is what turns a report into evidence. A reconciliation that someone can quietly revise after sign-off proves little. What a reconciliation software audit trail should record lists the entries an examiner will look for.
PreciseBankFlow handles the bank statement layer of this set. It reads trust and operating statements, proves each one foots from opening to closing balance, flags duplicate lines and check number gaps, and exports the exceptions with their source lines. The owner and tenant ledgers stay in your property management system.
When property management reconciliation software flags a negative owner ledger
A negative owner ledger means the firm paid out more for that owner than it holds for them. In a pooled trust account, the shortfall was covered with other owners' or tenants' money. Property management reconciliation software should flag any negative ledger the moment it appears, not only at month end.
Negative ledgers usually start innocently. A repair bill arrives before the month's rent, and the firm pays it on time. A tenant's rent check bounces after the owner draw was released. A management fee posts twice. Each is an ordinary event, but each one means another owner's funds were used without their knowledge.
What to do when one appears
- Identify the cause and the date the ledger went negative.
- Restore the shortfall from the firm's own funds or the owner, following your state's rules for doing so.
- Record the correction with support, so the next reconciliation shows when and how it was cleared.
- Change the process that allowed it, such as releasing draws before rent clears.
Some tools now suggest matches or flag patterns using machine learning. Those suggestions can speed up the receipt work, but the decision on a negative ledger stays with a person. What AI bank reconciliation can and cannot decide covers where that line falls.
If your trust and operating statements arrive as PDFs and the bank side takes most of the month-end time, request early access to PreciseBankFlow and run one month's statements through it.