Property Management Bank Reconciliation: A Practical Guide

A property management bank reconciliation should confirm that recorded cash activity agrees with the bank and that outstanding differences have a clear explanation. Because one portfolio can involve many properties, owners and accounts, regular reconciliation is especially important.

What should be reviewed?

• Tenant and owner receipts
• Vendor payments and outstanding checks
• Owner distributions
• Security-deposit or trust-related activity where applicable
• Transfers between accounts
• Bank fees and other direct charges
• Old or unexplained reconciling items

Start with the bank statement

Use the bank statement as the external record and match the activity recorded in the accounting system. A reconciliation should identify timing differences such as outstanding checks or deposits in transit while separating those from transactions that were never recorded or were recorded incorrectly.

Property-level detail matters

In a portfolio environment, a matched bank balance does not automatically prove that every property is correct. A receipt may have reached the bank but been applied to the wrong tenant or property. Review the supporting detail when a transaction is unusual or material. The tenant ledger reconciliation checklist covers how to check tenant-level charges, receipts, credits and open balances separately from the bank match.

A repeatable reconciliation workflow for a property portfolio

Use the same sequence for each account and reporting period so the reviewer can see what was checked and what remains open. The sequence below is an accounting workflow, not a substitute for any trust-account procedure required by the applicable jurisdiction.

1. Confirm the account and period. Match the bank statement to the correct legal entity, property group, account number and statement dates. Check that the accounting system is being reconciled to the same cutoff date.
2. Confirm the opening balance. Agree the prior period's ending reconciled balance to the current period's opening balance. If it changed, trace the adjustment to its entry, date and approval rather than carrying an unexplained difference forward.
3. Match deposits by batch and source. Compare bank deposits with the recorded receipt batches and supporting detail. Where several tenant receipts are combined into one deposit, retain a way to trace the bank amount back to the individual receipts and property or tenant records.
4. Match payments and transfers. Check vendor payments, owner distributions, internal transfers and other withdrawals against the recorded transactions. Confirm that transfers appear consistently in both affected accounts and have not been counted as income or expense.
5. Separate timing items from errors. An outstanding check or deposit in transit may be a timing difference. A duplicate entry, omitted bank fee, reversed payment or receipt posted to the wrong property is a different issue and needs correction or a documented decision.
6. Review the subledgers. Compare relevant tenant, owner, vendor and deposit schedules with the general-ledger control accounts. A bank reconciliation alone will not detect every allocation error inside those records.
7. Document and review. Record the preparer, reviewer, completion date, statement reference, outstanding items, proposed corrections and unresolved questions. Keep evidence with the reconciliation so another reviewer can reproduce the result.

Examples of exceptions worth investigating

• Deposit is on the bank statement but not in the books: check whether a receipt batch was not posted, was posted in a later period or was recorded in the wrong account.
• Receipt is recorded but no matching deposit appears: trace the receipt through the deposit process and check for a void, reversal, rejected payment or timing difference.
• Payment clears for a different amount: compare the cleared amount with the approved invoice or distribution and identify fees, partial payments, void-and-reissue activity or an entry error.
• Bank balance reconciles but a property cash balance looks wrong: inspect the property and owner allocations. The total cash account can agree while the supporting subledger contains a misapplied receipt or expense.
• Old outstanding checks remain open: establish whether they were voided, replaced, cleared later or still require action. Do not remove them solely to force the reconciliation to balance.
• A returned or reversed receipt appears: trace the original receipt and reversal together, then check the tenant or owner balance and any related fee or follow-up entry.

For each exception, keep the original transaction reference, amount, date, affected property or entity, current status, next action and responsible person together. That creates a useful handoff list instead of a collection of unexplained reconciling lines.

What a reviewer-ready reconciliation file should contain

