Short answer: three-way reconciliation compares the adjusted bank balance, the accounting-system cash balance, and the total of the underlying owner, property, tenant, or trust sub-ledgers for the same account and date. The three amounts should agree after valid timing items and corrections are explained.
This guide explains an operating control, not jurisdiction-specific legal advice. Trust-account requirements, frequency, documentation, responsible roles, and permitted adjustments vary. A qualified property-management accountant or local adviser should define the exact procedure for your business.
The three balances
1. Adjusted bank balance
Start with the statement ending balance for the account. Adjust for legitimate timing items such as outstanding payments or deposits in transit using the same cutoff date. Each item should have a reference, date, amount, owner, and expected clearing action.
2. Book or general-ledger cash balance
This is the cash balance recorded in the accounting system for that bank account. Investigate duplicated imports, missing transactions, entries posted to the wrong account, voided payments, reversals, and transactions dated outside the reconciliation period.
3. Sub-ledger total
Add the balances that explain whose money is represented in the account. Depending on the structure, that may include owner, property, tenant, security-deposit, or other trust-related ledgers. The total should connect to the same bank account and cutoff date.
The monthly reconciliation workflow
- Lock the account, period, statement, and cutoff date being reviewed.
- Confirm all expected bank activity has been imported or entered.
- Match deposits, payments, transfers, fees, interest, reversals, and adjustments.
- List outstanding and in-transit items with supporting evidence.
- Compare the adjusted bank balance with book cash.
- Generate the sub-ledger total for the identical account and date.
- Investigate every difference instead of posting an unexplained plug.
- Record corrections through controlled entries with a reason and reviewer.
- Save the statement, reconciliation, exception list, supporting reports, and sign-off.
Common causes of a difference
- A transaction was assigned to the wrong bank account or property.
- A bank-feed item and a manual entry both recorded the same activity.
- A payment was voided in one place but remains active elsewhere.
- An owner or tenant balance was changed without a corresponding cash entry.
- A transfer recorded one side but not the other.
- The reports use different dates, time zones, or inclusion rules.
- An old outstanding item is no longer valid but was never resolved.
- A prior period was edited after its reconciliation was completed.
How software should support the control
The system should preserve source references, make the report cutoff visible, show adjustments separately, link sub-ledger totals to detail, prevent silent edits to closed periods, and record preparation and review. Automated matching can reduce work, but the reviewer needs to understand why an item matched and how to undo an incorrect match.
Separation of duties for small teams
A large company may separate transaction entry, bank access, reconciliation, approval, and payment. A small team may not have enough people for complete separation. Compensating controls can include owner review, read-only bank access for the reconciler, approval thresholds, immutable audit history, exception reporting, and an external monthly review. Document the actual design rather than claiming separation that does not exist.
Reconciliation evidence checklist
- Bank statement and account identifier.
- Reconciliation summary and adjusted bank balance.
- Book cash or trial-balance detail.
- Sub-ledger balance report.
- Outstanding and in-transit item list.
- Corrections with supporting documents.
- Unresolved exceptions with owner and due date.
- Preparer and reviewer sign-off with timestamps.
How this connects to owner reporting
Reconciliation is an upstream control. Owner statements should be produced from reviewed records, with any provisional status explained. Use the property management accounting software guide to map the full transaction-to-report workflow.
Frequently asked questions
Is ordinary bank reconciliation enough?
It confirms bank and book agreement but may not prove that the supporting owner or trust balances add to the same amount. Whether a third comparison is required depends on the account and applicable rules.
Can reconciliation be fully automated?
Matching can be automated, but exceptions, stale items, unusual adjustments, and final review still need accountable oversight.
What should happen when the balances do not agree?
Keep the period in review, identify the difference, trace it to source records, correct it through a documented entry, and re-run all three balances.
Bottom line
Three-way reconciliation is valuable because it asks three independent views of cash to tell the same story. Software should make that comparison easier to inspect, not hide the evidence behind a green status.