Commercial Tenant AR Aging Report: A Landlord's Monthly Review Checklist

An aging report can tell you that a tenant balance is old. It cannot, by itself, tell you why it is still open or what the right next step is.

A balance in the 31–60 day column may be an unpaid rent invoice, but it may also be unapplied cash, a charge posted to the wrong tenant, a credit waiting to be applied, a disputed CAM item, or a bill that never should have been sent. If every aging item is treated as a collection problem, the team can send the wrong follow-up and leave the underlying record harder to explain next month.

The better monthly habit is to use the commercial tenant AR aging report as a review queue. Confirm what the balance represents, separate cleanup from collection activity, give each exception an owner, and leave a record of the decision.

> This checklist is an operating workflow, not legal, tax, or accounting advice. Lease terms, notice requirements, remedies, accounting treatment, and collection decisions vary by agreement, facts, and applicable law. Use the executed lease and qualified advisors for those decisions.

Start With a Reliable Snapshot

Pick a regular day each month to review receivables, such as shortly after payments and deposits through the prior period have been posted. Save or export the report with its as-of date, then avoid silently changing the review basis halfway through the meeting.

Before working the older columns, confirm that the report is usable:

• The report shows the correct as-of date and includes every active tenant or customer record that should be reviewed.
• Open invoices, credits, unapplied receipts, write-offs, and payment reversals are posting to the expected tenant record.
• The total ties reasonably to the tenant-ledger view and is not distorted by duplicate records, archived tenants, or a report filter.
• The aging basis is understood: invoice date, due date, or another configured method can move the same balance into a different bucket.
• The report separates or lets you identify base rent, additional rent, late fees, CAM or tax charges, and other items rather than presenting one unexplained total.

Do not use the aging buckets as a substitute for the lease. They are a way to prioritize review, not proof that a tenant is in default or that a charge is collectible.

Review the Oldest and Largest Items First

Start with the items most likely to need attention: the oldest open balances, material dollar amounts, recurring partial payments, and tenants whose balances increased since the prior review. Then scan the current bucket for unusual charges that could become next month's problem.

A simple priority view can keep the meeting focused:

| Priority | What to look for | First question | | --- | --- | --- | | High | Large or aging balances, returned payments, repeated broken promises, or balances tied to a time-sensitive lease event | Is the balance valid, and does the record show the next approved action? | | Medium | Partial payments, open credits, disputed charges, and balances that changed unexpectedly | Is this a collection item or a posting and billing question? | | Routine | Small current balances and items with a documented next step | Has the owner completed the last agreed action? |

The goal is not to chase every line in the same way. It is to decide which items need fact-finding, which need a correction, and which are ready for an appropriate collection follow-up.

Classify Every Open Balance Before Contacting the Tenant

For each meaningful item, use a short classification. A shared set of labels prevents the team from calling every older item “delinquent” when the ledger tells a different story.

| Classification | What it may mean | Operating response | | --- | --- | --- | | Payment application issue | Cash was received but is unapplied, applied to the wrong invoice, or posted to the wrong tenant | Verify the payment reference and posting record; correct or escalate the accounting item. | | Billing or setup issue | The amount may reflect a missed amendment, duplicate charge, incorrect rate, or missing credit | Compare the charge to the lease record and billing support before tenant outreach. | | Tenant question or dispute | The tenant has asked for support or disagrees with a charge | Log the stated issue, preserve the correspondence, identify the supporting documents, and assign a response owner. | | Valid open receivable | The charge appears properly billed and no unresolved posting or billing issue is evident | Follow the lease-aware collection workflow and record the contact attempt. | | Advisor review | The item involves a lease interpretation, notice, remedy, tax, accounting, or write-off question | Preserve the facts and route the question to the appropriate qualified advisor. |

This step should be quick, but it should not be skipped. A clean classification protects the tenant relationship and gives the property team a much better audit trail.

Validate the Charge Against the Operating Record

