Property Management Accounts Receivable Aging: Reconciliation and Review

A property management accounts receivable (AR) aging report shows charges that remain unpaid and how long they have been outstanding. It can support collection visibility, but it is also an accounting control: the detail should be complete, correctly dated, linked to the right tenant or property, and reconcilable to the receivables balance in the general ledger.

This guide focuses on the accounting review of aging reports—not tenant communication scripts or legal collection advice. Collection policies, lease terms, payment plans and escalation decisions should be handled by authorized personnel under applicable agreements and requirements.

1. Set the reporting date and scope

Before reviewing the numbers, confirm the report date, legal entity, property portfolio, receivable types, accounting basis and tenant-status filters. Check whether the report includes current and former tenants, non-rent charges, credits and unapplied receipts. Comparing reports with different dates or filters can create an apparent mismatch that is not an accounting error.

• Use the same cutoff date for the aging and general ledger.
• Confirm the property, entity and account filters.
• Check whether former tenants and closed properties remain in scope.
• Retain the report parameters or export with the close workpapers.

2. Validate the aging buckets and underlying transactions

Aging buckets commonly group balances by days outstanding, but exact labels and date logic vary. Confirm whether age is measured from the charge date, due date or another configured field. Sample material balances back to charge detail, lease terms, approved fees, adjustments and payment history. Investigate duplicate charges, wrong-period entries and charges assigned to the wrong tenant or unit.

Do not assume an old balance is collectible or uncollectible solely because of its age. The report identifies the accounting position; any provision, write-off or collection decision needs the organization’s documented policy and required approval.

3. Reconcile aging detail to the general ledger

Compare the total aging balance with the appropriate accounts receivable control account for the same entity and reporting date. The amounts should agree or have a documented reconciliation of differences. If they do not, check report filters, posting dates, manual journal entries, subledger batches, duplicate postings and transactions recorded directly in the general ledger.

Use a short reconciliation schedule that shows the aging total, general-ledger balance, each reconciling item, the supporting evidence and the person responsible for resolution. Avoid a generic journal entry that merely forces the two totals to match.

4. Review receipts, credits and unapplied cash

Unapplied payments, credit balances, reversals and refunds can distort the picture of what is overdue. Trace material receipts to the correct tenant or lease and confirm that credits are applied to the appropriate charge. Check whether a receipt has been recorded in the tenant ledger but not cleared through the deposit workflow, or whether the same receipt was entered twice.

For transaction-level charge and payment history, use the tenant ledger reconciliation checklist. For recorded receipts that have not yet matched a bank deposit, see the undeposited funds reconciliation guide.

5. Investigate former-tenant and disputed balances

Former tenants can disappear from a report when the export is filtered to active leases only. Where those balances remain within the accounting scope, review them separately and retain the charge history, receipts, credits and move-out adjustments. Confirm that security deposits are accounted for under the correct liability and settlement workflow rather than casually netted against rent receivables.

For disputed items, record the amount, reason, evidence requested, responsible person and status. Accounting records should reflect approved adjustments, not informal assumptions about whether a tenant will pay.

6. Use the rent roll as a cross-check, not a substitute

The rent roll typically describes units, lease terms, occupancy and scheduled rent. Receivables aging describes amounts still outstanding. They answer different questions and will not match line by line. Compare them to identify missing leases, incorrect recurring charges, rent changes not posted, concessions, move-in or move-out timing, and unusual differences between scheduled rent and billed amounts.

See the rent roll accounting guide for the operational report and its relationship to accounting records. Keep the aging report as the starting point for overdue-balance review.

7. Track aging trends and exceptions

Compare current aging with prior periods and investigate meaningful changes in total receivables, older balances, credit balances and the number of accounts affected. Use consistent date ranges and buckets when trending results. A larger balance may reflect a portfolio change or billing cycle, so explain the cause rather than relying on the total alone.

An exception log can record tenant or account reference, property, amount, age, issue, next action, assigned owner, due date and resolution. Restrict access to tenant information and share reports only with authorized recipients.

8. Complete the review before owner reporting

Resolve material mismatches or document them before issuing the financial reporting package. Confirm that corrections are approved and that the aging, tenant ledger, receivables control account and relevant cash or deposit records tell a consistent story. Include the reconciliation in the property management month-end close checklist and use the financial statements guide to understand how receivables support the wider reporting pack.

Receivables aging reconciliation checklist

• Reporting date, entity, property and tenant filters confirmed.
• Aging buckets and date logic understood.
• Material charges sampled to lease and source records.
• Aging total tied to the corresponding general-ledger control account.
• Unapplied receipts, credits, reversals and duplicate entries reviewed.
• Former-tenant balances and move-out adjustments considered.
• Meaningful changes and older balances explained or assigned for action.
• Adjustments approved and supporting evidence retained.
• Reviewer and completion date recorded before reporting is issued.

Frequently asked questions

A reliable aging report is more than a list of late payments. When it reconciles to the general ledger and is supported by tenant-level detail, it gives property managers a defensible view of outstanding balances and a cleaner foundation for owner reporting.