Fix the Records Before You Build Anything on Them
A $2M approval, 529,213 parcels and a wedding list, built the same way: records first, then the short part
Collateral came second. Before a lender would look at a race car, it had to believe the numbers, and the team's books were accounting exports for three entities, sloppy and often just incorrect. Nothing was modeled until each entity's records were reconciled and rebuilt into statements a lender could read. The forecast sits on numbers that tie out, the debt model sits on the forecast, and a lender approved a $2M revolving facility on the cars.
Our builds ran in that order. The records were most of the work; what ran on them was the short part.
Four plain steps
Count what came in against a total someone else published. Resolve duplicates to one record. Label how sure each record is: a scenario until verified, an inference never dressed as a fact. Put a source or a name on every row. None of it waits for perfect data. The checks run inside the build, and what they cannot fix is flagged, not hidden.
| Case | As found | Fixed first | Then built on it |
|---|---|---|---|
| Asset Financing | Three entities' exports, often incorrect | Reconciled, rebuilt into statements | Forecast, debt model, a $2M approval |
| Farmland | 5,423,489 parcels from 81 county layers | Counts checked against each county's total; duplicates removed | 529,213 parcels, three valuations, 15 tests |
| Pit Wall | Five driver lists that overlap | One set of profiles, 686 unique; wealth a scenario until verified | Three tools, licensed to other programs |
| Wedding Planners | Four relatives' phones; one aunt invited twice | One list, a link per family, a name on every action | Reminders to quiet families; a sheet the family trusts |
None of this is impossible by hand. It is clerical work on a scale nobody would pay for, which is why the records were in the state we found them. Written down as checks, it runs again on every rebuild, so a fix made once stays made.
What it is worth
We have no figure for what clean records saved, and we do not estimate one. The work is believed: a lender read the statements and approved. It is reused: the paddock profiles carry three tools, and the second diligence room took three days, the third one day. Its gaps are visible: the three farmland valuations agree within 20% on 34% of parcels, and the rest are flagged.
Where it breaks
It is slow, and it is never finished. The farmland counts matched the counties' own totals in the first 22 of 81 counties. Some homes were counted as farmland, a fix decided but not yet rebuilt. A clean record is a standard you keep, and the page should say where it falls short.
From the Asset Financing, Farmland, Pit Wall and Wedding Planners engagements. The same care with names is in Derive the number, where two spellings of one field were most of the work.