Skip to main content

Aging and delinquency reports

Three reports answer "who owes us, and for how long?" Delinquent Accounts lists every unit that was past due on a date, with its balance.

M
Written by Michael Bollinger

Three reports answer "who owes us, and for how long?" Delinquent Accounts lists every unit that was past due on a date, with its balance. Delinquent Accounts Detail lists the past-due invoices behind each of those units. Aging of Accounts spreads every unit's unpaid balance into columns by how far past due it is. The two delinquency reports can hide owner names for a board packet or a newsletter.

Before you start: you need Reports access. Picking the date, exporting, scheduling and adding a report to a packet work the same as on every report. See Run, filter, export and favorite a report.

All three are in the Who Owes You section of Reports, and all three run as soon as you open them, as of today.

Report

Filters

What it shows

Use it when

Delinquent Accounts

As of date, Anonymous mode

One row per past-due unit: its whole balance and the past-due part

You need the delinquency list for the board or for collections.

Delinquent Accounts Detail

As of date, Anonymous mode

Each past-due invoice, grouped by unit, with days past due

You need to see which invoices a delinquent owner hasn't paid.

Aging of Accounts

As of date

Every unit that owes anything, split into Currently Due, 1-30 Days Past, 31-60 Days Past, 61-90 Days Past and 90+ Days Past

You want an accounts-receivable aging for an audit or a year-end review.

Who counts as delinquent

A unit is delinquent on a date if it has at least one invoice whose due date was before that date and that still had money owing at the end of that day.

  • There's no grace period and no dollar threshold. An owner one day past the due date is listed, even for $0.50. An invoice due on the as-of date itself isn't past due yet.

  • The due date decides, not your late-fee rule. If your documents give owners until the 15th but invoices are due on the 1st, owners show up from the 2nd. To match your policy, set the invoice due date to the last day before it's late. See Add late fees.

  • Late fees count once they've been added, and an early-payment discount counts while it's still available.

  • Payments count if they were recorded by the end of the as-of date and haven't failed or been returned. Pending bank payments count.

  • Deleted units are left out of the two delinquency reports. Aging of Accounts still lists them.

Reports for a past date

Pick any earlier As of date to see the position on that day. The reports go by each invoice's active date and the date each payment was recorded, not by when someone typed it in. So if an invoice is back-dated into a past month, a report for that month changes when you run it again. That's expected. A PDF you already sent doesn't change.

On the current accounting system, an invoice that was later forgiven still counts as owed on dates before it was forgiven.

Delinquent Accounts

  1. On Reports, click Delinquent Accounts. It runs as of today.

  2. To see another day, change the As of date (Shows all units with outstanding balances as of the selected date.). Today jumps back to today. Future dates can't be picked.

  3. To hide names and addresses, turn on Anonymous mode (Replaces unit names and owner details with unit IDs for privacy.).

  4. Click Show results.

The results card is headed Delinquent accounts with the date under it.

Column

What it is

Unit

The unit. Click it to open the unit page.

Address

The unit's address

Owners

The current owners

Unit Balance

Everything the unit owed on invoices at the end of that day, past due or not. Unused account credit isn't taken off: credit only lowers this figure once it has paid an invoice. A unit that has credit and no past-due invoice isn't listed at all.

Past Due

The part of that balance whose due date had passed

The table has a Search… box, a Columns picker to show or hide columns, sorting on every column, and 25 rows per page. The footer holds the totals. If no unit was past due, you'll see No delinquent accounts and No unit had a past-due balance on this date. Try another date.

With Anonymous mode on, the columns are Unit ID, Unit Balance and Past Due. Unit names, addresses and owners are left out of the screen, the PDF and the CSV.

Delinquent Accounts Detail

  1. On Reports, click Delinquent Accounts Detail.

  2. Set the As of date and, if you need it, Anonymous mode.

  3. Click Show results.

Each unit is a heading with its owners, followed by its past-due invoices, latest due date first, and a Total for line. Total Invoices at the bottom is the grand total.

Column

What it is

Title

The invoice title

Active Date

The invoice date

Due Date

When it was due

Days Past

Days between the due date and the as-of date

Category

The invoice's income category

Charge

The invoice amount

Balance

What was still owed on it at the end of the as-of date

