EIV reconciliation is the part of affordable-housing operations that doesn't show up on a dashboard until it shows up on an audit finding. The PHA pulls the EIV report, runs the NDNH and SSA wage matches, identifies the households with discrepancies, opens the rent calc, decides whether to interim, and generates the discrepancy packet for HUD review. The clock is 15 days from the discrepancy identification. The cost of missing it is a HAP claw-back that can reach 60 months back.

Most PMS leave this on a spreadsheet. Yardi exports an EIV-formatted file. RealPage ships an EIV report. AppFolio doesn't natively handle EIV. None of them actually reconcile — that work happens manually, eight to twelve hours per household, by someone with a SSA wage report on one screen and a 50059 on the other.

This is what ExactEstate did to that workflow.

EIV reconciliation 101

EIV — the HUD Enterprise Income Verification system — pulls wage and benefit data from two federal sources. NDNH (the National Directory of New Hires) returns quarterly wages reported by employers. SSA returns Social Security and SSI benefits. The PHA's job is to compare those returns against the income the household reported at certification, identify discrepancies, and resolve them within 15 days per 24 CFR §5.233.

The 15-day clock starts when the discrepancy is identified, not when the EIV report was pulled. That distinction matters because the report can sit in a queue for weeks before someone opens it.

The math behind the 5-year HAP claw-back

If a household was certified at the wrong income and the discrepancy went unresolved, HUD can claw back HAP for up to 60 months. The math on a real portfolio:

100 households × average $700 HAP overpayment × 60 months = $4.2 million in potential exposure.

That's the upper bound. The realistic exposure is lower — HUD typically claws back where there's a clear pattern, not a single missed cycle — but the math is why compliance officers care. One mismanaged EIV cycle on 100 households is a six-figure finding.

Where the eight hours per household go

The manual reconciliation cycle, household by household:

1. Open the EIV NDNH return. Identify the employer, the reported wages, the quarter.
2. Open the 50059. Find the income source that should match. Often there are two or three.
3. Compare. Note the discrepancy amount and the quarter.
4. Open SSA return. Repeat for benefit income.
5. Decide: is this a reporting error (employer over-reported), a household disclosure problem (household didn't disclose), or a calculation problem (PMS handled the exclusion wrong)?
6. Build the discrepancy packet: EIV report excerpt, certification excerpt, comparison memo, household notice.
7. If the discrepancy requires an interim certification, generate the new 50059, route for signature, run the rent calc.
8. File the packet in the household record, log the resolution date.

Eight hours is the median we see for trained occupancy specialists. Twelve hours is the high end for complex households (multiple income sources, exclusions, asset issues). A 500-unit portfolio with a 20% discrepancy rate is 100 households × 8 hours = 800 hours per cycle, every cycle.

The ExactEstate mechanism: 12 minutes per cycle

The mechanism replaces every step above with a system action. The reconciliation is software, not a checklist.

One click: NDNH match

The 50058 holds the household's income sources by employer and frequency. The NDNH return comes back keyed to employer EIN and quarter. ExactEstate runs the match automatically. The output is a table of household, expected wage, reported wage, delta, and confidence flag.

One click: SSA match

Same mechanism for SSA benefit income. The 50059 holds the household's SSA/SSI declaration; the EIV return holds what SSA actually reports. The match runs at the household level and flags households where the declared amount differs from the SSA return by more than the de minimis threshold.

Auto-generated discrepancy packet

For every flagged household, the packet generates automatically: EIV report excerpt, certification excerpt, side-by-side comparison memo, household notice letter ready for signature. The compliance officer reviews and routes; the packet is built in the format HUD expects, with the 24 CFR §5.233 timeline annotated.

Walkthrough: 12 minutes

The full cycle on a 500-unit portfolio, with a 20% discrepancy rate: pull EIV (2 minutes, automated), run NDNH and SSA matches (3 minutes, automated), review flagged households (5 minutes for the officer to triage), generate packets and notices (2 minutes, automated). Total: 12 minutes from EIV report to resolved discrepancies queued for household response.

The 800 hours per cycle become 12 minutes. The 15-day clock stops being a problem because the cycle finishes inside the first day.

What the rest of the market actually does

• Yardi PHA: exports an EIV-formatted file from Voyager. The reconciliation happens in a spreadsheet downstream — not in the product.
• RealPage OneSite: ships an EIV report; reconciliation is manual.
• MRI Affordable: EIV report available; reconciliation handled in the compliance suite as a module, priced separately, mostly manual review.
• AppFolio Plus: no native EIV reconciliation.
• ExactEstate: NDNH match, SSA match, discrepancy packet, household notice — one cycle, one product, no module pricing.

The audit trail HUD asks for

The 24 CFR §5.233 timeline expects: discrepancy identification date, household notice date, resolution date, supporting documentation. ExactEstate logs every one of those as a system event on the household record. When a HUD monitoring review asks for the trail, the trail is a query, not a binder pull.

Watch the 12-minute EIV cycle

The product walkthrough takes longer than the cycle does. Book a 20-minute demo and we'll run the cycle on a dummy portfolio with realistic discrepancy patterns. If you want to bring a sanitized EIV report from your own portfolio, the demo will run it for you.

Related reading

• The 50058 Error Audit — where EIV discrepancies actually originate
• TRACS Submission Errors — the codes that fire after a bad reconciliation

Sources

• 24 CFR §5.233 — mandatory use of EIV and the 15-day discrepancy resolution clock.
• HUD Handbook 4350.3 REV-1, Chapter 9 — EIV review and discrepancy reporting requirements.
• HUD HCV Guidebook 7420.10G — HAP claw-back recovery procedures.
• EIV User Manual — NDNH and SSA wage match operation.
• Customer cycle-time benchmarks — ExactEstate PHA customers, Q1–Q2 2026.

About the author — ExactEstate compliance team. We built the reconciliation because we used to live in the spreadsheet.