Where can I get templates for the main property management tasks?

By Ranjit Bhinge, founder of Blur Studio · Updated · 6 min read

Short answer: Most small landlords and property managers need six sheets: a rent roll (one row per unit showing tenant, rent and lease dates), a monthly rent collection sheet, a maintenance log, a lease and renewal tracker, a security deposit ledger and an income and expense sheet for tax time. You can build each in Excel or Google Sheets in under an hour with the columns below. They work well up to a few dozen doors. After that, or when owners and tenants need their own logins, a property management system or a small custom app does the job better.

Ranjit Bhinge

You want ready-to-use sheets for rent, repairs and leases, and a clear sign of when a spreadsheet stops being enough.

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 six sheets most landlords need

I prefer to give you the columns and let you build the sheet yourself. A downloaded template often has fifteen tabs you never use, and you end up fighting it. Start with these six, one tab each, in one workbook. Excel is Microsoft's spreadsheet program. Google Sheets is the free web version from Google. Everything here works in both. For tools that record the inspection, see move-out inspection software.

If you want a ready-made pack to browse first, Smartsheet, a work-management tool built around spreadsheet-style grids, offers a page of 18 free property management templates, including checklists, receipts and management agreement forms. I would still build the tracking sheets yourself, because you will know what every column means.

1. Rent roll

A rent roll is a list of every unit with who lives there, what they pay and when the lease ends. It is the one sheet a lender, an owner or a buyer will ask for first.

Columns: property, unit, tenant name, lease start, lease end, monthly rent, security deposit held, status (occupied, vacant, notice given), and market rent. The gap between rent and market rent shows where you are under-charging.

Tip: keep one row per unit, never one per tenant. When a tenant moves out, change the status and start a new row of history on another tab.

2. Monthly rent collection sheet

This is the sheet you open every day in the first week of the month. Use one tab per month, copied from the last.

Columns: unit, tenant, due date, rent due, grace days, amount paid, date paid, method, late fee, balance, status, last contact and promised payment date.

A status formula saves manual checking: =IF(F2>=D2,"Paid",IF(TODAY()<=C2+E2,"In grace","Late")) if your columns match the list above (due date in C, rent due in D, grace days in E, amount paid in F). My rent collection process guide explains the full monthly timeline and what to do with the Late rows.

3. Maintenance log

A maintenance log tracks each repair request from the day it arrives to the day it is closed. Property managers call each request a work order, which is simply a job ticket for a repair.

Columns: request number, date received, property, unit, tenant, problem, urgency (emergency, urgent, routine), assigned vendor, date scheduled, date completed, cost, who pays (owner or tenant), owner approval needed (yes or no) and notes.

Tip: add an approval limit per owner, for example $300, and a column that flags any job over it. Owners do not mind spending money. They mind being surprised. For a signature-ready version of the paperwork, see my work order template.

4. Lease and renewal tracker

You do not want to learn a lease ended last week. This sheet puts every end date in one place.

Columns: unit, tenant, lease end, days left, renewal offer sent (date), new rent offered, tenant response, new lease signed (date). Days left is =C2-TODAY() if the lease end is in column C.

Color rows red under 60 days and orange under 90 using conditional formatting, a spreadsheet feature that changes a cell's color when it meets a rule. Google explains how in its help page on conditional formatting. Begin renewal talks at 90 days. That leaves time to re-rent if the tenant says no.

5. Security deposit ledger

A security deposit ledger records what each tenant paid as a deposit, where it is held, and what was returned or kept. Many states set rules for where deposits are held and how fast they must be returned, so check your state's rules or ask a local attorney.

Columns: unit, tenant, deposit amount, date received, where held (bank account name), move-out date, deductions with reasons, amount returned, date returned and return method. Attach photos or the move-out checklist for any deduction. My move-in and move-out checklist is built for this.

One tax note from the IRS: you generally do not count a security deposit as income when you receive it if you plan to return it. If you keep part of it because the tenant broke the lease, you count that part as income in the year you keep it. A deposit that is really the last month's rent is advance rent, and you count it when you receive it (see IRS Publication 527).

6. Income and expense sheet

This sheet feeds your tax return. Landlords report rental income and expenses on Schedule E of Form 1040, the IRS form for rental real estate income and loss.

