Commercial Property Bank Reconciliation: A Monthly Checklist for Landlords

Commercial Property Bank Reconciliation: A Monthly Checklist for Landlords
When a bank balance and the general ledger do not agree, the answer is rarely as simple as “the books are wrong.” A tenant payment may have landed in the bank after month-end. A vendor check may still be outstanding. A bank fee, ACH debit, or returned payment may not have reached the ledger yet.
For a commercial landlord, letting those small gaps linger creates bigger problems: cash reporting becomes less reliable, open receivables are harder to explain, and year-end CAM or NNN work starts with a question mark. A disciplined monthly bank reconciliation gives you a clean starting point before those loose ends pile up.
This is a practical operating checklist—not tax, legal, or accounting advice. Your lease terms, entity structure, accounting method, and reporting requirements control. Bring your bookkeeper or CPA into the review when an item affects financial statements, taxes, tenant accounting, or a prior period.
What you are reconciling
A bank reconciliation explains the difference, if any, between the ending balance on a bank statement and the cash balance in your general ledger for the same account and date. The goal is not to force the numbers to match. The goal is to identify every valid transaction and document the reason for each timing difference or correction.
For a property operating account, the supporting record set usually includes:
- The complete bank statement and transaction detail for the month
- General-ledger detail for the same bank account and period
- Tenant receipts, deposit detail, and any payment-processor reports
- Vendor bills, ACH confirmations, check images, and wire support
- Prior-month reconciliation and its unresolved-items list
The IRS notes that business records should identify the source and amount of receipts and expenses, with support such as invoices, receipts, deposit slips, and canceled checks.[^1]
Start with a clean cutoff
Choose a reconciliation date—normally the bank statement ending date—and use it consistently. Pull the bank activity and the general-ledger detail through that date. Do not blend the first few days of the next month into the current close just because the transactions are easy to see.
That cutoff discipline matters in commercial property accounting because the operational event and the bank event may fall in different periods. A tenant can remit rent on the last day of the month, while the payment settles after the statement closes. A vendor can invoice this month, while the payment clears next month. Record the transaction according to your accounting policies, then let the reconciliation show the timing difference clearly.
Match bank activity to the general ledger
Work through both lists, not just the largest transactions. Match each cleared item to its ledger entry using amount, date, payee or payer, payment reference, and property or entity where applicable.
Tenant receipts
For every deposit, ACH credit, lockbox receipt, or card settlement:
1. Match it to the tenant ledger, remittance advice, or payment batch. 2. Confirm what the money was applied to: base rent, CAM/NNN estimate, true-up, late fee, security deposit, or another charge. 3. Check whether the bank amount is net of processor fees, chargebacks, or other deductions. 4. Flag receipts without a clear tenant or charge application rather than posting them to a catch-all income account.
A tenant receipt that has reached the bank but remains unapplied in accounts receivable can make cash look right while the rent roll looks wrong. Resolve both sides before closing the month.
Vendor payments
For checks, ACH debits, wires, autopayments, and card activity:
1. Match the bank item to the bill, payment record, and ledger posting. 2. Verify the vendor, property, payment amount, and expense account. 3. Review partial payments, duplicate payments, and payments made from the wrong entity or operating account. 4. Keep the invoice and approval support with the payment record, especially for repairs, utilities, taxes, insurance, and shared-property costs.
Bank fees, interest, merchant fees, returned payments, and automatic debits often appear on the bank statement before anyone records them. Add or correct those entries with support; do not leave them as unexplained differences.
Separate timing differences from errors
Not every unmatched item is a mistake. Common, legitimate timing differences include:
- Deposits in transit: recorded in the ledger but not yet shown by the bank
- Outstanding checks: recorded in the ledger but not yet cleared
- ACH payments initiated before month-end that settle after the statement date
- Card or lockbox batches that settle after the tenant payment date
List each timing difference with the date, amount, counterparty, reference number, and expected clearing date. Then carry that list into next month’s reconciliation. If an item remains unresolved longer than your normal clearing window, investigate it instead of rolling it forward automatically.
Errors need a different response. Examples include a payment posted twice, a tenant payment applied to the wrong tenant, a vendor payment coded to the wrong property, a transposed amount, or activity that does not belong to the entity. Correct the ledger with an auditable entry and retain the explanation. If the correction reaches a closed reporting period or changes a tenant balance, pause for the appropriate accounting or management review.
Review unresolved items before you sign off
An unresolved-items list is one of the most useful outputs of the reconciliation. It should answer: what is open, why is it open, who owns the next step, and when will it be reviewed again?
Use a short log with these columns:
| Item | Amount | Date | Why it is open | Owner | Next review | | --- | ---: | --- | --- | --- | --- | | Tenant receipt awaiting application | | | | | | | Outstanding vendor check | | | | | | | Bank fee not yet recorded | | | | | | | Unknown ACH or debit | | | | | |
Do not write off, reclassify, or refund an unresolved item solely to make the reconciliation balance. First confirm the facts, the supporting documents, and any lease or entity implications.
Monthly commercial-property bank reconciliation checklist
Use this checklist after each statement closes:
- Save the complete bank statement, transaction detail, and any check images.
- Export general-ledger detail for the same bank account and statement period.
- Carry forward and recheck every prior-month unresolved item.
- Match all tenant receipts to tenant accounts and the correct charge categories.
- Match all vendor payments to bills, approvals, properties, and expense accounts.
- Record bank fees, interest, processor fees, returned payments, and other bank-only activity with support.
- Identify and document deposits in transit and outstanding checks.
- Investigate duplicates, unexpected debits, unclear deposits, wrong-entity activity, and stale checks.
- Confirm the adjusted bank balance agrees to the adjusted general-ledger balance.
- Save the reconciliation, support, corrections, and unresolved-items log together.
- Have the preparer and reviewer complete the review required by your internal controls.
When to involve a bookkeeper or CPA
Your internal team can usually handle routine matching and well-documented timing differences. Escalate early when you find an item that is material to the property or entity, has no support, has been carried forward repeatedly, affects a tenant balance, or may require a prior-period adjustment.
Ask a bookkeeper or CPA to review items involving tax treatment, owner contributions or distributions, intercompany transfers, deposits held for others, debt-service activity, large write-offs, fraud concerns, or changes to how transactions are recognized. They can also help set a repeatable close process that fits your entities and accounting method. The U.S. Small Business Administration similarly identifies bank reconciliation as a core bookkeeping responsibility and distinguishes the day-to-day role of a bookkeeper from the more tailored support a CPA can provide.[^2]
Make the next close easier
The best reconciliation is not a heroic month-end cleanup. It is a short, repeatable review that keeps tenant receipts, vendor payments, and bank activity connected to the records that explain them.
If you are also preparing for annual pass-through work, start with clean monthly records before building your CAM reconciliation process. PigJet helps commercial landlords keep the property operations behind rent, vendor costs, and NNN workflows organized in one place.
Want a simpler way to keep commercial-property operations and financial workflows connected? Schedule a PigJet demo.
[^1]: Internal Revenue Service, “How should I record my business transactions?” and “Recordkeeping,” accessed September 10, 2026. [^2]: U.S. Small Business Administration, “Manage your business,” accessed September 10, 2026.