HotsheetCNAT Title
Closing Audit · MLS → orders match

CNAT Title · Sales intelligence

Closing Audit

Cross-references MLS closings against CNAT Title order history. Any property that closed on the MLS without a matching CNAT order is business that walked.

Waiting on data

NTREIS IDX Plus does not return Closed listings — this report activates the moment NTREIS Back-Office approval lands and Closed records start flowing into listings_cache. All SQL plumbing, address normalization, and orders join logic is live and tested with the 10,950 historical closed orders already in orders_cache; the audit will populate automatically.

Closings this Month
Awaiting Back-Office
Matched to CNAT
Missed Closings
vs prior month: —
Missed Volume
Total sales price of missed deals
Last 12 Months
Match performance by month — track how often CNAT lands the closing.
MonthMLS ClosingsMatchedMissedMatch RateMissed Volume
No closed listings yet — table populates on Back-Office unlock.
Recent Missed Closings
Last 50 MLS closings where no CNAT Title order opened within ±90 days at the same address/zip.
ClosedAddressCityList AgentList OfficeClose Price
Nothing yet — populates automatically on Back-Office unlock.