InkSheet Studio
Landlord Rent Tracker Spreadsheet | Rent Roll, Late Fees, Expenses and Mortgage Progress for Small Landlords
Landlord Rent Tracker Spreadsheet | Rent Roll, Late Fees, Expenses and Mortgage Progress for Small Landlords
Couldn't load pickup availability
INSTANT DOWNLOAD — HOW IT WORKS: This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.
Running rentals on a notebook, a shoebox of receipts, or a spreadsheet that grew a new tab every time something broke? This is the tracker built for the rest of us: landlords with 1 to 10 units who want clean records, not property-management software with a monthly bill.
Open it and your whole rental picture is in one calm sheet: who paid, who is late, what each property actually made, and how much of each mortgage is paid off.
THE FEATURE LANDLORDS KEPT ASKING FOR
Buyers of other trackers keep asking for one thing: mortgage payoff progress. It is built in here. Every property gets its own progress bar and % paid off, updated the moment you type a new balance. No separate loan spreadsheet, no mental math.
LATE FEES WITHOUT THE AWKWARD MATH
Rent due on the 1st, grace period through the 5th — paid after the 5th and a flat $50 late fee appears on its own, next to the days-late count. Your lease uses a different fee? Change one number in the formula and every row follows your rule.
WHAT'S INSIDE — 16 tabs, the whole rental in one file:
- Start Here — plain-English guide, the late-fee rule, and a 2-minute quick start
- Dashboard — set the month and see expected rent, collected, outstanding, late fees, expenses, net, occupancy, and profit per property — all totaled for you
- Properties & Units — your rent roll: property, unit, tenant, monthly rent, deposit held, and lease dates, with Occupied/Vacant filled in for you
- Rent Log — one row per unit per month: rent due, due date, date paid, amount paid — Days Late and Late Fee calculate themselves (formulas pre-filled for 100 rows)
- Expenses — date, property, category, amount, note; feeds the Dashboard automatically
- Mortgage Progress — original loan, current balance, paid off so far, % paid off with a progress bar, and monthly payment, per property
- Tenant Directory — every tenant in one place: property, unit, phone, email, emergency contact, lease start — plus what each tenant has paid in total and still owes, figured from the Rent Log
- Lease Tracker & Renewals — lease start and end, term length, and a live days-left countdown per lease that flags RENEW SOON before a lease runs out
- Security Deposit Tracker — every deposit you hold, tied to the rent roll, with the total held at a glance
- Maintenance & Work Log — one row per job: date reported, priority, status, date done, vendor — and the cost pulled straight from the Expenses tab, so the log and your books never disagree
- Utility Bills — who pays what, per property: landlord vs tenant for every utility, with landlord amounts pulled from Expenses (never counted twice)
- Late Payment Notices — a log of every notice you send, with the days late, the late fee, and what is owed pulled from the Rent Log for that month
- Vacancy & Turnover — vacant days and rent lost between tenants, figured from the lease dates, plus what each turnover cost you
- Tax Summary — a per-property rollup for the year in the shape of a Schedule E: rent collected, late fees, expenses by category, net — ready to hand to your accountant
- Annual Summary — the whole year month by month, in the same method as the Dashboard, with a year total
- Property Documents Log — leases, insurance policies, inspections and warranties in one place, with an expiry countdown so nothing lapses quietly
The sheet comes with fictional sample data (a duplex, two houses, one very late rent check) so you can watch every formula work before you delete it and add your own.
REQUIREMENTS: a free Google account. Your tracker lives in Google Sheets — no Excel needed, nothing to install, works at home, at the property, and on your phone.
Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.
PLEASE NOTE: this tracker is a record-keeping and organization tool. It is not financial, tax, or legal advice, and it makes no promise about investment returns — always follow your lease and your local rules, and bring a bookkeeper or accountant anything official.
This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.
FINISHED FILE — PLEASE READ: This listing is for the finished file exactly as shown — nothing is customized, personalized or revised. If anything prints wrong or you find an error in a file, message us and we will fix it — error fixes are always free, with no time limit.
Share
