Data dictionary

What each metric means, how it's calculated, and its source field in the monthly data file.

Section	Metric	Business definition	Calculation / rule	Source field	Format
Summary	Beginning Inventory	Homes in inventory on the first day of the month.	Should equal prior month Beginning + New Files − Closings − Withdrawals.	Summary_BeginingInventory	Count (integer)
Summary	New Files	Homes newly referred into inventory during the month.	Count of files with referral date in month.	Summary_NewFiles	Count (integer)
Summary	Closings	Homes sold and closed during the month.	Count of files with close date in month. Drives the Sales section gating.	Summary_Closings	Count (integer)
Summary	Withdrawals	Homes removed from inventory without a sale (e.g. reinstated, returned to servicer).	Count of files withdrawn in month.	Summary_Withdrawals	Count (integer)
Summary	Total Turn Rate	Share of available inventory that sold.	Closings ÷ (Beginning Inventory + New Files) × 100. Total column = YTD.	Summary_TotalTurnRate	Percent (1 decimal)
Inventory Snapshot (Beg Month)	New REO Status	Newly acquired homes not yet in a workflow stage.	Status count at beginning of month.	NewReoBOM	Count (integer)
Inventory Snapshot (Beg Month)	Eviction	Occupied homes in the eviction process.	Status count at beginning of month.	EvictionBOM	Count (integer)
Inventory Snapshot (Beg Month)	Cash For Keys	Homes in a cash-for-keys negotiation with occupants.	Status count at beginning of month.	RedemptionBOM	Count (integer)
Inventory Snapshot (Beg Month)	Premarketing	Vacant homes being prepared for listing (repairs, valuation).	Status count at beginning of month.	PreMarketingBOM	Count (integer)
Inventory Snapshot (Beg Month)	Listed	Homes actively listed for sale.	Status count at beginning of month.	MarketingBOM	Count (integer)
Inventory Snapshot (Beg Month)	Negotiation	Homes with offers under negotiation.	Status count at beginning of month.	NegotiationBOM	Count (integer)
Inventory Snapshot (Beg Month)	Offer Accepted	Homes with an accepted offer, contract pending.	Status count at beginning of month.	OfferAcceptedBOM	Count (integer)
Inventory Snapshot (Beg Month)	Under Contract	Homes under a signed sales contract awaiting close.	Status count at beginning of month.	UnderContractBOM	Count (integer)
Inventory Snapshot (Beg Month)	Total	All homes across every status.	Sum of all status rows; must match the status counts (checked).	TotalBOM	Count (integer)
Performance Metrics	Aged Inventory >30 Days	Homes in inventory longer than 30 days.	Count where days in inventory > 30. Must be ≥ the >120 bucket.	AgedInventory30	Count (integer)
Performance Metrics	Aged Inventory >120 Days	Homes in inventory longer than 120 days.	Count where days > 120. Must be ≥ the >180 bucket.	AgedInventory120	Count (integer)
Performance Metrics	Aged Inventory >180 Days	Homes in inventory longer than 180 days — top priority for review.	Count where days > 180.	AgedInventory180	Count (integer)
Performance Metrics	Unmarketable >120 Days	Homes unable to be marketed for over 120 days (occupied, title, legal).	Count of non-listed files aged > 120 days.	OffMarket120	Count (integer)
Performance Metrics	Aged Listed >90 Days	Homes listed for more than 90 days without a contract.	Count of listed files > 90 days. Switches to >120 if feed supplies Listed120.	Listed90	Count (integer)
Performance Metrics	Aged U/C >60 Days	Contracts open more than 60 days without closing.	Count of under-contract files > 60 days.	UnderContract60	Count (integer)
Performance Metrics	Average Days Vacancy to List	Average time from a home becoming vacant to being listed.	Mean of (list date − vacancy date) in days.	AvgVacancyToList	Days (rounded)
Sales Metrics	Sold	Homes sold in the month (same as Closings).	Mirrors Summary_Closings.	Summary_Closings	Count (integer)
Sales Metrics	Net Proceeds to Sales Price	How much of the sale price is kept after costs.	Net proceeds ÷ gross sale price × 100.	NetProceedsToGrossSalesPricePct	Percent (1 decimal)
Sales Metrics	Gross Sales Price to Current List Price	Sale price compared with the final list price.	Gross sale ÷ current list price × 100.	GrossSaleAmtToCurrListPct	Percent (1 decimal)
Sales Metrics	Gross Sales Price to Original List Price	Sale price compared with the first list price.	Gross sale ÷ original list price × 100.	GrossSaleAmtToOrigListPct	Percent (1 decimal)
Sales Metrics	Average Days Acquisition to List	Average days from acquiring a sold home to listing it.	Mean (list date − acquisition date), sold files only.	AcquisitionToListDays	Days (rounded)
Sales Metrics	Average Days Acquisition to Close	Average total days from acquisition to sale closing.	Mean (close date − acquisition date), sold files only.	AcquisitionToCloseDays	Days (rounded)
Sales Metrics	Average Days Vacancy to List (Sold)	Average days from vacancy to listing, for sold homes.	Mean (list date − vacancy date), sold files only.	VacantToListDays	Days (rounded)
Sales Metrics	Average Days List to Contract Date (DOM)	Days on market before going under contract.	Mean (contract date − list date), sold files only.	ListToContractDays	Days (rounded)
Sales Metrics	Average Days Contract to Close Date	Average time from contract to closing.	Mean (close date − contract date), sold files only.	ContractToCloseDays	Days (rounded)

Data quality rules

Roll-forward: Next month's Beginning Inventory = this month's Beginning + New Files − Closings − Withdrawals.
Status reconciliation: Status counts must add up to Total.
Aging order: >180 ≤ >120 ≤ >30 ≤ Total.
Turn-rate sanity: Reported YTD turn rate within 3 points of the calculated rate.
Sales gating: Sales rows show “–” when a month has zero closings.
Unusual movements: A value far from the average of prior months is highlighted on the report and dashboard.

File format (technical)

CSV, one row per month; first column ColumnHeader holds the month as Mon-YY (e.g. Jan-26).
A final row labeled Total carries year-to-date values.
Blank cells are treated as missing, not zero.
“BOM” suffix = beginning-of-month snapshot.
Missing expected columns raise a warning; extra columns are listed as info.