Rental Property Tracker Spreadsheet, Landlord Spreadsheet, Rent Tracker, Multiple Property Income Expense, Google Sheets and Excel

A rental property tracker for landlords who want to see who's paid, who's late and by how many days — and what each property really made — with tax-ready category totals for your accountant.

Works with: Google Sheets (make your copy on a computer) and Excel 2019+ / 365. Instant download. No subscription.

━━━━━━━━━━━━━━━━━━━━
WHAT'S INCLUDED
━━━━━━━━━━━━━━━━━━━━
• Includes a filled EXAMPLE workbook, Access Guide (Google Sheets link), and Quick Start / how-to notes — open EXAMPLE before your blank.
• Access Guide PDF with your Make a copy Google Sheets link
• Quick Start (how to set up your first property — included with your download)
• Blank Excel file plus an EXAMPLE with fictional sample data
• 9 tabs: Start Here, Dashboard, Rent Due & Arrears, Transactions, Properties & Leases, Property Report, Tax Summary, Settings, Read Me

━━━━━━━━━━━━━━━━━━━━
HOW IT WORKS
━━━━━━━━━━━━━━━━━━━━
1. Open the access guide, make your copy (or open the .xlsx), then open the EXAMPLE.
2. Add properties and leases on Properties & Leases. Type only in the soft cream cells with a dark edge — everything else is protected.
3. Log rent and expenses in Transactions — Rent Due & Arrears and the Dashboard show who's late and what each property made.

━━━━━━━━━━━━━━━━━━━━
WHY YOU'LL LOVE IT
━━━━━━━━━━━━━━━━━━━━
• Days-late arrears for weekly, fortnightly and monthly rent, with a chase list
• 1–30 properties in one file, one transaction log (no tab-per-property sprawl)
• Rent increases by date and lease-end alerts; late fees off by default
• Switchable tax category sets: General, US Schedule E, Australia, UK or Custom
• Property Report for income and expenses per property
• Bank tie-out and dropdown-only categories so coding stays clean

━━━━━━━━━━━━━━━━━━━━
FAQ
━━━━━━━━━━━━━━━━━━━━
Q: Does this work in Google Sheets and Excel?
A: Yes. You get an Excel workbook and a Google Sheets link (via the Access Guide). Use whichever you prefer — no subscription to YamCo.

Q: How do I download and open it?
A: After purchase, open your Etsy Purchases (or confirmation email) and download the files. Start with the Access Guide PDF — it has the Google Sheets button and any backup link. Then open the EXAMPLE file before the blank.

Q: Can I use it on my phone?
A: You can view it on a phone, but setup and day-to-day typing are much easier on a computer or tablet. The Sheets / Excel mobile apps hide some features — we recommend a laptop or desktop for the first setup.

Q: Is this for personal use only?
A: Yes — for personal use only. Please don't share the download link or resell the files.

Q: What's your refund policy on digital files?
A: Digital files can't be returned for a change of mind once downloaded, so please check the details and preview before buying. If a file is faulty or doesn't match the description, message us and we'll fix it or send a replacement. If we can't fix it, or there's a major problem, you can choose a refund instead. This doesn't affect your rights under your local consumer law.

Q: Where should I start so it isn't confusing?
A: Open the EXAMPLE file first (about 2 minutes) — it's filled with sample data so you can see how it works. Then open your blank file and type only in the soft cream cells with a dark edge — everything else is protected. Start Here is the first tab.

Q: Where do I type?
A: Type only in the soft cream cells with a dark edge — everything else is protected.

Q: Is the Tax Summary advice?
A: No. Tax category labels are a starting point mapped from public tax-office guides and flagged "check with your accountant". General information only — not tax, legal or financial advice.

Q: Is there a video walkthrough?
A: [YouTube how-to — add when live]

━━━━━━━━━━━━━━━━━━━━
ALSO FROM YAMCO
━━━━━━━━━━━━━━━━━━━━
• Pricing Calculator: https://www.etsy.com/listing/4606041021/etsy-pricing-calculator-spreadsheet
• Budget Pro (AU): https://www.etsy.com/listing/4606050732/budget-pro-au-2026-27-australian-budget

PLEASE NOTE
• Tax category labels are a starting point — check with your accountant. General information only, not tax, legal or financial advice. Works in any currency.
• For personal use only. Please don't share or resell.

THE YAMCO WORKS-OR-WE-FIX-IT PROMISE
Digital files can't be returned for a change of mind once downloaded, so please check the details and preview before buying. If a file is faulty or doesn't match the description, message us and we'll fix it or send a replacement. If we can't fix it, or there's a major problem, you can choose a refund instead. This doesn't affect your rights under your local consumer law.

AI disclosure: YamCo makes its products with the help of AI tools. AI was used to build this spreadsheet, run its automated formula checks, and draft this description, following YamCo's design and brief.

YamCo