Free Rental Income + Expense Spreadsheet (That Won't Betray You at Tax Time)

Let's start with something a software company isn't supposed to say: a spreadsheet is a perfectly good way to track rental income and expenses. For one property, it's arguably the best way. It's free, it opens everywhere, your accountant already speaks fluent Excel, and nobody charges you $28 a month for the privilege of sorting your own rows. If you're a spreadsheet person, a real one, not an aspirational one, you should keep reading and take ours. I know because I ran my two rentals on a Google Sheets workbook for the better part of a decade, and it worked great. I never stopped trusting it. I stopped keeping up with it, which is a completely different problem, and the reason this post gives you both halves: a free rental income and expense spreadsheet that's genuinely worth using, and the honest math on the exact moment it stops working.

New to the sheet? The step-by-step spreadsheet guide walks the setup.

What's the fastest way to track rental income and expenses?

The fastest system is the one you actually maintain. For most small landlords that's a spreadsheet, one file per property, updated weekly, or a tracker app that files a receipt in about 30 seconds and logs rent in about 10. Both beat the shoebox. The real question isn't which is fastest today; it's which one is still accurate in February. That's the whole argument, and the rest of this article is the evidence. But first, the thing you came for.

The free spreadsheet (and why I'm giving you the real thing)

Most "free template" posts are bait. The sheet is a screenshot-quality prop, the expense categories are generic small-business filler, and the actual point is to make the software look good by comparison. This one is the actual tracker. Almost exactly the spreadsheet I used on my own properties for a decade. The only thing my personal copy had that yours doesn't is an extra set of columns combining both properties, so I could see the portfolio total. It's the same income and expense spreadsheet that ships with our complete guide to tracking rental income and expenses, rebuilt for landlords, not adapted from a generic business budget:

• Income tab, rent, late fees, pet rent, parking, laundry, application fees, forfeited deposits (the categories the IRS actually expects, not "Sales Revenue")
• Expense tab, mapped to the real Schedule E lines: advertising, auto and travel, cleaning and maintenance, commissions, insurance, legal and professional, management fees, mortgage interest, other interest, repairs, supplies, taxes, utilities, depreciation, other
• Property columns, because "how's the rental doing?" is the wrong question when you have three of them
• A yearly summary that rolls each property into totals you can hand to a CPA without a two-hour translation session It works in Excel and Google Sheets. No macros, no locked cells, no upsell page that appears when you click the wrong tab. One rule if you have more than one property: make a copy of the file per property and keep them as separate files. Don't build one mega-workbook with a tab per door; separate files are the easiest, fastest way to keep the numbers clean, and you can total them across files whenever you want the combined view. That's the exact setup I ran. Grab it from the form up top and it's yours, the email gate exists so we can send you the updated version when tax law moves, not so we can haunt you. If you want a walkthrough before you dive in, the step-by-step guide to using the spreadsheet covers setup, the Jobs tab, and how the Schedule E page fills itself in.

How do you set up a rental spreadsheet that actually works?

Open the file, make one tab (or column set) per property, or better, one file per property (the rule above), and enter every transaction the week it happens: date, vendor or tenant, amount, category, property, and a one-line note. The setup walkthrough has the field-by-field version. Log income when it arrives and expenses when you pay them, file the receipt immediately, and reconcile against your bank statement monthly. Ten minutes a week is the entire maintenance cost. Skip a month and the cost quadruples, that's not an exaggeration, it's the business model of the next section. Three setup rules that decide whether the sheet survives contact with reality:

1. One row per transaction, always. The day you write "Home Depot, misc, $340" covering three trips, you've started a junk drawer with a formula bar.
2. Categories come from Schedule E, not from your head. If your sheet says "house stuff," your April will involve a CPA, a hourly rate, and regret.
3. The receipt is the record. The spreadsheet row is just the index. The IRS expects documentary evidence, receipts, canceled checks, bills, supporting anything you deduct, which means the sheet without the receipts is a story you're telling yourself.

What does a good rental income log actually capture?

More than rent. Landlords who only track rent underreport income and, weirder, under-claim expenses, because the fee income and the fee-chasing costs both live outside the monthly rent line. Your income log should capture, per property:

• Rent received (and which period it covered, a December check for January's rent matters)
• Late fees, pet rent, parking, laundry, storage, application fees
• Forfeited security deposits, income in the year you keep them, not when you collected them. A deposit you intend to return is not income when received; a deposit kept because the tenant broke the lease is. One line on a spreadsheet, two different tax treatments, this is exactly where generic templates betray you.
• Advance rent, any amount received before the period it covers counts when you receive it, not when it's "for." First-and-last-month collections are the classic trap. If that last paragraph felt pedantic, good, pedantry is the entire job in April. Publication 527 is the referee if you want the full rules.

Which expenses bite spreadsheet users hardest?

Every deductible expense, in the year you pay it, in its Schedule E bucket. The complete map lives in our rental property accounting explainer. The short version: lines 5 through 19 of Schedule E cover everything from advertising to utilities, and your spreadsheet's expense categories should match those lines one-for-one so tax time is a copy-paste, not an archaeology dig. Three expenses deserve their own warning labels:

• Repairs vs. improvements. A repair (fixing what broke) deducts this year. An improvement (making it better, bigger, or restored, a new roof, a kitchen remodel) is capitalized and depreciated over the recovery period for that type of property: 27.5 years for the building and its structural components, 5 years for appliances and carpeting, 15 for land improvements like fences and driveways. The roof-vs-repair distinction comes straight from Publication 946, and it's the single most common way landlords get this wrong. Grouping expenses by job, not just by category, is what makes this decision visible: when every receipt from the kitchen remodel sits in one bucket, "what's part of the project?" answers itself. (More on why job-grouping matters in the bookkeeping guide.)
• Mortgage interest vs. the mortgage payment. Only the interest (and PMI, points, etc.) is deductible, never the principal. If you log the whole payment as an expense, you've just claimed your own equity as a deduction, and the IRS has opinions about that.
• PMI on a rental. Private mortgage insurance on a rental property is deductible on Schedule E as a rental expense, always has been, independent of the personal-residence deduction you may have heard expired. (The personal Schedule A version is the one that lapsed after 2021 and was reinstated for 2026. Different animal, different schedule.)

Where does the spreadsheet actually break?

Here's the part every template post skips, because the template is the pitch and the pitch needs the spreadsheet to be forever. Mine worked. I want to be precise about that, because every software-company blog post wants the spreadsheet to be the villain. Two properties, one Google Sheets workbook, rent and expenses logged by hand: as a system, it was completely trustworthy. I never once doubted the numbers. The problem was never the tool. The problem was the upkeep: keeping it current took more time than I had, I always fell behind, and I dreaded sitting down to fill it in. The spreadsheet didn't fail all at once. My discipline did, on a schedule:

Stage	What it looks like	The cost
January	Fresh sheet, high discipline, every receipt logged same-day	~10 min/week
March	A "to enter later" pile appears. It's fine. You'll catch up this weekend	~1 hr/month
June	The pile is a folder. The folder is in a drawer	~4 hrs/quarter
Tax season	A shoebox, a bank statement, a glass of something, and a full weekend of forensic accounting	1 weekend + CPA sorting fees

I lived the bottom row. My receipt system was my wallet; when the wallet got too full, the receipts moved to a folder. Sometimes I scribbled what it was for on top. Sometimes. At tax time I'd scan everything, rename every file, and re-type it all into the spreadsheet I had definitely meant to keep up with. The dread was strong enough that I filed extensions and did my taxes around August, for years, and paid penalties for the privilege. That's not a productivity problem, that's a discipline-decay problem, and no template fixes it because the template is the thing you're decaying on. Mine included. The three structural cracks, so you can watch for them in yourself:

1. No receipts, only rows. The sheet records that you spent $84 at Lowe's. It cannot hold the photo of the receipt proving what the $84 was. Under audit, the row is your claim; the receipt is your evidence. You need both, and the spreadsheet only does one. (Receipts also physically fade; thermal paper in a warm wallet is a countdown timer, which is why we reviewed receipt scanner apps separately.)
2. No automatic categorization check. Type "plumbing" under Repairs on a pipe-fix and you're fine; type the kitchen remodel under Repairs and you've expensed something that should be depreciated. The sheet never pushes back.
3. It can't answer "which property?" retroactively. Three months of untagged Amazon orders do not sort themselves by duplex. None of this makes the spreadsheet bad. It makes it a January tool with an expiration date printed in invisible ink.

Who should stay on a spreadsheet (and who shouldn't)?

Stay on the spreadsheet if: you have one or two properties, a rent check or two a month, a manageable pile of receipts, and (this is the load-bearing condition) you are the kind of person who actually updates it weekly. You'll know by March. Plenty of landlords genuinely don't mind working in a spreadsheet and don't mind how long it takes. If that's you, sincerely: take the template, you're set. You don't need to buy anything from anyone, including me. Stay on it even longer if you like your own math. This is the part no app will tell you: a spreadsheet does things mine doesn't. Total control means you can bolt on whatever investment metrics you care about. On my own sheet I added refinancing costs and acquisition costs as line items past the tax-form section, because I wanted the full picture of money in and money out, not just the IRS's picture. Cash-on-cash return, IRR, whatever you want: if you can express it as a formula, the sheet will compute it. That kind of analysis is exactly what a spreadsheet is for, and if that's why you love yours, you should keep it. Move off it the moment any of these are true:

• You're perpetually behind on entries and the catch-up session has its own dread attached (ahem)
• You've ever filed an extension because the records weren't ready
• You've handed a CPA a folder and paid them to do sorting, not advising
• You can't answer "what did property #2 actually net last year?" in under a minute The app pitch, since I obviously have one: Doortrackr is the same idea as the spreadsheet, income and expenses, by property, mapped to Schedule E, minus the decay. Photograph a receipt, the AI fills vendor, amount, and date (highlighted so you can double-check; scanners do get things wrong, ours included), and the receipt image stays attached to the entry. Thirty seconds, not 30 minutes. Income entries take about 10. Free for one property, $6.99/month flat for up to five, every feature included on every tier. If the spreadsheet is working for you, keep the spreadsheet. If it's a lie you tell yourself every Sunday, start free and let future you off the hook.

How long do you need to keep all this?

Longer than you think. The general IRS rule is 3 years from filing for income and expense records, but records tied to the property itself (purchase documents, improvement costs, anything affecting basis or depreciation) stay until the period of limitations expires for the year you sell the property. So: receipts and logs, 3+ years; the roof invoice and the closing statement, until you've sold the place plus a few. A spreadsheet row proves nothing without the document behind it, which is the one-sentence summary of this entire article.

Is a spreadsheet good enough for rental property bookkeeping?

Yes, for one or two properties, simple finances, and a landlord who updates it weekly. The IRS doesn't require any particular recordkeeping system, only that your records clearly show income and expenses and that you can back deductions with documentary evidence. Where spreadsheets fail is receipts (they can't store evidence), discipline (batching decays), and multi-property separation.

What should a rental income and expense spreadsheet include?

One tab or column set per property (or one file per property); income categories covering rent, late fees, pet rent, parking, laundry, application fees, forfeited deposits, and advance rent; expense categories matching Schedule E lines 5–19 (advertising through utilities, depreciation, other); date, vendor/tenant, amount, category, and note per row; and a yearly summary that totals each property. If the categories don't map to Schedule E, you're building yourself an April translation project.

Can a spreadsheet track investment metrics like cash-on-cash return or IRR?

Yes, and this is the spreadsheet's genuine superpower. Tax forms have fixed categories, but a sheet lets you add your own rows and formulas: refinancing costs, acquisition costs, cash-on-cash return, IRR, whatever you want to track. If portfolio analysis is why you love spreadsheets, an app is a downgrade for that job.

How should I track multiple properties in a spreadsheet?

One copy of the file per property, kept as separate files, easiest and fastest, and you can total across files whenever you want the portfolio view. Resist the mega-workbook with a tab per door: the more tabs, the more places a transaction can land in the wrong one. (The spreadsheet guide walks the per-file setup.)

Is it better to use Excel or Google Sheets?

Both work, our template opens in either. Google Sheets wins if you want to enter expenses from your phone at the hardware store (which is genuinely the best habit a spreadsheet landlord can build). Excel wins if your CPA wants a file, not a link. The choice matters far less than the weekly-updates part.

How do I handle security deposits in my spreadsheet?

A deposit you plan to return is not income when you collect it. Track it as a liability or a note, not rent. It becomes income only in the year you keep some or all of it (damage, broken lease), per Publication 527. And if a "deposit" is actually the last month's rent, that's advance rent, which is income when received. (Our rent receipt template has the same rule built into its income categories.)

When should I switch from a spreadsheet to software?

When you're chronically behind on entries, when you've paid a CPA to sort instead of advise, or when you've filed an extension because the records weren't ready. Any one of those means the spreadsheet has stopped being a system and started being a scrapbook.

Do I still need to keep receipts if everything is in the spreadsheet?

Yes. The spreadsheet is your index; the receipts are your evidence. The IRS expects documentary evidence, receipts, canceled checks, bills, to support deductions, and you generally need to keep them at least 3 years from filing (longer for anything tied to the property's basis, which you keep until you sell).

---

Doortrackr is rental property bookkeeping made stupid simple: AI receipt scanning, property and job organization, and IRS-ready Schedule E reports, free for one property and $6.99/month flat after that. Try it free, or take the spreadsheet up top and come back when the shoebox wins. Disclosure: Doortrackr publishes this blog and, yes, sells the software this article eventually recommends. The spreadsheet is real, free, and the right answer for some landlords. We'd rather you trust us in March than buy from us in January.