Service performance
Work-order completion time
Completed records with valid creation and completion dates
Checking sign-in…
Company reports are available only to approved accounts.
Property performance and maintenance overview
Checking access…
Queue and history share this tab. Each view uses its own report and filters.
Work orders are filtered by Created Date. Unit turns are filtered by Move Out Date. End dates include the full day.
Yearly activity
Service performance
Completed records with valid creation and completion dates
Make-ready performance
Recorded ready dates and turns awaiting a ready date
Activity over time
Created-month groups and their current completion status
Portfolio overview
Current status of the selected records
Request breakdown
Top 12 categories in the selected records
Listed units grouped by Days Vac. · blank values excluded
Top 12 by closed count • selected properties and employees
Labels from the export
Top 12 categories
Calendar days since Call Date
Counts of recorded cells, not a unit completion rate
All figures use the filters above
Which file updates which tab? A queue export with WO#, Call Date and Status updates Work Orders → Queue. It does not supply completion history. Maintenance Dashboard and Work Orders → History use a workbook containing a Work Orders sheet with Property, Work Order #, Created Date, Completed Date, Status and Category. Quarterly completion totals use Completed Date from that workbook, together with the selected property and chart year.
Work Orders → Queue: recognized by WO#, Call Date, Property, Unit, Brief Description, Category and Status. Age is measured in calendar days as of the selected date. This snapshot has no completion dates, so its statuses and counts are kept separate from maintenance metrics.
Unit Turns → Availability: Import a unit availability export with Property, Unit, Unit Type, Market Rent, Date Available, Days Vac. and Occ. Notice and Past labels are displayed exactly as reported. Listed units are not the full portfolio, so no occupancy rate is calculated. Blank numbers and dates are unknown. New availability uploads replace this snapshot and leave turn history unchanged.
Make-Ready Schedule: recognized by Property, Unit, Move Out Date, Move In Date and numbered task headings. Est and Act date markers are preserved. Blank cells are unknown, not unfinished. Unrecognized task values stay visible and produce a warning. No whole-unit readiness or completion percentage is inferred.
Employee Performance: import a WO Analytic by Employee report containing Property, Employee, Opening Balance, Created, Closed and Closing Balance. Title rows are supported. Its reporting period is read from the report header. Property and employee filters apply to the entire period; daily filtering and completion-time calculations are unavailable for these summarized counts. Undefined employee labels are retained. Balance differences are flagged without altering the source counts.
Use the original Work Orders and Unit Turns sheet names and headers. Blank template rows are ignored. One work order is identified by Property + Work Order #; one unit turn by Property + Unit + Move Out Date. Duplicate records or invalid required dates prevent import, keeping your previous import intact.
Open work orders include Open, In Progress and On Hold. Cancelled orders are shown separately and excluded from the completion-rate denominator. Average completion uses Completed Date minus Created Date for completed records with both dates. Average turn days uses Ready Date minus Move Out Date. These calculations use source dates rather than Excel's cached formula results.
All work-order views use Created Date for a consistent group of records. This differs from the Excel Dashboard's completed-in-period calculation, which uses Completed Date. The original Setup date range is offered automatically on import. Unit-turn views use Move Out Date.
This first version supports .xlsx files up to 10 MB and 50,000 rows per data sheet. The importer detects supported report types from their sheets and column headings. A maintenance workbook replaces only maintenance data. An employee report replaces only Employee Performance data. Queue and make-ready exports each replace only their own view. These five sources are never added together. Saved imports are shared with authorized site viewers and survive page reloads. Only upload admins can replace reports. Each upload replaces one report type. Load latest retrieves changes made by another admin; sample data is never saved. Date-only Excel entries provide day-level timing, so include times when hourly precision matters.