Report this item to Etsy

Rental Property Bookkeeping Spreadsheet: Landlord Schedule E Income and Expense Tracker, Excel Google Sheets

NowPrice:$11.98

Original Price: $17.12

30% off

•

Sale ends on November 18

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

★ 30-DAY MONEY-BACK GUARANTEE: if this template doesn't work for you, message us within 30 days of purchase for a full refund, no questions asked.

★ SAVE: this workbook is also in the Complete Landlord Bundle (US), 20 spreadsheets for CA$84.99: etsy.com/listing/4599085170

Keep your rental books tidy all year and be ready for tax season – in one spreadsheet that works in Microsoft Excel AND Google Sheets.

Built for small landlords with 1–10 properties who want clear numbers without paying for monthly software.

★ WHAT YOU GET
• Automatic DASHBOARD – total income, expenses, net income, cash flow, expense ratio and rent owing, plus 3 charts (monthly income vs expenses, where the money goes, net income by property)
• TRANSACTIONS log – 1,000 rows; pick property & category from dropdowns
• PROPERTY SUMMARY – annual totals per property, organized by IRS Schedule E (Part I) categories with line references
• MONTHLY view – 12 months, all properties or one property via dropdown
• RENT ROLL – tenants, lease dates, deposits, lease-renewal alerts; monthly rent paid, expected-to-date and balance owing fill in AUTOMATICALLY from your transactions (no double entry)
• CAPITAL ITEMS – log improvements and appliances for your depreciation schedule
• SETUP – tax year, up to 10 properties, ownership %, editable category notes
• START HERE guide – set up in about 10 minutes

★ HOW IT WORKS
1. Download the .xlsx file instantly after purchase (Etsy › Purchases › Download Files).
2. Open in Excel – or upload to Google Drive and choose File › Save as Google Sheets.
3. Delete the clearly-marked SAMPLE data, add your properties and start logging.

★ DETAILS
• Digital download – nothing will be shipped
• File: 1 × .xlsx (Excel 2010+ / Google Sheets; no macros)
• Currency-neutral number format (USD by default)
• Tested formula-by-formula; no add-ons required

★ AI DISCLOSURE
This template was designed by me with the help of AI tools (for drafting formulas, layout and text), then reviewed and tested before listing.

★ IMPORTANT
This is a record-keeping tool, not tax, legal or accounting advice. Category names follow IRS Schedule E for convenience only; please confirm how to report your rental income and expenses with a qualified tax professional (see IRS Publication 527).

Personal-use licence: for your own properties. Please don't resell or share the file. Because this is a digital item, returns aren't accepted – but if anything doesn't work, message me and I'll fix it.

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.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 19, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Bookkeeping Templates