Bank reconciliation is the process of matching the company's books to the bank statement. In most industries, it is a routine bookkeeping task. In commercial real estate, it is a control point for revenue protection.
A commercial property has multiple bank accounts: operating accounts, security deposit accounts, CAM escrow accounts, and reserve accounts. Each account has hundreds of transactions per month. Each transaction has to be matched to a tenant, an invoice, an expense, or a transfer. When the reconciliation fails, the error is not just an accounting discrepancy. It is a revenue leak.
This article explains why bank reconciliation matters more in commercial real estate than in other industries, and where the process breaks down.
Why It Is More Than Bookkeeping
In a standard business, bank reconciliation confirms that the books match the bank. The goal is accuracy.
In commercial real estate, bank reconciliation answers four additional questions:
Did we collect what we billed? The rent roll says Tenant A owes $5,000. The bank statement shows $4,800. The $200 difference is a short payment, a misapplied credit, or a billing error. Without reconciliation, the $200 is invisible.
Did we pay what we should have? The invoice says $3,200 for landscaping. The bank statement shows $3,200 to the landscaper and $3,200 to a different vendor with a similar name. One of them is a duplicate. Without reconciliation, the duplicate is not found.
Did we recover what we are owed? The CAM reconciliation says Tenant B owes $1,800 for the annual true-up. The bank statement shows no payment. The true-up was calculated but never billed. Without reconciliation, the recovery is lost.
Did we allocate correctly? A $12,000 insurance premium is paid from the operating account. It should be allocated to the insurance pool for NNN recovery. It is coded to "General Expenses." The recovery is missed. Without reconciliation, the allocation error is permanent.
The Four Failure Points
1. Missing Receipts
What it is: A tenant payment is recorded in the rent roll but never deposited, or deposited but not recorded.
How it happens: The check is received and logged but not taken to the bank. The electronic payment is received but not matched to the invoice. The payment is applied to the wrong tenant.
The impact: The property thinks it has collected rent it has not. The cash position is overstated. The delinquency report is wrong.
2. Duplicate Payments
What it is: The same expense is paid twice.
How it happens: The invoice is entered manually and then imported electronically. A credit memo is not applied. The vendor resubmits an invoice and it is paid again.
The impact: Expenses are overstated. Cash is reduced. The duplicate may not be recoverable if the vendor does not cooperate.
3. Unidentified Transactions
What it is: A bank transaction has no matching entry in the books.
How it happens: A tenant pays by ACH with no reference. A vendor auto-debits without an invoice. A bank fee is charged but not recorded. An interest payment is received but not recognized.
The impact: The books do not reflect reality. The reconciliation has an unexplained variance. The variance grows over time.
4. Incorrect Allocations
What it is: A transaction is recorded to the wrong account, the wrong tenant, or the wrong pool.
How it happens: The coding is done by hand. The chart of accounts is ambiguous. The person coding the transaction does not know the lease terms.
The impact: Expenses are misclassified. Recoverable expenses are treated as non-recoverable. Tenant charges are wrong. The CAM pool is incorrect.
The Manual Process
The manual bank reconciliation process in commercial real estate typically follows this pattern:
- Download the bank statement (PDF or CSV)
- Open the accounting system
- Print or export the general ledger activity for the month
- Compare the two documents line by line
- Mark matches with a highlighter or a checkmark
- Investigate unmatched items
- Prepare a reconciliation summary
- File the summary with the month-end package
This process takes 4 to 8 hours per account per month. A property with 4 bank accounts requires 16 to 32 hours of manual reconciliation every month.
The process fails when:
- The volume is too high to review every transaction
- The person doing the reconciliation does not know the lease terms
- The reconciliation is done weeks after the month ends
- The summary is filed without resolving the variances
The Automated Alternative
Automatic coding. Transactions are coded to the correct account based on vendor rules, lease terms, and historical patterns.
Exception flagging. Unmatched transactions are flagged immediately. The controller reviews exceptions, not every transaction.
Duplicate detection. The system flags transactions with matching vendor, amount, and date. Duplicates are caught before they are paid.
Allocation validation. Recoverable expenses are identified at the point of entry. The allocation is validated against the lease terms.
Audit trail. Every match, every exception, and every resolution is logged. The reconciliation is documented by default.
Conclusion
Bank reconciliation in commercial real estate is not a bookkeeping formality. It is the process that confirms revenue was collected, expenses were correct, and recoveries were billed. When it fails, the errors are permanent.
Komod.ai is an AI-native operating layer for the commercial real estate back office. The platform reads leases, invoices, and bank activity; performs deterministic calculations; and stages completed work for human approval. Nothing posts without you.