The CSV adds Unit, Address and Owners to every row so you can sort and filter in a spreadsheet. With Anonymous mode on, those are blank and each heading shows the unit ID. If nothing is past due, you'll see No results found and No delinquent account details were found. Try again later or adjust filters.

Only past-due invoices are listed. To see everything a unit owes, including invoices not yet due, use Unit Balance Detail or the unit's Account history PDF. See Unit balance and invoice reports.

Aging of Accounts

  1. On Reports, click Aging of Accounts. It runs as of today.

  2. Change the As of date if you need another day, and click Show results.

Column

What it is

Unit

The unit. A unit that has since been deleted but still owed money shows (deleted) after its name.

Total Due

Everything unpaid at the end of the as-of date

Currently Due

Invoices not yet past due, including any due on the as-of date

1-30 Days Past

Due 1 to 30 days before the as-of date

31-60 Days Past

Due 31 to 60 days before

61-90 Days Past

Due 61 to 90 days before

90+ Days Past

Due 91 days or more before

Totals is the last row. In the CSV, Unit is replaced by two columns, Unit Title and Unit Address.

Aging uses the same rules as the delinquency reports, so a unit's past-due columns add up to its Past Due on Delinquent Accounts for the same date. Unlike the delinquency reports, it also lists units that owe money that isn't past due yet, and units that have since been deleted. It has no Anonymous mode.

Anonymous reports for owners and board packets

To share delinquency figures without names:

  • On screen, turn on Anonymous mode before you click Show results, then Save as PDF or Export CSV.

  • In a report packet, set Make anonymous? to Yes on Delinquent Accounts or Delinquent Accounts Detail. See Report packets.

Why aging doesn't match Accounts Receivable on the balance sheet

They measure different things. The aging and delinquency reports add up the unpaid invoices on each unit on a date. Accounts Receivable on the Balance Sheet is a ledger account, built from the entries your accounting basis posts. On cash basis the balance sheet hides Accounts Receivable, so there's nothing to compare. On accrual basis they're close, but account credits, prepayments, late fees and discounts that haven't been applied yet, and adjustments posted straight to the ledger can make them differ. See Balance sheet and trial balance and Reports: common questions.

Troubleshooting

Problem

What to do

An owner shows as delinquent during our grace period

The report goes by the invoice due date. Change the due date on future invoices, or explain the grace period to the board. See "Who counts as delinquent".

An owner who paid still shows

The payment was recorded after the as-of date, failed, or was returned. Check the unit's Account history.

A unit that prepaid or has a credit is listed as delinquent, often for a small amount

The report lists a unit only when one of its invoices was past due with money still owing on the as-of date; a credit sitting on the unit doesn't come off until it pays an invoice. Run Delinquent Accounts Detail for the same date to see which invoice it is, then open the unit's Account history. Usual causes: the credit is smaller than the invoice, so a small amount is left; the invoice (often a late fee) was added after the credit was used up; or the credit or payment was recorded after the As of date you picked. Credit pays a unit's active, unpaid invoices by itself, straight away and again every hour, so you don't apply it by hand. If the unit's invoices all show as paid on the as-of date and the unit is still listed, or it has unused credit and an active unpaid invoice an hour later, contact PayHOA support with the unit, the As of date, the amount shown and a screenshot of the report and of the unit's account history. See Account credit.

Last month's report gives a different total now

An invoice or payment dated in that month was added, back-dated, deleted or returned since.

A deleted unit is on Aging of Accounts

It still had unpaid invoices on that date. Deal with the balance on the unit, or forgive it. See Delete, forgive, reinstate or archive an invoice.

The aging report (Aging of Accounts) or a delinquency report won't generate: it spins, then shows Unable to load report data. or goes back to Ready to generate

The report couldn't be generated. The message shows for a few seconds only; if you missed it, you just see Ready to generate (Configure your parameters above and generate the report to see results here) again. It has nothing to do with updating the general ledger. Check the As of date is filled in, click Show results again, then reload the page and try once more. If it fails again, contact PayHOA support with the report's name, the As of date, the time you tried and a screenshot; PayHOA has to look at why. Meanwhile Unit Balance Summary also shows what each unit owes.

The aging report doesn't match Accounts Receivable on the balance sheet

They're built differently. See Why aging doesn't match Accounts Receivable on the balance sheet above.

For other messages, see the troubleshooting table in Run, filter, export and favorite a report.

What's next

Did this answer your question?