• The complete bank statement for the period and the reconciliation report from the accounting system.
• A list of deposits in transit and outstanding payments, with dates and subsequent-clearance checks where available.
• Support for material deposits, withdrawals, transfers, reversals and adjustments.
• Relevant tenant, owner, vendor or deposit subledger reports at the same cutoff date.
• An exception schedule showing the issue, amount, property or entity, explanation, owner and next step.
• Evidence of review and a record of approved corrections, including the period in which each correction was posted.

Set a consistent file naming and storage convention across accounts and periods. If the reviewer cannot tell which statement, ledger export and exception list belong together, the reconciliation may be mathematically complete but difficult to rely on operationally.

When a trust-account workflow needs a three-way reconciliation

Where the applicable rules and account arrangement require trust-account reconciliation, a bank-to-book match may not be enough. For California real estate brokers subject to the applicable trust-fund rules, distinguish the record-to-record reconciliation from the bank reconciliation. The control record tracks trust-fund activity; separate records track each beneficiary or transaction; the required trust-account reconciliation compares the total of the separate records with the control-record balance at the same date. The reconciled records are then compared with the adjusted bank balance. Other jurisdictions and account arrangements may require different procedures, so the broker or responsible licensed professional must confirm which rules apply.

For California real estate licensees subject to the Department of Real Estate's trust-fund rules, the DRE describes a control record, separate beneficiary or transaction records, and a trust-account reconciliation that compares the total of separate records with the control-record balance. See the California DRE trust-fund recordkeeping guidance, the official DRE audit forms and the DRE’s Trust Funds guide. Applicability depends on the license, activity and governing rules; this guide is not legal advice.

1. Complete and review the bank reconciliation for the relevant account and date.
2. Confirm the control record includes the required receipts, disbursements and running balance.
3. Reconcile each required beneficiary or transaction record and total the balances.
4. Compare the detailed total to the control record and investigate any difference.
5. Document the preparer, reviewer, date, exceptions and correction trail according to the applicable requirements.

How to review the reconciliation before month-end reporting

A reviewer should be able to distinguish a bank timing difference from an allocation or posting error. Start by checking that the statement and ledger use the same account and cutoff date, then inspect the largest, oldest and unusual reconciling items. A small difference is not automatically harmless, and a large difference is not automatically an error; the supporting record and transaction history determine the next step.

• Check the opening balance: agree it to the prior approved reconciliation and trace any change to a dated adjustment.
• Check deposits after period end: use subsequent bank activity to test whether deposits in transit cleared and whether the amount agrees to the original receipt batch.
• Check outstanding payments: review later clearing, voids, replacements and stale items under the client's documented process.
• Check property allocation: compare material receipts and disbursements with the property, tenant or owner detail, not only the portfolio cash total.
• Check related control accounts: compare tenant, owner, vendor and deposit schedules to the relevant general-ledger balances at the same date.

For a useful close handoff, group unresolved items by cause and action: missing source record, timing difference, coding or allocation question, possible duplicate, reversal, bank-originated charge or approval required. Assign an owner and next review date. If the item affects an owner statement or other external report, identify that impact before the report is issued.

Do not let old items become normal

An outstanding item that remains month after month deserves a reason. Keep a short open-items list with the date, amount, property, likely cause and person responsible for resolution. This is more useful than repeatedly carrying the same unexplained difference forward.

After the reconciliation

Use the completed reconciliation as part of the monthly close. Then review the effect on tenant receivables, vendor payables, owner statements and cash reporting. If the accounting system feeds another reporting platform, confirm the handoff as well.

Related guides

Use the property management month-end close checklist to place reconciliations into the wider close process. See property management accounting, rent roll accounting and bookkeeping vs. accounting. The broader property management accounting and bookkeeping page explains how these pieces fit into the full portfolio workflow.

For receipts recorded before they appear in a bank deposit, use the undeposited funds reconciliation guide. For card liability, receipts and property expense coding, see the credit card reconciliation checklist. If you also need to compare reports from your property-management platform with the general ledger, see our platform-to-general-ledger reconciliation support. If you operate a property management company and need recurring accounting operations across properties and entities, review our accounting support for property management companies.