Illustrated commercial accounts receivable aging workflow with color-coded aging buckets and collection follow-up priorities.

--- slug: commercial-property-accounts-receivable-aging-report title: "Commercial Property Accounts Receivable Aging Report: A Landlord’s Guide" metaTitle: "Commercial Property Accounts Receivable Aging Report | PigJet" metaDescription: "Use a commercial property accounts receivable aging report to spot unpaid rent, isolate disputes, assign follow-up, and protect a clean tenant ledger." excerpt: "An accounts receivable aging report is not just a list of past-due tenants. For commercial landlords, it is a working view of unpaid rent, open CAM charges, credits, disputes, and the next follow-up needed." author: PigJet Team date: "2026-09-04" category: Commercial Landlord Accounting tags: [commercial property accounts receivable, AR aging report, tenant ledger, rent collections, NNN leases] readTime: "8 min read" ogImageUrl: "https://www.pigjet.com/blog-assets/commercial-property-accounts-receivable-aging-report-hero.png" ogImageAlt: "Illustrated commercial accounts receivable aging workflow with color-coded aging buckets and collection follow-up priorities." canonicalUrl: "https://www.pigjet.com/blog/commercial-property-accounts-receivable-aging-report" relatedSlugs: [tenant-ledger-cleanup-before-cam-reconciliation, rent-escalation-tracking-nnn-leases, commercial-landlord-accounting-response-problem] ---

Commercial Property Accounts Receivable Aging Report: A Landlord’s Guide

A tenant balance can look straightforward until someone has to explain it. Is the amount unpaid base rent? A CAM estimate? A tax or insurance charge? A late fee? A credit that was never applied? A dispute that is already being worked? Or an invoice that went to the wrong contact?

By the time a landlord tries to answer those questions from memory, an ordinary collection follow-up can turn into a ledger-cleanup project.

That is why a commercial property accounts receivable aging report matters. It shows open tenant balances by how long they have been outstanding, but its real job is to give the team a reliable next action. The report should help a landlord see who needs a reminder, which balance needs a lease or billing review, which promise-to-pay needs a date, and which account belongs with counsel or a collection process under the lease.

> An aging report is a follow-up list, not a verdict. An old balance may be collectible, disputed, misapplied, or already covered by a documented payment plan. The report needs context before it drives a decision.

What an AR aging report shows

Accounts receivable are amounts a business expects to collect. In commercial property, that commonly includes billed base rent, recurring additional rent, CAM estimates, tax and insurance estimates, utility rebills, late fees, and other lease-authorized charges.

An aging report groups open charges into time buckets, such as current, 1–30 days past due, 31–60, 61–90, and more than 90 days. The exact bucket names can vary, but the point is consistent: show both the total amount due and how long it has been open.

A useful commercial property report is more specific than a tenant-name-and-total list. For each tenant, it should make it possible to see:

That structure keeps the report from becoming a scoreboard. A $12,000 balance that is five days old after a monthly rent bill deserves different handling than a $2,000 utility rebill that has sat unresolved for 75 days.

Start with a tenant ledger you can trust

An aging report can only be as clear as the ledger behind it. Before escalating an apparent delinquency, confirm that the balance is real and explainable.

Review the tenant ledger for common causes of a misleading balance:

A clear ledger should distinguish base rent from estimated recoveries, one-off invoices, credits, and fees. If every open item is blended into one total, a property manager cannot give the tenant a useful explanation or decide what portion requires follow-up.

For a focused cleanup process, see this tenant ledger checklist before CAM reconciliation. The same discipline—trace each charge, payment, and credit to its reason—also makes ordinary AR work faster.

Use aging buckets to prioritize, not just report

Many teams run aging at month-end and circulate a total. That is useful, but it is too late if the report does not assign work during the month.

A practical cadence is to review the report at a set interval—weekly for active collections, or at least around invoice and payment due dates—and give each exception one of four paths:

