Form 4.0 (the Ohio probate inventory) and the county auditor record are the two sources investors lean on hardest when deciding whether a probate case is worth pursuing. They almost always agree on the basics: the decedent owned a parcel, the parcel has a value, the parcel is still on title. But disagreements happen often enough that an investor working leads at scale needs a fast way to resolve them.
Most disagreements fall into a small number of patterns. Some are clerical (a typo, a misspelled street, a stale auditor record), some are structural (a recent transfer not yet recorded, an undisclosed trust, a parcel held in a different county), and a few are genuinely ambiguous (the fiduciary listed a value the auditor cannot confirm). Knowing which type of disagreement you are looking at tells you whether to dig deeper, ignore one side, or skip the case.
This piece lays out the five comparison points to check, a decision tree for resolving conflicts, and a worked example that shows the cross-reference in action.
The Five Comparison Points
When Form 4.0 reports a parcel, here are the five fields that should be checked against the county auditor:
1. Owner name. Form 4.0 names the decedent as the owner. The auditor's owner-of-record should match.
2. Property address. Form 4.0 lists the property address (or legal description). The auditor's address for the parcel should match.
3. Parcel number. When Form 4.0 supplies a parcel number, it must match the auditor's parcel number for the same address.
4. Last sale date. The auditor's most recent sale date for the parcel should be earlier than the decedent's date of death (otherwise the parcel was already transferred).
5. Value range. Form 4.0's appraised value should be roughly 2.85 times the auditor's assessed value (Ohio's 35 percent assessment ratio in reverse).
When all five agree, the case is clean. When one or more disagree, the decision tree below applies.
A Decision Tree for Conflicting Records
Walk through the checks in this order:
1. Owner-name mismatch. Is the auditor's owner a surviving spouse, a trust, or a different person entirely? If yes, the parcel is outside probate (transferred to spouse, held in trust, or owner is someone else). Skip the case for real-estate purposes. If the auditor's owner is the decedent under a misspelled or alternate name (Earnest vs Ernest, LeMarc vs LAMARC, Frederick vs Fredrick), treat as a match and continue.
2. Address mismatch. Is the auditor's parcel at a different address from Form 4.0's listed property? If yes, search the auditor by parcel number first. If no parcel number on Form 4.0, search the auditor by the decedent's domicile address. If still no match, the parcel may be in a different county; the case is unenrichable from a single county's auditor. Defer.
3. Parcel number mismatch. Is Form 4.0's parcel number not found in the auditor? Possibly a typo on the form. Cross-search by address; if a match emerges, use the auditor's parcel number as the source of truth.
4. Last sale date after date of death. Did the parcel sell between the date of death and today? If yes, the estate already monetized the property; outreach now reaches an executor with cash, not a house. Note the sale price and buyer; the case is sold-out.
5. Value mismatch. Is Form 4.0's appraised value far outside 2.85x the auditor's assessed value? Possible explanations: recent improvements, a depressed appraisal for tax reasons, or a fiduciary error. Trust the auditor's market value (often available alongside assessed value); flag the case for a second-look on outreach.
Cases that survive all five checks without disagreement are the cleanest leads in the file.
Common Disagreement Patterns
Three patterns show up often enough to recognize:
•Auditor name-spelling fuzz. The auditor and the court spell the decedent's name differently. The mismatch is cosmetic. Cross-search by domicile address to confirm the parcel.
•Auditor street-name fuzz. The auditor and the court spell the street differently (LeMarc vs LAMARC, Bluepine vs Blueprint, Shroyer vs SHROVER). Address search by alternate spellings (drop suffixes, swap letters, try common typos).
•Form 4.0 lists a parcel the auditor cannot find. Possible cross-county property (search the relevant county's auditor instead) or a stale form (the parcel was transferred between filing and inventory).
For more on the patterns that signal a probate case has no real estate at all, see Why Many Ohio Probate Cases Have No Real Estate.
A Worked Example
A Hamilton County estate opens. Form 4.0 reports Real Property: $116,120. The schedule lists "5283 Highview Drive, Cincinnati 45238" with parcel number "180-0083-0185-00."
Walking the decision tree:
1. Owner-name check. The auditor lists "ERNST PEGGY A" at 5283 Highview Dr. Form 4.0 lists Peggy Ann Ernst. Match.
2. Address check. The auditor's parcel address is 5283 Highview Dr. Form 4.0 matches. Clean.
3. Parcel-number check. Auditor parcel 180-0083-0185-00 matches Form 4.0. Clean.
4. Last sale date check. Auditor records last sale 11/18/1993. Date of death 6/19/2025. Sale was 32 years before death, so the parcel was held by the decedent through her lifetime. No post-DOD sale. Clean.
5. Value check. Auditor assessed value $40,650; market value $116,120. Ratio: $116,120 / $40,650 = 2.86. Within the 2.85 expected ratio. Form 4.0's appraised value matches the auditor's market value almost exactly. Clean.
All five checks pass. The case is a high-confidence tier-B candidate: real property confirmed, value confirmed, no post-DOD sale, owner identity confirmed.
When to Escalate vs Skip
The decision tree resolves most disagreements quickly. Two situations call for escalation rather than auto-skip:
•High-value Form 4.0 with auditor missing. When Form 4.0 reports a real-property value north of $300,000 but the auditor returns no match, the parcel may be in a different county or under a different ownership entity. This is worth a manual check before skipping; the upside justifies the time.
•Multi-parcel estate with mixed signals. When Form 4.0 lists several parcels and the auditor confirms some but not others, the missing parcels may be cross-county or recently transferred. Confirm what you can; flag the rest.
For lower-value cases (under $100,000) with even one unresolvable disagreement, skipping is usually the right call. The lead is too uncertain to justify follow-up time.
Where Structured Data Helps
Running the cross-reference for one case takes a few minutes. Running it across hundreds of new probate filings per week is not practical without automation. Ohio Probate Data applies the decision tree above to every parcel in every weekly file, flagging the clean matches as high-confidence and the unresolved disagreements as cases that need a closer look. Investors who want to skip the cross-reference step can use the file as a pre-resolved list. The Free Sample page shows a recent week in the same format.
For the full inventory walkthrough that pairs with this cross-reference guide, How to Read a Form 4.0 Inventory covers what each field on Form 4.0 reports and how to read the real-property schedule.
Key Takeaways
1. Form 4.0 and the county auditor are the two primary sources investors compare on probate cases. Disagreements between them fall into a small number of recognizable patterns.
2. The five comparison points are owner name, property address, parcel number, last sale date, and value range. The 2.85x ratio between auditor assessed value and appraised value is a fast sanity check.
3. The decision tree resolves most conflicts in order of severity: owner-name mismatch first (kills the lead), then address, parcel, sale date, and value.
4. Common disagreements (name-spelling fuzz, street-name fuzz, parcels the auditor cannot find) are usually cosmetic or cross-county and can be resolved by alternate searches.
5. Escalate high-value or multi-parcel cases with unresolved disagreements; skip low-value cases that fail the cross-reference at any step.
6. Structured weekly data automates the cross-reference so investors can spend their time on outreach instead of source reconciliation.