Track unpaid rent across a portfolio with an A/R aging report: one list of every unpaid rent charge and invoice, each placed in a bucket by how many days old it is, run as of today and read on the same day every week. The rent roll shows what is due; the aging report shows how long it has been owed. Oldest first, every week, each balance gets its decision before it gets older.
It is the 12th, 9:15 AM. The rent roll shows fourteen open charges across four buildings. Unit 6 on Alder is 42 days behind and has stopped answering email. Unit 22 paid half on the 3rd and nothing since. At 8:50 the owner of the Birchview building asked who is behind and by how much, and the answer is in three places: the rent roll, the inbox, and whoever spoke to the resident last. Nobody has decided anything about Unit 6. It is 42 days old because no single one of those days felt like the day.
This is a spoke of Property Management Reports: What Owners Actually Expect, which covers the package an owner receives and the suite behind it. This one covers the A/R aging report: what it lists, how it differs from the rent roll, what each bucket usually holds, the weekly procedure, and how Scaalr runs it.
What an A/R aging report is
An accounts receivable aging report (the A/R aging report, or aged receivables) is a list of every amount owed to you that has not been paid, with each item placed in a bucket by how many days old it is, as of one date. Each line is one item, a rent charge, an invoice, or a receivable entered by hand, with its date, its due date, the original amount, the payments received, the balance still owed, and the days outstanding that place it in a bucket. Above the lines, a summary totals each bucket and the whole.
The report is a photograph of one date. Run it as of today and it shows what is owed today; run it as of the last day of a closed month and it shows what was owed when the month closed, the version an owner or an accountant asks for. It reads the ledger, not the lease: an item appears once its charge or invoice is posted, its balance falls as payments are recorded, and a fully paid item leaves. Most of the list is unpaid rent (rent arrears, in some markets); the rest is everything else you bill, a utility recharge, a damage invoice, a repair billed to an owner. Only the aging report says what a resident, or an owner, owes you in total and how long each piece has been owed.
The rent roll and the aging report answer different questions
The rent roll is the scheduled view. It lists every tenancy's charges for the cycle and where each stands: scheduled, paid, partially paid, overdue. It answers "what is due, and from whom" for this month. Property management software often calls the rent-only list of who is behind a delinquency report, and that list is usually built from the roll.
The A/R aging report is the posted view. It lists every unpaid amount the books carry, whatever it was for, by age, and answers "how long has this been owed, and how much of what we are owed is old." A resident overdue this month and clear last month is a rent roll problem; a resident carrying a balance from March is an aging report problem, and the roll will not tell you which is which. The two totals rarely match, and the difference is information: the roll counts scheduled rent past its due date, while the aging counts posted balances as of the date, including this month's rent that is not late yet and invoices for things other than rent.
What each aging bucket usually means
The table below reads the default buckets (30, 60, and 90 days) the way most residential portfolios experience them: what tends to sit in each, and the decision it needs.
| Bucket | What is usually in it | The decision it needs |
|---|---|---|
| Current (0–30 days) | This month's rent not yet paid, invoices inside their terms, a payment in transit or recorded a few days late | None beyond the reminder cadence. Confirm the reminder went out and the resident knows how to pay. |
| 31–60 days | Last month's rent, a partial payment with a silent balance, a charge the resident disputes | A conversation and a written plan with dates, or the first formal step your lease and your market's rules allow. Confirm the balance is real first. |
| 61–90 days | Two months owed, usually one tenancy, usually already known to everyone | The formal step that has been deferred, or a dated payment plan. The owner hears about it from you before the statement shows it. |
| Over 90 days | Former residents, disputes that went quiet, amounts nobody is currently chasing | Keep pursuing with a named next step, hand it to a collector, or write it off with a reason. Nothing stays here without a decision on record. |
Two things keep the buckets honest. The age counts from the item's own date, a charge from the day it was raised and an invoice from its invoice date, so a 30-day invoice that is 20 days old is current, and the due date beside the age is the column to read before chasing anyone. And a balance reaches the Over 90 bucket only by passing through the other three, one week at a time, in front of whoever was reading the report. A large Over 90 total is not a collections problem that appeared; it is a series of weekly reads that ended without a decision.
The last bucket carries a tax question the write-off decision does not settle, and the answer depends on your accounting method and your country. The IRS's Publication 527 says a cash-basis landlord does not deduct uncollected rent, because it was never counted as income, while a landlord on the accrual method may be able to deduct it as a business bad debt. The CRA's T4036 rental income guide allows the deduction only when the amount was included in income, became uncollectible during the year, and was still owing at year end, with proof of the attempts to collect. Ask your accountant which applies to you; what the report contributes is the date, the balance, and the record of what was tried.
How to work the A/R aging report every week, step by step
Once the bookkeeping is current, the weekly read of fourteen open charges takes about twenty minutes, and it is the same twenty minutes every week.
- Run it as of today, on the same weekday every week. The same day makes the totals comparable; the as-of date makes them true.
- Read the bucket totals against last week's. What moved from 31–60 into 61–90 is the news.
- Start at the oldest line and work down. The newest line can wait a week; the oldest cannot.
- Check that each line is real before you chase it. A payment recorded against the wrong charge, a charge raised twice, a credit never applied: each ages like a debt and is fixed in the books, not by a phone call.
- Classify what remains. Paying in part with a plan, disputed, silent, or gone (a former resident). The class decides the next step.
- Decide the next step per line, and date it. A reminder, a call, the notice your lease and market allow, a written plan, a handoff. The date goes on the case or the charge, so next week's read starts from it.
- Tell the owner before the statement does. Any building with a line past 60 days gets a sentence in that owner's note this month, with the step taken.
- Close the loop next week. A line with a dated next step either moved or gets escalated; it does not get re-read and re-deferred.
Step 4 saves the most embarrassment, and step 6 is what empties the Over 90 bucket over time. A line with no dated next step is a balance aging by default.
How Scaalr runs the A/R aging report
In Scaalr the A/R aging report is the Accounts Receivable report in the Reports area. It reads the posted entries on your accounts receivable control accounts, one per currency, as of the date you choose, and lists every item still carrying a balance: a rent charge, an invoice, or a receivable entered by hand. Each line shows the item and its date, the due date, the days outstanding, the bucket, the original amount, the payments received, and what is still owed, sorted oldest first, and each line opens the item it came from: the rent charge with the residents on it and its payment history, the invoice, or the journal entry. An aging summary above the lines totals each bucket and the whole, one section per currency.
The buckets are yours to set. The default is 30, 60, and 90 days, which reads as Current (0–30 days), 31–60, 61–90, and Over 90, and the boundaries are a comma-separated setting in Accounting Configuration, beside the control accounts, so a portfolio that works in two-week steps can age in two-week steps.
The age counts from the item's own date. A rent charge is raised on its due day by the nightly generator and posts to receivables the same day, so its age is days since it was due; an invoice ages from its invoice date, with the due date shown beside it. Recording a payment posts the credit, and the line shrinks or leaves; a partial payment leaves the balance on the same line with its original date, so a half-paid March charge still reads as March. The report downloads as a branded PDF and prints. On accounts that encrypt their ledger, the totals lock until the secret is entered and the export waits, so a locked amount never shows as a smaller total.
The signed-in home screen carries two views of the same money. A Rent overdue tile counts scheduled rent charges past their due date, with the amount per currency, and opens the rent roll filtered to Overdue. A Receivables aging panel below it shows the posted picture: the total outstanding per currency, each bucket's total, and the amount past the second boundary (60 days by default) marked at risk, with a link to the full report. The two can disagree, and the tile says why: it counts scheduled rent, and the panel shows what is posted to the ledger. A subledger reconciliation report shows whether the receivables control account and the items behind it agree.
Chasing runs beside the report, not inside it. A nightly sweep flags charges more than three days past due and emails every resident on the charge a branded overdue notice, with a re-notification throttle and a per-lease opt-out, as described in Automated Rent Collection: From Charge to Cleared Payment. The report sends nothing; it shows what the reminders have not resolved, which is where the decisions are. The report, the rent roll, and the dashboard are on every plan, including Starter; invoices, which put non-rent receivables on the same report, are Growth and up.
Back to the 12th, 9:15 AM. The owner's question gets a reply from the report run as of this morning: Birchview has one balance, Unit 22, in the 31–60 bucket, half paid on the 3rd, written plan requested today. Unit 6 on Alder is the oldest line in the portfolio, 42 days, silent, and its decision is made and dated before the coffee is cold. Next Tuesday's read starts from that date.
Key questions
What do the 30, 60, and 90 day buckets on an aging report mean?
They are the age ranges an unpaid amount is sorted into, counted in days from the item's date as of the report date: Current is 0 to 30 days, then 31 to 60, 61 to 90, and over 90. Current holds this month's rent that is not late yet, so it is the least interesting total; the buckets to its right are the ones to read, and the question each week is whether their share grew.
How often should I run an A/R aging report?
Weekly, as of that day, on the same weekday, plus one run as of the last day of each closed month for the owner package and the accountant. Weekly is the shortest interval at which last week's decision has had time to show up as a payment, a plan, or silence; monthly reads let a balance cross a whole bucket between looks.
What is the difference between the rent roll and the A/R aging report?
The rent roll is the scheduled view: every tenancy's charges for the cycle and their status, which answers what is due this month and from whom. The A/R aging report is the posted view: every unpaid amount in the books, rent or otherwise, by how long it has been owed. Their totals differ by design, since the aging includes current items and non-rent invoices and the roll counts only scheduled rent past due.
What is a normal rent delinquency rate?
There is no published benchmark for a small residential portfolio, and the percentages that circulate in operator forums come without a source. For context, the Consumer Financial Protection Bureau's January 2025 report on rental payment data found that 14 percent of renters had incurred a late fee in the previous twelve months as of November 2024, down from 23 percent in early 2023. The useful measure is your own: rent collected against rent due this cycle, and the share of your aging total past 60 days, tracked week to week.
When should I tell an owner about unpaid rent?
Before the statement shows it, and in your words. Any balance on the owner's property that passes 60 days gets a sentence in that month's note: the unit, the amount, the age, and the step you have taken, with the date. An owner who learns about a two-month balance from a thin income line has learned two things, and the second one is about you.
Which Scaalr plan includes the A/R aging report?
All of them, including Starter. The Accounts Receivable report, the configurable buckets, the rent roll, and the dashboard tiles are part of every plan; Starter is free for the first 5 units, then $0.99 a unit a month, and Growth is $99 a month for the first 50 units, then $1.49 per additional unit. Invoices, which put non-rent receivables on the same report, and ledger encryption are Growth and up.