Mixed status casing
PAID · Paid · paid · OUTSTANDING — every row different
Inconsistent dollars
$1,180 vs 85 vs "$2,840.00" — three formats in one column
Stray whitespace + empty rows
" Walgrove HOA " · blank rows scattered through
Mixed date formats
2025-11-04 vs 11/15/2025 vs 12/19/2025
Junk columns × 9
Tax · Discount · Promo · Photos? · Sync ID · Source · Region · Modified By — none of it ends up in the dashboard
System sync noise
Random GUIDs · "QB Export" vs "imported_v2" · NE-04 / ne-04 / NE04
Excel errors leaking through
#N/A · #REF! · leftover =IF(...) formulas in real cells
Email pastes in customer name
"Marcus Reilly <mreilly@gmail.com>" — copy/paste from inbox