> ## Content Index
> Fetch the complete content index at: https://landlordsheet.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to Set Up a Rental Property Expense Tracking Spreadsheet (That You'll Actually Keep Up With)
- URL: https://landlordsheet.com/rental-property-expense-tracking-spreadsheet/
- Published: 2026-10-05T14:00:00.000Z
- Updated: 2026-10-16T13:53:22.000Z
- Description: The columns, categories, and 10-minute monthly habit that turn a messy shoebox of receipts into a clean, tax-ready rental ledger.
- Author: Jon
- Tags: Bookkeeping, Spreadsheets, Taxes

If you own one to twenty rental units and do your own books, you don't need expensive property management software. A well-built spreadsheet does the job if two things are true: it's organized around the categories your tax preparer actually needs, and it's simple enough that you'll update it every month.

This guide walks through how to set one up from scratch: which columns to use, which categories to pick, and the habits that keep it accurate. If you'd rather skip the setup, the [free single-property tracker](#/portal/signup) and the [bookkeeping workbook](https://payhip.com/b/IJ4pL?ref=landlordsheet.com) in [the Toolkit](https://landlordsheet.com/toolkit/) are already built this way.

> **Not tax or legal advice.** This article is general education for DIY landlords. Tax rules change and depend on your situation, so confirm anything important with a qualified tax professional.

## Why a spreadsheet beats a shoebox (and often beats software)

Most small landlords end up in one of two camps. Some keep receipts in a folder and rebuild the year in a panic every March. Others sign up for software, use it for two months, and drift away because it does far more than they need.

A spreadsheet sits in the sweet spot:

- **You own the data.** No subscription, no export headaches, no lost history if a company changes its pricing.
- **It's transparent.** You can see every formula and every number. When your preparer asks "where did this figure come from?", you can show them.
- **It scales to about 20 units.** Beyond that, dedicated software starts to earn its keep. Below that, a clean workbook is usually enough.

## Step 1: Separate your money first

No spreadsheet can fix commingled money. Before you build anything, open a **separate checking account for your rentals** (one per property or LLC if your attorney or CPA recommends it). Run all rent deposits and all rental expenses through it.

This one habit does more for clean books than any template. Your bank statement becomes a second record that should match your spreadsheet line by line.

## Step 2: Choose your columns

Every transaction gets one row. Here are the columns that matter:

| Column        | What goes in it                      | Why it matters                                           |
| ------------- | ------------------------------------ | -------------------------------------------------------- |
| Date          | Date the money moved                 | Needed for the tax year and for matching bank statements |
| Property      | Address or short nickname            | Schedule E is reported per property                      |
| Type          | Income or Expense                    | Keeps totals clean                                       |
| Category      | One of your fixed categories (below) | Maps to Schedule E lines                                 |
| Payee / Payer | Who you paid or who paid you         | Audit trail                                              |
| Description   | "Replaced kitchen faucet, Unit B"    | Helps you split repairs from improvements later          |
| Amount        | Positive number                      | Totals by category                                       |
| Method        | Check #, ACH, card                   | Matching against the bank                                |
| Receipt?      | Yes/No, or a link to the scan        | Proof if you're ever asked                               |

Resist the urge to add twenty more columns. Every extra field is one more reason to put off updating it.

## Step 3: Use categories that match Schedule E

Individual landlords in the U.S. generally report rental income and expenses on **Schedule E (Form 1040)**, Part I. The IRS's own form gives you a ready-made category list, so use it rather than inventing your own:

