Short answer: An AR aging report groups the amounts tenants owe by how long they've been outstanding, usually current, 31–60, 61–90 and over 90 days. Reading it well means looking past the totals: separating current and former tenants, rent and non-rent charges, credit balances and disputed or plan-covered amounts, and checking that the report agrees with the ledger. The oldest buckets highlight balances that generally require the closest collection review, but only after the report is clean.
The aging report says $84,000 is more than 90 days past due. That number gets attention. Then someone looks closer. Half of it belongs to tenants who moved out months ago. Some of it is a commercial expense true-up billed in March that the tenant is disputing. A few residents with large balances are on payment plans and paying on schedule. And credit balances from tenants who paid ahead are quietly netting the total down.
The aging report is one of the most used collections reports in property management, and one of the easiest to misread. This guide covers what each bucket means, what typically distorts the report, the questions to ask before acting, and how to keep the report clean.
Must Read: How to Build a Rent Delinquency Workflow: Automated Escalation, Notices, and Arrears Tracking, for the escalation process the aging report feeds.
Table of Contents
-
The Buckets at a Glance
-
How Charges Land in Each Bucket
-
What Sits in the Buckets Besides Unpaid Rent
-
Six Questions to Ask Before Acting
-
Watching Balances Move Between Buckets
-
Residential vs Commercial Aging
-
Keeping the Report Clean
-
AR Aging Checklist
-
Common Mistakes
-
FAQs
The Buckets at a Glance
Bucket ranges vary by system and company. A common setup:
| Bucket | What it usually means | The question to ask |
|---|---|---|
| Current (0–30 days) | This month's charges not yet paid, or recently late | Is this normal timing, or an early sign of a problem? |
| 31–60 days | A second month of rent may now be unpaid | Has the tenant been contacted, and is there a plan? |
| 61–90 days | A sustained shortfall | Has the account moved to the next escalation stage? |
| Over 90 days | The balances that generally need the closest collection review | Is the tenant still in place, on a plan, in legal, or gone? |
The age is usually measured from each charge's due date, not the date it was billed. Check how your system calculates it, because the two can produce different reports.
How Charges Land in Each Bucket
How payments are applied changes the buckets. Payment application settings determine which open charges a payment clears first. In some systems, payments may be applied to older charges before newer ones. If a tenant pays this month's rent but has an old late fee, a payment applied to the old fee first can leave this month's rent showing as unpaid.
Some states regulate this. Washington, for example, requires landlords to apply a tenant's payment toward rent before late fees, damages, legal costs or other fees under RCW 59.18.283. Check your state's rules and your lease, then confirm your system's payment application settings follow them.
Fees arrive on their own schedule. Late fees are only charged after any grace period in the lease or state law. Washington, for instance, bars late fees on rent paid within five days after the due date under chapter 59.18 RCW. So fees often appear in the report later than the rent they relate to.
What Sits in the Buckets Besides Unpaid Rent
| Item | Why it distorts the report | How to handle it |
|---|---|---|
| Former tenant balances | Balances from move-outs sit next to current residents but follow a different collection path | Report former tenants separately |
| Credit balances | Prepaid rent and overpayments net against what others owe, understating the gross amount past due | Show gross receivables and credits separately |
| Unapplied cash | A payment received but not matched to a tenant leaves a balance showing that's actually paid | Apply cash before reviewing the report |
| Expense reconciliation charges | Commercial CAM true-ups are billed once and can jump straight into older buckets if disputed | Track them separately from rent |
| Late fees and other charges | Mixed in with rent, they inflate balances that may be treated differently by law or policy | Split rent and non-rent amounts |
| Disputed charges | Amounts under dispute shouldn't be treated like ordinary arrears | Flag them with the dispute status |
| Payment plans | Old balances under a plan may be on track | Flag plan accounts and check against the plan schedule |
| Legal and eviction accounts | Balances in legal follow the court process, not collections calls | Flag accounts in legal status |
Commercial true-up charges come from the annual reconciliation covered in CAM reconciliation in commercial leases.
Six Questions to Ask Before Acting
-
Does the report agree with the ledger? The aging total should agree with accounts receivable in the general ledger. The period-end reconciliation that confirms this is covered in How to Automate Rent Collection.
-
Is it gross or net? Are credit balances reducing the total?
-
Current or former tenants? How much of the oldest bucket belongs to people who no longer live there?
-
Rent or other charges? How much is rent, and how much is fees, utilities or reconciliation charges?
-
What's already being handled? Which balances are on payment plans, disputed or in legal?
-
How concentrated is it? Do a handful of accounts make up most of the oldest bucket? If so, those accounts need individual attention.
Watching Balances Move Between Buckets
A single month's aging is a snapshot. Comparing months shows how balances move. A simple measure is how much of last month's 0–30 bucket is now in the 31–60 bucket, and so on. If more of each bucket is rolling into the next, collections are slipping, even if the total hasn't changed yet.
Older balances eventually either get collected or written off as bad debt. Bad debt reduces the rent a property actually collects, which shows up in economic occupancy.
Residential vs Commercial Aging
Residential aging is mostly rent and recurring charges across many small balances. Patterns across tenants matter more than any single account.
Commercial aging usually has fewer, larger balances, including expense reconciliation charges and sometimes disputed amounts. A single tenant can drive the oldest bucket, so commercial aging is usually reviewed account by account.
Keeping the Report Clean
A monthly cleanup before the report is reviewed:
-
Apply all unapplied cash.
-
Apply credit balances where the lease and your policy allow, and show the remaining credits separately.
-
Move former tenant balances to a separate status or report.
-
Record disputes, payment plans and legal status on the account.
-
Write off uncollectible balances according to your approval policy, and check that the reserve is recorded according to your accounting framework.
A dashboard that shows aging by bucket, status and property from the same data as the ledger, such as property management dashboards and reports, makes the review faster. Escalation steps and reserve approaches are covered in the delinquency workflow guide linked above.
AR Aging Checklist
-
Aging total agrees with accounts receivable in the general ledger
-
Unapplied cash applied before review
-
Gross receivables and credit balances shown separately
-
Former tenants reported separately from current residents
-
Rent and non-rent charges split
-
Disputes, payment plans and legal status flagged
-
Payment application settings follow state law and the lease
-
Bucket movement compared with last month
-
Largest balances in the oldest bucket reviewed individually
-
Write-offs made according to the approval policy
Common Mistakes
Reading the net total. Credit balances can make the past-due total look smaller than it is.
Mixing current and former tenants. Former tenant balances need a different collection approach.
Ignoring payment application rules. Applying payments to fees first can misstate the buckets and, in some states, breach the law.
Treating every old balance the same. Disputed, plan-covered and legal accounts need different handling.
Reviewing before cash is applied. Unapplied payments make paid balances look overdue.
Looking at one month only. Movement between buckets shows the trend before the total changes.
FAQs
1. What is an AR aging report in property management?
A report that groups the amounts tenants owe by how long they've been outstanding, typically current, 31–60, 61–90 and over 90 days.
2. What are aging buckets?
Time ranges used to group outstanding balances by age. Ranges vary by system, but 30-day buckets are common.
3. Is aging measured from the billing date or the due date?
It depends on the system. Many measure from each charge's due date. Check your system's setting, because the two produce different results.
4. Why do former tenants show up in the aging report?
Balances remaining after move-out stay in receivables until collected or written off. Reporting them separately avoids mixing them with current residents.
5. How do credit balances affect the aging report?
Credit balances from prepaid rent or overpayments can net against amounts owed, understating the gross past-due total. Show them separately.
6. How are tenant payments applied to old balances?
It depends on the system's payment application settings, the lease and state law. Some states regulate the order. Washington, for example, requires payments to be applied to rent before late fees and other charges.
7. How often should the aging report be reviewed?
Commonly weekly for collections follow-up and monthly at close, after cash is applied and the report is reconciled to the ledger.
8. What should be done with balances over 90 days?
Check whether the tenant is still in place, on a plan, disputing the charge or in legal, then follow your escalation and write-off policies.
Conclusion
The aging report shows how long tenants have owed money, but only a clean report shows where collection attention is really needed. Reconcile it to the ledger, separate current and former tenants, rent and other charges, and gross balances and credits. Flag disputes, plans and legal accounts, and watch how balances move between buckets month to month. Then act on what's left.
Note: This article is general information, not legal or accounting advice. Payment application rules, late fee limits and reserve methods depend on state law, lease terms and your accounting framework. Confirm the rules that apply to you.
.svg)
.svg)
.svg)