Occupancy & Revenue Pulse Reporter
Last reviewed
IntermediateWhat you'll learn
~40 min- Ask an AI tool, in plan mode, for a small program that reads two weekly rent rolls (the office system's list of every apartment, its lease, rent and balance) and makes the owner's weekly report
- Say how your report counts occupancy, leased apartments, rent owed by age and concessions (discounts written into a lease), and read the plan for those definitions and their dates
- Check each figure against the rent rolls, and check the list of what changed in the week, apartment by apartment
- Find out what an earlier figure counted before the owner compares it with this week's, and draft the note for you to check and send
The story, and what you will end up with
It is Friday 20 November 2026 at The Concord. Every Friday afternoon you send the owner, and your regional manager, a short report on the building: how many apartments are lived in, how many are leased, what changed in the week, what residents owe and for how long, and what concessions are running. Until now you made it by hand in a spreadsheet. Last Friday’s hand-made report told the owner the building was 96.6% leased.
Offices often mean one of two different counts by the word leased. Some count every apartment lived in or signed to move in. Others also take out apartments whose residents have given notice and have no one signed to follow. Neither is the right one. The Concord’s management agreement with its owner defines leased the second way, so that is the count your report calls leased, and it shows the other count beside it under its own label.
Today you have two exports from the office system: last Friday’s rent roll and today’s. A rent roll is the system’s list of every apartment, with its status, its lease, its rent and what the resident owes on the date it was run. The owner will read your figures beside last week’s and act on them, so each one has to say what it counted and as of what date.
By the end of this lesson you will have a small program on your own computer, the report builder, that reads the two rent rolls and makes a one-page report for the owner: the figures for both weeks, what changed apartment by apartment, what is owed by how long it has been owed, and a line under the figures saying what each one counts. It never sends anything. You build it by asking your AI tool in plain English, and you check it by reading what it makes.
🔍Words used in this lessonclick to expand
These are the definitions this lesson uses. Your management company and your owner may define these figures differently, which is why the report prints the ones it used.
- Rentable apartments: every apartment except those marked down (out of service, for example after water damage) or model (kept to show prospective residents).
- Occupancy: apartments with a resident living in them, including residents who have given notice to leave, out of the rentable apartments.
- On notice: the resident has said they are leaving on a date, and still lives there until then.
- Vacant-leased: a lease is signed but the new resident has not moved in. The apartment is empty.
- Leased: apartments someone lives in, plus vacant-leased apartments, minus apartments on notice with no new lease signed, out of the rentable apartments. An apartment whose resident is leaving and has no one signed to follow is not counted as leased. So leased can be lower than occupancy, in a week when more residents are leaving than new ones have signed.
- Lived in or signed to move in: apartments someone lives in, plus vacant-leased apartments, out of the rentable apartments.
- Rent owed: the total of what residents owe (positive balances). A credit is money a resident has paid ahead, a negative balance; it is listed apart, not subtracted from what others owe.
- Owed by age: each balance put in one of three ages by how long the apartment has owed money on the report’s date: up to 30 days, 31 to 60 days, or over 60 days.
- Concession: a discount written into a lease. In these files it is a monthly amount.
Before you start
First, if your AI tool is still open, leave it: type /exit and press Enter (if you use Antigravity, press Ctrl+D with nothing typed instead), and wait until you see the $ or % prompt. The next line goes there, in the terminal, not in the AI tool. It makes a new folder for this lesson inside property-ops, next to the earlier lessons’ folders, and goes into it:
mkdir -p ~/property-ops/05-occupancy-pulse && cd ~/property-ops/05-occupancy-pulseStart your AI tool with the start line you kept from the setup lesson, the one with approval prompts off. Then ask it to set the folder up:
Set this folder up so we can undo any change you make, download https://learn.intellimetrics.net/starters/property-mgmt/05/rent-rolls.zip and unpack it into a data folder, and save a checkpoint.Look for it saying three things: the folder is set up with Git (the program that saves snapshots, from setup), two files are in the data folder (rent-roll-2026-11-13.csv and rent-roll-2026-11-20.csv), and a first snapshot, your checkpoint, is saved. Later you can ask whether the files have changed since then. If it does not mention one of them, ask: “Did you save a checkpoint with the files in it?” If it says it kept the zip file somewhere outside this folder, ask it to delete that copy. If the download does not work, download rent-rolls.zip in your browser, check where it went (the browser’s list of downloads shows the folder), and tell your AI tool, for example: “rent-rolls.zip is in my Downloads folder. Unpack that one file into a data folder here, and save a checkpoint.” In Windows PowerShell or a desktop app, “my Downloads folder” works as is; only say “my Windows Downloads folder” if you use Ubuntu (WSL) on Windows, which keeps its own Downloads folder apart from Windows.
The files carry no resident names. No real resident’s details should go into this folder.
The box below says what is in the practice files; later steps refer to them.
ℹWhat is in rent-rolls.zipclick to expand
Two spreadsheet files (each opens in Excel), one rent roll as of Friday 13 November 2026 and one as of Friday 20 November 2026. Each has a title line (“Rent Roll as of 11/20/2026”) above the column headings, one row for each of the building’s 120 apartments, and a totals line at the bottom, as exports often do. Money is written the way an export writes it, such as $2,250.00, and a credit as -$2,355.00. The totals line’s balance figure has the credits subtracted. Beside each amount owed, an Owed Since column gives the date the apartment has owed money since.
Each apartment has one status: Occupied, Notice, Vacant, Vacant-Leased or Down/Model.
| 13 November | 20 November | |
|---|---|---|
| Down/Model (0201 model, 0710 down) | 2 | 2 |
| Rentable apartments | 118 | 118 |
| Occupied | 109 | 109 |
| Notice (still lived in) | 3: 0305, 0908, 1102 | 2: 1102, 1306 |
| Vacant-Leased (signed, not moved in) | 2: 0506, 1007 | 5: 0305, 0409, 0603, 1007, 1209 |
| Vacant, not leased | 4: 0409, 0603, 0807, 1209 | 2: 0807, 0908 |
In both files, no apartment on notice has a new lease signed yet.
What changed between the two Fridays, apartment by apartment:
- Move-outs: 0305 and 0908, both on notice, moved out on Saturday 14 November.
- Move-in: 0506’s new resident moved in on Monday 16 November.
- New leases: 0305, 0409, 0603 and 1209 were leased, with move-ins between 1 and 15 December. 0908 is vacant.
- New notice: 1306 gave notice, to leave on 31 January 2027.
- 0702’s balance went down from $2,250 to $1,125. The files do not say whether that was a payment or an adjustment. Every other balance, credit and Owed Since date is the same in both files.
| Owes | 13 November | 20 November | Owed since |
|---|---|---|---|
| 0402 | $2,250 | $2,250 | 1 November 2026 |
| 0702 | $2,250 | $1,125 | 1 October 2026 |
| 1003 | $310 | $310 | 6 November 2026 |
| 1203 | $4,500 | $4,500 | 1 September 2026 |
Two apartments have credits, both weeks: 0902 $2,355, a prepaid December rent, and 1301 $125. Concessions: 0403 $200, 1110 $100 and 1304 $250 a month, the same both weeks.
Each lesson’s practice files are their own made-up week and do not continue from one lesson to the next, so an apartment can be occupied in one lesson’s files and empty in another’s.
Switch to plan mode
Your AI tool is already open. Switch to plan mode now: Shift+Tab until it says plan, or /plan (the keys for each tool). In plan mode it usually reads your files, asks its questions and shows you a plan before it builds anything; the order can vary.
The conversation
Each message below is an example. Say it your own way.
Say what you want
Say what you do, which files to use, and what you want from them:
I manage an apartment building. From the two rent rolls in data, build a weekly report for the owner: occupancy, leased, rent owed by age, concessions, and what changed since last week. Ask me what you need first.Your AI tool usually reads both files and comes back with questions. It may also list what changed between the weeks, or point out the title line, the totals line, or that the totals line subtracts the credits.
Answer its questions
Answer each in a sentence. These are questions the tools often ask, with one way to answer each. Yours may ask them in a different order or show a list of choices:
| If it asks | You might say |
|---|---|
| A printable report, a spreadsheet, or a dashboard? | One page I can open in my browser and print. |
| Which occupancy: lived in, or including signed leases? | Residents living there, including on notice, out of the 118 we can rent. |
| Should apartments on notice count as leased? | Leased is lived in, plus signed future move-ins, minus apartments on notice with no new lease signed. |
| Do any apartments on notice have a new lease signed? | No, none of them has a new lease signed yet. |
| Age what’s owed as 0 to 30, 31 to 60, 61 to 90 and over 90 days? | Up to 30 days, 31 to 60, and over 60, as of the report date. |
| Should the down and model apartments count? | Leave them out of the 118, and list them. |
| Should credits be subtracted from what’s owed? | No. Show what’s owed without subtracting credits, and list credits separately. |
| Any notes on the balances, such as payment plans? | I’ll add notes on payment plans myself. |
| Are concessions monthly discounts or one-time? | Monthly discounts. |
| Should it count the gap between asking rent and actual rent? | Leave that out. |
| A written summary, or only figures? | A few plain sentences on what changed, no causes or predictions. |
| A report you can run each week, or one for this week only? | One I can run each week. |
| What date goes on the report? | As of 20 November, compared with 13 November. |
| Should it use the building’s name? | Call it The Concord. |
If it asks several questions at once, answer any about how something is counted or who decides from your owner’s agreement or your own judgment, and accept its suggestions only about how the page looks. If it asks something not listed here, answer it the same way, in a sentence.
These are one manager’s answers for one owner; another owner may want ages of 0 to 30, 31 to 60, 61 to 90 and over 90 days.
Read the plan
Next it usually shows you a plan: what it will build and how it will check it. Read it for six things:
- Both weeks are read, and every figure carries the date of the rent roll it came from: 13 November or 20 November.
- Occupancy and leased are counted as you answered, both out of the 118 rentable apartments.
- What changed is listed by apartment: move-ins, move-outs, new leases signed and new notices.
- Rent owed counts only what residents owe, in three ages as of the report date: up to 30 days, 31 to 60, over 60. Credits are listed on their own and not subtracted.
- Under the figures, the report says in words what each one counts, and that the down and model apartments are left out.
- Nothing is sent, and your two files are read and left as they are.
A first plan often leaves one of these out, most often item 5. Say so in a sentence, in your own words, for example:
Under the figures, say in words what each one counts, and that the two down and model apartments are left out.When the plan has all six, approve it: if your AI tool offers a choice to go ahead, pick it; otherwise say “Yes, go ahead and build it.” In Codex, press Shift+Tab first to leave plan mode. In Copilot, saying it brings up a choice to go ahead; pick that. Let it build. It may run what it built and tell you how to run it yourself; either way, the next step asks it to. When it has finished, ask it: “Did you install anything, and where?” Nothing, or something inside this lesson’s folder, is fine for these lessons. If it names anywhere else on your computer, ask it what that is for, and to remove it if you do not want it there.
Look at what it built
Ask it to run what it built:
Run it and show me the report.It may show the report’s figures in the terminal and say where the page is saved, or start the page and give you an address to open. To see the page itself, ask: “Open the report in my browser.” If it says the address is already in use, say: “Something else is using that address. Don’t stop it. Use a different address for my page.” If your AI tool does not take a message after opening the page, wait a minute. If it still does not, close the terminal window, open a new one, type the line at the top of this page that begins with mkdir again, start your tool, and say: “Start the page again so it keeps running while we talk.” The page and your saved work are files in the folder, so nothing is lost. When you have finished with the page, ask: “Stop the report page if it is still running.”
Your report will be worded and laid out in its own way. Check it for these:
- It is dated as of 20 November 2026 and compared with 13 November 2026.
- Occupancy is 94.9% on 13 November (112 of 118) and 94.1% on 20 November (111 of 118), one apartment fewer.
- Leased is 94.1% on 13 November (111 of 118) and 96.6% on 20 November (114 of 118), three more. The apartments on notice with no new lease are out: 0305, 0908 and 1102 on 13 November, 1102 and 1306 on 20 November. If it shows 96.6% and 98.3%, it has counted apartments lived in or signed to move in; tell it which count the agreement calls leased. This report takes out every notice, whatever its date: 1306’s resident leaves on 31 January 2027, ten weeks ahead, and is already out of the 20 November figure. An office may take out only the notices inside a window it sets. If 1306 stayed in, 20 November leased would be 115 of 118, 97.5%. Which rule applies is the owner’s agreement’s to say and your regional manager’s to confirm.
- What changed is listed by apartment: one move-in (0506), two move-outs (0305 and 0908), four new leases (0305, 0409, 0603 and 1209) and one new notice (1306).
- Rent owed is $9,310 on 13 November and $8,185 on 20 November, across four apartments, with the credits ($2,480 on 0902 and 1301) listed apart and not subtracted. If it shows $5,705, it has taken the totals line, which subtracts the credits; tell it so.
- By age on 20 November: up to 30 days $2,560 (0402 and 1003), 31 to 60 days $1,125 (0702), over 60 days $4,500 (1203). If it shows 13 November the same way: $2,560, $2,250 and $4,500. These files give each apartment one date, the date it has owed money since, so a whole balance lands in its oldest age; many real aging reports age each charge, so part of an old balance can be newer. To say so on the report, ask: “Head the part of the report with the ages of what is owed: by oldest unpaid date.” An owner may also want what is owed as a share of the rent charged.
- Concessions are $550 a month, on 0403, 1110 and 1304, both weeks: every concession in force on the roll. An owner may ask first about concessions on leases signed this week. The roll does not show when a concession was granted, but comparing the two weeks finds the four new leases (0305, 0409, 0603 and 1209), and none of them carries one.
- Under the figures it says what each counts and that 0201 and 0710 are left out.
- When you ask “Have my rent roll files changed since the checkpoint?”, it compares them with the checkpoint and says no.
The percentages are rounded to one decimal place. If yours shows 94.92% or 94.07%, that is the same figure with more decimals. The report gives amounts and ages only; it says nothing about why anyone has not paid or when they will.
Your AI tool may call 0702’s lower balance a payment. The rent rolls show only that the balance went down; if the report says more, ask it to say only that.
If something on the list is not true, tell your AI tool in a sentence what you see and what you expected, for example: “The report says 111 of 120. Leave out the two down and model apartments, so it’s out of 118.”
Show the other count beside it
Ask for the other count, under its own label, beside the leased line:
Beside the leased line, add a line for apartments lived in plus signed future move-ins, labelled Lived in or signed to move in, with its count. Then run it and show me both lines for both weeks.Check that the new line says 114 of 118, 96.6%, on 13 November and 116 of 118, 98.3%, on 20 November, that it does not use the word leased, and that the line under the figures says what it counts.
Notice what last week’s figure counted
Your report says that on 13 November leased was 94.1%, and that 96.6% of apartments were lived in or signed to move in. Last Friday’s hand-made report told the owner the building was 96.6% leased. Ask your AI tool:
Last Friday's report, made by hand, told the owner the building was 96.6% leased on 13 November. What count of that week's rent roll gives 96.6%?Before you read on: what did last Friday’s figure count?
96.6% is 114 of 118: the 112 apartments lived in, plus 0506 and 1007, signed with residents not yet moved in. That is the count of apartments lived in or signed to move in, and the arithmetic is right. What differs is the word. This owner’s agreement takes out of leased the three apartments that day whose residents were leaving with no one signed to follow, 0305, 0908 and 1102, which gives 111 of 118, 94.1%. A matching percentage is a lead, not proof: only the working behind last Friday’s report shows which count it made.
Now look at it as the owner will. Last week: leased 96.6%. This week: leased 96.6%. That reads as a week with no change, and it was not one. Counted the agreement’s way, leased rose by three apartments, from 111 to 114: four new leases, less the new notice on 1306. Counted the other way, it rose by two, from 114 to 116.
A figure the owner compares week to week has to count the same things every week and say what they are; if an earlier figure counted something else, say so before the owner compares them.
The note is yours to make and to send. Before anything goes to the owner, check last Friday’s working to see which count it made, look at the earlier hand-made reports to see whether they did the same, read how the management agreement defines leased, and agree the note with your regional manager. Your AI tool can draft it:
Draft a short note to the owner with both counts for both weeks. Say what 13 November's leased figure is under each count, and leave a blank for which count last Friday's 96.6% was. I'll check last Friday's working first.Look for a draft that gives leased as the agreement defines it (94.1% on 13 November, 96.6% on 20 November) and the other count beside it (96.6% and 98.3%), says 13 November’s figure is 94.1% under the agreement’s count and 96.6% under the other, and leaves a blank for which count last Friday’s 96.6% was. If it fills that blank in or calls last Friday’s figure wrong, ask it to leave the blank for you. Fill it in yourself once you have checked last Friday’s working. It should not be sent, and nothing in it should guess at a cause. If it says nothing about earlier reports, add a sentence yourself once you have checked them.
One real run
Here is part of what one AI tool said after it added the second line, with Claude Code on 11 November 2026. Yours will word it differently; check your report against the list above, not against this.
| | 13 November | 20 November || Leased | 111 of 118 (94.1%) | 114 of 118 (96.6%) || Lived in or signed to move in | 114 of 118 (96.6%) | 116 of 118 (98.3%) |
The 13 November "lived in or signed to move in" figure, 114 of 118(96.6%), is the count behind last Friday's hand-made 96.6%.The building and every figure in this answer are made up for this course.
How real properties differ
A real rent roll holds more than these files do:
- Real exports may list an apartment twice (the resident leaving and the one arriving), repeat the column headings on every page, and carry resident names, deposits, and balances split into rent, late fees and other charges. Check what your own export holds before you trust a figure from it.
- Your management company and your owner decide how each figure is defined and what the weekly report includes. Some measure occupancy on every apartment, down ones included, or want both; some count a model apartment differently; some ask for other figures, such as apartments that will be empty soon. Use their definitions, and keep the line under the figures that says which ones you used.
- Your system may also mark an apartment on notice that already has a new lease signed. Leased, as this lesson counts it, keeps that apartment in.
- Rent owed depends on the day you measure it. If rent is charged on the 1st, a balance on 20 November includes November’s rent and one on 4 December includes December’s as well. Do not compare what is owed across the start of a month without saying so.
- In many systems, a resident who moves out still owing money leaves the rent roll, but the debt does not go away; it moves to the office’s records for former residents. If what is owed falls because someone moved out, say so rather than let it read as money collected.
- What the report says about a resident’s balance is what the records show: an amount, and any payment plan or legal step as recorded. It never says when someone will pay, why they have not, or what the office will do about it.
- Concessions are often one-time, such as a few weeks free, rather than a monthly discount. Say how yours are counted.
Keep going
Small changes do not need plan mode. Say each in a sentence, then run it again:
- “Also show occupancy out of all 120 apartments, labelled, beside the 118 figure.” Some owners ask for both.
- “Add a line listing each down or model apartment, with a place for me to write why and when it comes back.”
- “Make sure the report never shows a resident’s name, even if a rent roll has one.” These files have none; real ones do.
- “Does the program name any apartment from these practice files? If it does, make it work those out from the files instead.” A program built in a conversation may keep your answers written into it, and on next week’s files it would get those apartments wrong.
- “Save a checkpoint.” Your AI tool saves a snapshot you can return to.
When you want a report from your real rent rolls, use the finished report builder. It runs on your real files by itself, with your AI tool closed, so your AI tool never sees them. Your office system’s export will not be shaped like the practice files: its columns will have other names, it may hold more than one row for an apartment, and it will carry residents’ names. Those names stay out of this course folder. Do these steps in order; the first four happen now, while your AI tool is open and this folder still holds only the practice files:
-
Go through the data check, the questions in setup about what the data is, who decides how it is used, and which AI tool would see it. A rent roll carries residents’ names, rents and balances, and is your management company’s to decide on. Go on only if it allows this use.
-
Make a folder of its own for your real rent rolls, outside this course folder. You can ask your AI tool: “Make an empty folder called owner-reports in my home folder.”
-
Open your own export in a spreadsheet. Tell your AI tool the names of its columns, and give it two rows you make up in the same shape, with made-up apartment numbers, names and amounts, never a real row. The headings alone do not show which words your export uses for each status, how it writes dates, or whether an apartment can have two rows. For example: “My rent roll has the columns Unit, Resident, Status, Rent, Lease From, Lease To, Move In, Move Out, Balance and Oldest Charge. Here are two made-up rows in the same shape. Change the report builder to read files like that.” Then paste the two rows you made up.
-
Ask your AI tool for the exact line, for example: “Give me the exact one line to run this myself on last week’s and this week’s rent rolls in my owner-reports folder, with full paths, saving the report there too.” If it offers to copy your real files into this folder instead, say no. Copy the line it gives you into a note. It will look something like this one, though yours may differ:
Terminal window python3 /home/dana/property-ops/05-occupancy-pulse/scripts/build_report.py /home/dana/owner-reports/rent-roll-2026-11-13.csv /home/dana/owner-reports/rent-roll-2026-11-20.csv /home/dana/owner-reports/owner-report-2026-11-20.htmlRead it left to right.
python3runs a Python program. Next comes the report builder, in this lesson’s folder; then last week’s rent roll and this week’s, in owner-reports; last, the report it writes there./home/danais the home folder of someone whose computer name is dana; yours shows your own name. Each week you change the file names to that week’s. If you are unsure about any part, ask your AI tool now, while it is still open. -
Leave your AI tool the way you did at the start of this lesson.
-
Save last week’s and this week’s exports into owner-reports, named as the line names them. Paste the line from your note at the
$or%prompt and press Enter. The report appears beside your real files, not in the course folder. To come back to the lesson folder later, type the line at the top of this page that begins withmkdir. -
Before the report goes to the owner, compare its figures with the office system’s own occupancy and balance reports for the same date. If they differ, find out why before you send.
Try another case
Before the quiz, write two or three sentences for yourself. Next Friday a new regional manager asks you to “lead with the leased figure; it looks better”. The leased figure counts empty apartments whose new residents move in during December. What do you put on the report, and what would you tell the owner?
A good answer sees three things. The leased figure, counted as the report defines it, is a fair count, but it is not occupancy, so it goes on the report under its own name with its definition, beside occupancy, not in place of it. If the report changes which figure leads or how one is counted, the owner is told in the report that week, before they compare it with earlier weeks. And which figures the owner gets is settled with the owner and your company, not chosen for how it looks.
Key takeaways
- A short ask is enough. The job and the files; its questions do the rest.
- How a figure counts comes from the owner’s agreement, never from the tool’s suggestions.
- One word, two counts. The report shows the agreement’s leased, and the other count beside it under its own label.
- Changes go by apartment: who moved in, who left, who signed, who gave notice.
- Same count every week, and the owner hears before comparing if an earlier week counted differently.
- Real rent rolls stay out of the course folder: the finished program reads them with your AI tool closed.
On 20 November The Concord has 120 apartments. 0201 is a model and 0710 is down. Of the other 118, 111 have a resident living in them (2 of those on notice, with no new lease signed), 5 are vacant with a signed lease, and 2 are vacant and not leased. What is occupancy, as this lesson defines it?
What’s next
In the next lesson you build the Daily Ops Command Center, one read-only page that shows the latest results of your five property tools side by side, each with the date its file was made.