| What the report shows | Practical next action | | --- | --- | | A recent unpaid invoice | Confirm delivery, the right tenant contact, and the due date; send a courteous reminder. | | A balance with a payment promise | Record the amount, promised date, contact, and the next follow-up if it is missed. | | A balance with a billing question | Separate the disputed line, gather the lease and source records, and assign an owner to resolve it. | | A repeatedly aged balance | Review the lease remedies, notices already sent, security-deposit treatment, guaranty, and counsel or collection escalation process as appropriate. |

The person reviewing AR should not have to infer who owns the next call. Add a collection owner and next-action date to the report or to the operating record behind it. That simple field turns “we need to follow up” into a task that can be completed or escalated.

Separate collections work from lease and billing questions

Not every past-due balance is a collections problem. Sometimes it is a documentation problem.

For example, a tenant may dispute a rent increase because the escalation notice or calculation is hard to locate. The landlord may be right, but the immediate need is to retrieve the lease clause, amendment, calculation, and prior notice—not to send another generic demand.

Likewise, a tenant can question a CAM or repair charge without disputing base rent. Treating the whole account as a single delinquent total can delay the undisputed payment and make a resolvable question harder to untangle.

Use clear account notes or tags for statuses such as:

These labels do not replace the lease or legal advice. They keep the operational record honest about what is known, what is contested, and who needs to act next.

Watch the gaps between the rent roll, invoices, and cash

An aging report is most useful when it is checked against the records that create and clear receivables.

Start with the rent roll. Compare expected base rent and recurring additional-rent charges to what was actually billed. Then compare billed amounts to payments received and applied. Differences usually point to one of a handful of issues: a missed invoice, a changed lease term, a posting error, a payment application issue, or a real delinquency.

This is especially important when rent changes. A fixed annual bump, CPI adjustment, or amendment can affect both the invoice amount and the tenant’s understanding of what is due. Keep the escalation calculation and notice history easy to find alongside the receivable. Our guide to rent-escalation tracking for NNN leases outlines the records worth keeping before a billing question becomes an AR problem.

For NNN properties, run the same comparison for CAM, tax, and insurance estimates. A tenant’s open balance may reflect a correct charge, an estimate change, a partial payment, or a charge that should be reviewed against the lease before it is pursued.

A simple review meeting that produces action

A short AR review does not need to become a finance committee meeting. The goal is to make sure every material open balance has a current explanation and owner.

For each tenant with an aged amount, ask:

1. What charges make up the balance? 2. Have payments, credits, and unapplied cash been checked? 3. Is any part of the balance disputed or awaiting documentation? 4. What was the most recent tenant contact? 5. What commitment, notice, or next step is documented? 6. Who owns the next action, and when is it due?

Keep the meeting focused on exceptions. A current tenant who pays on time generally needs no discussion. A balance that has crossed a threshold, missed a payment promise, or lacks documentation does.

Avoid turning the report into a collection of unexplained totals

A few habits make AR aging harder to use:

The remedy is not necessarily a larger process. It is a consistent operating record that connects the tenant, lease, charge, payment, supporting documents, and next action.

Commercial AR aging report checklist

Before sending a report to ownership, accounting, or a property manager, confirm that it answers these questions:

Keep AR aging connected to the work behind it

The best AR aging report gives a landlord more than an overdue total. It shows what the balance consists of, what has already happened, and what should happen next.

That clarity protects relationships with good tenants, helps resolve legitimate billing questions sooner, and gives the team a better record when a balance truly needs escalation. It also makes the report more useful at month-end, before CAM true-ups, and when ownership asks why cash has not arrived.

For general U.S. tax-accounting background on cash and accrual methods, see the IRS’s Publication 538: Accounting Periods and Methods. Your lease language, accounting policies, and professional advisers should guide property-specific billing, default, and tax decisions.

PigJet helps commercial landlords keep tenant ledgers, lease context, property records, and follow-up work connected. If AR aging still means sorting through invoices, emails, and spreadsheets, explore a one-property PigJet pilot to test a clearer operating record.