Commercial Property Operating Account Reconciliation: A Monthly Workflow for Landlords

Commercial Property Operating Account Reconciliation: A Monthly Workflow for Landlords
The operating account can look busy and still be wrong.
Rent deposits arrive in batches. An ACH payment clears without the invoice nearby. A check remains outstanding for months. A bank fee appears after the books have been reviewed. None of those items is automatically a crisis. But when they are left unexplained, the bank balance stops being a dependable starting point for an owner conversation.
A monthly operating-account reconciliation is the practical close step that connects the bank activity to the books and gives every remaining difference a name, an owner, and a next action. It is not a CAM recovery calculation, a redesign of the chart of accounts, or an accounts-payable approval process. Those workflows may feed the records you review, but reconciliation asks a narrower question: can you explain the difference between the statement balance and the cash balance in the books as of the same date?
This is an educational operating workflow, not tax, legal, or entity-specific accounting advice. Ask your accountant how the process, adjustments, and retained records should work for your entities and reporting requirements.
Start with one account, one cutoff, and two complete lists
Choose the property operating account and use the statement ending date as the cutoff. Pull two complete lists through that date:
- the bank statement and transaction detail, including check images or electronic-payment detail where available
- the general-ledger detail for that same cash account and period
Also bring forward the prior reconciliation and its unresolved-items list. The work is much harder when last month's unexplained ACH debit or outstanding check has vanished into an old folder.
Do not quietly blend the first days of the next month into the current reconciliation. A payment can be entered in the books before it clears the bank, or reach the bank after the statement cutoff. The reconciliation should make that timing visible rather than hide it by changing the period.
> The goal is not to make two totals agree by force. The goal is to account for every difference with support that another reviewer can follow.
Match cleared bank activity to the books
Work through the bank detail and the book detail together. For each cleared item, match the amount, date, payer or payee, reference number, and property or entity context. A match based only on a similar dollar amount is not enough when the portfolio has recurring rent, utilities, or vendor payments.
Receipts and deposits
For each deposit, ACH credit, lockbox batch, or payment-processor settlement, identify what it represents and whether the books reflect the same activity.
- Tie tenant receipts to the tenant ledger, remittance, or payment batch.
- Check deposits containing more than one receipt; a correct total can still hide an unapplied payment.
- Note processor fees, returned payments, chargebacks, or bank adjustments that make the net bank amount differ from the gross receipt.
- Flag deposits that cannot yet be connected to a tenant, charge, refund, owner contribution, or other supported purpose.
An unidentified deposit should not be pushed to a generic income account just to clear the reconciliation. Keep it visible as an exception while the team locates the remittance or confirms the facts.
Disbursements and debits
For checks, ACH debits, wires, card activity, and bank fees, connect the cleared bank item to the book entry and the record that explains it.
- Match vendor payments to the bill, payment record, and available invoice support.
- Verify that the payment belongs to the correct property and entity before treating it as a simple coding cleanup.
- Look for a repeated amount, invoice number, or payment reference that could indicate a duplicate.
- Capture bank-only activity—fees, interest, returned payments, or automatic debits—so it is not carried as an unexplained difference.
This is not the moment to redo the original approval process. If a bill was approved for payment, reconciliation confirms whether the bank activity and books reflect the payment accurately. If support is missing or the activity is unexpected, record the exception and assign it for follow-up.
Sort every unmatched item before it gets old
At the end of matching, every open item should fall into one of three buckets: a documented timing item, an item that needs a correction, or an item that needs investigation.
Timing items
Common timing items include deposits in transit, outstanding checks, and payments initiated before month-end that settle after the statement date. List each one with its original date, amount, counterparty, reference number, and expected clearing date. Carry the list to next month and actively recheck it.
Timing is an explanation, not a permanent category. An outstanding check that remains open beyond the portfolio's normal clearing window deserves a follow-up. The same is true of a deposit in transit that never reaches the bank.
Corrections
Corrections can include duplicated entries, transposed amounts, a payment recorded in the wrong cash account, or a bank charge that was never recorded. Preserve the reason for the correction and the support for it. If the item affects a closed period, tenant balance, owner balance, or another sensitive account, stop and use the review your accountant or internal policy requires.
Investigations
Some differences need facts before they need an entry. An unknown ACH debit, a stale check, an unexpected transfer, or a deposit without a remittance should stay on an exception log until the team can determine what happened. Name one owner and a next review date; otherwise, the same question will return at every close.
Retain a reconciliation package, not just a completed screen
A reconciliation is only reviewable if the support survives the person who prepared it. Keep the following together for each account and month:
- final bank statement and transaction detail
- ledger detail used for the reconciliation
- reconciliation summary showing the book balance, statement balance, and identified differences
- support for material receipts, payments, adjustments, and corrections
- the current unresolved-items log, including ownership and follow-up dates
- preparer, reviewer, and completion dates under your internal process
The IRS advises businesses to retain records that show income and expenses and to keep supporting documents such as invoices, receipts, deposit slips, and canceled checks.[^1] Your accountant can advise on the records and retention practices appropriate to your entity and circumstances.
This package is not meant to create paperwork for its own sake. It makes the next question faster to answer: Why is cash different from the books? What has not cleared? Where did this receipt go? What did we do about the unusual debit?
Build an owner-ready handoff
The owner handoff should be short enough to review and specific enough to be useful. It is not a dump of every transaction, and it is not a substitute for a full owner statement. It is the close record that tells the reviewer whether the operating account is reconciled and what still needs attention.
Use a one-page summary or concise cover note with:
| Include | What the reviewer needs to know | | --- | --- | | Account and period | Which operating account and statement cutoff were reconciled | | Reconciliation status | Whether the account reconciles and the date it was completed | | Open timing items | Count, total, oldest item, and expected clearing or review date | | Exceptions | Unknown activity, duplicates, missing entries, or corrections still in progress | | Material activity | A short explanation of unusual receipts, payments, or transfers that merit attention | | Next actions | Owner, due date, and decision needed for each unresolved item |
Keep the supporting package available behind that summary. A reviewer should be able to ask about an exception and reach the bank line, ledger entry, and related document without rebuilding the month from email.
A monthly workflow that fits a small commercial portfolio
Use this sequence every month after the bank statement is available:
1. Set the statement-date cutoff and gather the bank detail, ledger detail, prior reconciliation, and open-items log. 2. Match cleared deposits and debits to book entries using more than the amount alone. 3. Record legitimate timing items with references and expected clearing dates. 4. Identify duplicates, missing entries, incorrect amounts, wrong-entity activity, and unsupported transactions. 5. Make or route corrections with the supporting record preserved. 6. Assign each unresolved item to a person and a next review date. 7. Save the reconciliation package and produce the owner-ready summary. 8. Review recurring exceptions before they become the next month's inherited problem.
For a small portfolio, this can be a focused monthly routine rather than a large accounting project. The discipline is in the follow-through: every open item stays visible until it clears, is corrected, or is resolved with support.
Keep bank reconciliation separate from the workflows around it
Clear boundaries make the monthly close easier to manage.
- CAM recovery asks whether a lease allows an expense to be allocated or billed to tenants. Reconciliation confirms that the cash and book activity behind an expense or receipt are explained; it does not decide recoverability. Start annual work from a documented CAM reconciliation process, then apply the lease and qualified advice to the recovery analysis.
- Chart-of-accounts design determines how transactions are organized for reporting. Reconciliation uses the existing cash-account detail to identify mismatches; it is not the time to rebuild the entire account structure.
- AP approval documents whether a bill or commitment had the right operational review before payment. The commercial property accounts-payable approval workflow should preserve that trail; reconciliation checks whether the payment that cleared is complete and correctly reflected in the books.
When those workflows stay connected but distinct, the bank reconciliation becomes a dependable control rather than a catch-all cleanup exercise.
Make next month easier to explain
The best operating-account reconciliation is not a heroic cleanup at quarter-end. It is the routine that lets a landlord look at cash, identify what is still open, and give an owner a reviewable answer without relying on memory.
I built PigJet for commercial landlords who need their property activity, supporting records, and follow-up work to stay connected. If your month-end process still means hunting across bank portals, inboxes, and spreadsheets to explain a cash difference, explore a one-property PigJet pilot.
[^1]: Internal Revenue Service, "How should I record my business transactions?" and "What kind of records should I keep?", accessed November 22, 2026.