{"product_id":"landlord-rent-tracker-spreadsheet-rent-roll-late-fees-expenses-and-mortgage-progress-for-small-landlords","title":"Landlord Rent Tracker Spreadsheet | Rent Roll, Late Fees, Expenses and Mortgage Progress for Small Landlords","description":"\u003cp\u003e\u003cstrong\u003eINSTANT DOWNLOAD — HOW IT WORKS:\u003c\/strong\u003e 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.\u003c\/p\u003e\u003cp\u003eRunning 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.\u003c\/p\u003e\n\u003cp\u003eOpen 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eTHE FEATURE LANDLORDS KEPT ASKING FOR\u003c\/strong\u003e\u003cbr\u003eBuyers 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eLATE FEES WITHOUT THE AWKWARD MATH\u003c\/strong\u003e\u003cbr\u003eRent 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWHAT'S INSIDE\u003c\/strong\u003e — 16 tabs, the whole rental in one file:\u003c\/p\u003e\n\u003cp\u003e- \u003cstrong\u003eStart Here\u003c\/strong\u003e — plain-English guide, the late-fee rule, and a 2-minute quick start\u003cbr\u003e- \u003cstrong\u003eDashboard\u003c\/strong\u003e — set the month and see expected rent, collected, outstanding, late fees, expenses, net, occupancy, and profit per property — all totaled for you\u003cbr\u003e- \u003cstrong\u003eProperties \u0026amp; Units\u003c\/strong\u003e — your rent roll: property, unit, tenant, monthly rent, deposit held, and lease dates, with Occupied\/Vacant filled in for you\u003cbr\u003e- \u003cstrong\u003eRent Log\u003c\/strong\u003e — 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)\u003cbr\u003e- \u003cstrong\u003eExpenses\u003c\/strong\u003e — date, property, category, amount, note; feeds the Dashboard automatically\u003cbr\u003e- \u003cstrong\u003eMortgage Progress\u003c\/strong\u003e — original loan, current balance, paid off so far, % paid off with a progress bar, and monthly payment, per property\u003cbr\u003e- \u003cstrong\u003eTenant Directory\u003c\/strong\u003e — 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\u003cbr\u003e- \u003cstrong\u003eLease Tracker \u0026amp; Renewals\u003c\/strong\u003e — lease start and end, term length, and a live days-left countdown per lease that flags RENEW SOON before a lease runs out\u003cbr\u003e- \u003cstrong\u003eSecurity Deposit Tracker\u003c\/strong\u003e — every deposit you hold, tied to the rent roll, with the total held at a glance\u003cbr\u003e- \u003cstrong\u003eMaintenance \u0026amp; Work Log\u003c\/strong\u003e — 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\u003cbr\u003e- \u003cstrong\u003eUtility Bills\u003c\/strong\u003e — who pays what, per property: landlord vs tenant for every utility, with landlord amounts pulled from Expenses (never counted twice)\u003cbr\u003e- \u003cstrong\u003eLate Payment Notices\u003c\/strong\u003e — 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\u003cbr\u003e- \u003cstrong\u003eVacancy \u0026amp; Turnover\u003c\/strong\u003e — vacant days and rent lost between tenants, figured from the lease dates, plus what each turnover cost you\u003cbr\u003e- \u003cstrong\u003eTax Summary\u003c\/strong\u003e — 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\u003cbr\u003e- \u003cstrong\u003eAnnual Summary\u003c\/strong\u003e — the whole year month by month, in the same method as the Dashboard, with a year total\u003cbr\u003e- \u003cstrong\u003eProperty Documents Log\u003c\/strong\u003e — leases, insurance policies, inspections and warranties in one place, with an expiry countdown so nothing lapses quietly\u003c\/p\u003e\n\u003cp\u003eThe 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eREQUIREMENTS:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003cp\u003eTransparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePLEASE NOTE:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\u003cp\u003eFINISHED 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.\u003c\/p\u003e","brand":"InkSheet Studio","offers":[{"title":"Default Title","offer_id":68083110674717,"sku":null,"price":2.69,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1015\/0618\/7549\/files\/01-hero_ae0c1852-c37d-4875-8a18-633d9af23fe6.jpg?v=1794696439","url":"https:\/\/inksheetstudio.com\/products\/landlord-rent-tracker-spreadsheet-rent-roll-late-fees-expenses-and-mortgage-progress-for-small-landlords","provider":"InkSheet Studio","version":"1.0","type":"link"}