Skip to content

No account required

Start a project

Analyze a rent roll.

Aged arrears, the tenants who are current but always late, and the month your lease expiries stack up.

No account needed to start. You only pay when you like what you see.

  • .xlsx. Excel workbook. Every sheet read, including the ones that are notes rather than data.
  • .xls. Excel 97–2003. Read the same as a modern workbook.
  • .xlsm. Excel, macro-enabled. Values and formulas are read. Macros are never executed.
  • .ods. OpenDocument spreadsheet. LibreOffice and OpenOffice workbooks, read like Excel.
  • .numbers. Apple Numbers. Tables are pulled out of the Numbers package sheet by sheet.
  • .csv. CSV. Delimiter, quoting and encoding detected rather than assumed.
  • .tsv. Tab-separated. Read as delimited text.
  • .pdf. PDF. Checked for a text layer first. A PDF written by software keeps its table structure; a scan is read as an image and told apart from the first kind.
  • .docx. Word document. Tables are lifted out of the document; the prose around them is kept as context.
  • .pptx. PowerPoint deck. Tables and the data behind native charts are read slide by slide.
  • .rtf. Rich text. Tables extracted, formatting discarded.
  • .txt. Plain text. Read as notes, or as data when the contents turn out to be a table.
  • .md. Markdown. Markdown tables become tables; the rest becomes context for the analysis.
  • .zip. Zip archive. Unpacked, and each file inside is treated as though you had uploaded it yourself.

What comes back

rent_roll_jun_2026.xlsx
84 rowsChecked

Two fifths of your monthly rent comes up for renewal in one quarter.

28 of 84 leases end in January, February and March 2027, carrying $85,700 of the $214,800 monthly roll — 39.9% of the income renegotiated in thirteen weeks, because the buildings were let up together and nobody has looked at the calendar in aggregate since. Separately, 19 tenants are shown as current who have not paid on time in a year, and the $93,100 of arrears is not spread across the portfolio: three tenants carry $61,200 of it and all three are past 90 days.

39.9%Rent expiring in one quarter
$93,100Arrears outstanding+21.4%
72.6%Occupancy, paying
Open the full sample project

The renewals are not spread across the year

$85,700 a month lands in Q1 2027

  1. 0128 leases worth $85,700 a month all end in the first quarter of 2027.
  2. 0219 tenants have never paid on time and every one of them shows as current.
  3. 03Three tenants owe $61,200 of the $93,100 outstanding.

01

It separates being behind from paying late

A rent roll shows a balance, which says nothing about the tenant who clears it on the twenty-eighth every single month. Payment timing is reconstructed from the ledger, so habitual lateness shows up before it becomes arrears.

02

It puts the expiries on a calendar

Leases ending are individually unremarkable and collectively a cliff. Expiries are laid out by month with the income attached to each, so a quarter carrying a fifth of the rent is visible while there is still time to do something.

03

It reports occupancy honestly

Occupied by a tenant, occupied by a tenant not paying, and vacant are three states that a single occupancy percentage collapses into one. They are counted separately, and the rent at risk is stated in money rather than in units.

It expects a mess.

Most files that arrive here have several tables on one sheet, a title block above the data, totals stranded in the middle of it, and dates in more than one format. That is the normal case, not the awkward one.

  • Aged arrears, by tenant and by property
  • Payment timing, including the tenants who are always late
  • Lease expiries by month, with income attached
  • Occupancy split by paying, non-paying and vacant
sales_export_FINAL_v3(2).xlsx
A messy sales export, and the repairs Data Analysis App applies to it.
OrderDateCustomerAmt
1024107/02/26John Smith$84.00
102422 July 2026SARAH LOPEZ$41.00
102422 July 2026SARAH LOPEZ$41.00
1024345840s. lopez41
Not suppliedNot suppliedSUBTOTAL$166.00
102442026-07-03Amara Osei$127.50
  • Date format
  • Duplicate row
  • Serial date · text number
  • Total inside the data
A rent roll, payment ledger and lease calendar separating arrears, habitual lateness and vacancy.

Questions it works through

  • Who is actually behind, and by how long?
  • Which tenants pay late every month without ever going into arrears?
  • When do my leases expire, and how much income is in that month?
  • What is my occupancy once non-paying tenants are counted properly?

Questions people ask

Can it read a rent roll that is a PDF from the agent?

That is fine. Tables are lifted out of it and checked against the totals printed on the same page, and anything that could not be read confidently is listed rather than guessed.

Several properties in one file?

Expected, and better than one file each. Every property is analysed on its own and against the others, because a portfolio average is usually hiding the one building with the problem. The comparison is the point — a single figure across all of them answers nothing.

Does it handle service charges and deposits?

They are kept apart from rent rather than summed into one balance. A deposit held is not income and an unpaid service charge is not rent arrears, and treating them alike is how a rent roll misleads.

Upload rent roll

No account needed to start. You only pay when you like what you see.