Combine Rent Roll and Maintenance CSV Exports for a Weekly Portfolio Review

Portfolio reviews are harder than they should be when leasing data and maintenance data live in separate exports. One file shows occupancy, arrears, and unit status. Another shows open work orders, completion delays, and repeat maintenance requests. If those files are reviewed separately, managers can miss the connection between building performance and unresolved operational issues.

Combining the exports into one weekly portfolio review gives property teams a clearer operating picture.

What the Combined Review Should Answer

Question	Primary source	Why it matters
Which properties have the most vacancy or delinquency pressure?	Rent roll export	Establishes revenue and occupancy risk
Which properties have the most open or overdue work orders?	Maintenance export	Shows service and resident-experience pressure
Are high-maintenance properties also showing weaker leasing performance?	Combined view	Helps prioritize management attention
Where are repeat issues clustering by building or vendor?	Maintenance detail	Supports corrective action

Simple Weekly Workflow

1. Export the latest rent roll for the full portfolio.
2. Export open and recently completed maintenance orders for the same properties.
3. Standardize property names, building codes, and unit identifiers.
4. Group maintenance records by property and issue type.
5. Join the summarized maintenance view back to the rent roll.
6. Build a weekly review table sorted by exceptions.

Example Weekly Portfolio Table

Property	Occupancy	Delinquent units	Open work orders	Overdue work orders	Watchlist note
Cedar Point Homes	94%	7	31	9	Service backlog rising
Maple Square	89%	11	14	2	Leasing pressure first
Harbor Flats	97%	3	29	12	Repeat plumbing issues
Elm Court	91%	8	10	1	Stable but monitor delinquency

This kind of summary helps a regional manager see where site follow-up is needed before the meeting turns into isolated anecdotes.

Useful Groupings

Grouping	Use
Property	Weekly operating review
Building	Multi-building campus comparison
Vendor	Detect recurring contractor delays
Issue type	Spot clusters such as plumbing, HVAC, or turnover prep
Unit status	Separate occupied-unit problems from make-ready backlog

A Small Example of Maintenance Aggregation

Property	HVAC	Plumbing	Turnover	Safety	Total open
Cedar Point Homes	6	11	9	5	31
Harbor Flats	4	15	6	4	29
Maple Square	3	4	5	2	14

This makes it easier to explain whether a property is struggling because of routine volume or a concentrated operational issue.

Text Chart

Weekly portfolio attention

Occupancy pressure          ██████░░░░
Delinquency pressure        ███████░░░
Open work-order volume      █████████░
Overdue work-order risk     ████████░░
Repeat-issue concentration  ██████░░░░

Common Mistakes in Property Reviews

• Using property names from one system and building codes from another without standardization.
• Presenting raw maintenance line items instead of a summarized issue view.
• Reviewing delinquency and service backlog in separate meetings with no shared context.
• Ignoring overdue work orders because the total count looks manageable.

When This Workflow Is Most Useful

This is a strong fit for regional operators, asset managers, property analysts, and multifamily teams running weekly review cadences across several buildings. It is especially helpful when each site exports data separately but leadership still needs one clear portfolio view every week.

Weekly Review Checklist

• Standardize property IDs before joining files.
• Separate open work orders from recently completed work orders.
• Add an overdue flag instead of relying on raw due dates in the meeting.
• Keep one final watchlist note per property so follow-up is obvious.

Download DataOlllo

If weekly portfolio reviews still require rebuilding rent roll and maintenance summaries by hand, try a local workflow with DataOlllo: download DataOlllo.