Columns: date, property, category (repairs, insurance, mortgage interest, property tax, utilities, management fees, advertising, other), payee, amount, income or expense, receipt link and notes. Use a drop-down list for the category so no one types "repair", "repairs" and "Repairs" as three different things. Google shows how to build a drop-down list in a cell.

Ask your tax preparer which categories they want. For owner-facing reports built from this data, see the owner report guide and my note on property management tax reporting.

A filled-in rent roll row

Here are two rows with made-up figures for a small building:

UnitTenantLease endRentMarket rentDeposit heldStatus
2BA. Rivera2027-03-31$1,350$1,425$1,350Occupied
3A(vacant)none$0$1,500$0Vacant, turn in progress

From these two rows you can already see a $75 monthly gap on unit 2B and $1,500 a month of lost rent on 3A. Add a SUMIF formula at the bottom that totals rent for rows marked Vacant at market rent, and you have a live "rent we are losing" number.

Habits that keep a spreadsheet honest

  • One table per tab, one row per thing, one header row. No merged cells.
  • Drop-down lists for every status and category field.
  • Conditional formatting for anything with a deadline.
  • One person owns each sheet. Everyone else views it.
  • Back up weekly. Google Sheets keeps version history, but a copy to another folder is cheap insurance.
  • Never store social security numbers or bank account numbers in a shared sheet.

When a spreadsheet should become software

I would move off sheets when any of these are true:

  • More than one person edits the same sheet and you find conflicting versions.
  • Owners or tenants need their own login to see their own numbers.
  • You type the same payment or tenant detail in two places.
  • You spend more than a few hours a month copying numbers into reports.

The first step up is usually software built for the job. TurboTenant, a landlord platform, has a free plan that covers online rent collection. DoorLoop, property management software, starts at $2.50 per unit per month on yearly billing ($3.00 monthly) with a minimum spend and a minimum number of units, as of November 2026. See my property management software guide and cost guide. If your process is unusual and no tool fits, the second step is a small custom app that keeps your sheet's logic but adds logins and automatic updates. I explain the idea in turning an Excel sheet into a web app and turning a spreadsheet into a dashboard.

How I'd approach this

Build the rent collection sheet and the rent roll first. Those two give you the most value for the least work. Add the maintenance log in month two, once you see how many requests you really get. Do not build all six in a weekend and then abandon them.

Give every sheet one owner and a fixed time to update it, for example Friday afternoon. A sheet that is two weeks stale is worse than none, because people trust it. And review any notice, lease or agreement you pull from a template with a local attorney, because state rules differ. Tracking sheets for rent and repairs do not carry that weight, but notices and leases do. If you are already hitting the "when to move on" list above, a short call with me will tell you whether software or a small custom app fits better.

Questions people ask

Where can I get free property management templates?

You can build the main ones yourself in an hour using the columns on this page. Start with a rent roll, a rent collection sheet and a maintenance log. Smartsheet also offers a page of 18 free generic property management templates you can adapt. For a signature-ready paperwork set, see my property management agreement template.

What is the best property management Excel template?

The best one is the one your team keeps up to date. Use one table per workflow, drop-down lists for status fields and conditional formatting for deadlines. A simple sheet you maintain beats a complicated one you ignore.

Is there a monthly rent collection spreadsheet template?

Build one with a row per unit and columns for rent due, grace days, amount paid, date paid, late fee, balance and status. A status formula can mark each unit Paid, In grace or Late. The exact formula is in my rent collection process guide.

When should I stop using a spreadsheet?

Stop when several people edit it at once, when owners or tenants need their own login, or when you type the same data twice. Check whether a ready-made property management tool covers it first, then consider a small custom app. See Excel to web app.

Do I need a lawyer to review templates?

Have an attorney in your state review any notice, lease or agreement, because landlord-tenant rules differ by state. Tracking sheets for rent, repairs and leases do not carry the same legal weight, but keep them accurate.

More in this topic: US property management: running the business (17 guides) →

Sources

Ready for the next step?

A 30 minute call. If you do not need me, I will tell you.

Ranjit Bhinge You talk to me, Ranjit. I reply within a few hours.

Not sure what you need? Tell me what is going on. I will point you the right way, even if it is not me.

Blur Studio · 30 minute call

Book a 30 minute call

You talk to me, Ranjit. If you do not need me, I will tell you.

  • We talk about your business and what is going on.
  • You leave with a clear next step, even if it is not me.
  • I reply to every message within a few hours.
Loading the calendar…