Rental Property Bookkeeping Spreadsheet 2026
Rent, expenses and mileage for up to 10 properties, with Schedule E-style totals for every one.
Tax year 2026 closes in 52 days
Tax-ready rental books, without the March scramble.
Spreadsheet templates built for US landlords and hosts: bookkeeping, leases, 1099s, inspections, deal analysis and short-term rentals. Log as you go and every total, summary and Schedule E-style report fills itself in, in Excel or Google Sheets.
One-time payment · instant download · $11.80 per template in the Toolkit (save $42)
Sample data shown
Schedule E-style totalsBuilt for tax year 2026
Next deadline
Tax year 2026 closes · Dec 31, 2026
52days
10hrs
13min
55sec
Excel & Google Sheets
Windows, Mac & web
Instant download
No bank logins
One-time price
The 2026 tax calendar
The clock is already running on your 2026 records
These dates don't move. Landlords who log as they go hand over clean totals. Everyone else spends evenings rebuilding a year from bank statements.
Dec 31, 2026
Tax year 2026 closes
Every rent payment, repair and mile driven this year belongs in your 2026 records.
52days left
Feb 1, 2027
1099-NEC forms due
Forms for 2026 contractor payments are generally due to contractors and the IRS (Jan 31 falls on a Sunday).
84days left
Apr 15, 2027
Tax Day
Federal returns for 2026, including Schedule E, are generally due.
157days left
Every week you wait adds receipts to dig up later. Start today and the rest of the year takes minutes a week. Your templates are ready the moment checkout finishes.
See inside
Real spreadsheets. Not printables.
Click through every template. Screenshots show the included sample data; click one to enlarge it.
For landlords with 1-10 units
Rental Property Bookkeeping Spreadsheet 2026
Rent, expenses and mileage for up to 10 properties, with Schedule E-style totals for every one.
- Income, expense and mileage logs for up to 10 properties
- 13 expense categories that mirror the lines on IRS Schedule E
- Both 2026 IRS mileage rates built in: 72.5¢ through June 30, 76¢ from July 1
- Data checks flag rows missing a property, category or date
$27one-time · instant download
For landlords who manage their own tenants
Lease & Tenant Tracker
Every unit, lease and deposit in one place, with renewal reminders and a monthly rent-collection grid.
- Up to 40 units and 100 leases, with status worked out for you
- Renewal-notice dates and an 'expiring soon' list you can tune
- A 12-month rent-collection grid with balances and late flags
- Deposits held, occupancy and monthly rent roll on one dashboard
$17one-time · instant download
For landlords who pay contractors
Contractor Payments & 1099 Tracker 2026
Every payment to your plumber, cleaner and handyman, W-9 status, and who likely needs a Form 1099-NEC.
- Up to 50 contractors and 1,000 payments
- 2026 reporting threshold of $2,000 built in (editable)
- Card and app payments set aside, since those are generally reported on 1099-K
- A ready list of names, addresses and amounts, plus the filing deadline
$15one-time · instant download
For move-ins, move-outs and every repair in between
Move-In/Move-Out Inspection & Maintenance Log
A room-by-room inspection, a deposit-return worksheet, a repair log and a preventive maintenance schedule.
- A printable 76-item room-by-room checklist with signature lines
- A deposit-return worksheet that pulls damage charges from the inspection
- A 500-row repair log with target response times by priority
- A preventive schedule pre-filled with common tasks
$15one-time · instant download
For your next rental purchase
Rental Property Deal Analyzer
Cash flow, cap rate, cash-on-cash and DSCR estimates for any rental, five deals side by side, and a 5-year projection.
- 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
$27one-time · instant download
For Airbnb, Vrbo and direct-booking hosts
Short-Term Rental Bookkeeping Spreadsheet 2026
Bookings, payouts, expenses and mileage for up to 10 listings, with occupancy, ADR and RevPAR worked out.
- Up to 10 listings and 1,000 bookings, with nights and payout calculated
- Occupancy, ADR and RevPAR by month and by listing
- 15 short-term-rental expense categories, from cleaning to software
- Both 2026 IRS mileage rates built in, and editable
$27one-time · instant download
The collection
Pick what you need, or get everything
Six templates, each a one-time purchase. Five of them come together in the Landlord Toolkit for $59.
Lease & Tenant Tracker
Every unit, lease and deposit in one place, with renewal reminders and a monthly rent-collection grid.
Contractor Payments & 1099 Tracker 2026
Every payment to your plumber, cleaner and handyman, W-9 status, and who likely needs a Form 1099-NEC.
Move-In/Move-Out Inspection & Maintenance Log
A room-by-room inspection, a deposit-return worksheet, a repair log and a preventive maintenance schedule.
Rental Property Deal Analyzer
Cash flow, cap rate, cash-on-cash and DSCR estimates for any rental, five deals side by side, and a 5-year projection.
Short-Term Rental Bookkeeping Spreadsheet 2026
Bookings, payouts, expenses and mileage for up to 10 listings, with occupancy, ADR and RevPAR worked out.
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
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.
Do the math
Stop renting your own records
A subscription charges you every month for as long as you keep your books. A Rent & Tally template is paid for once.
An app at $20/month (example)
After 1 year$240
After 3 years$720
After 5 years$1,200
And it keeps going$1,200+
The Landlord Toolkit
Today$59
Year 3$0 more
Year 5$0 more
Total, ever$59
$20/month is an example for illustration. Compare it with what you pay today.
Instant access
From checkout to organized in minutes
About 1 min
Check out once
Pick a template or the Toolkit. Pay once, with no account to create and nothing to renew.
Instantly
Download or copy
Get the Excel files right away, or click once to put your own copy in Google Sheets.
Minutes a week
Log as you go
One row per payment, bill, lease or trip. Summaries, dashboards and checks update themselves.
Every template
Built like software. Priced like a template.
Each one is tested formula by formula against independently calculated results before release.
Excel and Google Sheets
Download the Excel files, or make your own Google Sheets copy in one click. No macros, no add-ins.
Formulas you can't break
Formula cells are protected in Excel, so a stray keystroke can't wipe out a total.
Sample data and a blank copy
See exactly how it works with realistic examples, then start fresh with the blank file.
Private by design
No bank logins and no account. Your numbers stay on your computer or in your own Google Drive.
Built-in data checks
Each template flags missing dates, properties or categories, so gaps get fixed early.
Ready for 2026
US date and currency formats, 2026 IRS mileage rates and the new 1099-NEC threshold, all editable.
Questions
Frequently asked
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.
Is this tax software?
No. These are record-keeping and calculation spreadsheets. They organize your numbers so you, or your tax preparer, can work from clean totals. Nothing here is tax, legal or investment advice.
Who can see my numbers?
Only you. The files live on your computer or in your own Google Drive, and Rent & Tally never sees what you type.
Which template should I start with?
Most landlords start with the Rental Property Bookkeeping Spreadsheet. If you also manage leases, pay contractors or plan to buy more property, the Landlord Toolkit gets you five templates for $59 instead of $101 bought separately.
What if I get stuck?
Email support@rentandtally.com. A real person answers, usually within one business day.
Tax year 2026 closes · Dec 31, 2026
52days
10hrs
13min
55sec
2026 won't log itself. Start before the next deadline.
Get all five templates for $59 and have every rent payment, bill, contractor and lease in order this week.
- Instant download
- Excel + Google Sheets
- One-time price
- No subscription