Is there a ready-made property management workflow template I can use with my team?
Short answer: Yes, and you can build one in about an hour. Use one tab per workflow in Excel (Microsoft's spreadsheet program) or Google Sheets (Google's free spreadsheet). Give every tab the same base columns: record, property, person, step, status, owner, due date and notes. Add drop-down lists for status and step, and a color rule that turns overdue rows red. This works well up to a few dozen open items. Past that, the sheet starts to need a real system.
You want a set of sheets and checklists your team can use tomorrow to stop losing track of applications, repairs, renewals and move-outs.
I'm Ranjit, and I run Blur Studio: 15+ years building software, 120 apps taken live, and clients who have gone on to raise $10M+. I build AI systems and processes that help businesses do a lot more with a lot less time. I also work differently from most of what else is out there, more on that further down this page. Say hello.
The base sheet every workflow shares
Make one tab per workflow. Use the same columns on each so your team learns one layout. Put the column headings in row 1, and freeze that row so it stays visible.
| Column | What goes in it |
|---|---|
| Record ID | A short unique code, such as L-0412 for a lease or WO-1187 for a work order |
| Property and unit | Address and unit number |
| Person | Tenant, applicant, owner or vendor name |
| Step | Where this record is now (a drop-down) |
| Status | Not started, In progress, Waiting on someone, Done (a drop-down) |
| Owner | The one staff member responsible for the next step |
| Next due date | The date the next step is due |
| Notes | One line: what you are waiting for |
Keep a separate tab called Lists. It holds the allowed values for Step and Status, one list per column, with no blank cells. Do not store tenant Social Security numbers, bank details or full ID scans in a sheet. Keep those in a system built to hold them.
Set up drop-downs and the overdue color
In Excel: select the Status cells, open the Data tab, choose Data Validation, set Allow to List, and point the Source at the Status list on your Lists tab (leave out the header cell). Microsoft also suggests keeping the list in an Excel table, so drop-downs update when you add entries. For colors, use Home, then Conditional Formatting, then Manage Rules, and choose "Use a formula to determine which cells to format." Microsoft's page shows a date rule in the same style, =B2<TODAY()+60, which flags dates less than 60 days away. In our sheet, if Next due date is in column G and Status is in column E, a rule like =AND($G2<TODAY(),$E2<>"Done") applied to the whole row turns late, unfinished rows red.
In Google Sheets: select the cells, go to Insert, then Dropdown, and set the criteria to a range, pointing at your Lists tab. For colors, use Format, then Conditional formatting, set "Format cells if" to "Custom formula is", and enter the same style of formula. Click Done.
Share the sheet with edit access for staff only, and keep a read-only copy for owners if you want them to see status.
Template 1: Leasing
Steps list: Inquiry, Showing booked, Application received, Screening, Decision, Lease sent, Lease signed.
Extra columns: Lead source, Showing date, Application date, Screening complete (Yes or No), Decision date.
Checklist for each applicant:
- Written screening criteria sent with the application.
- The same criteria applied to every applicant for the unit.
- Decision date and reason noted, in plain facts tied to the criteria.
The Fair Housing Act, per HUD, prohibits housing discrimination because of race, color, national origin, religion, sex, familial status and disability. Check whether your state or city protects more groups. A sheet does not make a decision safe, so check your state's rules or ask a local attorney. For documents you can reuse, see property management templates.
Template 2: Move-in
Steps list: Lease signed, Deposit and first rent received, Disclosures given, Condition report signed, Utilities confirmed, Keys released.
Checklist:
- Deposit amount and date received.
- First month's rent received and posted.
- Required disclosures given and signed (see the lead paint line below).
- Move-in condition report signed and dated, with photos.
- Smoke and carbon monoxide alarm check noted, if your state or city requires it.
- Keys, fobs and garage openers counted.
For most housing built before 1978 (the EPA lists some exceptions, such as zero-bedroom units), the EPA requires landlords and property managers to give specific information about known lead-based paint and hazards before the renter signs, including a Lead Warning Statement in the lease, and says to keep signed copies of the disclosures for three years after the lease begins. Add a column "Lead disclosure signed (date)" so you can see gaps at a glance. See which lead paint form to use and the move-in and move-out checklist with tenant signature.
Template 3: Rent and late follow-up
Steps list: Due, Reminder sent, Paid, Late notice sent, Payment plan agreed, Escalated.
Extra columns: Amount due, Amount paid, Days late, Last contact date.
Days late can be a formula: =MAX(0,TODAY()-G2) where G is the due date. Your lease and your state's rules set when a late fee may be charged and how much, so do not hard-code a fee from a template. Put the lease terms into a note, and ask a local attorney if unsure. For reminder wording, see rent reminders and renewal outreach.
Template 4: Maintenance
Steps list: Request received, Triaged, Vendor assigned, Scheduled, Work done, Bill received, Bill approved, Closed.
Extra columns: Urgency (Emergency, Soon, Routine), Vendor, Cost limit, Tenant told (date), Photos link, Invoice amount.
Two rules that save money: set a cost limit before the vendor starts, and do not close a request until the bill is approved.
Template 5: Renewals
Steps list: 90 days out, Market rent reviewed, Offer sent, Answer received, Renewal signed, Moving out.
Extra columns: Lease end date, Current rent, Offered rent, Date offer sent.
Set a formula for the 90-day mark: =F2-90 where F is the lease end date. This mirrors the example AppFolio gives for its renewal flow, which starts at the 90-day mark before a lease ends. Check your state's notice rules for rent increases and non-renewals, since required timing varies. For bulk sending, see sending 100 renewals at once.
Template 6: Move-out
Steps list: Notice received, Inspection booked, Inspection done, Charges listed, Deposit settled, Unit relisted, Owner told.
Extra columns: Notice date, Move-out date, Deposit held, Deductions, Date deposit returned.
Add a "Return by" column and fill it from your state's deadline, which you should confirm on your state's official page or with a local attorney. Color the row red when that date is close.
A filled-in example with made-up data
This is a maintenance row with invented values.
| Record | Property | Person | Step | Status | Owner | Next due | Notes |
|---|---|---|---|---|---|---|---|
| WO-1187 | 214 Elm St, Unit 3 | J. Rivera (tenant) | Vendor assigned | Waiting on someone | Dana | 2026-11-14 | Plumber quoted $340, limit $400. Waiting for visit time. |
If today is November 16 and Status is still not Done, the color rule turns the row red. Dana sees it, calls the plumber, and updates the note. That is the whole system: one row, one owner, one date.
When the sheet stops working
A sheet starts to fail when several people edit it at once, when you need the tenant or owner to see their own status, or when you copy the same data into three places. Property management software such as Buildium (a property management system for small and mid-size managers) offers Workflow Automations that run steps on triggers, and AppFolio (a cloud property management system) has Realm-X Flows, a workflow tool with templates for rent collection and lease renewals. As of November 2026, Buildium shows plans from $65 a month and AppFolio shows Core from $1.49 per unit per month with a 50-unit minimum. If your process is unusual, a small web app built from your sheet can be a better step; I explain that in turning an Excel sheet into a web app. For the process behind these sheets, read property management workflows mapped.
How I'd approach this
Start with one tab, not six. Pick the workflow that leaks the most, probably maintenance or renewals, and use it for two weeks. Count how many rows went red and why. That count tells you what step is missing or who is overloaded.
Then add the next tab. Keep the base columns the same so nobody has to relearn. When you hit the point where people paste data between tabs or ask for a login for owners, that is the signal to move to software or a small custom tool. Do that move on purpose, with your sheets as the specification. They already describe your process better than any sales demo will.
Questions people ask
Is there a free property management workflow template?
You can build one in an hour. Use one tab per workflow with columns for record, property, person, step, status, owner, due date and notes. Add drop-downs and a rule that colors overdue rows. The templates above give the steps for six workflows.
How do I make a property management workflow template in Excel?
Create a table and add the base columns. Put your step and status lists on a separate tab. Use Data, then Data Validation, set Allow to List, and select the list as the Source. Then use Home, Conditional Formatting, and a formula rule to color late rows.
How do I make a property management workflow template in Google Sheets?
Use Insert, then Dropdown, for the step and status columns. Use Format, then Conditional formatting, then "Custom formula is", to color late rows. Share the sheet with edit access for staff only.
Which workflows should I template first?
Start with the one that causes the most late work, often maintenance or renewals. Then add leasing, move-in, rent follow-up and move-out. See the workflow map for how they connect.
When should I move from a spreadsheet to software?
When several people edit at once, when owners or tenants need their own login, or when you copy the same data into three places. See Excel to web app for one path.
More in this topic: US property management: running the business (17 guides) →
Sources
- Microsoft Support: Create a drop-down list
- Microsoft Support: Use conditional formatting to highlight information in Excel
- Google Docs Editors Help: Add a drop-down list to a cell
- Google Docs Editors Help: Use conditional formatting rules in Google Sheets
- EPA: Real estate disclosure of lead-based paint
- HUD: Fair Housing Act overview
- AppFolio: Realm-X Flows
- Buildium: Workflow Automations