1. Your rent ledger
Needs a Due Date, a Unit (or Tenant), an Amount Due (or Rent) and an Amount Paid, one row per monthly charge. A Date Paid column is used when present and is needed for late-payment figures. Comma, tab and semicolon files, quoted fields, US and day-first dates and UTF-16 exports are read. Rows that cannot be read are listed with a line number and reason.
Choose a file or paste the text, then click Analyze.
Result
Unpaid rent by age
| Past due | Charges | Unpaid |
|---|
By unit
| Unit | Charges | Billed | Unpaid | Oldest, days | Late charges | Avg days late | Part-paid |
|---|
By month due
| Month | Charges | Billed | Collected | Unpaid | Collected % | On time % |
|---|
The model, and what it leaves out
- Owed is the amount due minus the amount paid on each charge that fell due on or before the as-of day. A payment dated after that day is treated as not yet made.
- Age is the days from a charge's due date to the as-of day. A charge is late when it was paid in full, or is still unpaid, more than the grace period after its due date.
- Collected is the money received against charges, capped at each charge's amount; on time is the share of charges paid in full within the grace period.
- Reconciles. The age rows plus the not-yet-late amount, the unit rows and the month rows each add up to the total unpaid at the top.
- Habitually late needs at least three late charges and half of a unit's charges; a unit with fewer is shown but never listed as habitual.
- The late fee figure is an upper bound. It multiplies the fee you type by the late charges; your lease must allow it and local law may cap, delay or forbid it. The 5-day grace default is a placeholder, not a measurement.
- Not modelled: security deposits, utilities and other non-rent charges unless they are rows in your file, fees already billed, notice periods, part-payment rules, interest, vacancy, and anything not in the file.
Common questions
Who owes me rent, and how old is it?
Export or copy your rent ledger into one table with a due date, a unit or tenant, the amount charged and the amount paid, and drop it here. Every charge that fell due on or before the date you choose is checked against what was paid. What is still owed is grouped by how long it has been past due (1–30, 31–60, 61–90 and over 90 days) and listed by unit. Nothing is uploaded; the file is read in your browser.
Which tenants pay late most often?
If the file has a date paid, each paid charge is compared with its due date. A unit is listed as habitually late when at least three of its charges, and at least half, were paid more than your grace period after the due date. The grace period is a number you type; the default of 5 days is a placeholder, so use what your lease says.
How much in late fees could I have charged?
If you type a flat late fee, the tool multiplies it by the number of charges paid after the grace period or still unpaid past it. That is an upper bound, not an entitlement: your lease has to provide the fee and local law has to allow it, and many places cap late fees or require a longer grace period. A fee you already billed is not in the file and is not netted off.
What is the collection rate?
It is the rent collected divided by the rent charged for charges due on or before the date you chose, shown overall and per month. The on-time rate is the share of charges paid in full within the grace period. Overpayments are shown separately and are not used to cover other charges.
Which columns does the file need?
A due date, a unit or tenant, an amount due and an amount paid; a date paid is used when present and is needed for late-payment figures. One row per monthly charge works best. Column names are matched by alias; if a row cannot be read the page lists it with its line number and reason.
Is this legal or accounting advice?
No. It applies arithmetic to the file you supply and the numbers you type. Notices, late fees, part-payments and collection steps are governed by your lease and by local law, which vary widely and are not modelled. It is independent of every property-management product and not affiliated with any of them.