Rental Property Tracker Spreadsheet, Landlord Bookkeeping, Schedule E Template, Rent Roll & Depreciation, Google Sheets and Excel
Item highlights
If something goes wrong with an order, we've got your back for all eligible purchases. View program terms
Price:$17.00
You can only make an offer when buying a single item
Delivery
Instant download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Seller's description
Specifications
Stop sorting a year of bank statements every April.
The Rental Property Tracker is a spreadsheet for small landlords with 1 to 10 doors. Log each rent payment and expense, pick the property and category, and it totals every line of IRS Schedule E for each property. That's the page your tax preparer actually asks for.
WHAT IT DOES
- Schedule E summary: lines 3 through 21, per property and in total, for the tax year you choose
- Categories are pre-mapped to Schedule E lines (rent, repairs, mortgage interest, insurance, taxes, utilities, HOA and more). You can edit or add your own
- Dashboard: gross rent, operating expenses, NOI, cash flow before principal, expense ratio and net Schedule E income or loss
- Rent roll: tenants, leases, rent, deposits held and rent paid this year. Leases ending within 60 days, expired, or in holdover (lease ended but rent still coming in) are flagged automatically
- Depreciation estimate: 27.5-year straight-line with the mid-month convention, land excluded. Each capital improvement gets its own row and in-service date, and everything flows into Schedule E line 18 per property
- Monthly cash flow table and chart
- 1,000-row transaction log with dropdowns (property, category, tenant) and date checks. The Dashboard flags any uncategorized rows so nothing silently drops out of your totals
- Mileage guidance built in: miles x the IRS rate for the trip date (2026: 72.5 cents Jan-Jun, 76 cents from Jul 1)
- Preparer notes for fair rental / personal use days (line 2) and passive loss limits (Form 8582)
- Yellow cells are for typing; formulas stay out of your way
WHAT YOU GET
- Blank tracker, ready for your properties
- Sample tracker with 3 example properties so you can see it working
- Step-by-step setup guide (PDF)
- Works in Google Sheets (free) and Microsoft Excel 2016 or newer. No add-ons, macros or subscription
- One-time purchase
WHO IT'S FOR
Self-managing landlords and house hackers with 1 to 10 long-term rentals who want clean year-end numbers without paying for a monthly app.
FAQ
Is this tax advice? No. It's a record-keeping tool. Confirm everything with a tax professional.
More than 10 properties? Use a second copy.
Problems? Message us on Etsy and we'll help.
DIGITAL DOWNLOAD
No physical item is shipped. Download from Etsy > Purchases right after checkout. Digital files can't be returned, but if a file won't open or something doesn't work, message us on Etsy and we'll fix it, send a replacement or refund you.
HOW THIS WAS MADE
Designed by Groundplane Labs. AI tools helped build and test the formulas, guide and preview images; every file was checked by us before listing.
Not affiliated with, sponsored or endorsed by Google, Microsoft or the IRS. Google Sheets is a trademark of Google LLC; Microsoft Excel is a trademark of Microsoft Corporation.
-
Designed by
-
Item typeDigital download
-
Digital file type(s)1 PDF, 2 other files
If something goes wrong with an order, we've got your back on all eligible purchases. View program terms
Meet your seller
More from this shop
-
Digital download
Etsy Seller Spreadsheet: Fee Calculator, Bookkeeping, Inventory Tracker and Profit Dashboard | Google Sheets & Excel | Profit Tracker
$17.00
-
Digital download
n8n Automation Templates: Lead Follow-Up, Invoice Reminders & Google Review Requests | Small Business Workflow Pack | No Code
$39.00
-
Digital download
Tax Deduction Tracker: Freelancer Tax Spreadsheet, Quarterly Estimated Tax, Invoice and Expense Log | Google Sheets & Excel | 1099
$15.00
-
Digital download
Reseller Spreadsheet: Profit Tracker eBay Poshmark Mercari Etsy Depop | 1099-K Check + Schedule C | Inventory Tracker | Google Sheets Excel
$17.00
-
Digital download
Rental Property Bookkeeping Google Sheets Landlord Spreadsheet Multi Property Income and Expense Tracker Excel Tenant Tracker Rent Payment
Sale Price $8.59
Original Price $17.18
-
Digital download
Multi Unit Rental Income Expense Tracker Landlord Property Management Spreadsheet Google Sheets Rental Bookkeeping Excel Tenant Ledger
Sale Price $8.59
Original Price $17.18
-
Digital download
Rental Property Tracker Landlord Spreadsheet beginner Property Income and Expense Excel Google Sheets Rental Bookkeeping Rent Payment
Sale Price $5.50
Original Price $11.00
-
Digital download
Rental Property Tracker Google Sheets Landlord Spreadsheet Multi Property Management Tracker Excel Rental Bookkeeping Rent Payment Tracker
Sale Price $8.79
Original Price $17.58
-
Digital download
Rental Property Tracker Landlord Spreadsheet Multi Property Income and Expense Excel Google Sheets Rental Bookkeeping Rent Payment Tracker
Sale Price $8.79
Original Price $17.58
-
Digital download
Landlord Rental Property Income & Expense Tracker Excel Template – Property Management Spreadsheet for 24 Properties
$12.90
-
Digital download
Multi-Unit Rental Property Tracker Excel Template – Landlord Income & Expense Spreadsheet (10 Properties, 60 Units)
$13.90
-
Digital download
Tenant Rent Payment Tracker for Landlord, Rental Property, Rent Roll, Rent Receipt, Google Sheets Template, Spreadsheet, Property Management
$12.44
-
Digital download
Rental Property Tracker Landlord Spreadsheet single Property Income and Expense Excel Google Sheets Rental Bookkeeping Rent Payment Tracker
Sale Price $5.50
Original Price $11.00
-
Digital download
Multi Property Rental Tracker Spreadsheet Dark Mode Landlord Bookkeeping Google Sheets Rental Income Expense Tenant Ledger Rent Management
Sale Price $7.99
Original Price $15.98
-
Digital download
Landlord Rental Property Spreadsheet Template, Excel & Google Sheets, Rental Property Spreadsheet, Landlord Tracker, Real Estate Spreadsheet
Sale Price $9.22
Original Price $18.43
-
Digital download
Rental Property Template Landlord Spreadsheet Income and Expense Tracker Rental Bookkeeping Excel Google Sheets Real Estate Management
Sale Price $24.96
Original Price $35.66
Shoppers with similar taste loved these
-
Digital download
Kanban Board Task Tracker for Small Business Project Planning To-Do List Project Template Task Checklist Small Business Planner Excel
Sale Price $6.20
Original Price $8.27
-
Digital download
Weekly Rent Payment Ledger Spreadsheet Template. Weekly Rent Payment Tracker. Rooms, Apartments, Houses, Flats Rental Payment Log.
Sale Price $4.61
Original Price $9.22
-
Digital download
Rent Payment Tracker | Rental Payment Ledger | Monthly Rent Payment Log | Landlord Rental Spreadsheet | Landlord Rental Payment Log
$1.99
-
Digital download
Tenant Rent Payment Tracker for Landlord, Rental Property, Rent Roll, Rent Receipt, Google Sheets Template, Spreadsheet, Property Management
$12.44
-
Digital download
Rent Payment Ledger, Rent Payment Tracker, Monthly Rent Payment Ledger, Rental Payment, Editable Rent Payment, MS Excel, MS Word, PDF
$2.45
-
Digital download
Kanban Board Excel Template | Task Tracker | Project Management | Gantt Chart | To Do List | Calendar
$3.66
-
Digital download
Rent Payment Tracker Excel Template: Landlord Rental Log (Digital Download)
$11.10
-
Digital download
Fundraiser Donation Tracking Spreadsheet Template for Google Sheets, Charity Event Donor List, Nonprofit Organization Budget Manager
$5.00
-
Digital download
Rental Income Tracker: Excel & Google Sheets Spreadsheet (Digital Download)
Sale Price $4.49
Original Price $6.60
-
Digital download
Real Estate Investment Cashflow Analyzer Pro: ROI Analysis
Sale Price $33.14
Original Price $55.23
-
Digital download
LAUNDROMAT Business Analysis template for Washateria Business, Calculate gross revenue, expenses and ROI
$45.00
-
Digital download
Rental Property Template Landlord Spreadsheet Income and Expense Tracker Rental Bookkeeping Excel Google Sheets Real Estate Management
Sale Price $24.96
Original Price $35.66