Rental Income & Expense Spreadsheet: Getting Income Right and Building a Per-Unit P&L

Ask most landlords how their expenses break down and they can tell you roughly — mortgage, insurance, the plumber they keep calling. Ask the same landlords how their income breaks down and the answer is usually just "rent." That asymmetry isn't an accident: expenses are where the tax deductions live, so people build careful categories for them, while income feels like it takes care of itself — the rent either shows up or it doesn't. It doesn't take care of itself. A late fee that never gets logged, a pet fee that gets folded into "rent" instead of tracked separately, a partial payment nobody flagged as short — none of these break anything immediately, but they're exactly the kind of gap that turns into a confusing bank balance six months later. This guide is about fixing the income side specifically, and then using it to build something most rental spreadsheets skip entirely: a profit-and-loss view for each individual property, not just the portfolio as a whole.

What actually counts as rental income

Monthly rent is the obvious line, but a complete income picture usually needs a small handful of categories beyond it. Late fees, charged when rent arrives past the due date, deserve their own category rather than getting lumped into rent — they tell you something rent alone doesn't: how often a specific tenant or property is running late. Pet fees or pet rent, where you charge them, are the same story. And a general "Other Income" catch-all covers the occasional oddball — a coin-op laundry machine's take, a lease-break settlement a departing tenant pays to exit early, an insurance payout covering lost rent during a repair.

A security deposit is a different animal and worth being precise about: it isn't income when you receive it, because you're generally expected to return it. It only becomes income — if it becomes income at all — for whatever portion you keep after a tenant moves out, and whether that's taxable and how it should be recorded depends on rules that vary by where you are. That's a question for a qualified accountant, not a spreadsheet category, so don't log a deposit as income the day it arrives.

Logging income by the row, not by the month

The habit that keeps an income log useful is the same one that keeps an expense log useful: one row per actual event, not one row per month with a lump sum typed in. Every rent payment, every late fee, every odd bit of income gets its own row with a date, the property it belongs to, a category, an amount, and a note if anything's unusual about it. That granularity is what lets you answer questions a lump sum can't — was this month's rent from Unit B actually on time, or two weeks late and you just didn't notice because the total looked right?

Partial payments are the case that trips people up. Log the amount that actually arrived, not the amount that was supposed to. If a tenant owes $1,200 and pays $900, the row reads $900, dated to when it landed — not $1,200 with a mental note that it's "basically paid." The $300 gap isn't something a simple income log calculates automatically; it's something you catch by comparing what your tenant log says is owed against what your transaction log shows arriving, which is one more reason those two logs should share the same property names and stay easy to cross-reference.

From one log to a per-unit profit and loss

Here's where logging by property pays off. If every income and expense row carries a Property tag alongside its Type and Category, you already have everything needed to build a small table that answers a much better question than "did I make money this year" — it answers "which property made money, and which one didn't." For each property: sum every row tagged Income for that address, sum every row tagged Expense for that address, and subtract. Income minus expenses, per property, is a per-unit profit and loss — the same arithmetic as your portfolio total, just grouped one more way.

That one extra grouping surfaces things a single combined total hides completely. Two properties can produce an identical combined net cash flow while one of them is comfortably profitable and the other is bleeding money every month, propped up by the first. A portfolio-level number can't show you that; a per-property table shows it immediately, and it's the number worth checking before you consider buying a third property, refinancing, or raising rent on a specific unit rather than across the board.

What a per-unit P&L doesn't replace

A per-unit P&L tells you what a property earned and spent over a period. It doesn't tell you whether the property was a good purchase in the first place — that's a return-on-investment question, using your purchase price and financing alongside the same income and expense numbers, and the rental property ROI calculator runs cap rate and cash-on-cash return from those figures. It also doesn't replace a proper expense category breakdown — for the full eleven-category expense list, the tenant and lease log, and the monthly routine that ties all three logs together, see the rental property expense tracker guide. And it won't tell you why maintenance costs on one unit keep climbing — that pattern lives in a dedicated maintenance log, covered in the rental property maintenance log guide, with its own categories and an Open-vs-Completed item count. If you're deciding between a long-term tenant and furnishing a unit for short-term rental, the Airbnb vs long-term rental calculator compares both scenarios on the same property.

A simple starting point, and where it stops being enough

If you just want to get in the habit of logging money in and money out before building anything property-specific, the free income & expense tracker on this site is a reasonable place to start — it's a flat log with a Type and eight generic categories covering both income and expenses. Worth knowing plainly: it doesn't have a Property column, so it can't produce a per-unit breakdown on its own. It's fine for a single rental or for getting the logging habit started; the moment you're tracking more than one property and want the per-property split described above, you need that structure built in, not bolted on afterward.

Keeping the income side honest

The same monthly discipline that keeps expenses accurate applies to income: work down your bank statement line by line and log every deposit, rather than trusting memory for whether a particular tenant paid this month. A few minutes spent reconciling the income log against what actually hit your account catches a missed rent payment, a late fee that should have been charged and wasn't, or a deposit logged under the wrong property — all small errors on their own, all the kind that compound quietly across a year if nobody's checking. Do this consistently, and the per-unit P&L stops being a periodic exercise and becomes a live, trustworthy number you can glance at any time.

What this doesn't cover

This is a guide to organizing rental income and building a per-property view of profit, not a guide to what's taxable, how a security deposit should be treated, or how depreciation applies to a rental property. Those depend on rules that vary by where you live and how the property is held, and no spreadsheet or article can tell you the answer for your situation. Keep clean, organized, per-property records and bring them to a qualified accountant for anything involving what you actually owe.