**Income:** Rents received (and royalties, which most landlords won't have).

**Expenses (Schedule E lines 5–19):** Advertising; Auto and travel; Cleaning and maintenance; Commissions; Insurance; Legal and other professional fees; Management fees; Mortgage interest paid to banks; Other interest; Repairs; Supplies; Taxes; Utilities; Depreciation expense or depletion; Other.

Set these up as a **dropdown list** (Data Validation in both Excel and Google Sheets) so every entry lands in exactly one bucket. Free-typed categories ("repair", "Repairs", "fix") are how spreadsheets fall apart.

We cover each line in detail in [Schedule E Categories for Landlords, Explained](https://landlordsheet.com/schedule-e-categories-for-landlords/).

### Add a "capital improvement" category, too

Not everything you spend goes straight onto Schedule E. A new roof, a full kitchen remodel, or a new HVAC system is generally a **capital improvement** that gets depreciated over time instead of deducted all at once. Track these in their own category (or a separate tab) so your preparer can set up depreciation. IRS **Publication 527, Residential Rental Property**, explains the difference between repairs and improvements.

## Step 4: Build a simple summary tab

Once transactions are categorized, a summary tab practically builds itself. In Google Sheets or Excel, a `SUMIFS` formula pulls totals by property and category:

```
=SUMIFS(Amount, Property, "Maple St", Category, "Repairs")

```

Lay the summary out with categories down the side and properties across the top, and you have something that looks almost exactly like the Schedule E your preparer will fill in. Add a row for **net income** (income minus expenses) per property and a column for the portfolio total.

Two more views worth adding:

- **Monthly cash flow by property**, so you spot a money-losing unit early instead of in April.
- **Year-over-year comparison**, so you notice when insurance or taxes jump.

## Step 5: The 10-minute monthly routine

The spreadsheet only works if you feed it. Pick a fixed day each month (the 5th works well, after rent comes in) and do this:

1. **Download your rental bank and card transactions** for the prior month.
2. **Paste or type each one** into the ledger and assign a category.
3. **Snap photos of any paper receipts** and save them to a folder named by year and month. Put the link or "Yes" in the Receipt column.
4. **Reconcile:** check that your spreadsheet's ending balance for the month matches the bank statement. If it doesn't, find the gap now while you still remember.
5. **Glance at the summary.** Anything surprising? Deal with it this month.

Ten minutes a month is roughly two hours a year, which is a lot less than the weekend you'd otherwise lose every spring.

## Step 6: Keep good records (and keep them long enough)

The IRS expects you to keep records that support your income and deductions. For rental property, that includes:

- Leases and rent records
- Receipts and invoices for expenses
- Closing statements from when you bought the property
- Records of improvements (they affect your basis)
- Mileage logs if you claim auto expenses

The IRS's general guidance on recordkeeping (see **Publication 583** and the "How long should I keep records?" page on IRS.gov) says to keep most records for at least as long as the period of limitations for that return. **Property records should be kept until that period expires for the year you sell or dispose of the property**, because your purchase and improvement costs determine your gain or loss. In practice, that often means keeping property records for as long as you own the property, plus several years.

## Common mistakes to avoid

- **Mixing personal and rental expenses.** That Home Depot run where you bought a rental faucet and a personal grill? Split it on the receipt and in the ledger.
- **Expensing improvements.** A new roof isn't a "repair." Flag it and let your preparer depreciate it.
- **Forgetting small cash expenses.** A $12 lock, a $30 cleaning supply run. They add up over a year.
- **Treating security deposits as income.** If you plan to return a deposit, it generally isn't income when you receive it (Publication 527 covers this). Track deposits on their own tab. See our [security deposit basics](https://landlordsheet.com/security-deposit-basics-for-landlords/).
- **Never reconciling.** A spreadsheet that doesn't match the bank is a guess, not a record.

## Spreadsheet vs. software: when to switch

A spreadsheet is a great fit when you have 1–20 units, simple ownership, and you're comfortable with basic formulas. Consider dedicated software (or a bookkeeper) if you have many entities, many units with frequent turnover, employees, or you just hate spreadsheets. There's no shame in either choice. The best system is the one you'll actually maintain.

## Get the template

If you want to skip the build:

- **Free:** the [single-property tracker](https://payhip.com/b/DORST?ref=landlordsheet.com). It has the columns and Schedule E dropdowns above, ready to fill in. [Subscribe here](#/portal/signup) and it lands in your inbox.
- **Paid:** the Multi-Property Rental Bookkeeping Workbook covers up to 20 properties, with a dashboard and mortgage tracker. See it in [the Toolkit](https://landlordsheet.com/toolkit/).

New here? [Start Here](https://landlordsheet.com/start-here/) is the fastest way to find the right tool for where you are.

### Save with a bundle

- [**Tax-Season Pack ($45)**](https://payhip.com/b/Ji5SI?ref=landlordsheet.com): [Buy the bundle →](https://payhip.com/b/Ji5SI?ref=landlordsheet.com)
- [**Complete Landlord Library ($89)**](https://payhip.com/b/Ta5id?ref=landlordsheet.com): [Buy the bundle →](https://payhip.com/b/Ta5id?ref=landlordsheet.com)

---

*This article is for general educational purposes and is not tax, legal, or accounting advice. Consult a qualified professional about your specific situation. — Jon, Everyone's Landlord*

### Tools that help with this

- [Rental Bookkeeping Workbook ($27)](https://payhip.com/b/IJ4pL?ref=landlordsheet.com)
- [Airbnb/STR Host Tracker ($19)](https://payhip.com/b/qgjYJ?ref=landlordsheet.com)

[**→ Download the free Single-Property Tracker**](https://payhip.com/b/DORST?ref=landlordsheet.com) (or [subscribe](#/portal/signup) and get it with the weekly email)