Report this item to Etsy

Rental Property Tracker Spreadsheet, Landlord Bookkeeping, Schedule E Template, Rent Roll & Depreciation, Google Sheets and Excel

Item highlights

  • Digital download
  • Digital file type(s): 1 PDF, 2 other files
View more
Etsy's Purchase Protection

If something goes wrong with an order, we've got your back for all eligible purchases. View program terms

Price:$17.00

Loading

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

May include: A digital software interface titled BitWorks Rental Portfolio Dashboard displaying financial metrics including gross rental income, net operating income, cash flow, and Schedule E net. The layout features tables for property data and navigation tabs for settings, transactions, and rent rolls.

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 type
    Digital download
  • Digital file type(s)
    1 PDF, 2 other files
Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 21, 2026