← Builds · Worked example

“Why is my cheque smaller this month?”

Owner statements get hand-assembled off the rent roll every month, and then the call comes. This builds each owner’s statement automatically — rent collected, expenses, your management fee, net payout — and flags the owners whose payout dropped, with the unit-level reason attached. This page is a worked example of that build, with the sample workbook to download.

For: property managers who issue monthly owner statements
Needs: a rent roll: unit, owner, rent due, rent collected, expenses
This page: a read, plus a free .xlsx to open in Excel or Google Sheets
The paid build: $650 one-time, on your units, owners and management-fee %

Every number below is invented. This is a sample workbook built to show the shape of the output — the businesses named in it do not exist, and neither do the amounts. Nothing here is a client, a result, or a case study. The owners, buildings and street addresses were rewritten to fictional ones before this page was published, because the original sample was seeded from a real local contact list.

What the sample shows

Twelve units across five owners. $17,300 collected, $6,210 in expenses, $1,384 in management fees at 8%, $9,706 paid out to owners.

Four of the five owners were down against last month, and one went negative: a $3,200 roof-leak repair landed on a single $1,750 unit, so that owner is invoiced rather than paid.

Owner	Collected	Expenses	Net payout	vs last month
Redbrick Partners	$1,750	$3,200	−$1,590	−$3,175
Ardsley Holdings	$2,950	$490	$2,224	−$1,398
Fenmore Rentals	$4,650	$1,190	$3,088	−$1,054
Kestrel Property Trust	$3,900	$890	$2,698	−$784
Ironwood Commercial	$4,050	$440	$3,286	+$136
Portfolio	$17,300	$6,210	$9,706

The flag is the easy half. The half that ends the call is the reason, attached at unit level — a vacancy, an AC repair, a water heater, the roof. Obvious once the sheet says it; invisible in a stack of numbers.

What is in the workbook

Rent Roll — one row per unit — owner, address, rent due, rent collected, expenses, last month’s net, and a note. This is the tab you maintain.
Owner Statements — portfolio totals, a statement per owner (rent, expenses, management fee, net payout, change vs last month) and a “why the drops happened” table down at unit level.

Take the workbook

Free, no email, no signup, no follow-up sequence. It opens in Excel, Numbers or Google Sheets — the formulas are already in it, so you can delete the sample rows and put your own in.

Download the .xlsx ↓

Built by this script, which is public along with everything else on this site. The site does not serve _brand/ itself — GitHub Pages hides underscore directories — so the link goes to the repository.

What it does not do

It is a spreadsheet, not a portal. Owners do not log into it; you send them their statement.
The reason field is one per unit. Five small expenses drifting up would still raise the flag, but the reason attached would be whichever line was typed in — the honest version of that is a ranked list, and it is not in this sample.
The 8% management fee is one cell. So is the comparison month.
No AI. The flag is arithmetic — this month’s net against last month’s — and the reason comes from the expense line you recorded, not from a model’s guess about what happened.

Prefer something you can press right now instead of a file to open? The live dashboard demo takes your own export and rebuilds itself on your numbers in the browser, and the free tools run without uploading anything.

Want this one on your own numbers?

Send the chore and I’ll rebuild a real piece of it on your own file, usually within a business day. Free, and yours to keep either way — no contract and no follow-up sequence.