#2 · Template

Landlord Income & Expense Tracker — Excel & Google Sheets Template for Up to 10 Properties

The rent comes in, the plumber gets paid, the insurance renews — and by the time someone asks what the year actually did, it lives in a bank app, a shoebox and your memory. Not because the numbers are hard, but because nobody wrote them down as they happened.

One-time purchase $24

Get the Tracker — $24

Works in Excel and Google Sheets. One payment, yours to keep.

A light spreadsheet listing page reading "Landlord expense spreadsheet — every dollar in and out" over a cyan rule and the line Excel plus Google Sheets. — Every dollar in and out, in one sheet.

What the file does

Landlord Income & Expense Tracker is where you write them down. You type each entry once — month, property, category, amount — and the file adds up your year while you use it: four headline numbers, twelve months, twelve expense categories and up to ten properties, each with its own column. It is a record you keep, and a clean year to hand to whoever prepares your return.

The number

The headline "What a landlord year kept" above a pale blue panel showing $26,205, with the line $114,975 in and $88,770 out beneath it. — In the example loaded in the file: $114,975 in, $88,770 out, $26,205 kept. Arithmetic on numbers someone typed in, not a typical result.

What's included

Seven tabs: Start Here · Setup · Income · Expenses · Summary · Summary Dark · The Numbers
Up to 10 properties, named once in Setup
150 income rows and 250 expense rows — one row per entry, month 1–12
2,011 cells you can type in — 11 in Setup, 750 in Income, 1,250 in Expenses
A worked example already loaded — Maple Street Duplex, Oak Ridge Single and Cedar Court Triplex, across a sample year — so nothing is ever blank
Four headline numbers: income · expenses · what you kept · the same before loan interest
Twelve expense categories, always the same: mortgage interest, property taxes, insurance, repairs, maintenance, utilities, management fees, advertising, legal and professional, supplies, travel, other
Four income types: rent · late fee · deposit kept · other income
Month by month, the twelve months with what came in
Where the money went, every category with its share of the year
By property, income, expenses and what you kept for each one
A dark Summary, the same view drawn on a dark background — a second tab, nothing to switch on
The Numbers, a tab that defines every figure, explains why you type property numbers instead of names, and says what the file cannot tell you
Works in Excel and Google Sheets, desktop and mobile
One payment. Yours to keep. No subscription

How it works

Name your properties in Setup
Once, at the start of the year.
Type each entry as it happens
One row in Income or Expenses: month, property, category, amount.
Read the Summary
Your year, added up, whenever you open it.

What you see before you pay

Every image below is a screenshot of the file itself, with the worked example that comes loaded in it.

A cropped screenshot of the Summary tab showing the twelve months with what came in each one. — Month by month, the twelve months with what came in.

A list of the seven tabs in the file with a one-line description of each. — The seven tabs, and what each one holds.

A capacity panel reading up to ten properties, one year per file, 150 income rows and 250 expense rows. — The capacity of the file, stated plainly.

A dark Summary tab from a landlord tracker, four figures across the top in pale cyan on near-black. — The same Summary, drawn dark. A second tab, nothing to switch on.

Three numbered steps: name your properties, type each entry, read the Summary. — Name, type, read.

The same tracker shown in Excel and in Google Sheets, on desktop and on a phone. — Excel and Google Sheets, desktop and mobile.

A list of what the file does not do, including that it does not calculate tax or fill any form. — What the file does not do.

Compatibility

Microsoft Excel · Google Sheets · both mobile apps. No add-ins, no macros, no account to create. Formulas are open — you can see every calculation.

Questions

Do I need Excel?

No. The file opens in Google Sheets and in the Excel mobile app, and behaves the same in both.

Is this a subscription?

No. One payment, and the file is yours to keep. There is nothing to renew.

Can I edit it?

Yes. Every formula is open to read. The sheets are protected so a stray click cannot delete a formula. In Excel: Review > Unprotect Sheet. The password is printed inside the file, in Start Here. In Google Sheets: you own your copy, so you can edit anything — Sheets will just ask you to confirm first. What you cannot do is add expense categories: the twelve are fixed, and the totals depend on them.

Does it handle several properties?

Yes, up to ten. Each one gets its own column in the Summary. In Income and Expenses you type the property number, not the name — that way a typo cannot split one property into two in your totals.

How do I add an entry?

Type over the empty rows that are already there. Do not insert rows: the engine uses fixed cell references and inserting rows breaks them.

Can I use this for my taxes?

No. This is a record, not a tax return. It does not calculate tax, fill any form, or replace the person who files for you — it gives them a clean year to work from. See the disclaimer below.

Why one year per file?

So last year stays exactly as you left it. You start a new copy each January and nothing you already closed can move.

A clean year, kept as you go

One payment of $24, and the file is yours to keep. No subscription, nothing to renew — and a one-page Welcome Guide arrives with it.