When a balance is unclear, work from the source records rather than a total on the aging report. Pull the invoice, the applicable ledger entries, payment details, and the relevant lease summary or source document.

Check these basics:

• What charge created the balance, and what billing period does it cover?
• Is the tenant legal name and suite or premises correct?
• Was the invoice sent, and is there a delivery or communication record where available?
• Did a payment, credit memo, concession, or adjustment affect the same period?
• Does the amount reflect a lease change, escalation, amendment, occupancy change, or approved adjustment that has been documented?
• Has the tenant already raised a question or provided remittance information that changes how the payment should be applied?

If the question is whether a charge was omitted rather than whether an existing charge was paid, keep that work separate. Use a missed-charge review to identify the source, support, and tenant communication needed before adding a new receivable. PigJet's commercial tenant billing missed lease charges guide covers that recovery workflow.

Turn the Aging Report Into a Named Follow-Up Queue

An aging report becomes useful when every exception has a visible next step. Keep a companion note, task list, or system record with enough detail that another team member can understand the status without reopening every email.

For each item requiring follow-up, capture:

• Tenant, property, suite, invoice or charge reference, and amount
• Aging bucket and report as-of date
• Classification: payment application, billing/setup, dispute, valid receivable, or advisor review
• The factual reason for the status and links or references to the supporting records
• The assigned owner and next action
• Target date and last contact or review date
• Outcome when resolved, including any payment reference, adjustment, or escalation record

Keep the note factual. “Tenant says CAM estimate is wrong; invoice and lease summary sent for internal review” is more helpful than “tenant refusing to pay.” It documents the work without making a legal conclusion or obscuring what still needs to happen.

Use a Different Path for Cleanup and Collection

The most efficient AR reviews split the work early.

When the Item Needs Cleanup

Cleanup items may include unapplied cash, duplicate invoices, credits without a clear purpose, misapplied payments, or charges that do not match the current billing setup. Give these an accounting or operations owner, a correction target date, and a note explaining the change.

Do not leave the aging report to tell the story after the correction. Update the underlying ledger appropriately, retain the support, and record why the item was changed. Before annual CAM work, a similar discipline is essential; use the tenant ledger cleanup checklist to keep estimates, credits, and one-off charges explainable.

When the Item Is Ready for Collection Follow-Up

Once the team has confirmed a valid open receivable, use a consistent, lease-aware follow-up process. The message should identify the amount, billing period, and practical route for questions or payment. Keep a record of the contact and any remittance or promise-to-pay information received.

Do not improvise formal notices, cure periods, late fees, interest, remedies, or payment arrangements from the aging report alone. Confirm the governing lease terms and use qualified counsel or other advisors where appropriate. For the broader recurring process, see PigJet's commercial rent collection checklist.

Watch for Patterns, Not Just Individual Balances

The monthly review also shows where the process is breaking before the next month closes.

Look for patterns such as:

• Several tenants asking the same question about a recurring charge
• Payments consistently arriving without invoice references
• A specific property or billing type generating repeated unapplied cash
• Credits entered without an explanation or connection to an original charge
• Repeated balances immediately after rent escalations, CAM estimate changes, or amendments
• The same tenant appearing in the aging report because promises, disputes, or internal responses are not being tracked to completion

A pattern does not prove the cause, but it gives the team a practical place to investigate. The right fix may be a better invoice description, a clearer remittance process, a billing-control check, or a more current lease setup record.

Close the Review With a Short Control Check

Before ending the monthly AR review, make sure the team can answer four questions for every material aged balance:

1. What is the balance made of? 2. Is it a valid receivable, a cleanup item, a tenant question, or an advisor-review item? 3. Who owns the next action, and by when? 4. Where is the supporting record and the last decision documented?

That is the difference between an aging report that merely lists old numbers and one that helps a commercial landlord run a controlled receivables process.

If your team is tracking tenant balances, lease changes, billing questions, and follow-up notes across disconnected spreadsheets and inboxes, see how PigJet helps keep the operating record together.