Tidy Doors guides

Rental Property Expense Tracker Spreadsheet: What to Include and How to Set It Up

By Tidy Doors · General information for US landlords, not tax advice

If you own one to a few rental properties, you probably don't need property-management software. You need a place to write down every dollar that comes in and goes out, and a way to see the totals per property when tax season arrives. A well-built rental property expense tracker spreadsheet does exactly that, in a file you control, without a monthly fee.

This guide covers what a good tracker should include, the columns that matter, how to set up categories that line up with your tax return, and the mistakes that tend to cause problems in March. You can build your own from scratch with the steps below, or start from a template.

Why a spreadsheet works well for small landlords

Spreadsheets get a bad reputation because many of them are a single tab of numbers that nobody can follow a year later. A structured spreadsheet is different. For a landlord with a handful of units, it has real advantages:

• You own the data. It lives in your Google Drive or on your computer, not in an account you might cancel.
• It's flexible. If you need a column for a unit number or a note about a tenant, you add one.
• It's cheap or free. Excel or Google Sheets is usually all you need.
• It's transparent. You can click any total and see exactly which entries it adds up.

The trade-off is that a spreadsheet won't connect to your bank or collect rent for you. You (or someone helping you) type or paste in each entry. For most small landlords, that's a few minutes a week.

The five tabs every rental tracker needs

A tracker that is easy to keep up with separates entering data from reporting it. You type into a small number of logs, and everything else is calculated.

1. Properties

One row per property: a short nickname (for example, "Elm St Duplex"), the address, the property type, the number of units and the expected monthly rent. If you rent part of the year or use a property yourself, add columns for fair rental days and personal use days, because Schedule E asks for both.

The nickname matters more than it looks. Every income and expense entry will point to it, so keep it short and unique.

2. Income log

One row per payment received. Useful columns:

Column	Why it's there
Date	When you received the money
Property	Which property it belongs to (pick from a dropdown)
Income type	Rent, late fee, pet fee, deposit kept, other
Tenant / payer	Who paid
Amount	What you received
Method	Check, bank transfer, payment app, cash
Notes	Anything you'll want to remember

Keep refundable security deposits in their own income type so they don't get counted as rent. More on that below.

3. Expense log

One row per expense:

Column	Why it's there
Date	When you paid
Property	Which property it belongs to
Category	What kind of expense (see the next section)
Vendor / payee	Who you paid
Amount	What you paid
Method	How you paid
Receipt saved?	Yes / No, so you can chase missing receipts later
Notes	For example, "kitchen faucet, unit B"

That "Receipt saved?" column is simple, but it's one of the most useful habits you can build. At year-end you can filter for "No" and fix the gaps while you still remember what each charge was.

4. Monthly summary

Income, expenses and net income for each month, for one property or all of them. Add an expense ratio (expenses divided by income) so you can spot a month, or a property, that is eating more than its share.

5. Year-end summary

Totals for the year, per property, organized the same way as the tax form you'll file. For most US landlords who own rental real estate directly, that form is Schedule E (Form 1040), Part I. When your summary follows the same line order, handing numbers to a tax preparer, or typing them into tax software, is mostly copying.

Use expense categories that match Schedule E

The single biggest time-saver is choosing your expense categories once, based on the lines of Schedule E, instead of inventing them as you go. On the 2025 Schedule E, the expense lines are:

Line	Category	Examples
5	Advertising	Listing sites, signs
6	Auto and travel	Mileage or actual car costs for rental trips
7	Cleaning and maintenance	Cleaning, lawn care, pest control
8	Commissions	Leasing agent or booking commissions
9	Insurance	Landlord or hazard policy
10	Legal and other professional fees	Tax prep, attorney, eviction filing
11	Management fees	Property manager
12	Mortgage interest paid to banks, etc.	Interest from Form 1098 (not principal)
13	Other interest	Other loans used for the rental
14	Repairs	Fixing a lock, repainting a room
15	Supplies	Light bulbs, filters, small items
16	Taxes	Property taxes
17	Utilities	Utilities you pay
18	Depreciation expense or depletion	Annual figure, often from Form 4562
19	Other	HOA dues, bank fees, software

Add one more category that is not a Schedule E expense line: Capital improvement. Keep it out of your expense totals (more on why below).

Line names and numbers can change from year to year, so check the current Schedule E instructions on irs.gov when you set up a new year's file.

Four things that trip up landlord spreadsheets

Repairs vs. improvements

A repair keeps the property in its normal working condition: fixing a leak, replacing a broken window pane, repainting a room. An improvement makes it better, restores it or adapts it to a new use: a new roof, an addition, a full kitchen remodel. In general, repairs are deducted in the year you pay for them, while improvements are added to the property's basis and depreciated over time. IRS Publication 527 explains the difference in more detail.

In a spreadsheet, the practical move is a separate Capital improvement category that is tracked but not added to your deductible expense total. Your preparer can then decide how each one should be handled.

Security deposits

A refundable security deposit you expect to return is generally not income when you receive it. If you keep some or all of it (for damage or unpaid rent), the amount you keep generally is income. If a deposit is applied as the final month's rent, it is treated as rent. Use two separate income types, "deposit held" and "deposit kept," and exclude the first from your rent totals.

Mortgage payments

Your monthly mortgage payment usually mixes principal, interest and sometimes escrow for taxes and insurance. Only some of those pieces belong in expense categories. A common approach is to log the interest from your year-end Form 1098 under Mortgage interest, and log property taxes and insurance under their own lines when they're paid from escrow. Principal is not a rental expense.

Shared costs

If one insurance policy or one invoice covers two properties, split it: enter one row per property with that property's share. That keeps every property's totals honest.

Building it yourself: the formulas that do the work

If you'd like to build your own tracker, the core is one function: SUMIFS. It adds up the amounts that match more than one condition, and it works the same way in Excel and Google Sheets.

For example, to total repairs for the property in cell B2, assuming your expense log is on a tab called Expenses with property in column C, category in column D and amount in column G:

=SUMIFS(Expenses!G:G, Expenses!C:C, B2, Expenses!D:D, "Repairs")

To get a single month's total, add date conditions:

=SUMIFS(Expenses!G:G, Expenses!C:C, B2,
        Expenses!B:B, ">="&DATE(2026,1,1),
        Expenses!B:B, "<"&DATE(2026,2,1))

A few tips that make a homemade tracker more reliable:

• Use dropdowns (data validation) for property, category and income type. Typos like "Elm St" vs. "Elm Street" are the most common reason totals don't add up.
• Add a check cell that totals any entries with a blank property or category. If it isn't zero, something isn't being counted.
• Protect or shade formula cells so they don't get typed over.
• Use one file per tax year. It keeps formulas simple and gives you a clean record to archive.

Keep it up

The best tracker is the one you actually update. For a weekly, monthly and year-end routine, see How to Track Rental Income and Expenses for Taxes.

When a spreadsheet isn't enough

A spreadsheet is a good fit if you have a small number of units and keep your own books. It may not be the right tool if you need online rent collection, tenant screening, maintenance requests, or bank feeds that categorize transactions for you, or if your portfolio has grown past what you can comfortably update by hand. At that point, software or a bookkeeper may be worth the cost.

A ready-made option

---

Not tax advice. This article is general information for US landlords and is not tax, legal or financial advice. Line names follow the 2025 Schedule E (Form 1040) instructions and IRS Publication 527; tax rules change and depend on your situation. Confirm with a qualified tax professional before you file.

← All guides