To the new district manager, retire the master tracker

The spreadsheet you inherit on Monday is the most dangerous document in this company.

You start next week as our district manager, Marcus, and someone will hand you a file called something like Master_Tracker_FINAL_v7. It has a tab for every association, twenty of them, and each tab was built by whoever ran that community at the time. Some track violations by lot number. Some by street. One tracks by homeowner last name, which works fine until the house sells.

I call it dangerous because it looks like control. It isn't. It's twenty private systems sharing one file, held together by the memory of the people who built them. Two of those people don't work here anymore.

So here's what I want you to build instead. None of it is clever.

Start with one template per walk type, not one per community. A common-area walk at Willow Creek and one at Harbor Pointe should ask the same questions in the same order: entry monuments, pool deck and gates, irrigation, lighting, signage, mailbox kiosks. If one community has a lake and the other doesn't, the lake section gets skipped. When every walk reads the same way, a board member can find what they need in any report, and so can you at eleven at night before a meeting.

Violation drives get their own template. So do move-out walks if we keep picking up rental work. Keep the count small. A couple of templates you trust beat fifteen you have to choose between in a parking lot.

Next, cadence lives with the community, not in somebody's head. Say Harbor Pointe's board wants monthly common-area walks and quarterly violation drives, and Willow Creek's documents call for drives twice a year. Write that down once, against each community, and let the schedule generate the walks. Right now cadence is whatever the last manager remembered, and I'd bet you find at least one community nobody has walked since spring.

Assign managers by portfolio. Each community has one name on it. When Sam owns seven associations, Sam's walks and open work orders are one view, not seven tabs. That's how you find out someone is drowning before they tell you.

Every board gets one link. Not a forty-page PDF stuffed in the board packet, not an email chain with photos attached. One link showing the latest walk, the open findings, which vendor has each one, and what's closed since the last meeting. Boards stop asking whether anyone looked at the fence when they can see the fence, the work order and the repair photo. You'll get fewer late-night emails.

Work orders belong to the association, never to a spreadsheet row. A cracked sidewalk found on a walk becomes a work order for that community's concrete vendor, and it stays open until the vendor sends back a photo of the fixed slab. When a homeowner reports a broken pool gate, it should land in the same queue, so you aren't reconciling a walk list against a resident inbox against a vendor invoice. That closed loop is the job. Everything else is paperwork about the loop.

Then there's Monday. I want your Monday to start with one screen: overdue walks, work orders past due, findings with no vendor assigned, and board meetings this week with no packet sent. Sorted by community, filterable by manager. If it's empty, go get coffee. If it isn't, you know whose desk to stop by and which vendor to call. Nobody should spend Monday morning building a report about last week.

The real test is handing a community to a new manager, and you will, probably by summer. In the spreadsheet world that handoff is a two-hour call full of "oh, also." Done properly, you change the name on the community and everything moves with it: template, cadence, board link, open work orders, walk history. The new manager reads the last two reports and walks the property the following week.

We've already moved about half the portfolio into Sitesui, and your job is the other half. Read how it's set up on our HOA solutions page, and if you're wondering whether twenty associations really fit in one workspace, they do. It'll hold at forty if we get there.

Before lunch on your first day, open the master tracker and write down one date for each of the twenty tabs: the last common-area walk. Anything blank, or older than that board's cadence, goes on your calendar for this week.