Rental Property Bookkeeping Spreadsheet 2026
Rent, expenses and mileage for up to 10 properties, with Schedule E-style totals for every one.
Sample data shown · click to enlarge
Deal Analyzer: inputs on the left, estimates on the right.
For your next rental purchase
Run the numbers on a rental before you make an offer.
Type in the price, financing, rents and expenses. The analyzer estimates loan payment, cash needed, NOI, cash flow and the common ratios, then compares up to five deals side by side.
$27one-time · instant download
Buy now: instant access
Excel + Google SheetsNo subscriptionSecure checkout
Best value: get this plus 4 more templates in the Landlord Toolkit for $59 (save $42) →
- Loan payment, cash needed, NOI and monthly cash flow estimates
- Cap rate, cash-on-cash, DSCR, GRM, 1% rule and break-even occupancy
- Compare up to 5 properties, with a 'best on this measure' column
- A 5-year projection using growth rates you choose
What's inside
A tour, tab by tab
Screenshots show the included sample data. Click any screenshot to enlarge it.
Tab · Deal Analyzer
Deal Analyzer
Purchase price, closing costs, rehab, down payment, rate, term, points, rents for up to 8 units, vacancy and every operating expense. Results include loan amount, monthly P&I, total cash needed, NOI, cash flow, cap rate, cash-on-cash, DSCR, GRM, the 1% rule and break-even occupancy.
Tab · Compare Deals
Compare Deals
Five deals in columns with the same inputs and results, plus a column naming the best deal on each measure.
Tab · 5-Year Projection
5-Year Projection
Year-by-year income, expenses, NOI, debt service, cash flow, loan balance, property value and equity, based on the appreciation, rent and expense growth rates you set.
In your download
Everything arrives in under a minute
Rental Property Deal Analyzer (Excel, with sample data)
A blank Excel copy, ready for your records
A one-click Google Sheets copy link
A Start Here tab with setup steps
Is it right for you?
Who it's for
A great fit for
- Buyers comparing single-family, duplex and small multi-family rentals
- Investors who want to see every assumption, not a black box
Not built for
- Commercial properties or syndications
- Anyone looking for a forecast or a recommendation; results are estimates from your inputs
Why it's the smart buy
More built in than a free template. A fraction of a subscription.
Everything a small landlord needs for the 2026 tax year, without another monthly bill or a bank login.
| Our templatesRent & Tally | Subscription landlord apps | Free templates online | Shoebox + bank statements | |
|---|---|---|---|---|
| One-time price, no monthly fee | Yes | Monthly or yearly fee | Free | Free |
| Ready for tax year 2026 (mileage rates, $2,000 1099-NEC threshold) | Built in | Varies | Rarely updated | No |
| Schedule E-style expense categories | 13 categories | Varies | Sometimes | No |
| Contractor totals and likely 1099-NECs | Yes | Varies | Rarely | No |
| Works in Excel and Google Sheets | Both | App only | Usually one | No |
| No bank login needed | Never asked | Often asks to link | Yes | Yes |
| Built-in checks catch missing data | Yes | Varies | Rarely | No |
| You keep your file forever | Yes | Tied to your plan | Yes | Paper only |
| Sample data and a setup guide | Yes | Usually | Sometimes | No |
A general comparison of common alternatives, not of any specific product. Features of individual apps and templates vary.
Questions
Rental Property Deal Analyzer FAQ
Is this investment advice?
No. Every result is an estimate based on the numbers you type in. It isn't a forecast or a recommendation; confirm details with a lender and other professionals.
Does it handle all-cash purchases?
Yes. Set the down payment to 100% and the loan figures drop to zero.
Can I change the growth assumptions?
Yes. Appreciation, rent growth and expense growth are settings on the 5-Year Projection tab, labelled as your assumptions.
Do they work in Google Sheets as well as Excel?
Yes. Every template comes as Excel files (sample and blank) plus a link that puts your own copy in Google Drive in one click. Excel 2010 or later on Windows or Mac, and Excel for the web, all work. No macros or add-ins.
Is there a subscription?
No. Each template is a one-time purchase. The file is yours to keep and use.
How do I get my files?
Right after checkout you'll see your download and Google Sheets links, and we email them to you as well.
Pairs well with
Complete your setup
Lease & Tenant Tracker
Every unit, lease and deposit in one place, with renewal reminders and a monthly rent-collection grid.
Best value · save $42
The Landlord Toolkit
Five spreadsheets that run the whole landlord year: the books, the leases and rent, the contractors, the turnovers and your next purchase. One download, one price, yours to keep.
- Rental Bookkeeping 2026$27
- Lease & Tenant Tracker$17
- Contractor 1099 Tracker 2026$15
- Inspection & Maintenance Log$15
- Rental Property Deal Analyzer$27
Best value
Bought separately: $101
$59
You save $42
That's $11.80 per template, paid once.
The Toolkit price goes up to $79 on Jan 1, 2027.
Get all 5 now
Instant download · Excel + Google Sheets · One-time price
Tax year 2026 closes · Dec 31, 2026
52days
10hrs
13min
55sec
Rental Property Deal Analyzer, ready in minutes
Cash flow, cap rate, cash-on-cash and DSCR estimates for any rental, five deals side by side, and a 5-year projection.
- Instant download
- Excel + Google Sheets
- One-time price
- No subscription