Rental Property Expense Tracker Spreadsheet: Rent, Tenants and Maintenance

Most landlords don't lose track of the big things — the mortgage payment, the annual insurance renewal. They lose track of the small ones: the $85 plumbing call that never got logged, the security deposit nobody wrote down the amount of, the lease that quietly expired two months ago because nobody was watching the date. None of those is a crisis on its own. Add them up over a year across two or three properties and they're the difference between knowing your numbers and guessing at them.

You don't need property management software to fix this. You need three simple logs — money, tenants, and maintenance — each with the right columns, tied together by one shared idea: every row belongs to a specific property. Here's how to set that up in a spreadsheet, and what to do with it once a month.

Three logs, not one

The temptation is to keep everything in a single sheet — one long list of "stuff that happened". Resist it. Rent payments, tenant details, and repair jobs have different shapes, different update frequencies, and different questions attached to them, and cramming them together makes all three harder to read. Split them into three purpose-built logs instead:

• An income & expense log — every dollar in and out, by property and category.
• A tenant & lease log — who's in each unit, what they pay, and when their lease ends.
• A maintenance & repair log — what broke, what it cost, who fixed it, and whether it's done.

Each one gets a Property column, using the exact same property names across all three, so you can always slice any of them by address. That's the whole trick — three focused sheets that share one key, rather than one sheet trying to be three things at once.

Income and expense categories that actually earn their place

Income is short. Most landlords need only four categories: Rent, Late Fees, Pet Fees, and an Other Income catch-all for anything like a laundry machine or a lease-break settlement. Don't overbuild this side — four categories is usually enough for the life of the spreadsheet.

Expenses need more room, because deductible costs come in more shapes than income does. An eleven-category list that covers a typical rental without becoming a maze:

Every category is a starting point, not a rule. Rename or add one the moment your properties need something the list above doesn't cover — a spreadsheet's whole advantage over off-the-shelf software is that you can do that in ten seconds.

The transaction log: one row per dollar

One row per payment or purchase, not one row per month or per property. The columns that matter: Date, Property, Type (Income or Expense), Category, Amount, and Notes. A single combined Category dropdown that lists both income and expense categories together works well in practice — you pick Type first, then pick whichever category matches from the same list, and you never need two different dropdown columns doing the same job.

From that one log, three numbers should update themselves without you touching a formula: total income, total expenses, and net cash flow — with the overall net cash flow figure flagged visually the moment it goes negative, so a loss shows up while it's still small enough to do something about. Break both income and expenses out by property and by category — a bar chart of income versus expenses per property, and a breakdown of where the expense money actually goes — and patterns jump out that a column of numbers hides: one property quietly running at a loss, or repairs eating a share of the budget that utilities never do.

Tenants and leases: the columns that prevent surprises

A tenant log needs: Property, Tenant Name, Lease Start, Lease End, Monthly Rent, Security Deposit, Status, and Notes. Status as a short dropdown — Active, Notice Given, Vacant — turns the sheet into a snapshot of occupancy at a glance, without anyone having to read every row.

The column worth building is a days-until-lease-end formula next to Lease End — today's date subtracted from the lease end date, recalculating on its own every time you open the file. Pair it with conditional formatting: amber inside 90 days, red once a lease is already past its end date. That's the difference between finding out a lease expired last month, from a tenant who's now paying month-to-month with no agreement in place, and getting a renewal conversation started three months out while you still have leverage and time.

From the tenant log, a small dashboard answers the questions you actually ask day to day: how many active tenants you have, your total monthly rent roll from active leases only, and how many leases fall inside that 90-day window right now.

Maintenance: where the real cost history lives

A single "Maintenance & Repairs" line in your expense log tells you how much you spent. It doesn't tell you on what, or whether the same problem keeps coming back. A separate maintenance log does both. Columns: Date, Property, Issue/Description, Category, Vendor/Contractor, Cost, Status, and Notes.

Categorize the issue, not just the cost — Plumbing, Electrical, HVAC/Heating & Cooling, Appliance, Structural/Roofing, Pest Control, Landscaping/Exterior, Cleaning/Turnover, and Other covers most rentals. Status as Reported, Scheduled, In Progress, or Completed keeps open jobs visible instead of forgotten in an email thread. Once you're logging by category, a spend-by-category breakdown and a spend-by-property breakdown both fall out automatically, and that's where the useful pattern shows up: a unit with three HVAC calls in eighteen months isn't unlucky, it's telling you the unit needs a system replacement budgeted, not another service call.

Handling more than one property

The Property column is what makes this scale past a single rental. Keep property names identical, character for character, across all three logs — a dropdown sourced from one settings list, rather than free-typed text, is what prevents "Main St" and "Main Street" from silently splitting one property's numbers into two totals. For most small landlords, somewhere up to eight properties is comfortably manageable this way before a dedicated system starts to look worth the switch; well below that, the three-log spreadsheet structure holds up fine.

Once every log carries the property key, a per-property cash flow table costs nothing extra to build — it's the same totals, grouped one more way. That's the number worth checking before you consider buying another property: is this specific address, on its own numbers, actually worth what you paid for it? Run your purchase price and current numbers through the rental property ROI calculator to see cap rate and cash-on-cash return side by side, rather than relying on a gut sense that the property "feels fine".

Furnished and short-term units need a different comparison

If you're weighing a long-term lease against furnishing a unit for short-term or Airbnb-style rental, the categories above still apply — the money still needs to go through Rent, Maintenance, Utilities, and the rest — but the comparison itself isn't something a category list settles. Occupancy rate, cleaning turnover cost, and platform fees change the math enough that the two paths rarely land where instinct says they will. The Airbnb vs long-term rental calculator runs both scenarios side by side on the same property so you're comparing real numbers instead of a hunch.

The monthly routine

Twenty minutes, once a month, is enough if the three logs are already set up:

1. Transactions (8 min): enter any rent payments and expenses you haven't logged yet. Bank and card statements are the fastest source — work down them line by line rather than trying to remember what happened.
2. Tenants (5 min): scan the days-until-lease-end column. Anything newly amber gets a renewal email this week, not next month.
3. Maintenance (5 min): update the status on anything open, and log the cost the moment an invoice comes in rather than letting a stack of receipts build up.
4. Numbers (2 min): glance at net cash flow by property. A property that's gone negative deserves five minutes of attention now, not a surprise at tax time.

None of this replaces professional advice on your specific situation — landlord-tenant law and what counts as a deductible repair versus a capital improvement both vary by location, so check anything you're unsure about with a qualified professional. What the routine above gives you is complete, organized records to bring to that conversation, instead of a shoebox.