Property Maintenance Tracker from a Google Sheet — Free

You manage forty-one units across three buildings, which means you manage forty-one refrigerators, forty-one water heaters, and an unknowable number of garbage disposals — plus the tenants attached to them. This morning alone: a leak under the sink at Maple 2B, a lockout at Birch 4A, and unit 12 at Oakview going vacant on the 31st, which starts the turnover clock — clean, paint, repairs, photos, listed — where every idle day is rent you never get back.

The work arrives from every direction at once. Tenants text you, call the office line, or flag you down in the parking lot. Vendors confirm by voicemail. Lease dates march forward on their own schedule whether or not you're watching. The platforms built for this want onboarding calls and per-unit or per-user fees, and most of what they sell is designed for portfolios ten times your size.

What actually keeps a small portfolio running is a spreadsheet, and yours probably exists already. What it needs is a way for tenants to file requests without texting your personal phone, a board per building, and a pipeline view for turnovers. AI can build all three on top of the sheet, without moving a single row anywhere.

Step 1: Start With Your Units-and-Work Sheet

One row per piece of work — a repair, a turnover step, an inspection:

Turnover steps get their own rows — "Paint unit 12," "Photos unit 12" — with Type set to Turnover, so a vacancy becomes five trackable rows instead of one vague to-do.

Step 2: Make a Free Account

Register at lovespreadsheets.com — its free tier builds and runs everything below, while paid adds logins for your maintenance tech or assistant plus a custom web address, worth considering once tenants use the intake link daily.

Step 3: Describe How Work Flows Through Your Buildings

Grab the Project Tracker template and set down your operation as if training a new assistant manager:

• "A maintenance request moves New → Scheduled → Vendor on site → Done, and the tenant should never have to call twice to keep it moving."
• "A turnover is a fixed sequence — clean, paint, repairs, photos, listed — and the whole sequence is late if any step is."
• "Anything touching a lease date — renewals, notices, inspections — gets scheduled off the sheet, not off my memory."

Then request:

• A tenant intake form — a link tenants use to report issues; each submission lands in the sheet as a new row with unit, description, and date filled in
• Per-building boards — Maple, Birch, and Oakview each as their own board, because buildings are how you drive your day
• A turnover pipeline — every vacant unit shown at its current stage with days-vacant counting, so the unit stuck at "paint" for a week has nowhere to hide

AI Optimize will firm up a loose description, the AI might ask you to pin down a detail or two, and the build needs somewhere between 15 and 20 minutes.

Step 4: Three Buildings, Zero Guesswork

The build hands you a web app: today's jobs by building, open requests by age, turnovers as a pipeline, and a calendar carrying due dates and lease deadlines. Update a status from your phone in the Maple St basement and the sheet has it before you're back in the truck; your assistant edits the sheet at the office and your view refreshes to match. The sheet remains the one true record — the app is just the fast way in and out of it.

Why Property Managers Keep the Sheet

Owners get reports without homework. Monthly owner updates are a filter and an export — every repair, cost note, and turnaround time for their building, straight from rows you already keep.

History defends you. When a tenant disputes how long a repair took, the row shows reported date, scheduled date, and completion. Documentation beats recollection.

The price doesn't scale against you. Platform pricing grows with doors or seats. Your sheet doesn't care whether you run forty-one units or ninety.

Common Questions from Property Managers

Do tenants need accounts to submit requests? No — the intake form is just a link. Tape the QR code in the laundry room, and the 11 p.m. "my heat is out" text becomes a row with a timestamp.

Can my maintenance tech see only his jobs? Yes — request a tech view filtered to assigned work, with statuses he can tap from his phone between jobs.

Emergency versus routine — can it triage? Put a priority field on the intake form and ask that anything marked Emergency emails you immediately while routine items queue normally.

Build Yours

Open the spreadsheet that already knows your buildings — or set up the eight columns above during one quiet hour — then head over to lovespreadsheets.com and explain how a leak becomes a closed ticket and a vacancy becomes a lease. The next request will still come in at 11 p.m. It just won't come to your personal phone.