The day you enter data into your property management system is the last day that data is guaranteed to be accurate. From that moment forward, it decays.
Not because of bugs. Not because of user error, necessarily. Because the real world changes and databases do not update themselves.
How Data Decays
A tenant moves in. You record their contact information, lease terms, unit assignment, and move-in date. Everything is correct. Twelve months later:
- Their phone number changed. Nobody updated it.
- Their emergency contact moved. The old number rings to a disconnected line.
- The unit was recarpeted and the flooring type field still says "original hardwood."
- The lease renewed but the renewal terms were entered in a notes field instead of the lease terms fields.
- The tenant added an occupant who is not on the lease and not in the system.
None of these are catastrophic. All of them are wrong. And they accumulate.
The Three-Year Cliff
In my experience, property management data hits a reliability cliff at about three years. Before that, enough of the original data is still accurate that reporting works reasonably well. After three years without a systematic cleanup, the percentage of records with at least one inaccurate field gets high enough that aggregate reporting becomes unreliable.
This is not a theory. Pull a report on your oldest properties. Check ten random tenant records against reality. Check ten random unit records against the physical property. The gap between what the system says and what is actually true will be wider at older properties than newer ones.
That gap is your data decay rate, and it compounds.
Where It Hurts
Insurance renewals. Your insurer asks for a current unit mix, square footage breakdown, and construction type summary. If your unit records have not been validated in three years, you are submitting inaccurate information to your insurer. Best case: you are overpaying because the data overstates your exposure. Worst case: you are underinsured because the data understates it, and you find out during a claim.
Tax assessments. Your tax consultant uses your unit data to challenge assessments. If the data says you have 50 two-bedrooms averaging 1,100 square feet but the reality is 45 two-bedrooms and 5 converted one-bedrooms averaging 950 square feet, your challenge is built on wrong numbers. The assessor will find the discrepancy. You will not get the reduction.
Refinancing. Lenders want rent rolls, operating statements, and tenant profiles. Stale data in any of these documents creates questions during underwriting. Questions create delays. Delays cost money — sometimes they cost the rate lock.
Disposition. Selling a property with dirty data adds weeks to due diligence. Every discrepancy the buyer's team finds is a question that requires research. Every question extends the timeline. Enough questions and the buyer starts discounting the price for "data risk" — which is just their way of saying they do not trust your records and are pricing in the uncertainty.
Why Nobody Fixes It
Because it is not urgent. Decayed data does not create emergencies. It creates friction — slightly longer month-end closes, slightly less reliable reports, slightly more manual work to reconcile things that should reconcile automatically. The cost is real but distributed across dozens of small inefficiencies that are individually tolerable and collectively expensive.
Nobody gets fired for having stale emergency contacts. But the company that never audits its data pays a tax on every report, every renewal, every transaction — a tax that grows every year and never shows up as a line item.
What a Data Hygiene Program Looks Like
The answer is not a massive one-time cleanup project that takes six months and costs fifty thousand dollars. The answer is a recurring discipline:
- Annual unit audit. Once a year, walk the property. Verify unit types, square footage, flooring, appliance inventory, and any physical attribute your system tracks. Update what has changed. This takes one to two days per property depending on size.
- Lease renewal validation. Every time a lease renews, verify the tenant record. Update contact information, occupants, vehicles, pets. Make the renewal process the data validation trigger.
- Quarterly vendor review. Every quarter, review vendor records for duplicates, missing tax IDs, and inactive vendors that should be deactivated. Fifteen minutes per property per quarter prevents a two-week cleanup in December.
- Chart of accounts review at onboarding. Every time a new property is added to the portfolio, verify the GL structure before the first transaction posts. Aligning the chart of accounts on day one prevents twelve months of reclassification work later.
None of this is exciting. All of it works. The companies with the cleanest data are not the ones with the best technology — they are the ones with the most boring, consistent data maintenance habits.
Your data is an asset that depreciates without maintenance. Unlike your buildings, there is no reserve fund for it. The maintenance is either happening or the value is declining. There is no third option.