An AP aging report shows how long unpaid bills have been outstanding: current, 30 days, 60, 90 and beyond. In a business that owns all its properties, it is primarily a view of the business's outstanding supplier obligations and how long they have been unpaid.

In property management, the same report leaves out a more complicated picture. A bill can sit at 60 days because the owner's balance cannot cover it, because the owner has not approved it, because the vendor has not supplied the paperwork, or because the work is in dispute. None of those is about the management company's own cash, and each needs a different person to act.

An aging report that shows only how old a bill is cannot tell you which. This covers what to add so it can.

The Standard Report

The familiar layout groups unpaid invoices by vendor across five columns: current, 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days.

Useful, and incomplete for this purpose in two ways.

It shows age but not cause. A 60-day bill could be a process failure or a correct decision to hold payment, and the report treats them identically.

It shows vendors but not owners. For owner-funded property expenses, each payable should be associated with the property and owner responsible for the cost, with the applicable funds used to settle it. The vendor view tells you about relationships. The owner view tells you about obligations. The management company's own payables sit separately and belong in their own view.

Add a Reason to Every Item Past Terms

The single most useful change is a reason code on any bill that is past its payment terms. A short, fixed list, chosen by whoever is holding the bill.

Two rules keep this useful.

• No reason means no documented explanation. A bill past terms with no reason recorded is the one to look at first, because nobody has documented why payment is being held.

• Reasons have owners. Each code points to who has to move next. An aging report grouped by reason becomes a list of whose turn it is.

The categories map onto controls elsewhere. Owner approval holds come from the approval matrix. Documentation holds often trace to missing W-9s and incomplete vendor records. Funding holds lead to the owner's ledger.

The View by Owner

The vendor view is standard. The owner view is the one specific to property management, and it is worth producing monthly.

Group every unpaid owner-funded bill by the property and owner it will be charged to. Two things become visible that the vendor view hides.

• Owners with accumulating obligations. An owner with $4,000 of approved bills waiting on funds is an owner whose available balance may be insufficient once those obligations are taken into account. That is a conversation to have before the vendor starts chasing, and the handling of negative owner balances is worth reviewing if the bills would take the balance below zero.

• Funds that are not really available. Where an owner's balance shows $2,500 but $1,800 of approved bills are outstanding against their property, the balance is not all free to distribute. Before an owner distribution is calculated, outstanding approved payables and other applicable obligations should be considered, so the amount considered available for distribution does not overlook bills that still need to be paid.

When the owner view shows a real funding gap, the owner communication templates cover how to ask for funds with the figure, the reason and a date.

What to Watch

Signals in the aging report worth acting on.

• The same owner, month after month. Repeated funding holds for one property can mean the reserve is too small for its cost pattern, or the owner's circumstances have changed. Either way it is a conversation rather than a series of reminders.

• The same vendor sliding. A vendor whose invoices consistently move into the later buckets warrants review. The reason may be owner funding, internal processing, disputes or another issue, and the pattern can affect the vendor relationship if payment delays continue.

• Concentration in internal approval. Bills aging while they wait for someone inside your own business to approve them is a process bottleneck, not an owner problem. That is the category you control completely.

• Disputes with no activity. A disputed bill that has not moved in 30 days needs review. The dispute may be legitimate, but there should be a documented next step.

• Anything over 90 days without a reason. These items deserve immediate review because the reason for the delay is still undocumented.

Late Charges

A vendor who charges a late fee raises a question the aging report should help answer: who bears it?

That depends on the management agreement and on why the payment was late. A charge caused by an owner not funding an approved bill is a different situation from one caused by an invoice sitting in your own approval queue. Whether a late charge can be passed to an owner is a question the agreement should settle, and where it does not, the reason code on the aged bill is the evidence for how it arose.

Reconciling Vendor Statements

The other half of AP housekeeping, and one the aging report cannot do on its own.

Many vendors send a statement of account showing what they believe you owe. Comparing it to your own AP records catches problems that neither record reveals alone.

• Invoices on their statement that you do not have. The most important category. Either the invoice was never received, arrived through a channel nobody monitors, or was posted to the wrong property or vendor record. It may also be a liability you have not recorded at all.

• Invoices you have that they do not show. Possibly paid and applied by the vendor, possibly a duplicate on your side, possibly entered against the wrong vendor.

• Payments you made that they have not applied. Often with vendors who receive payments without clear references. The fix is a remittance advice that identifies the invoices each payment covers.

• Credits. Credit notes issued by the vendor that were never applied on your side, or applied twice.

Reconciling every vendor every month is rarely proportionate. A workable approach is monthly for your largest and most active vendors, on request for disputes, and across the vendor list before year end, when unrecorded liabilities and misapplied payments matter most. The year-end calendar is where the full sweep belongs.

Frequently Asked Questions

1. What is an AP aging report in property management?
A report showing unpaid vendor bills grouped by how long they have been outstanding, typically in 30-day buckets. In property management it is most useful when it also shows why each overdue bill is unpaid and, for owner-funded expenses, which owner's property it will be charged to, because a bill can age for reasons that have nothing to do with the manager's own cash.

2. Why do payables age in property management?
Common reasons include the owner's balance being insufficient to cover an approved bill, owner approval being pending for spend above their limit, internal approval delays, disputes with the vendor over amount or quality, missing documentation, and work not yet verified as complete.

3. Should aged payables affect owner distributions?
They should be taken into account. An owner's balance that appears available may already be needed for approved bills and other obligations that have not yet been paid. Before a distribution is made, those outstanding obligations should be considered under the applicable accounting procedures and management agreement.

4. Who pays a vendor's late fee?
It depends on the management agreement and on why the payment was late. A late charge caused by an owner not funding an approved bill is different from one caused by the manager's own process delay. Recording a reason on every overdue bill provides the evidence for how the lateness arose.

5. What is vendor statement reconciliation?
Comparing a vendor's statement of account with your own AP records to find invoices one side has and the other does not, payments not applied, and credits not recorded. It can surface unrecorded liabilities, duplicate invoices and misapplied payments that an aging report alone will not show.

6. How often should vendor statements be reconciled?
A proportionate approach is monthly for the largest and most active vendors, on demand when there is a dispute, and across the full vendor list before year end.

Age Is the Symptom

A number in the 60-day column says a bill is late. It does not say whose move it is, and in property management that could be the owner, the vendor, an approver inside your business, or nobody at all.

Add the reason, add the owner view, and the aging report stops being a record of lateness and becomes a list of decisions that someone needs to make.

RIOO is a property management platform built on NetSuite, with vendor management and accounts payable and property accounting in the same underlying system.

Note: Guidance in this article is general. The treatment of owner funds, spending authority, late charges and payment obligations is governed by each management agreement and by applicable law. Figures shown are illustrative.