Common problems
| Unit / tenant | Lease | Rent |
|---|---|---|
| 101 - Morgan Lee | 01/01/26 - 12/31/26 | $1,450.00 |
| UNIT TENANT LEASE RENT Repeated page heading imported as a record | ||
| 102 - Avery Johnson | 02/15/26 - 02/14/27 | $ 1,525 .00 |
| Occupied units: 2 | $2,975.00 | |
Reviewable result
| Unit | Tenant | Start | End | Rent |
|---|---|---|---|---|
| 101 | Morgan Lee | 01/01/26 | 12/31/26 | 1450.00 |
| 102 | Avery Johnson | 02/15/26 | 02/14/27 | 1525.00 |
Excluded: the repeated heading and summary row. Currency becomes a usable numeric field rather than split text.
Checks illustrated
- Separate real unit records from page headings and totals.
- Join text that wrapped across visual lines without combining separate records.
- Keep dates in their correct columns.
- Normalize currency only when the source value is clear.
- Compare row counts and totals with the original before delivery.
Limits: Real rent rolls vary. MessyFile does not infer missing tenants, lease terms, balances, or accounting meaning. Consequential dates and amounts should be validated against the source, and sensitive tenant information should be redacted when it is not needed.