Nightly checks on the 12 data domains AppFolio is the system-of-record for. Catches sync failures, GL miscodes, owner-name drift, balance disagreements, and bank-rec gaps before they reach owners or auditors. Last 90 days: 99.6% data-integrity score.
Composite score across 12 data-quality dimensions. Healthy >94% · Watch 90–94% · Action <90%.
Last sync: today 4:18 AM · next: tomorrow 4:00 AM · 28 records flagged for human review.
| Date | Records | Errors | DQ score | Notes |
|---|---|---|---|---|
| May 7 · 4:18 AM | 3,418 | 0 hard · 28 flagged | 96% | Routine · 14 contact-stale + 5 transfer flags + 9 W-9 / TIN. |
| May 6 · 4:08 AM | 3,418 | 0 hard | 96% | Routine. |
| May 5 · 4:14 AM | 3,418 | 1 hard · ledger drift | 94% | Lakes $0.18 drift · resolved Wednesday. |
| May 4 · 4:22 AM | 3,418 | 0 | 97% | Routine. |
| May 3 · 4:18 AM | 3,420 | 0 hard · 1 flagged | 96% | OPV new owner not yet synced. |
| May 2 · 4:11 AM | 3,418 | 0 | 97% | Routine. |
| May 1 · 4:14 AM | 3,420 | 2 hard | 91% | End-of-month posting collision · resolved by 9 AM. |
AppFolio CSV export pulled. 12 domain checks run. Discrepancies posted to alert queue. Email digest to ops director by 5:30 AM (read-and-acknowledge required for hard errors).
Hard error (ledger drift >$1, missing TIN, balance disagreement) = AGF + ops director ping. Soft flag (stale email, W-9 needed) = manager queue. Most resolved by close of business.
Known-pattern fixes (late fee on workout owner, allocation rounding, transfer-flag) auto-correct + log. Tizi reviews patterns monthly to add new auto-fixes.
Last-3-days-of-month run a tighter sweep + a per-association close checklist before financials publish. Catches the timing collisions that cause month-end variance memos.
Every alert + resolution stored 7 years. Auditor pulls the DQ history during annual audit; demonstrably more defensible than "yes we checked."
Per-domain SLAs (ledger drift cleared T+1 · stale email actioned T+5d · TIN collected T+30d). Misses surface in leadership weekly digest. Drives accountability.
The auditor finding $14 of mis-coded GL during August fieldwork. The owner who calls because their portal balance disagreed with their statement. The 1099 vendor whose missing TIN we discovered in late January. The mid-month panic when a NOLA was sent against the wrong unit owner.
AppFolio sync · AppFolio Stack tracker · Owner verification · Bill Pay · Owner Ledger · Audit Prep · Annual Report.
