Data analytics for a property management company means tracking a handful of operating numbers that can affect net operating income (NOI), rather than reading the monthly accounting package after the fact. Five starting measures are physical occupancy alongside rent collected against potential rent, work-order resolution, days vacant between tenants, rent more than 30 days late, and controllable operating expenses per square foot. Choose the ones that fit your portfolio and data; some inputs may already be in your property management software.
Accounting Reports Tell You What Happened. Operating Metrics Tell You What's Coming.
Most property management systems produce a thorough monthly package: rent roll, income statement, general ledger, aged receivables. It's accurate, and it's backward-looking. By the time a slow repair or a rising utility bill shows up on the income statement, the tenant is already frustrated or the money is already spent.
Operating metrics are the leading indicators behind those accounting results. Repair times, turn times, and late balances move weeks or months before NOI does, which gives you time to act.
The test for including any metric is simple: does it help the property earn more revenue, run more efficiently, or cost less to operate? If it doesn't, leave it off. Keep the scorecard to four to seven numbers so someone actually acts on each one; how many KPIs a small business should track explains why that range holds.
1. Physical Occupancy and Rent Collected Against Potential Rent
Physical occupancy is the share of leasable space that has a tenant in it. For this scorecard, use a cash-collection ratio to show the share of potential rent actually collected. Some property reports call a related measure economic occupancy, but definitions vary, so keep the numerator and denominator visible:
Cash-collection ratio = rent collected for the period ÷ gross potential rent for the same period × 100
Here, gross potential rent is what the property would bring in if every leasable space were occupied at the documented market-rent assumption for that space and every tenant paid in full. Document that rent basis and use it consistently; scheduled rent in existing leases, billed rent, concessions, and cash collected are different amounts.
The two numbers can diverge because of vacancy, free-rent concessions, discounts, and unpaid balances. The gap is not all collectible debt: some of it reflects deliberate lease terms or empty space.
A building is 95% physically occupied. After two months of free rent on a new lease, one tenant well behind on payments, and a discounted renewal, it collects 84% of gross potential rent. The 11-point gap calls for a breakdown of vacancy, concessions, discounts, and overdue rent. The late balance is the part collections can pursue without changing lease terms.
2. Work Order Resolution Time
How quickly a routine repair gets fixed is something every tenant experiences, every month, long before the renewal conversation. Track three numbers:
- Time to first response: hours from the request to someone acknowledging it or being assigned.
- Time to complete: days from request to closed work order, for routine requests.
- Open requests past the property's service target: the backlog that needs someone's attention. Set that target by request type and urgency rather than using one cutoff for every repair.
Watch the trend rather than the average alone. A property whose completion time creeps up quarter after quarter has a staffing, vendor, or parts problem building, even if no single request looks bad. Slow repairs can also weigh on whether a tenant renews, so watch the renewal rate next to these numbers; it connects service back to NOI.
3. Days Vacant Between Tenants
Rent lost while a space sits empty doesn't come back. Measure the total days from move-out to the new tenant's lease start, and split it into three stages:
- Move-out inspection and scoping: from the keys being returned to a defined list of work.
- Make-ready: repairs, paint, flooring, cleaning.
- Leasing: from rent-ready to a signed lease and move-in date.
The split tells you where time goes. If make-ready is the long stage, the question is vendor scheduling. If spaces sit rent-ready for weeks, it's a leasing or pricing question. A shared board listing every vacant space with its current stage and days in that stage is often enough to show the bottleneck.
4. Rent More Than 30 Days Late
A late balance is much easier to collect while it's young. The metric is the over-30-day late rate:
Over-30-day late rate = rent balances more than 30 days past due ÷ rent billed for the month × 100
Don't wait for the month-end aging report to find it. Send reminders and talk to tenants before balances become overdue. Use the over-30-day bucket as a review trigger; a balance approaching 60 days calls for a more direct follow-up under the lease and collection process. What counts as a normal level depends on the property type and tenant mix, so compare each property against its own history rather than a generic benchmark.
5. Controllable Operating Expenses per Square Foot
Some operating costs, like property taxes and insurance, are set outside day-to-day management. Others, like janitorial, landscaping, repairs, and utilities, are controllable. Track those separately and divide by rentable square feet so you can compare properties of different sizes and each property against its own past months.
Unexplained changes are the trigger. Water cost per square foot at one building runs 40% above the same month last year with no change in occupancy. That's a reason to walk the building before the next bill: a running toilet, an irrigation zone stuck on, or a meter reading that needs checking. The metric doesn't diagnose the cause. It tells you where to look.
How to Start Without Buying New Software
You probably have all five metrics' raw data already.
- Export what you have. Rent roll, aged receivables, work order history, and the general ledger by property are standard exports from most property management systems. Put them into one spreadsheet, one tab per export.
- Build one screen. Five metrics, one row per property, each with a target, the current value, and a green, yellow, or red status. How to build a monthly KPI scorecard shows the layout.
- Review it weekly or monthly with the people who can act. The review is a short conversation about what the numbers mean, who will act on them, and by when. How to get your team to actually use your reports covers running that meeting.
Stay in the spreadsheet while it gives the team a reliable, timely view. If recurring exports and reconciliation consume more staff time than a reporting tool would save, or multiple systems make errors hard to catch, evaluate an upgrade against those actual costs.
If your portfolio includes parking, its operating metrics need their own scorecard. The KPIs every parking lot operator should track covers capacity, utilization by hour, revenue per space, and payment capture, which may matter there alongside property-level measures.